ACT! 2011 Premium database update error

[Vad]

Hi all,

I got an error during the installation ACT! 2011 Premium under ACT! 2010 Premium: Exceptions Occured While executing the database Schema Update Script.

I can't update and open my existing database under ACT! 2011 Premium. And I can't understand what is the source of error. I already tried to use all Sage knowledgebase advises. Nothing was change. 

Here it is error log:

ProductVersion                  
--------------------------------
10.50.1600.1                    
SETTING DATABASE COMPATIBILITY LEVEL...
   LOCAL DATETIME: 2011-01-21 10:13:58
       SERVERNAME: MSK01-ACT\ACT7
   ENGINE EDITION: 4  Express Edition
  PRODUCT VERSION: 10.50.1600.1 (RTM)
 SERVER COLLATION: Latin1_General_CI_AS
------------------------------------------------------------------------------
     SYNC ENABLED: False
        SYNC ROLE:
------------------------------------------------------------------------------
         DATABASE: Test13
           STATUS: ONLINE
   CREATE VERSION: 661
   RECOVERY MODEL: SIMPLE
     DB COLLATION: Latin1_General_CI_AS
       AUTO CLOSE: 0
      AUTO SHRINK: 0
AUTO CREATE STATS: 1
AUTO UPDATE STATS: 1
 TORN PAGE DETECT: 1
 
Configuration option 'user instances enabled' changed from 0 to 0. Run the RECONFIGURE statement to install.
-------------------------------------------------------------


 CURRENT BUILD: 12.10.0165.0000
  UPDATE BUILD: 13.1.97.1


-------------------------------------------------------------


SETTING DATABASE AUTO_SHRINK TO OFF...
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
TraceFlag Status Global Session
--------- ------ ------ -------
     8017      1      1       0
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


NOW DROPPING ALL SYNC UPDATE TRIGGERS...
STARTTIME: 2011-01-21 10:13:58
  ENDTIME: 2011-01-21 10:14:12


----------------------------------------------------------------
NOW DROPPING ALL TABLE AND COLUMN TRIGGERS...
STARTTIME: 2011-01-21 10:14:12
  ENDTIME: 2011-01-21 10:14:13
SETTING TBL_SYSLOCALCOLUMN DATA...
 
 
*** Upgrading/Checking database for Schema Version 07.00.0441.0000 at 2011-01-21 10:14:14.010 ***
 
*** Upgrading/Checking database for Schema Version 07.01.0457.0000 at 2011-01-21 10:14:14.093 ***
 
*** Upgrading/Checking database for Schema Version 07.01.0473.0000 at 2011-01-21 10:14:14.127 ***
 
*** Upgrading/Checking database for Schema Version 07.03.0099.0000 at 2011-01-21 10:14:14.183 ***
 
*** Upgrading/Checking database for Schema Version 07.03.0139.0000 at 2011-01-21 10:14:14.200 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0001.0000 at 2011-01-21 10:14:14.237 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0010.0000 at 2011-01-21 10:14:14.277 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0015.0000 at 2011-01-21 10:14:14.300 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0018.0000 at 2011-01-21 10:14:14.337 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0030.0000 at 2011-01-21 10:14:14.380 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0040.0000 at 2011-01-21 10:14:14.473 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0046.0000 at 2011-01-21 10:14:14.587 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0101.0000 at 2011-01-21 10:14:14.630 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0107.0000 at 2011-01-21 10:14:14.677 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0111.0000 at 2011-01-21 10:14:14.747 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0128.0001 at 2011-01-21 10:14:14.793 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0148.0000 at 2011-01-21 10:14:14.817 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0157.0000 at 2011-01-21 10:14:14.850 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0182.0000 at 2011-01-21 10:14:14.867 ***
 
*** Upgrading/Checking database for Schema Version 08.01.0057.0000 at 2011-01-21 10:14:14.937 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0017.0000 at 2011-01-21 10:14:14.960 ***
  Re-instating Standard Permission for Delete Activity Series (Workgroup)...
 
*** Upgrading/Checking database for Schema Version 08.02.0030.0000 at 2011-01-21 10:14:15.063 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0039.0000 at 2011-01-21 10:14:15.103 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0040.0000 at 2011-01-21 10:14:15.447 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0040.0001 at 2011-01-21 10:14:15.483 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0002.0000 at 2011-01-21 10:14:15.503 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0006.0000 at 2011-01-21 10:14:15.530 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0007.0000 at 2011-01-21 10:14:15.600 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0020.0000 at 2011-01-21 10:14:15.767 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0027.0000 at 2011-01-21 10:14:15.813 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0032.0000 at 2011-01-21 10:14:16.153 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0033.0000 at 2011-01-21 10:14:16.170 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0053.0000 at 2011-01-21 10:14:16.197 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0058.0000 at 2011-01-21 10:14:16.220 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0100.0000 at 2011-01-21 10:14:16.403 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0104.0000 at 2011-01-21 10:14:16.447 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0116.0000 at 2011-01-21 10:14:16.467 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0145.0000 at 2011-01-21 10:14:16.510 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0532.0000 at 2011-01-21 10:14:16.570 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0535.0000 at 2011-01-21 10:14:16.587 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0535.0001 at 2011-01-21 10:14:16.637 ***
 
*** Upgrading/Checking database for Schema Version 09.01.0038.0000 at 2011-01-21 10:14:16.647 ***
 
*** Upgrading/Checking database for Schema Version 09.01.0068.0000 at 2011-01-21 10:14:16.837 ***
 
*** Upgrading/Checking database for Schema Version 09.01.0121.0000 at 2011-01-21 10:14:16.917 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0003.0000 at 2011-01-21 10:14:16.930 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0008.0000 at 2011-01-21 10:14:16.963 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0012.0000 at 2011-01-21 10:14:17.017 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0015.0000 at 2011-01-21 10:14:17.083 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0046.0000 at 2011-01-21 10:14:17.110 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0065.0000 at 2011-01-21 10:14:17.243 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0077.0000 at 2011-01-21 10:14:29.457 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0160.0000 at 2011-01-21 10:14:29.500 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0209.0000 at 2011-01-21 10:14:29.550 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0026.0000 at 2011-01-21 10:14:29.663 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0047.0000 at 2011-01-21 10:14:29.863 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0065.0000 at 2011-01-21 10:14:30.010 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0068.0000 at 2011-01-21 10:14:30.027 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0125.0000 at 2011-01-21 10:14:30.047 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0191.0003 at 2011-01-21 10:14:30.127 ***
 
*** Upgrading/Checking database for Schema Version 10.03.0085.0000 at 2011-01-21 10:14:30.203 ***
 
*** Upgrading/Checking database for Schema Version 10.03.0169.0000 at 2011-01-21 10:14:30.233 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0066.0000 at 2011-01-21 10:14:30.270 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0247.0000 at 2011-01-21 10:14:30.287 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0308.0000 at 2011-01-21 10:14:30.317 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0010.0000 at 2011-01-21 10:14:30.370 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0029.0000 at 2011-01-21 10:14:30.637 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0036.0000 at 2011-01-21 10:14:30.700 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0045.0000 at 2011-01-21 10:14:30.740 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0050.0000 at 2011-01-21 10:14:30.750 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0068.0000 at 2011-01-21 10:14:30.813 ***
 
*** Upgrading/Checking database for Schema Version 11.02.0010.0000 at 2011-01-21 10:14:30.913 ***
Deleting Netherlands verbiage
Adding Netherlands, The verbiage
***********************
SETTING SYSTABLEDOMAIN DATA at 2011-01-21 10:14:31.290
***********************
 
*** Upgrading/Checking database for Schema Version 12.00.0064.0000 at 2011-01-21 10:14:31 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0075.0000 at 2011-01-21 10:14:33 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0112.0000 at 2011-01-21 10:14:33 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0117.0000 at 2011-01-21 10:14:33 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0120.0000 at 2011-01-21 10:14:33 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0148.0000 at 2011-01-21 10:14:33 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0152.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0160.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0171.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0196.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0197.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0213.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0227.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0239.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0273.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0306.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0333.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0367.0000 at 2011-01-21 10:14:34 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0405.0000 at 2011-01-21 10:14:37 ***
 
*** Upgrading/Checking database for Schema Version 12.10.0088.0000 at 2011-01-21 10:14:37 ***
 
*** Upgrading/Checking database for Schema Version 12.10.0126.0000 at 2011-01-21 10:14:37 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0104.0000 at 2011-01-21 10:14:37 ***
Creating table CTL_WF_COMPLETEDSCOPE...
Creating index CTL_WF_COMPLETEDSCOPE_IF1
Creating index CTL_WF_COMPLETEDSCOPE_IE1
Creating table CTL_WF_INSTANCESTATE...
 
*** Upgrading/Checking database for Schema Version 13.00.0105.0000 at 2011-01-21 10:14:38 ***
Creating table TBL_WORKFLOWDEF...
Creating index TBL_WORKFLOWDEF_IE1
Creating index TBL_WORKFLOWDEF_IF1
Creating table TBL_WORKFLOWDEF_ACL...
 
*** Upgrading/Checking database for Schema Version 13.00.0131.0000 at 2011-01-21 10:14:38 ***
Removing ACTIVITYSERIESAPPLIED_ACTIVITYSERIESID_FK
Adding ACTIVITYSERIESAPPLIED_ACTIVITYSERIESID_FK
Removing ACTIVITY_ACTIVITYSERIESAPPLIEDID_FK
Adding ACTIVITY_ACTIVITYSERIESAPPLIEDID_FK
 
*** Upgrading/Checking database for Schema Version 13.00.0162.0000 at 2011-01-21 10:14:38 ***
Creating table TBL_WORKFLOW_SUBSCRIPTION...
Creating table TBL_WORKFLOW_QUEUE...
Creating index TBL_WORKFLOW_QUEUE_IF3...
 
