Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database Issue

Copper Contributor
Posts: 21
Country: USA

Database Issue

I am using ACT2012

 

I cannot backup or Save As due to an error that occurs. I have run all repair options and they error as well ...

This is following error message issue:  cannot insert duplicate key row in object 'syssyscommitab' with unique index 'si_xdes_id'. The duliate key value is (668355).Failed to flush the commit table to disk in dbid 6 due to error 2601. ....

 

How can I get this fixed ?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Database Issue

That may be a know problem. Make sure you have akk service packs and hotfixes installed and see if the problem persists. If it does search the knowledge base for the error.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 21
Country: USA

Re: Database Issue

Thank you for the quick reply

 

My version level is: Version 14.1.108.0

 

If I click the Update ACT in the Help menu ... it does nothing.

 

How do I find out whether I have the latest updates and hot fixes ?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Database Issue

Go to the ACT! web site act.com and check the downloads for your version to see if there's any hotfixes.

 

Howfixes must be downloaded and manually installed,

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 21
Country: USA

Re: Database Issue

I have seen a listing of hotfixes ... but is there a way to tell if I have already installed any by the version number ?

 

If not, do I need to install all 7 in order ?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Database Issue

In About ACT! any installed hotfixes will be listed after the build number.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129