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

(0) Share

Report

Posted on by Refeesh Ali

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

All responses (10)

Answers (1)

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

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 120 on at

Like (0)

Report

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 Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

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 120 on at

Like (0)

Report

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 Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

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 5,195 on at

Like (1)

Report

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 Microsoft Employee on at

Like (0)

Report

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 1,072 on at

Like (0)

Report

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

blogs.msdn.microsoft.com/.../identifying-duplicate-transactions
Refeesh Ali 5,195 on at

Like (0)

Report

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

kindly provide me the steps how can i fix it
GMA 1,072 on at

Like (0)

Report

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.