*** Upgrading/Checking database for Schema Version 13.00.0203.0000 at 2011-01-21 10:14:38 ***
Dropping index CTL_SYSTABLEORDER_IE1 ON dbo.CTL_SYSTABLEORDER;
Expanding ORDINAL on CTL_SYSTABLEORDER
Creating index CTL_SYSTABLEORDER_IE1 ON dbo.CTL_SYSTABLEORDER;
 
*** Upgrading/Checking database for Schema Version 13.00.0204.0000 at 2011-01-21 10:14:38 ***
Creating index TBL_SYNCSET_AK1 ON dbo.TBL_SYNCSET
 
*** Upgrading/Checking database for Schema Version 13.00.0215.0000 at 2011-01-21 10:14:38 ***
Creating Appointment Activity Type
 
*** Upgrading/Checking database for Schema Version 13.00.0215.0000 at 2011-01-21 10:14:38 ***
Creating WF_INSTANCEID on TBL_ACTIVITY
Creating WF_CONTEXTID on TBL_ACTIVITY
 
*** Upgrading/Checking database for Schema Version 13.00.0224.0000 at 2011-01-21 10:14:38 ***
Creating TBL_CONTACT_SOURCE
 
*** Upgrading/Checking database for Schema Version 13.00.0225.0000 at 2011-01-21 10:14:38 ***
Adding field WORKFLOWDEFID to TBL_ATTACHMENT
Adding index TBL_ATTACHMENT_IF7 on TBL_ATTACHMENT
 
*** Upgrading/Checking database for Schema Version 13.00.0268.0000 at 2011-01-21 10:14:38 ***
Creating table TBL_WORKFLOW_ARCHIVE...
Creating view VWT_WORKFLOW_ARCHIVE...
 
*** Upgrading/Checking database for Schema Version 13.00.0300.0000 at 2011-01-21 10:14:38 ***
Adding CTL_SYNCSETTYPE entry
Adding Syncset entries
Adding SyncsetQuery entries
 
*** Upgrading/Checking database for Schema Version 13.00.0322.0000 at 2011-01-21 10:14:39 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0332.0000 at 2011-01-21 10:14:39 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0338.0000 at 2011-01-21 10:14:39 ***
Adding sample workflows
 
*** Upgrading/Checking database for Schema Version 13.00.0349.0000 at 2011-01-21 10:14:39 ***
Adding HISTORYTYPEGROUPID to TBL_HISTORYTYPE
Inserting values into HISTORYTYPEGROUPID on TBL_HISTORYTYPE
Modify nullibility of HISTORYTYPEGROUPID on TBL_HISTORYTYPE
Msg 515, Level 16, State 2, Server MSK01-ACT\ACT7, Line 5
Cannot insert the value NULL into column 'HISTORYTYPEGROUPID', table 'Test13.dbo.TBL_HISTORYTYPE'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
***********************
SETTING TABLE METADATA at 2011-01-21 10:14:42.993
***********************
PROCESSING ERROR OCCURRED ADDING SYSTABLE INFO FOR CTL_ABL_ACTIVITY
Msg 50000, Level 16, State 1, Server MSK01-ACT\ACT7, Line 31
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
***********************
SETTING COLUMN METADATA at 2011-01-21 10:14:44.930
***********************
PROCESSING ERROR OCCURRED ADDING SYSCOLUMN INFO FOR ABL_ACTIVITYID on CTL_ABL_ACTIVITY
Msg 50000, Level 16, State 1, Server MSK01-ACT\ACT7, Line 62
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
PROCESSING ERROR OCCURRED ADDING SYSCOLUMN INFO FOR COMPANYID ON VWT_COMPANY_ACCESS
Msg 50000, Level 16, State 1, Server MSK01-ACT\ACT7, Line 35
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
PROCESSING ERROR OCCURRED ADDING SYSCOLUMN INFO FOR OPPORTUNITYID ON VWT_OPPORTUNITY_STAGE_PROCESS
Msg 50000, Level 16, State 1, Server MSK01-ACT\ACT7, Line 31
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
***********************
SETTING KEY METADATA at 2011-01-21 10:14:45.273
***********************
PROCESSING ERROR OCCURRED ADDING SYSTABLEKEY INFO FOR XPKABL_ACTIVITY on CTL_ABL_ACTIVITY
Msg 50000, Level 16, State 1, Server MSK01-ACT\ACT7, Line 22
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
***********************
DONE SETTING KEY METADATA at 2011-01-21 10:14:45.333
***********************
 
FOOTER ENTRY TRANCOUNT = 0
Msg 50000, Level 25, State 1, Server MSK01-ACT\ACT7, Line 19
***** Update of database failed!  Exiting from update!
Msg 2745, Level 16, State 2, Server MSK01-ACT\ACT7, Line 19
Process ID 53 has raised user error 50000, severity 25. SQL Server is terminating this process.

[rkumar]

I had the same issue too. The best thing to do is to make a backup copy first prior to upgrade. I wil assume you have done so before following the rest of this advice.

Delete the .pad and the .adf file, but leave the .alf file. Run actdiag,
and follow this KB article

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2704...