Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL Error while applyi...
Microsoft Dynamics GP (Archived)

SQL Error while applying V90 SP4

(0) ShareShare
ReportReport
Posted on by Bron 4,887

My client is trying to apply V90 SP4 (build 9.00.0385).

They are on build 9.00.0372 (SP3 - I think).

They have 9 different databases.

During the Upgrade of company databases - the main database throws a SQL error as follows:

"the stored procedure smbindtabledefaults returned the following results DBMS: 15101, Microsoft Dynamics GP 0"

 Most companies do upgrade without problems - so data in the main company is culprit.

Has anyone seen this error? I found nothing on PartnerSource.

Thanks in advance........

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: SQL Error while applying V90 SP4

    Hi Bron, 

    Yes, change the dex.ini to record the Dexsql log. You could be right on the Date/Time stamp issue. I haven't come across it before. I don't think the checklinks would resolve but I don't know for sure so its worth trying...and I have no idea about the in between builds. You could try David Musgrave or Mariano Gomez on this one - they usually have ideas / solutions on this kind of thing.

    Post the results of the dex log when you get it.

    Ian.

  • Bron Profile Picture
    Bron 4,887 on at
    Re: Re: SQL Error while applying V90 SP4

    Basically - I will have to change the dex.ini to create the log and then filter through the log to where it errors?

    Then I will have to decide - try to fix or restore dynamics and the company database...........

    I was hoping somebody may have encoutnered this on a particular table. I think the system is trying to convert a date column into a date/time column - as you know in GP they starting doing date/time stamps on some of the tables (SOP for example) at some point in time.

    In the past - i've had incredible luck applying service packs - normally everything works great.

    Do you think a checklinks on all series if done right before the upgrade might eliminate this error?

    Also - I was wondering if there is a build between .0372 and .0385 that I could deploy and see if this error re-occurs....

    Just wondering........

    Thanks for your assistance........your advice is always spot on..........

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: SQL Error while applying V90 SP4

    That sproc is in the Dynamics database, but the table that is causing the issue is probably in your main company alright. You will need to get a dexsql log for the upgrade process to see which table this is before you can debug the problem.

    Best regards,

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans