I have an issue with Receivable Batch when click post the batch doesn't post. Below is the screen on the process monitor. This process doesn't complete and it stays forever. I cant end GP normally I am forced to use task manager.
I have cleared the sessions through
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
I have even cleared SY01300 but still no success. After running the trace it the following stored procedures keep on recurring repeatedly
(1)exec FBI.dbo.zDP_RM00101SS_1 'MAUR00010-GICE'
(2)exec FBI.dbo.zDP_RM10301N_4
25,'RM_Sales','MM-09-18',7,'CREDT000000001389','RM_Sales','TEST',-32768,'','RM_Sales','TEST',32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ'
(3)exec FBI.dbo.zDP_RM10301N_1 25,1,'SALES000000000216',NULL,NULL,NULL,NULL
(4)exec FBI.dbo.zDP_RM00101SS_1 'WILK00014-AHU'
The batch remain unposted, has no errors and surprisingly, no reports on the screen that comes on screen/on file as the batch posts towards completion.
I have already restarted the server but this never ending posting process continues. When I end through the task manager, the batch status changes to interrupted and have to be recovered plus clearing the posting batch from sy00800.
My question is, how can I sought this problem so that the batches post normally. My GP version is GP2010 R2 (Version 11.00.1752)
RomRyan
*This post is locked for comments