Community
Showing results for 
Search instead for 
Do you mean 
Reply

user error 50000 message when upgrading 2011Pro to 2011SP1Pro

Accepted Solution Solved
Copper Super Contributor
Posts: 47
Country: United States
Accepted Solution

user error 50000 message when upgrading 2011Pro to 2011SP1Pro

I've installed the SP1 upgrade to my  ACT2011 package and have successfully converted all but my most important database. I continue to get the user error 50000, severity 25 message followed by a failed conversion. I cannot ascertain where the issue is located or what to do next. Knowledgebase issues seem to be of no help so far.  What are my next best steps to resolve this?? Please help...

 

Here is the entire text of my "Schema Update Script" error report:

ProductVersion                 
--------------------------------
10.50.1600.1                   
SETTING DATABASE COMPATIBILITY LEVEL...
   LOCAL DATETIME: 2011-05-31 17:02:20
       SERVERNAME: KARLS-LT\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: LG
           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: 13.00.0396.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-05-31 17:02:22
  ENDTIME: 2011-05-31 17:02:57


----------------------------------------------------------------
NOW DROPPING ALL TABLE AND COLUMN TRIGGERS...
STARTTIME: 2011-05-31 17:02:58
  ENDTIME: 2011-05-31 17:02:58
SETTING TBL_SYSLOCALCOLUMN DATA...
 
 
*** Upgrading/Checking database for Schema Version 07.00.0441.0000 at 2011-05-31 17:03:01.990 ***
 
*** Upgrading/Checking database for Schema Version 07.01.0457.0000 at 2011-05-31 17:03:02.287 ***
 
*** Upgrading/Checking database for Schema Version 07.01.0473.0000 at 2011-05-31 17:03:02.333 ***
 
*** Upgrading/Checking database for Schema Version 07.03.0099.0000 at 2011-05-31 17:03:02.910 ***
 
*** Upgrading/Checking database for Schema Version 07.03.0139.0000 at 2011-05-31 17:03:02.973 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0001.0000 at 2011-05-31 17:03:03.207 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0010.0000 at 2011-05-31 17:03:03.283 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0015.0000 at 2011-05-31 17:03:03.423 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0018.0000 at 2011-05-31 17:03:03.520 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0030.0000 at 2011-05-31 17:03:03.580 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0040.0000 at 2011-05-31 17:03:03.940 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0046.0000 at 2011-05-31 17:03:04.410 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0101.0000 at 2011-05-31 17:03:04.830 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0107.0000 at 2011-05-31 17:03:05 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0111.0000 at 2011-05-31 17:03:05.750 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0128.0001 at 2011-05-31 17:03:06.170 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0148.0000 at 2011-05-31 17:03:06.250 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0157.0000 at 2011-05-31 17:03:06.607 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0182.0000 at 2011-05-31 17:03:06.857 ***
 
*** Upgrading/Checking database for Schema Version 08.01.0057.0000 at 2011-05-31 17:03:08.527 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0017.0000 at 2011-05-31 17:03:08.667 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0030.0000 at 2011-05-31 17:03:09.743 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0039.0000 at 2011-05-31 17:03:11.473 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0040.0000 at 2011-05-31 17:03:11.613 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0040.0001 at 2011-05-31 17:03:11.817 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0002.0000 at 2011-05-31 17:03:11.927 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0006.0000 at 2011-05-31 17:03:12.193 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0007.0000 at 2011-05-31 17:03:12.630 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0020.0000 at 2011-05-31 17:03:13.377 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0027.0000 at 2011-05-31 17:03:14.080 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0032.0000 at 2011-05-31 17:03:14.407 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0033.0000 at 2011-05-31 17:03:14.453 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0053.0000 at 2011-05-31 17:03:14.703 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0058.0000 at 2011-05-31 17:03:14.847 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0100.0000 at 2011-05-31 17:03:15.110 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0104.0000 at 2011-05-31 17:03:15.470 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0116.0000 at 2011-05-31 17:03:15.670 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0145.0000 at 2011-05-31 17:03:16.017 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0532.0000 at 2011-05-31 17:03:16.483 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0535.0000 at 2011-05-31 17:03:16.577 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0535.0001 at 2011-05-31 17:03:16.763 ***
 
*** Upgrading/Checking database for Schema Version 09.01.0038.0000 at 2011-05-31 17:03:16.950 ***
 
*** Upgrading/Checking database for Schema Version 09.01.0068.0000 at 2011-05-31 17:03:19.120 ***
Altering table TBL_SYSCOLUMN (MIN_COLUMNLENGTH - NON-STRING)
 
*** Upgrading/Checking database for Schema Version 09.01.0121.0000 at 2011-05-31 17:03:19.337 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0003.0000 at 2011-05-31 17:03:19.383 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0008.0000 at 2011-05-31 17:03:19.977 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0012.0000 at 2011-05-31 17:03:20.303 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0015.0000 at 2011-05-31 17:03:20.600 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0046.0000 at 2011-05-31 17:03:20.727 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0065.0000 at 2011-05-31 17:03:20.833 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0077.0000 at 2011-05-31 17:03:20.897 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0160.0000 at 2011-05-31 17:03:20.943 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0209.0000 at 2011-05-31 17:03:21.177 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0026.0000 at 2011-05-31 17:03:23.207 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0047.0000 at 2011-05-31 17:03:23.910 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0065.0000 at 2011-05-31 17:03:24.597 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0068.0000 at 2011-05-31 17:03:24.703 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0125.0000 at 2011-05-31 17:03:24.783 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0191.0003 at 2011-05-31 17:03:25.110 ***
 
*** Upgrading/Checking database for Schema Version 10.03.0085.0000 at 2011-05-31 17:03:25.470 ***
 
*** Upgrading/Checking database for Schema Version 10.03.0169.0000 at 2011-05-31 17:03:25.577 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0066.0000 at 2011-05-31 17:03:25.733 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0247.0000 at 2011-05-31 17:03:25.780 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0308.0000 at 2011-05-31 17:03:25.873 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0010.0000 at 2011-05-31 17:03:26.310 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0029.0000 at 2011-05-31 17:03:27.263 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0036.0000 at 2011-05-31 17:03:27.497 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0045.0000 at 2011-05-31 17:03:27.683 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0050.0000 at 2011-05-31 17:03:27.777 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0068.0000 at 2011-05-31 17:03:28.183 ***
 
*** Upgrading/Checking database for Schema Version 11.02.0010.0000 at 2011-05-31 17:03:28.680 ***
***********************
SETTING SYSTABLEDOMAIN DATA at 2011-05-31 17:03:29.040
***********************
 
*** Upgrading/Checking database for Schema Version 12.00.0064.0000 at 2011-05-31 17:03:30 ***
  now establishing record-level security (TBL_OPPORTUNITY_ACL)...
  setting Standard Tier Opportunity security...
  (1) = 0
  (2) = 0
  (3) = 0
  (Set Private) = 0
 
*** Upgrading/Checking database for Schema Version 12.00.0075.0000 at 2011-05-31 17:03:32 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0112.0000 at 2011-05-31 17:03:32 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0117.0000 at 2011-05-31 17:03:33 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0120.0000 at 2011-05-31 17:03:35 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0148.0000 at 2011-05-31 17:03:36 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0152.0000 at 2011-05-31 17:03:38 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0160.0000 at 2011-05-31 17:03:38 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0171.0000 at 2011-05-31 17:03:39 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0196.0000 at 2011-05-31 17:03:39 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0197.0000 at 2011-05-31 17:03:39 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0213.0000 at 2011-05-31 17:03:39 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0227.0000 at 2011-05-31 17:03:39 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0239.0000 at 2011-05-31 17:03:39 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0273.0000 at 2011-05-31 17:03:40 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0306.0000 at 2011-05-31 17:03:40 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0333.0000 at 2011-05-31 17:03:40 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0367.0000 at 2011-05-31 17:03:40 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0405.0000 at 2011-05-31 17:03:40 ***
 
*** Upgrading/Checking database for Schema Version 12.10.0088.0000 at 2011-05-31 17:03:41 ***
 
*** Upgrading/Checking database for Schema Version 12.10.0126.0000 at 2011-05-31 17:03:41 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0104.0000 at 2011-05-31 17:03:41 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0105.0000 at 2011-05-31 17:03:41 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0131.0000 at 2011-05-31 17:03:41 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0162.0000 at 2011-05-31 17:03:42 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0203.0000 at 2011-05-31 17:03:42 ***
Dropping index CTL_SYSTABLEORDER_IE1 ON dbo.CTL_SYSTABLEORDER;
Creating index CTL_SYSTABLEORDER_IE1 ON dbo.CTL_SYSTABLEORDER;
 
