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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Database not found GP ...
Microsoft Dynamics GP (Archived)

Database not found GP 2010

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator
Here is one I have never seen before. Client had a sales batch stuck in posting. Did the usual to get it back. Now when I attempt to post it, for every invoice in the batch I get these messages: SQL Error : 911 GPS Error : 10 ODBC Error: 08004 Database AAAAUpdate does not exist where AAAAA is the GP company INTERID Now SQL Error 911 means no entry found meaning the database does not exist. But why is it looking for a database called AAAAAUpdate? How do I correct this? I will be running SQL Profiler later today after everyone has left for the day.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Database not found GP 2010

    Hi Richard,

    That is indeed weird.  Have you tried checking the INTERID of the transactions in the header table?  Perhaps someone else updated it incorrectly?  

    You can also try running Check Links against the Work logical tables (not sure if this is on RM or Sales) for this module which may re-create the header information.

    Do let me know how this goes please.  Quite interested on what happened and possible solution!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Database not found GP 2010

    use AAAAA

    UPDATE PM20000

     SET PM20000.TRXDSCRN = RTrim(SOP30200.SOPNUMBE)+' - '+RTrim(SOP30200.CUSTNMBR)

     FROM (SOP30200 INNER JOIN SOP30300 ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE)

       INNER JOIN (((SOP60100 INNER JOIN POP10500

         ON (SOP60100.ORD = POP10500.POLNENUM) AND (SOP60100.PONUMBER = POP10500.PONUMBER))

           INNER JOIN POP30300 ON POP10500.POPRCTNM = POP30300.POPRCTNM)

             INNER JOIN PM20000 ON POP30300.VNDDOCNM = PM20000.DOCNUMBR)

               ON (SOP30200.ORIGNUMB = SOP60100.SOPNUMBE) AND (SOP30300.LNITMSEQ = SOP60100.LNITMSEQ)

               WHERE LEN(PM20000.TRXDSCRN) = 0

    AND POP30300.VNDDOCNM=PM20000.DOCNUMBR

    AND PM20000.VENDORID = POP30300.VENDORID

    AND SOP10100.SOPNUMBE = '578621'

    This is what actually got sent to SQL

    use AAAAAUPDATE PM20000

     SET PM20000.TRXDSCRN = RTrim(SOP30200.SOPNUMBE)+' - '+RTrim(SOP30200.CUSTNMBR)

     FROM (SOP30200 INNER JOIN SOP30300 ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE)

       INNER JOIN (((SOP60100 INNER JOIN POP10500

         ON (SOP60100.ORD = POP10500.POLNENUM) AND (SOP60100.PONUMBER = POP10500.PONUMBER))

           INNER JOIN POP30300 ON POP10500.POPRCTNM = POP30300.POPRCTNM)

             INNER JOIN PM20000 ON POP30300.VNDDOCNM = PM20000.DOCNUMBR)

               ON (SOP30200.ORIGNUMB = SOP60100.SOPNUMBE) AND (SOP30300.LNITMSEQ = SOP60100.LNITMSEQ)

               WHERE LEN(PM20000.TRXDSCRN) = 0

    AND POP30300.VNDDOCNM=PM20000.DOCNUMBR

    AND PM20000.VENDORID = POP30300.VENDORID

    AND SOP10100.SOPNUMBE = '578621'

    Look at the first line: use AAAAAUPDATE PM20000  -- What is causing this?

    It is only this batch having this problem. All other sales batches posted fine today.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Database not found GP 2010

    OK, now the skies are becoming clear. I just happened to check out the SOP10100 table and much to my surprise someone has attached triggers to it. So for now, I will stop everything until I get told why those triggers are there and what do they do.

    Upon preliminary review they are writing data out to the eConnectOut table but that is as far as I want to go right now. Before I start cutting off fingers I will explain an explanation.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Database not found GP 2010

    This one will remain a mystery. I did find what piece of code was causing the problem by why this piece of code only has problems with this one batch of invoices is a mystery. Years ago we had Microsoft provide a chunk file that updates the payables transaction description field to the customer number and sales order number coming from the SOP-POP relationship. But for some reason for just this batch instead of the SQL command starting out with USE AAAAA UPDATE PM20000 the space is missing between the AAAAA and UPDATE. This is very odd.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans