Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problems upgrading DB to ACT 2010 from ACT 2009

Tuned Listener
Posts: 19
Country: Canada

Problems upgrading DB to ACT 2010 from ACT 2009

Hello, I have a laptop running Windows XP SP3 running ACT 2010 connecting back to a main database, which has 25 users.

 

All other users have upgraded successfully,  I've already attempted to uninstall and reinstall ACT and SQL 2005.

 

When the database is upgraded, it throws an error about a schema exception and then displays this text file:

 


 

 

LOCAL DATETIME: 2010-02-26 10:13:15 SERVERNAME: SALES18\ACT7 ENGINE EDITION: 4 Express Edition PRODUCT VERSION: 9.00.4035.00 (SP3) SERVER COLLATION: Latin1_General_CI_AS ------------------------------------------------------------------------------ SYNC ENABLED: True SYNC ROLE: SUBSCRIBER ------------------------------------------------------------------------------ DATABASE: SALESMANSDB STATUS: ONLINE CREATE VERSION: 611 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 ProductVersion -------------------------------- 9.00.4035.00 Configuration option 'user instances enabled' changed from 0 to 0. Run the RECONFIGURE statement to install. ------------------------------------------------------------- CURRENT BUILD: 11.00.0348.0000 UPDATE BUILD: 12.00.0405.0000 ------------------------------------------------------------- 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. SETTING DATABASE COMPATIBILITY LEVEL... DBCC execution completed. If DBCC printed error messages, contact your system administrator. create_date compatibility_level user_access_desc recovery_model_desc ----------------------- ------------------- ------------------------------------------------------------ ------------------------------------------------------------ 2010-02-26 10:11:31.880 90 MULTI_USER SIMPLE ------------------------------------------------------------- NOW DROPPING ALL SYNC UPDATE TRIGGERS... (PRIOR VERSION = 11.00.0348.0000) STARTTIME: 2010-02-26 10:13:16 ENDTIME: 2010-02-26 10:13:24 ---------------------------------------------------------------- NOW DROPPING ALL TABLE AND COLUMN TRIGGERS... STARTTIME: 2010-02-26 10:13:25 ENDTIME: 2010-02-26 10:13:25 SETTING TBL_SYSLOCALCOLUMN DATA... *** Upgrading/Checking database for Schema Version 07.00.0441.0000 at 2010-02-26 10:13:26.323 *** *** Upgrading/Checking database for Schema Version 07.01.0457.0000 at 2010-02-26 10:13:26.427 *** *** Upgrading/Checking database for Schema Version 07.01.0473.0000 at 2010-02-26 10:13:26.440 *** *** Upgrading/Checking database for Schema Version 07.03.0099.0000 at 2010-02-26 10:13:26.507 *** *** Upgrading/Checking database for Schema Version 07.03.0139.0000 at 2010-02-26 10:13:26.513 *** *** Upgrading/Checking database for Schema Version 08.00.0001.0000 at 2010-02-26 10:13:26.540 *** *** Upgrading/Checking database for Schema Version 08.00.0010.0000 at 2010-02-26 10:13:26.577 *** *** Upgrading/Checking database for Schema Version 08.00.0015.0000 at 2010-02-26 10:13:26.593 *** *** Upgrading/Checking database for Schema Version 08.00.0018.0000 at 2010-02-26 10:13:26.620 *** *** Upgrading/Checking database for Schema Version 08.00.0030.0000 at 2010-02-26 10:13:26.637 *** *** Upgrading/Checking database for Schema Version 08.00.0040.0000 at 2010-02-26 10:13:26.710 *** Removing index CTL_SYNCROW_FILE_IE1... *** Upgrading/Checking database for Schema Version 08.00.0046.0000 at 2010-02-26 10:13:27.053 *** *** Upgrading/Checking database for Schema Version 08.00.0101.0000 at 2010-02-26 10:13:27.090 *** *** Upgrading/Checking database for Schema Version 08.00.0107.0000 at 2010-02-26 10:13:27.133 *** *** Upgrading/Checking database for Schema Version 08.00.0111.0000 at 2010-02-26 10:13:27.190 *** *** Upgrading/Checking database for Schema Version 08.00.0128.0001 at 2010-02-26 10:13:27.223 *** *** Upgrading/Checking database for Schema Version 08.00.0148.0000 at 2010-02-26 10:13:27.240 *** *** Upgrading/Checking database for Schema Version 08.00.0157.0000 at 2010-02-26 10:13:27.260 *** *** Upgrading/Checking database for Schema Version 08.00.0182.0000 at 2010-02-26 10:13:27.273 *** *** Upgrading/Checking database for Schema Version 08.01.0057.0000 at 2010-02-26 10:13:27.503 *** *** Upgrading/Checking database for Schema Version 08.02.0017.0000 at 2010-02-26 10:13:27.517 *** Re-instating Standard Permission for Delete Activity Series (Workgroup)... *** Upgrading/Checking database for Schema Version 08.02.0030.0000 at 2010-02-26 10:13:27.680 *** *** Upgrading/Checking database for Schema Version 08.02.0039.0000 at 2010-02-26 10:13:27.710 *** Altering table TBL_ACTIVITY (Fixing any Endtime records) *** Upgrading/Checking database for Schema Version 08.02.0040.0000 at 2010-02-26 10:13:28.113 *** *** Upgrading/Checking database for Schema Version 08.02.0040.0001 at 2010-02-26 10:13:28.163 *** *** Upgrading/Checking database for Schema Version 09.00.0002.0000 at 2010-02-26 10:13:28.180 *** *** Upgrading/Checking database for Schema Version 09.00.0006.0000 at 2010-02-26 10:13:28.197 *** *** Upgrading/Checking database for Schema Version 09.00.0007.0000 at 2010-02-26 10:13:28.243 *** *** Upgrading/Checking database for Schema Version 09.00.0020.0000 at 2010-02-26 10:13:28.370 *** *** Upgrading/Checking database for Schema Version 09.00.0027.0000 at 2010-02-26 10:13:28.400 *** *** Upgrading/Checking database for Schema Version 09.00.0032.0000 at 2010-02-26 10:13:28.610 *** *** Upgrading/Checking database for Schema Version 09.00.0033.0000 at 2010-02-26 10:13:28.623 *** *** Upgrading/Checking database for Schema Version 09.00.0053.0000 at 2010-02-26 10:13:28.640 *** *** Upgrading/Checking database for Schema Version 09.00.0058.0000 at 2010-02-26 10:13:28.660 *** *** Upgrading/Checking database for Schema Version 09.00.0100.0000 at 2010-02-26 10:13:28.690 *** *** Upgrading/Checking database for Schema Version 09.00.0104.0000 at 2010-02-26 10:13:28.727 *** *** Upgrading/Checking database for Schema Version 09.00.0116.0000 at 2010-02-26 10:13:28.750 *** *** Upgrading/Checking database for Schema Version 09.00.0145.0000 at 2010-02-26 10:13:28.790 *** *** Upgrading/Checking database for Schema Version 09.00.0532.0000 at 2010-02-26 10:13:28.860 *** *** Upgrading/Checking database for Schema Version 09.00.0535.0000 at 2010-02-26 10:13:28.877 *** *** Upgrading/Checking database for Schema Version 09.00.0535.0001 at 2010-02-26 10:13:28.923 *** *** Upgrading/Checking database for Schema Version 09.01.0038.0000 at 2010-02-26 10:13:28.933 *** *** Upgrading/Checking database for Schema Version 09.01.0068.0000 at 2010-02-26 10:13:29.353 *** *** Upgrading/Checking database for Schema Version 09.01.0121.0000 at 2010-02-26 10:13:29.450 *** *** Upgrading/Checking database for Schema Version 10.00.0003.0000 at 2010-02-26 10:13:29.480 *** *** Upgrading/Checking database for Schema Version 10.00.0008.0000 at 2010-02-26 10:13:29.520 *** *** Upgrading/Checking database for Schema Version 10.00.0012.0000 at 2010-02-26 10:13:29.573 *** *** Upgrading/Checking database for Schema Version 10.00.0015.0000 at 2010-02-26 10:13:29.643 *** *** Upgrading/Checking database for Schema Version 10.00.0046.0000 at 2010-02-26 10:13:29.677 *** *** Upgrading/Checking database for Schema Version 10.00.0065.0000 at 2010-02-26 10:13:29.820 *** *** Upgrading/Checking database for Schema Version 10.00.0077.0000 at 2010-02-26 10:13:32.377 *** Dropping VIEW VWT_COMPANYACCESS... Dropping VIEW VWT_GROUPACCESS... *** Upgrading/Checking database for Schema Version 10.00.0160.0000 at 2010-02-26 10:13:32.463 *** *** Upgrading/Checking database for Schema Version 10.00.0209.0000 at 2010-02-26 10:13:32.507 *** *** Upgrading/Checking database for Schema Version 10.02.0026.0000 at 2010-02-26 10:13:32.623 *** *** Upgrading/Checking database for Schema Version 10.02.0047.0000 at 2010-02-26 10:13:32.910 *** *** Upgrading/Checking database for Schema Version 10.02.0065.0000 at 2010-02-26 10:13:33.057 *** *** Upgrading/Checking database for Schema Version 10.02.0068.0000 at 2010-02-26 10:13:33.073 *** *** Upgrading/Checking database for Schema Version 10.02.0125.0000 at 2010-02-26 10:13:33.100 *** *** Upgrading/Checking database for Schema Version 10.02.0191.0003 at 2010-02-26 10:13:33.177 *** *** Upgrading/Checking database for Schema Version 10.03.0085.0000 at 2010-02-26 10:13:33.253 *** *** Upgrading/Checking database for Schema Version 10.03.0169.0000 at 2010-02-26 10:13:33.283 *** *** Upgrading/Checking database for Schema Version 11.00.0066.0000 at 2010-02-26 10:13:33.323 *** *** Upgrading/Checking database for Schema Version 11.00.0247.0000 at 2010-02-26 10:13:33.350 *** *** Upgrading/Checking database for Schema Version 11.00.0308.0000 at 2010-02-26 10:13:33.383 *** *** Upgrading/Checking database for Schema Version 11.01.0010.0000 at 2010-02-26 10:13:33.443 *** Creating table TBL_CONTACT_CONTACT ... Dropping table TBL_CONTACT_RELATION ... IF EXISTS (SELECT 1 FROM sysobjects WHERE id = OBJECT_ID('dbo.VRP_CONTACT_RELATION')) DROP VIEW dbo.VRP_CONTACT_RELATIONIF EXISTS (SELECT 1 FROM sysobjects WHERE id = OBJECT_ID('dbo.FNB_CONTACT_RELATION')) DROP FUNCTION dbo.FNB_CONTACT_RELATION Adding column ROLETYPENUM to TBL_SYSENTITYRELATION ... Adding column HASCREATEEDIT to TBL_SYSENTITYRELATION ... Adding column HASDETAILS to TBL_SYSENTITYRELATION ... Adding column ISCUSTOM to TBL_SYSENTITYRELATION ... Adding column RELATIONID to TBL_SYSTABLERELATION ... *** Upgrading/Checking database for Schema Version 11.01.0029.0000 at 2010-02-26 10:13:34.913 *** Adding column DETAILS to TBL_IMPORT_HISTORY ... Adding column NAME to TBL_IMPORT_HISTORY ... Update syscolumn metadata for TBL_IMPORT_HISTORY ... Creating table TBL_IMPORT_HISTORYITEM ... Creating index TBL_IMPORT_HISTORYITEM_IF1 Creating index TBL_IMPORT_HISTORYITEM_IE1 *** Upgrading/Checking database for Schema Version 11.01.0036.0000 at 2010-02-26 10:13:35.020 *** Adding column IMPORTDATE to TBL_CONTACT ... Adding column IMPORTDATE to TBL_COMPANY ... Adding column IMPORTDATE to TBL_GROUP ... *** Upgrading/Checking database for Schema Version 11.01.0045.0000 at 2010-02-26 10:13:35.067 *** Adding a default value for column ISMEMBER to TBL_GROUP_OPPORTUNITY ... *** Upgrading/Checking database for Schema Version 11.01.0050.0000 at 2010-02-26 10:13:35.087 *** Moving data from externalmap to historyitem Moving data from externalmap to historyitem Dropping table TBL_COMPANY_EXTERNALMAP ... Dropping table TBL_CONTACT_EXTERNALMAP ... Dropping table TBL_GROUP_EXTERNALMAP ... *** Upgrading/Checking database for Schema Version 11.01.0068.0000 at 2010-02-26 10:13:35.260 *** Altering table TBL_SYSENTITY, adding ISDEFINEFIELD... Adding ISDISPLAYED to TBL_SYSENTITY... *** Upgrading/Checking database for Schema Version 11.01.0094.0000 at 2010-02-26 10:13:35.320 *** Altering CTL_DBCONFIG DATETIME formats... SECTION NAME CONFIGVALUE CREATEDATE EDITDATE -------------------------------- -------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------ ----------------------- ----------------------- DATABASE CREATE DATE 2009-05-15 16:04:22 2009-05-15 15:43:38.450 NULL DATABASE ORIGINAL SCHEMA DATE 2009-05-15 15:43:38.450 2009-05-15 15:43:38.450 NULL DATABASE SCHEMA DATE 2009-05-15 15:43:38.450 2009-05-15 15:43:38.450 NULL MAINTENANCE LOCK EFFECTIVE 2010-02-26 17:13:11.760 2009-05-15 15:43:38.450 2010-02-26 17:13:11.760 SYNC LAST SUCCESS DATE 2010-02-20 02:45:14.357 2009-05-15 15:43:38.450 2010-02-20 02:56:02.577 SYNC LOG RETAIN DATE 2009-05-15 16:04:22 2009-05-15 15:43:38.450 2010-02-26 17:11:37.057 SECTION NAME CONFIGVALUE CREATEDATE EDITDATE -------------------------------- -------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------ ----------------------- ----------------------- DATABASE CREATE DATE 2009-05-15T16:04:22 2009-05-15 15:43:38.450 NULL DATABASE ORIGINAL SCHEMA DATE 2009-05-15T15:43:38.450 2009-05-15 15:43:38.450 NULL DATABASE SCHEMA DATE 2009-05-15T15:43:38.450 2009-05-15 15:43:38.450 NULL MAINTENANCE LOCK EFFECTIVE 2010-02-26T17:13:11.760 2009-05-15 15:43:38.450 2010-02-26 17:13:11.760 SYNC LAST SUCCESS DATE 2010-02-20T02:45:14.357 2009-05-15 15:43:38.450 2010-02-20 02:56:02.577 SYNC LOG RETAIN DATE 2009-05-15T16:04:22 2009-05-15 15:43:38.450 2010-02-26 17:11:37.057 *** Upgrading/Checking database for Schema Version 11.01.0178.0000 at 2010-02-26 10:13:35 *** Truncating sync data tables... LogonHistory cleanup... ErrorNumber ErrorMessage RETURNED_TRANCNT ----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ ---------------- 8630 Internal Query Processor Error: The query processor encountered an unexpected error during execution. 1 PROCESSING ERROR OCCURRED IN BUILD 11.01.0178.0000! Msg 50000, Level 16, State 1, Server SALES18\ACT7, Line 83 WORK WAS ROLLED BACK - EXITING FROM UPDATE! HResult 0xCF, Level 16, State 1 Invalid column name 'ISDISPLAYED'. *********************** SETTING SYSTABLEDOMAIN DATA at 2010-02-26 10:13:48.070 *********************** *** Upgrading/Checking database for Schema Version 12.00.0064.0000 at 2010-02-26 10:13:48 *** Dropping ACTUALAMT constraints on TBL_OPPORTUNITY Dropping Column Constraints for table : PROCESSING ERROR OCCURRED IN BUILD 12.00.0064.0000! Msg 50000, Level 16, State 1, Server SALES18\ACT7, Line 48 WORK WAS ROLLED BACK - EXITING FROM UPDATE! FOOTER ENTRY TRANCOUNT = 0 Msg 50000, Level 25, State 1, Server SALES18\ACT7, Line 19 ***** Update of database failed! Exiting from update! Msg 2745, Level 16, State 2, Server SALES18\ACT7, Line 19 Process ID 52 has raised user error 50000, severity 25. SQL Server is terminating this process.

 

 