*** Upgrading/Checking database for Schema Version 13.00.0204.0000 at 2011-05-31 17:03:42 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0215.0000 at 2011-05-31 17:03:42 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0224.0000 at 2011-05-31 17:03:42 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0225.0000 at 2011-05-31 17:03:43 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0268.0000 at 2011-05-31 17:03:43 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0322.0000 at 2011-05-31 17:03:43 ***
Modifying alias name for ISINVITATIONSENT
 
*** Upgrading/Checking database for Schema Version 13.00.0332.0000 at 2011-05-31 17:03:43 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0349.0000 at 2011-05-31 17:03:44 ***
 
*** Upgrading/Checking database for Schema Version 13.1.1.0 at 2011-05-31 17:03:44 ***
 
*** Upgrading/Checking database for Schema Version 13.1.47.0 at 2011-05-31 17:03:45 ***
Expanding DISPLAYNAME on TBL_SYSTABLE
Expanding DESCRIPTION on TBL_SYSTABLE
Expanding DISPLAYNAME on TBL_SYSCOLUMN
Expanding DESCRIPTION on TBL_SYSCOLUMN
 
*** Upgrading/Checking database for Schema Version 13.1.67.0 at 2011-05-31 17:03:45 ***
Creating ENABLEDATE on TBL_WORKFLOW_SUBSCRIPTION
 
*** Upgrading/Checking database for Schema Version 13.1.90.0 at 2011-05-31 17:03:45 ***
Alter IsDisplayed for DiscountType
 
*** Upgrading/Checking database for Schema Version 13.1.99.0 at 2011-05-31 17:03:51 ***
SETTING CTL_LOCALSTRING DATA...2011-05-31 17:03:53
DONE SETTING CTL_LOCALSTRING DATA...2011-05-31 17:03:53
***********************
SETTING TABLE METADATA at 2011-05-31 17:03:54.640
***********************
***********************
FINISHED SETTING TABLE METADATA at 2011-05-31 17:03:56.370
***********************
***********************
SETTING COLUMN METADATA at 2011-05-31 17:03:58.773
***********************
Setting syscolumn metadata for TERRITORY on TBL_COMPANY ...
Msg 2627, Level 14, State 1, Server KARLS-LT\ACT7, Line 5
Violation of UNIQUE KEY constraint 'TBL_SYSCOLUMN_AK2'. Cannot insert duplicate key in object 'dbo.TBL_SYSCOLUMN'.
The statement has been terminated.
PROCESSING ERROR OCCURRED ADDING SYSCOLUMN INFO FOR TERRITORY on TBL_COMPANY
Msg 50000, Level 16, State 1, Server KARLS-LT\ACT7, Line 32107
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 KARLS-LT\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 KARLS-LT\ACT7, Line 31
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
***********************
SETTING KEY METADATA at 2011-05-31 17:04:32.117
***********************
PROCESSING ERROR OCCURRED ADDING SYSTABLEKEY INFO FOR XPKABL_ACTIVITY on CTL_ABL_ACTIVITY
Msg 50000, Level 16, State 1, Server KARLS-LT\ACT7, Line 22
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
***********************
DONE SETTING KEY METADATA at 2011-05-31 17:04:32.240
***********************
 
FOOTER ENTRY TRANCOUNT = 0
Msg 50000, Level 25, State 1, Server KARLS-LT\ACT7, Line 19
***** Update of database failed!  Exiting from update!
Msg 2745, Level 16, State 2, Server KARLS-LT\ACT7, Line 19
Process ID 53 has raised user error 50000, severity 25. SQL Server is terminating this process.


Accepted Solutions
Solution
Accepted by topic author No Satisfaction
‎09-25-2015 03:20 AM
Copper Super Contributor
Posts: 47
Country: United States

Re: user error 50000 message when upgrading 2011Pro to 2011SP1Pro

Greg,

The data repair resolved all issues. No data was lost and I'm 100% again.

Thanks for the support!!!

Karl

View solution in original post


All Replies
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: user error 50000 message when upgrading 2011Pro to 2011SP1Pro

The reason for the error:

The update to 2011 SP1 is attempting to insert a new default field called 'Territory', your database already contains a Company field named 'Territory'. 

 

To resolve this issue:

In ACT! 2011 13.0, rename the Territory field to a new name (ex: Area or Territory1).  You will then be able to update to SP1 and convert the database.

 

Note: Always make a backup (File > Backup > Database) of your database before making changes to fields.

 

Greg Martin
Sage
Copper Super Contributor
Posts: 47
Country: United States

Re: user error 50000 message when upgrading 2011Pro to 2011SP1Pro

Hi Greg,

