Error while running Reconcile Receivables

(0) Share

Report

Posted on by Community Member

Good day to everyone,

I'm trying to run the process in Reconcile Receivables Amount window, however I got an error prompted:

Error: Another user is aging or reconciling debtor information. Please try again later.

I have already check the User Activity , as well as using script on SSMS to ensure no one is using Dynamics GP at that point.

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Nevertheless, the error remain still, anyone may help please?

Thanks,

Vince

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

You could try David Musgrave script to see if it makes any difference:

— Dexterity Sessions Table
delete S
— select *
from tempdb..DEX_SESSION S
where not exists (
select * from DYNAMICS..ACTIVITY A
where S.session_id = A.SQLSESID)

— Dexterity Locks Table
delete L
— select *
from tempdb..DEX_LOCK L
where not exists (
select * from DYNAMICS..ACTIVITY A
where L.session_id = A.SQLSESID)

— Batch_Headers table in each company
exec sp_MSforeachdb
‘ use [?]
if exists ( select INTERID from DYNAMICS..SY01500 D where INTERID = ”?” )
begin
update S set BCHSTTUS = 0, MKDTOPST = 0, USERID = ””
— select *
from SY00500 S
where BCHSTTUS in (1,2,3,4,5,6)
and not exists (
  select * from DYNAMICS..ACTIVITY A
  JOIN DYNAMICS..SY01500 C ON C.CMPNYNAM = A.CMPNYNAM
  where S.USERID = A.USERID and C.INTERID = db_name())
and exists (
  select * from DYNAMICS..SY00800 B
  where not exists (
   select * from DYNAMICS..ACTIVITY A
   where B.USERID = A.USERID and B.CMPNYNAM = A.CMPNYNAM)
  and S.BCHSOURC = B.BCHSOURC and S.BACHNUMB = B.BACHNUMB)
print ””
print ”(” + ltrim(str(@@ROWCOUNT)) + ” row(s) affected) – Database ” + db_name()
end
‘

— SY_Batch_Activity_MSTR table
delete B
— select *
from DYNAMICS..SY00800 B
where not exists (
select * from DYNAMICS..ACTIVITY A
where B.USERID = A.USERID and B.CMPNYNAM = A.CMPNYNAM)

— SY_ResourceActivity table
delete R
— select *
from DYNAMICS..SY00801 R
where not exists (
select * from DYNAMICS..ACTIVITY A
JOIN DYNAMICS..SY01500 C ON C.CMPNYNAM = A.CMPNYNAM
where R.USERID = A.USERID and R.CMPANYID = C.CMPANYID)

Was this reply helpful? Yes No
Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

Have you tried looking into activity monitor using managment studio to see if there's an activity running and killing the process?

Was this reply helpful? Yes No
Tim W 2,925 on at

Like (0)

Report

Sounds like someone started an Aging and then client was killed off before it finished.

select * from RM10901

If you have a record delete the row.

Was this reply helpful? Yes No
Tim W 2,925 on at

Like (0)

Report

Was this reply helpful? Yes No