Posted by: istewart | June 3, 2009

Batch stuck in posting / Receiving / Busy etc etc


Could this be the most common support query we get! …near enough…Usually down to a network interruption and seen most often in Terminal Server enviornments.
The solution is straighforward.

Get all users to exit GP. Note down the Batch ID that is causing the problem.

Open MSSQL and run the following scripts:

SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION

If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.

DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION

Then run the following against the company database:
 
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’
(Where ‘XXX’ is the batch ID of the batch that is stuck in posting / Reeiving / Busy / Marked etc.)

About these ads

Responses

  1. Hi All,

    I am really suffering of receivables batch posting stuck. I am running Dynamics 10 under Citrix Env. Most of our batches get stuck at the month end. I tried all possible solution with no luck. I will appreciate if some body can give me a tip how to resolve this issue.

    • Hi Diknash, email me at is@genesys.ie. I’ll respond and we’ll see what can be done.
      Ian.

  2. [...] http://dynamicsgp.wordpress.com/2009/06/03/batch-stuck-in-posting-receiving-busy-etc-etc/ [...]

  3. I’m from syvantis technologies and needed to actually do some work with a financial batch that is stuck…ironically you have the solution…you are a talented man :)

    • Hi Sara. Glad you got it sorted. Ian.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

Follow

Get every new post delivered to your Inbox.

Join 28 other followers

%d bloggers like this: