web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member 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 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 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans