Category: Blog Spot

Secure Your CRM Data with Zoho’s Admin Backup, Recycle Bin, and Audit Trail

Protecting Your CRM Data: Zoho’s Admin Backup, Recycle Bin, and Audit Trail As a business owner or sales manager, you understand the importance of keeping your customer relationship management (CRM) data secure, accurate, and accessible. But what happens when a salesperson accidentally deletes a valuable lead, or when changes to your CRM data are made Learn More “Secure Your CRM Data with Zoho’s Admin Backup, Recycle Bin, and Audit Trail”

LEARN MORE

How Zoho Workflow Automation Can Revolutionize Your Business Processes

Transform Your Business Processes with Workflow Automation In the fast-paced business world of today, time is of the essence, and maximizing productivity has become a critical aspect. Therefore, it’s no surprise that workflow automation has gained popularity as one of the most effective ways to streamline business processes and enhance productivity. In essence, workflow automation Learn More “How Zoho Workflow Automation Can Revolutionize Your Business Processes”

LEARN MORE

8 Ways CRM Software Can Help Reduce Costs for Your Business

8 ways Zoho CRM saves business costs, improves ROI Integrating customer relationship management (CRM) software within your business model can do more than just enhance customer interactions. It can lower customer acquisition costs and improve overall business efficiency. In this article, we will explore eight ways in which utilizing a CRM system can help reduce Learn More “8 Ways CRM Software Can Help Reduce Costs for Your Business”

LEARN MORE

Lead Nurturing Process

7 Steps for a Successful Lead Nurturing Process The lead nurturing process plays a vital role in the sales cycle. It’s a mechanism that allows you to nurture your leads continually, even after they’ve converted into clients. The process includes communication that can range from automated emails to high-touch phone calls and meetings with sales Learn More “Lead Nurturing Process”

LEARN MORE

Zoho Books anytime anywhere access for the win!

Today I want to share a little “win” I experienced with Zoho Books. To give you some background, prior to January 1, 2020, I had been a Quickbooks Pro desktop user for about 18 years – except for a short stint on QB Online about 5 years ago. Having moved to Zoho One at the end of 2019, I decided to go “all in” with Zoho and convert my QuickBooks Pro to Zoho Books.

LEARN MORE

ERROR: “CANNOT INSERT DUPLICATE KEY ROW IN OBJECT ‘SYS.SYSCOMMITTAB’ WITH UNIQUE INDEX ‘SI_XDES_ID’… ERROR 2601″ WHEN ATTEMPTING TO BACKUP, COPY, REPAIR, CREATE A REMOTE, OR SYNCHRONIZE AN ACT! DATABASE

This is an error associated with Microsoft® SQL Server® 2008 R2. You can resolve this issue by applying Cumulative Update 8 for SQL Server 2008 R2 Service Pack 2, then running the batch file provided in this article to fix the issue in your database(s). Please follow the exact steps below:Step 1: If necessary, apply SQL Server 2008 R2 Service Pack 2If you are not already running Service Pack 2 you will need to apply this update on the Act! server and all remote database machines with Act! and SQL Server 2008 R2 installed. 

  1. Download the update from the Microsoft download site: Microsoft® SQL Server® 2008 R2 Service Pack 2
    • Choose your version from the list (x64 for 64-bit, x86 for 32-bit, and IA64 for Itanium-based servers)
  2. Follow the download instructions from the site to install the Service Pack on all machines with Act! and SQL Server 2008 R2, starting with the database server.
  3. When the Service Pack has been applied to all machines, proceed to Step 2 below.

Step 2: Apply Cumulative Update 8 for SQL Server 2008 R2 Service Pack 2

You will need to apply this update on the Act! server and all remote database machines with Act! and SQL Server 2008 R2 installed.

  1. Download CU8 from the Microsoft download site: Cumulative update package 8 for SQL Server 2008 R2 Service Pack 2
  2. Follow the download instructions from the site to install the hotfix on all machines with Act! and SQL Server 2008 R2, starting with the database server.
  3. When the hotfix has been applied to all machines, proceed to Step 3 below.