I changed the name of the "Territory" field to "Coverage Area" under both contacts and company, then re-installed the SP1 upgrade. While converting the file, ACT again gave me a Schema error message, different form the last one, so there is still work to be done. I assume I'll need to make further modifications to the db, so will have to de-install SP1 and re-install the basic ACT package. Please tell me where to go from here.  The schema error message content is as follows:

 

ProductVersion                 
--------------------------------
10.50.1600.1                   
SETTING DATABASE COMPATIBILITY LEVEL...
   LOCAL DATETIME: 2011-06-01 10:37:52
       SERVERNAME: KARLS-LT\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: LGActivities
           STATUS: ONLINE
   CREATE VERSION: 661
   RECOVERY MODEL: SIMPLE
     DB COLLATION: Latin1_General_CI_AS
       AUTO CLOSE: 0
      AUTO SHRINK: 1
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: 13.00.0396.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-06-01 10:37:53
  ENDTIME: 2011-06-01 10:38:21


----------------------------------------------------------------
NOW DROPPING ALL TABLE AND COLUMN TRIGGERS...
STARTTIME: 2011-06-01 10:38:21
  ENDTIME: 2011-06-01 10:38:22
SETTING TBL_SYSLOCALCOLUMN DATA...
 
 
*** Upgrading/Checking database for Schema Version 07.00.0441.0000 at 2011-06-01 10:38:26.433 ***
 
*** Upgrading/Checking database for Schema Version 07.01.0457.0000 at 2011-06-01 10:38:26.730 ***
 
*** Upgrading/Checking database for Schema Version 07.01.0473.0000 at 2011-06-01 10:38:26.870 ***
 
*** Upgrading/Checking database for Schema Version 07.03.0099.0000 at 2011-06-01 10:38:27.180 ***
 
*** Upgrading/Checking database for Schema Version 07.03.0139.0000 at 2011-06-01 10:38:27.210 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0001.0000 at 2011-06-01 10:38:27.320 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0010.0000 at 2011-06-01 10:38:27.413 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0015.0000 at 2011-06-01 10:38:27.523 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0018.0000 at 2011-06-01 10:38:27.600 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0030.0000 at 2011-06-01 10:38:27.697 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0040.0000 at 2011-06-01 10:38:27.943 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0046.0000 at 2011-06-01 10:38:28.070 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0101.0000 at 2011-06-01 10:38:28.180 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0107.0000 at 2011-06-01 10:38:28.350 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0111.0000 at 2011-06-01 10:38:28.537 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0128.0001 at 2011-06-01 10:38:28.663 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0148.0000 at 2011-06-01 10:38:28.723 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0157.0000 at 2011-06-01 10:38:28.787 ***
 
*** Upgrading/Checking database for Schema Version 08.00.0182.0000 at 2011-06-01 10:38:28.833 ***
 
*** Upgrading/Checking database for Schema Version 08.01.0057.0000 at 2011-06-01 10:38:28.960 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0017.0000 at 2011-06-01 10:38:29.053 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0030.0000 at 2011-06-01 10:38:29.303 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0039.0000 at 2011-06-01 10:38:29.460 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0040.0000 at 2011-06-01 10:38:29.723 ***
 
*** Upgrading/Checking database for Schema Version 08.02.0040.0001 at 2011-06-01 10:38:29.800 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0002.0000 at 2011-06-01 10:38:29.850 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0006.0000 at 2011-06-01 10:38:29.957 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0007.0000 at 2011-06-01 10:38:30.083 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0020.0000 at 2011-06-01 10:38:30.287 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0027.0000 at 2011-06-01 10:38:30.363 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0032.0000 at 2011-06-01 10:38:30.550 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0033.0000 at 2011-06-01 10:38:30.690 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0053.0000 at 2011-06-01 10:38:30.847 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0058.0000 at 2011-06-01 10:38:30.957 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0100.0000 at 2011-06-01 10:38:31.033 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0104.0000 at 2011-06-01 10:38:31.190 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0116.0000 at 2011-06-01 10:38:31.283 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0145.0000 at 2011-06-01 10:38:31.567 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0532.0000 at 2011-06-01 10:38:31.830 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0535.0000 at 2011-06-01 10:38:31.910 ***
 
*** Upgrading/Checking database for Schema Version 09.00.0535.0001 at 2011-06-01 10:38:32.063 ***
 
*** Upgrading/Checking database for Schema Version 09.01.0038.0000 at 2011-06-01 10:38:32.173 ***
 
*** Upgrading/Checking database for Schema Version 09.01.0068.0000 at 2011-06-01 10:38:32.610 ***
Altering table TBL_SYSCOLUMN (MIN_COLUMNLENGTH - NON-STRING)
 
*** Upgrading/Checking database for Schema Version 09.01.0121.0000 at 2011-06-01 10:38:32.797 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0003.0000 at 2011-06-01 10:38:32.843 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0008.0000 at 2011-06-01 10:38:33 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0012.0000 at 2011-06-01 10:38:33.127 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0015.0000 at 2011-06-01 10:38:33.280 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0046.0000 at 2011-06-01 10:38:33.360 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0065.0000 at 2011-06-01 10:38:33.563 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0077.0000 at 2011-06-01 10:38:33.873 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0160.0000 at 2011-06-01 10:38:34.047 ***
 
*** Upgrading/Checking database for Schema Version 10.00.0209.0000 at 2011-06-01 10:38:34.200 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0026.0000 at 2011-06-01 10:38:34.450 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0047.0000 at 2011-06-01 10:38:35.030 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0065.0000 at 2011-06-01 10:38:35.323 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0068.0000 at 2011-06-01 10:38:35.730 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0125.0000 at 2011-06-01 10:38:35.810 ***
 
*** Upgrading/Checking database for Schema Version 10.02.0191.0003 at 2011-06-01 10:38:36.150 ***
 
*** Upgrading/Checking database for Schema Version 10.03.0085.0000 at 2011-06-01 10:38:36.370 ***
 
*** Upgrading/Checking database for Schema Version 10.03.0169.0000 at 2011-06-01 10:38:36.557 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0066.0000 at 2011-06-01 10:38:37.027 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0247.0000 at 2011-06-01 10:38:37.230 ***
 
*** Upgrading/Checking database for Schema Version 11.00.0308.0000 at 2011-06-01 10:38:37.710 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0010.0000 at 2011-06-01 10:38:38.147 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0029.0000 at 2011-06-01 10:38:38.790 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0036.0000 at 2011-06-01 10:38:39.147 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0045.0000 at 2011-06-01 10:38:39.320 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0050.0000 at 2011-06-01 10:38:39.443 ***
 
*** Upgrading/Checking database for Schema Version 11.01.0068.0000 at 2011-06-01 10:38:39.770 ***
 
*** Upgrading/Checking database for Schema Version 11.02.0010.0000 at 2011-06-01 10:38:40.473 ***
***********************
SETTING SYSTABLEDOMAIN DATA at 2011-06-01 10:38:40.753
***********************
 
*** Upgrading/Checking database for Schema Version 12.00.0064.0000 at 2011-06-01 10:38:41 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0075.0000 at 2011-06-01 10:38:41 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0112.0000 at 2011-06-01 10:38:42 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0117.0000 at 2011-06-01 10:38:42 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0120.0000 at 2011-06-01 10:38:42 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0148.0000 at 2011-06-01 10:38:43 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0152.0000 at 2011-06-01 10:38:44 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0160.0000 at 2011-06-01 10:38:44 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0171.0000 at 2011-06-01 10:38:44 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0196.0000 at 2011-06-01 10:38:44 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0197.0000 at 2011-06-01 10:38:44 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0213.0000 at 2011-06-01 10:38:44 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0227.0000 at 2011-06-01 10:38:45 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0239.0000 at 2011-06-01 10:38:45 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0273.0000 at 2011-06-01 10:38:45 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0306.0000 at 2011-06-01 10:38:45 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0333.0000 at 2011-06-01 10:38:45 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0367.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 12.00.0405.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 12.10.0088.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 12.10.0126.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0104.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0105.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0131.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0162.0000 at 2011-06-01 10:38:46 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0203.0000 at 2011-06-01 10:38:47 ***
Dropping index CTL_SYSTABLEORDER_IE1 ON dbo.CTL_SYSTABLEORDER;
Creating index CTL_SYSTABLEORDER_IE1 ON dbo.CTL_SYSTABLEORDER;
 
*** Upgrading/Checking database for Schema Version 13.00.0204.0000 at 2011-06-01 10:38:47 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0215.0000 at 2011-06-01 10:38:47 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0224.0000 at 2011-06-01 10:38:47 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0225.0000 at 2011-06-01 10:38:47 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0268.0000 at 2011-06-01 10:38:47 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0322.0000 at 2011-06-01 10:38:47 ***
Modifying alias name for ISINVITATIONSENT
 
