On occasion, when reconciling inventory tables, an error message is displayed suggesting someone is posting when you know for a fact that everyone is out of the application. Here are a couple of things you can do to clear up this situation. First, examine the Batch Recovery and make sure that there are no stuck batches. If stuck batches are found, clean them up and complete the posting of those batches. Re-try the reconcile. If you still get the error message, perform the following:
1. Get everyone out of GP
2. Run these commands in Query Analyzer against the Dynamics Database
Delete Activity
Delete SY00800
Delete SY00801
3. Run the following commands against the TEMPDB database
Delete DEX_LOCK
Delete DEX_SESSION
4. Have one user log back in and try the reconcile process
No comments:
Post a Comment