Step 3: Run the batch file on all databases

Run the batch file for your version of SQL Server found in the File Attachments section of this article to resolve the issue in the databases.

If you are using SQL Server 2008 R2 Express, use SQL2008R2_Express_BackupFix.bat
If you are using SQL Server 2008 R2 Standard, use SQL2008R2_Standard_BackupFix.bat

Click HERE for instructions to determine your version of SQL Server.

Important Note for Remote Database Users:
If you are experiencing this error during remote database synchronization, you will need to run the batch file on all remote databases and the main database. No users should attempt to sync until all databases have successfully run the batch file.

To download and run the file:

  1. Ensure you are signed in to Windows as an Administrator User.
  2. Ensure that the SQL Server (ACT7) service is running on your machine. Click HERE for instructions to verify if the service is running.
  3. Right-click on the appropriate batch file for your version of SQL Server from the File Attachments section below, and choose the Save option. Save it to your computer’s Desktop.
  4. Close Act!
  5. Locate the file you downloaded on your Desktop. Right-click on it and select “Run As Administrator”.
  6. When prompted, you will type in the name of the database in which you are experiencing the error. If you do not know the name of your database, then open Act! in look in the upper left corner of the screen – the name of your database will be after the Ac! product name.
  7. After you type in the name of your database, press ENTER on your keyboard to run the fixImportant: Run the .bat file multiple times, until 0 rows affected is displayed. Wait approximately 30 seconds before running the file again.
  8. Reopen Act! and test the function you were receiving the error with.

If you receive an error when running the batch file, please see the Related Information below.

Related Information

Note: The information below only applies if you receive an error when applying the batch file mentioned above. If you have not received an error when applying the batch file, then this information does not apply.

If you receive an error when running the batch file, you may be able to resolve using the following steps:

Option 1: Disable User Account Control (UAC) in Windows

  1. For instructions on how to disable UAC, follow the steps in the article below that applies to your computer’s operating system:
    How to Disable User Account Control (UAC) in Windows Vista®
    Answer ID: 20220
    How to Change or Disable User Account Control (UAC) in Windows® 7 & Windows Server® 2008
    Answer ID: 25665
  2. Double-click on the .bat file to run it.

Option 2: Change Location of .Bat File

  1. Copy the batch file you downloaded from this article.
  2. Open Windows® Explorer and browse to one of the following directories, depending on your operating system and SQL Server installation:SQL Server (64-bit version) installed on a 64-bit operating system:
    C:\Program Files\Microsoft SQL Server\100\Tools\BinnSQL Server (32-bit version) installed on a 64-bit operating system:
    C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn 

    SQL Server (32-bit version) installed on a 32-bit operating system:
    C:\Program Files\Microsoft SQL Server\100\Tools\Binn

  3. Paste the batch file in the “Binn” folder.
  4. Double-click the batch file to run it from this location. When prompted, you will type in the name of the database in which you are experiencing the error. If you do not know the name of your database, then open Act! in look in the upper left corner of the screen – the name of your database will be after the Act! product name.

Option 3: Service SQL Server Browser Not Running

  1. Open Windows Services
  2. Locate SQL Server Browser
  3. Right click service; select Start
  4. Attempt to run bat file

Option 4 – Microsoft SQL Server 2008 Feature Pack
If the above steps still do not allow you to run the batch without error, then you may be able to resolve this by downloading the Microsoft SQL Server 2008 R2 Command Line Utilities package, which is listed on the Microsoft SQL Server 2008 Feature Pack web page. Run the batch file again after downloading this utility pack.

In addition, please see the following Knowledgebase article for more information:

Title: Error: “Msg 18456, level 14, state 1, server Server\Act7, line1…Login Failed for user domain\username” While Running a .bat File
Answer ID: 33620