Tuned Listener
Posts: 19
Country: Canada

Re: Problems upgrading DB to ACT 2010 from ACT 2009

I recut the remote database and transferred to the station, good thing it was at the office because it would not take the new 2008 database on SQL 2005 and had to uninstall 2005 express and install 2008 express.  Would have been nice to know, but ultimately did not affect the operation as the laptop was at the office.

 

Good day

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Problems upgrading DB to ACT 2010 from ACT 2009

There was obviously an issue with the database preventing the schema update.

 

The good thing is Sage will do the updates free if this happens... but best to just recut the remote as you did

Tuned Listener
Posts: 19
Country: Canada

Re: Problems upgrading DB to ACT 2010 from ACT 2009

[ Edited ]

Hi Mike, could you address the issue I had with recutting the database?

 

ie upgraded server DB to 2008 and now I can't use 2005 express on clients?

 

Thanks

Brandon

 

EDIT: all existing clients who upgraded their DBs are working fine so right now there is no problem, but if I have to recut their DB then they will have to upgrade to SQL 2008, is that correct?

Message Edited by guardianchem on 03-02-2010 04:10 PM
Copper Elite Contributor
Posts: 233
Country: USA

Re: Problems upgrading DB to ACT 2010 from ACT 2009

Brandon,

 

If the sever is running SQL 2008, and client machines are running SQL 2005 express, and all you want to do is have them access the database across the network this is fine. You don't need to update the clients to SQL 2008 express.

 