*** Upgrading/Checking database for Schema Version 13.00.0332.0000 at 2011-06-01 10:38:48 ***
 
*** Upgrading/Checking database for Schema Version 13.00.0349.0000 at 2011-06-01 10:38:48 ***
 
*** Upgrading/Checking database for Schema Version 13.1.1.0 at 2011-06-01 10:38:48 ***
 
*** Upgrading/Checking database for Schema Version 13.1.47.0 at 2011-06-01 10:38:49 ***
Expanding DISPLAYNAME on TBL_SYSTABLE
Expanding DESCRIPTION on TBL_SYSTABLE
Expanding DISPLAYNAME on TBL_SYSCOLUMN
Expanding DESCRIPTION on TBL_SYSCOLUMN
 
*** Upgrading/Checking database for Schema Version 13.1.67.0 at 2011-06-01 10:38:49 ***
Creating ENABLEDATE on TBL_WORKFLOW_SUBSCRIPTION
 
*** Upgrading/Checking database for Schema Version 13.1.90.0 at 2011-06-01 10:38:49 ***
Alter IsDisplayed for DiscountType
 
*** Upgrading/Checking database for Schema Version 13.1.99.0 at 2011-06-01 10:38:54 ***
SETTING CTL_LOCALSTRING DATA...2011-06-01 10:38:55
DONE SETTING CTL_LOCALSTRING DATA...2011-06-01 10:38:55
***********************
SETTING TABLE METADATA at 2011-06-01 10:38:57.117
***********************
***********************
FINISHED SETTING TABLE METADATA at 2011-06-01 10:38:58.880
***********************
***********************
SETTING COLUMN METADATA at 2011-06-01 10:39:08.770
***********************
Setting syscolumn metadata for TERRITORY on TBL_COMPANY ...
Setting syscolumn metadata for REGION on TBL_COMPANY ...
Msg 2627, Level 14, State 1, Server KARLS-LT\ACT7, Line 5
Violation of UNIQUE KEY constraint 'TBL_SYSCOLUMN_AK2'. Cannot insert duplicate key in object 'dbo.TBL_SYSCOLUMN'.
The statement has been terminated.
PROCESSING ERROR OCCURRED ADDING SYSCOLUMN INFO FOR REGION on TBL_COMPANY
Msg 50000, Level 16, State 1, Server KARLS-LT\ACT7, Line 32158
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 KARLS-LT\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 KARLS-LT\ACT7, Line 31
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
***********************
SETTING KEY METADATA at 2011-06-01 10:39:24.013
***********************
PROCESSING ERROR OCCURRED ADDING SYSTABLEKEY INFO FOR XPKABL_ACTIVITY on CTL_ABL_ACTIVITY
Msg 50000, Level 16, State 1, Server KARLS-LT\ACT7, Line 22
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
***********************
DONE SETTING KEY METADATA at 2011-06-01 10:39:24.137
***********************
 
FOOTER ENTRY TRANCOUNT = 0
Msg 50000, Level 25, State 1, Server KARLS-LT\ACT7, Line 19
***** Update of database failed!  Exiting from update!
Msg 2745, Level 16, State 2, Server KARLS-LT\ACT7, Line 19
Process ID 61 has raised user error 50000, severity 25. SQL Server is terminating this process.

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: user error 50000 message when upgrading 2011Pro to 2011SP1Pro

This time it is hitting your field named 'Region'.  The same steps to rename it will work; however, if you'd like to submit your database to our Database Services group - they will correct and update the database for you (no charge for this).  Database Services can be reached via the information at: Database Services.

 

Note: I didn't suggest Database Services last time because you already had V13.0 reinstalled.  This time DB Services may save you some time and effort.

Greg Martin
Sage
Copper Super Contributor
Posts: 47
Country: United States

Re: user error 50000 message when upgrading 2011Pro to 2011SP1Pro

Greg,

Shortly after receiving your latest post, I submitted the working db to the repair center as you suggested, to make the necessary corrections. I'm concerned that they may overlook the second post, "Lost History Functional​ity & No Activity Clearing Options for 2011 Pro," and the need to resolve that matter as well. I'll post again as soon as I get the file back.

Karl

 

Solution
Accepted by topic author No Satisfaction
‎09-25-2015 03:20 AM
Copper Super Contributor
Posts: 47
Country: United States

Re: user error 50000 message when upgrading 2011Pro to 2011SP1Pro

Greg,

The data repair resolved all issues. No data was lost and I'm 100% again.

Thanks for the support!!!

Karl