Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Trying to upgrade to G...
Microsoft Dynamics GP (Archived)

Trying to upgrade to GP 2016 R2

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I'm trying to upgrade from GP 2015 R2 to GP 2016 R2, but am running into an issue.  If  I run this

SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID
FROM DYNAMICS.dbo.DU000030 a
JOIN
DYNAMICS.dbo.DU000010 b
ON a.fileNumber = b.fileNumber
AND a.PRODID = b.PRODID
JOIN
DYNAMICS.dbo.SY01500 c
ON a.companyID = c.CMPANYID
WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15


I get this:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'P310PO30'.                                                                                                                                                                         

Has anyone seen this before?

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trying to upgrade to GP 2016 R2

    I guess I should flesh this out a little more.

    I was able to get the upgrade complete, but it took some work.  SQL Replication was still enabled, so I had to remove that (looking in dexsql.log told me that) and after that, I just had to bring POP30310 in from a backup (I have no idea why it was removed)

    After that, I was good to go.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Trying to upgrade to GP 2016 R2

    Hi,

    I also have gone from 2015R2 to 2016R2 without issue. The POP30310 table does get updated with 16R2. Look in your DU000010 table in the Dynamics (or whatever you've named it) database for both the 'POP30310' table and the 'P310PO30' table. You should not have a table named 'P310PO30'. I would be inclined to change the table name to 'POP30310' if one turns up and I didn't have a 'POP30310' entry. I'm certainly no SQL expert, but I do not know why the statement you posted would generate the error. You're not referencing that table in your query, so I'm not sure why it would care.

    As Richard suggested, I would also look in my company database and see if I had either table.

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Trying to upgrade to GP 2016 R2

    I would look in your company database for a table by this name. If it is there I would rename it to POP30310. I would also correct this in the DUOS tables. I would imagine that you do not process purchase orders. After the upgrade it would be a good idea to use the SQL maintenance utility to drop and create this table.

  • GMA Profile Picture
    GMA 1,072 on at
    RE: Trying to upgrade to GP 2016 R2

    That doesn't look list a valid object in GP. "P310PO30" looks like a mangled version of POP30310 (receipt line history). You may want to review those tables individually to ensure there isn't corrupt data.

    But no, I haven't seen that. I have performed a test upgrade (GP 2013SP2 to GP2016) without issues.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans