Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

Posted on by 5,195

hi,

an error is occuring one of my vendor transaction ( inquiry=>Purchasing=>Transaction by vendor) the error is "The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions". please advice how to resolve it

*This post is locked for comments

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    you need to replace the value within the quotes by your own of course.. this value is coming from the duplicate results returned from step 1.

    VCHRNMBR='xxxxxxxx'  where xxxxxx is your own value

  • Alvaidas Gedminas Profile Picture
    Alvaidas Gedminas 120 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    after running the second step select * from PM20000 where VCHRNMBR='PV-943936'

    select * from PM30200 where VCHRNMBR='PV-943936' there were no results returned.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    Use step 2 & 3 that Refeesh posted in this thread earlier.

    It goes without saying that you've taken a full backup of your company DB before running any SQL Delete action..

  • Alvaidas Gedminas Profile Picture
    Alvaidas Gedminas 120 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    I have ran the first SQL statement and it returned the VCHRNMBR 606994 count of 2 what do i have do next to clear the things up?

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    Hi Ali,

    Have a look at this blog post :

    blogs.msdn.microsoft.com/.../the-stored-procedure-createsqltmptable-returned-the-following-results-dbms-12-exceptions

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,195 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    I fix the issue. 

    step 1: i run this query to understand duplicate entries :

    select DOCTYPE, VCHRNMBR, COUNT(*) as [COUNT] from
    (
    select DOCTYPE, VCHNUMWK as VCHRNMBR from PM10000 W
    UNION ALL
    select DOCTYPE, VCHRNMBR from PM10300 P
    UNION ALL
    select DOCTYPE, VCHRNMBR from PM10400 M
    UNION ALL
    select DOCTYPE, VCHRNMBR from PM20000 O
    UNION ALL
    select DOCTYPE, VCHRNMBR from PM30200 H
    ) C
    group by DOCTYPE, VCHRNMBR
    having COUNT(*) > 1

    step2: after the result ,run invididual document PV numbers using the below querries:

    select * from PM20000 where VCHRNMBR='PV-943936'
    select * from PM30200 where VCHRNMBR='PV-943936'

    step3:

    removed the duplicate value from PM_Transaction_OPEN file
    DELETE from PM20000 where VCHRNMBR='PV-943070'
    DELETE from PM20000 where VCHRNMBR='PV-943936'

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    i find which transaction is duplicate but i dont know how can i fix the issue. can anyboady advice me how to fix this issue.

  • Verified answer
    GMA Profile Picture
    GMA 1,072 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    blogs.msdn.microsoft.com/.../identifying-duplicate-transactions

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,195 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    kindly provide me the steps how can i fix it

  • GMA Profile Picture
    GMA 1,072 on at
    RE: ERROR:The stored procedure createSQLTmpTable returned the following results: DBMS: 2627" exceptions

    Most likely that vendor has a duplicate transaction in the system. I would check the history, open, and work tables to ensure there are no duplicates.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans