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
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
after running the second step select * from PM20000 where VCHRNMBR='PV-943936'
select * from PM30200 where VCHRNMBR='PV-943936' there were no results returned.
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..
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?
Hi Ali,
Have a look at this blog post :
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'
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.
kindly provide me the steps how can i fix it
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156