02-03-2014 09:05 PM
Error message when trying to open an existing database in ACT Pro 2014 v16. The database is from a 2009 Premium v11. ACT support was on my system via remote for over 6 hours without a resoltion. I am going from V11 Premium to V16 Pro. V11 (2009) did not have an option to save a copy of the database as a Pro version. Only as a Standard version. We tried opening up the Standard copy. That gave us an error (see below). We also tried to bring over the premium version and used actdiag to downgrade to PRO. Both executions gave us the same error (see below). The Demo DB from V11 had no problem converting. Tomorrow morning, I am going to have the database services look at the issue.
My server is a dedicated server hosted at Godaddy running Server 2012
Here is the error message: violation of primary key constraint 'ctl_user_columnaccess_pk. cannot insert duplicate key in objectdbo.ctl_user_columnaccess. the duplicate key value is changed database context to.[my DB name].
02-06-2014 01:31 PM
Spoke with ACT Tech Support. pretty the large DB files are the problem.
I will repost if after fixing that issue I have an issue still upgrading.
Here's how to deal with the large file issue:
02-03-2014 11:01 PM
02-04-2014 12:08 PM
02-04-2014 12:14 PM
02-04-2014 12:16 PM
Yes, ACT support tryied using ACTDIAG to download. Same error. I don't understand why, on my current/old server with 2009, V11 Premium, the ADF file and the Attached documents folder are each about 400MB. That's a total of 800 GB. Templates 30MB. Yest, when I just now created a RD for a client, it was ove 7 GB! How is that possible? Is it including the backup files in the RD? We have 4 users. 3 of us are back on using the old server, which keeps crashing until I get this figured out. 1 agent can't get on until I successfully download her 7 GB RD file. And with the server constantly crashing, that's not easy to accomplish.
02-04-2014 12:26 PM