But if you want to Sync databases, the SQL version needs to be the same on the server and the work station. So if your running SQL 2008 express on the server and you cut a remote database, the machine you want to unpack the remote on needs to be running SQL 2008 express.

 

Is that what you were asking?

Kurt Rosemann

Platinum Act! Consultants
Kurt@ActiveSales.net | www.ActiveSales.net | 877-569-8005
Tuned Listener
Posts: 19
Country: Canada

Re: Problems upgrading DB to ACT 2010 from ACT 2009

Hi Kurt, can you please provide instruction for downgrading the server to SQL 2005?

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Problems upgrading DB to ACT 2010 from ACT 2009

Brandon,

Unfortunately, once a SQL database has been converted to SQL 2008, then it cannot go back to SQL 2005. If you would like to move forward with updating the remote machines to SQL 2008, then please see the following Knowledgebase article:

 

How to Upgrade an Existing ACT! by Sage Premium 2010 ACT7 instance to Microsoft® SQL Server® 2008

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Tuned Listener
Posts: 19
Country: Canada

Re: Problems upgrading DB to ACT 2010 from ACT 2009

Thanks Greg, so all clients need to be upgraded to SQL 2008 Standard, doesn't this break your license with Microsoft?
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Problems upgrading DB to ACT 2010 from ACT 2009

Actually, the client machines need to be updated to SQL 2008 Express, which is the free version. You can get this from your ACT! disk or download from Microsoft. This is not in violation of the Microsoft EULA. As a rule, you should not install SQL Standard on a client-class operating system, only on server-class operating system. SQL 2008 Express will work with SQL 2008 Standard.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Tuned Listener
Posts: 19
Country: Canada

Re: Problems upgrading DB to ACT 2010 from ACT 2009

Ok, can you provide instruction for this process, the link you sent me was instructions for SQL 2008 standard included on DVD #3?

 

There is an EXE on DVD #1 that says SQLEXPR but it looks like SQL 2005, can you provide the download link from Microsoft or Sage or whoever?