02-07-2011 07:05 AM
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.
02-07-2011 04:31 PM