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.
