I'm upgrading a client from GP 10.00.1868 to 12.00.1412 on a new server. I'm also trying to test using Tenant Services since this client has 2 instances of GP due to different account frameworks. They only have 3 GP users, so I believe that a single-server deployment would be sufficient. To that end, I installed Tenant Services and the first GP 2013 instance on the new server. I named the system database DYNSOUTH. I restored their 10.00.1868 DYNAMICS database to this database and changed the SQL Compatibility Level to SQL Server 2008 as well as the dbowner to 'DYNSA'.
I ran into this error first:
The following SQL statement produced an error:
if exists (select * from sysobjects where id = object_id('dbo.GPS_CHAR') and sysstat & 0xf = 6) drop default dbo.GPS_CHAR
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]The default 'dbo.GPS_CHAR' cannot be dropped because it is bound to one or more column
I didn't see any info I could use in the DEXSQL.log file, so I tried running GP Utilities again. This time it noted that a previous upgrade failed and proceeds through the upgrade until it hits this error:
The following SQL statement produced an error:
CREATE VIEW [dbo].[smUsersLoggedIn] as ( select ACTIVITY.USERID as 'USERID', SY01400.UserType as 'UserType', SY01400.UserStatus as 'UserStatus' from ACTIVITY left outer join SY01400 ON (SY01400.USERID = ACTIVITY.USERID) )
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'UserType'.
The DEXSQL.log noted the following: [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'DYNSOUTH.dbo.zDP_duLCKF_1'.*/. Upon further inspection, I noted that all of the zDP_duLCK* stored procedures were missing from my DYNSOUTH database. I have another instance of GP 2013 that I scripted those stored procedures from and ran them against the DYNSOUTH database.
Then I tried to run GP Utilities again. I still get the error about the smUsersLoggedIn view. When I look in the DYNSOUTH database in SY01400, neither the UserType nor the UserStatus fields exist from GP 10.
How do I resolve this? I'm hoping for a workaround other than to apply another hotfix or service pack on their exisiting GP version given that it takes 30 hours to upgrade the company databases on their old server.
*This post is locked for comments
Test the GP upgrade, 10 -> 2013, first to check if there's any problem. If not, then you can be sure that the errors were somehow caused by the TS.
The Tenant Services documentation states to install TS first, then GP. If I don't get a resolution to this, I will try that.
What I understand you installed both Tenant Services (for testing) and GP2013, and then ran GP Utilities which caused errors. Can you scrap the whole setup and start new? Try GP2013 setup first until everything works out then add the Tenant service. I've done lots of "Moving to New Server" setups and have never had any problem.
Yes, I did.
I'm just checking. Did you apply the Dex_req.sql and Grant.sql on the new server?
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156