Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Error upgrading to GP 2013

(0) ShareShare
ReportReport
Posted on by 270

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error upgrading to GP 2013

    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.

  • Tricia Mummert Profile Picture
    Tricia Mummert 270 on at
    RE: Error upgrading to GP 2013

    The Tenant Services documentation states to install TS first, then GP.  If I don't get a resolution to this, I will try that.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error upgrading to GP 2013

    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.

  • Tricia Mummert Profile Picture
    Tricia Mummert 270 on at
    RE: Error upgrading to GP 2013

    Yes, I did.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error upgrading to GP 2013

    I'm just checking.  Did you apply the Dex_req.sql and Grant.sql on the new server?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans