728
User is trying to post a Purchasing Batch.
Dynamics GP->Purchasing->Purchasing Batches
They select the batch, then click "Post"
The Progress window comes up and shows 100% but it never clears. Eventually have to force the GP client closed.
I can reset the batch and another user can post the batch without issue.
Has anyone ever encountered this before? What could be stopping a specific user?
Andrea,
I checked the User security again to ensure that they match. I am logging in with their usernames from the same workstation in our Dev environment.
Below is the Debug trace from Dexterity. This is for the user that the posting completes.
For the user that does not complete, that traced reaches the very top line of the trace below and goes no further. ('IsRequired() of form POP_POLINE')
10:21:51 B: 'IsRequired() of form POP_POLine', 0, 1-
10:21:51 'View_Add_POPLine', table 'POP_POLine', 8
10:21:51 'POC_Activated() of form POE_PO', 0, 0
10:21:51 'Timer_Refresh() of form POE_Cache', 0, 1
10:21:51 'Timer_Reset() of form POE_Cache', 12:00:00 AM, 1
10:21:51 'SQLPath', 2277, 3, 0, ""
10:21:51 'OSRC_POP_POLine_Update', table 'POP_POLine'
10:21:51 'ICJC_LE_Update_PO', table 'POP_POLine'
10:21:51 'SQLPath', 346, 10, 22020, ""
10:21:51 B: 'GetCurrOrdQty() of form POP_POLine', 0.00000, 1-, table 'POP_POLine'
10:21:51 B: 'IsParentLine() of form POP_POLine', 0, 1-
10:21:51 B: 'IsBlanketPO() of form POP_POLine', 0, 1-
10:21:51 B: 'Get() of form POP_PORcptApply', 0, 1-, table 'POP_PORcptApply', 23, "", 0
10:21:51 B: 'Get() of form TableObj', 0, 1-, table 'POP_PORcptApply', 23
10:21:51 B: 'Destroy of form POP_POLine', 1-, table 'POP_POLine'
10:21:51 B: 'Destroy of form POP_PORcptApply', 1-, table 'POP_PORcptApply'
10:21:51 B: 'GetPostingBackOrderedItems of form popBackOrderedItemsRpt', 1-, 3-, table 'POP_ReceiptLine', 10/30/2020
10:21:51 B: 'GetItemID() of form POP_ReceiptLine', "", 3-, table 'POP_ReceiptLine'
10:21:51 B: 'GetSiteID() of form POP_ReceiptLine', "", 3-, table 'POP_ReceiptLine'
10:21:51 B: 'ExistsForReceiptItem() of form popBackOrderedItemsRpt', 0, 1-, "CAQUAL8560.098", "MAIN"
10:21:51 B: 'SetIndexItemID of form popBackOrderedItemsRpt', 1-, "CAQUAL8560.098", 1, 0, 0/0/0000, "", 0
10:21:51 B: 'Get() of form popBackOrderedItemsRpt', 0, 1-, 13
10:21:51 B: 'Get() of form TableObj', 0, 1-, table 'popBackOrderedItemsTemp', 13
10:21:51 B: 'GetItemID() of form POP_ReceiptLine', "", 3-, table 'POP_ReceiptLine'
10:21:51 B: 'GetSiteID() of form POP_ReceiptLine', "", 3-, table 'POP_ReceiptLine'
10:21:51 B: 'GetUnlinkedSalesItems of form popBackOrderedItemsRpt', 1-, "CAQUAL8560.098", "MAIN"
10:21:51 'SQLPath', 0, 2, 156, ""
10:21:51 B: 'Create() of form SOP_SOLine', 0, 0-, table 'SOP_LINE_WORK', "", 0, 0, 0
10:21:51 B: 'SetRangeTrxSourceByItem of form SOP_SOLine', 1-, table 'SOP_LINE_WORK', -, -
10:21:51 B: 'Get() of form SOP_SOLine', 0, 4-, 11
10:21:51 B: 'Get() of form TableObj', 0, 4-, table 'SOP_LINE_WORK', 11
10:21:51 B: 'IsCommitments() of form popBackOrderedItemsRpt', 0, 1-
10:21:51 B: 'MoveToHist() of form POP_ReceiptLine', 0, 3-, table 'POP_ReceiptLine'
10:21:51 'SQLPath', 0, 3, 159, ""
10:21:51 'FA_TRIGGER_ADD_POP_ReceiptLineHistNew', table 'POP_ReceiptLineHist'
10:21:51 'SQLPath', 309, 1, 22000, ""
Hi Andrea,
I confirmed they are set to the same Alternate/Modified Forms.
I am able to recreate the issue in our DEV environment.
Update: I believe this is not a problem as it appears in the trace for the user that works as well.
I did turn on the Debug option for dexterity this morning. (I had forgotten about that option) I turned it on after the 100% window appeared. Here is what is contained in the script log file.
09:10:15 B:'mxCheckForRemoteSign'
09:10:15 'SQLPath', 4965, 2, 0, ""
09:10:15 B:'mxCheckForApproval'
09:10:15 'SQLPath', 4965, 2, 0, ""
09:10:16 B:'mxUpdateELSTriggers'
09:10:16 'SQLPath', 4965, 8, 0, ""
09:11:30 B:'mxCheckForRemoteSign'
09:11:30 'SQLPath', 4965, 2, 0, ""
09:11:31 B:'mxCheckForApproval'
09:11:31 'SQLPath', 4965, 2, 0, ""
09:11:31 B:'mxUpdateELSTriggers'
09:11:31 'SQLPath', 4965, 8, 0, ""
09:11:45 'Get_Number_of_DPS', "", [Not Found], [Not Found], [Not Found]
09:11:45 'SQLPath', 0, 7, 0, ""
09:12:08 B:'mxCheckForRemoteSign'
09:12:08 'SQLPath', 4965, 2, 0, ""
09:12:08 B:'mxCheckForApproval'
09:12:08 'SQLPath', 4965, 2, 0, ""
09:12:08 B:'mxUpdateELSTriggers'
09:12:08 'SQLPath', 4965, 8, 0, ""
If you compare the Alternate/Forms and Reports ID for the problem user vs. the user for whom the batch posts and journals print: Are they the same? (Microsoft Dynamics GP >> Tools >> Setup >> System >> User Security >> populate user and company)
If each user has a 'different' Alternate/Modified Forms and Reports ID, try assigning the problem user the Alternate Forms and Reports ID being used by the 'working' user. Does it work?
Are these two users testing on the same workstation, or on different workstations?
Is GP installed locally?
Thank you for the reply.
I have checked those tables and have no remnant records.
I have restored our production system to a test system and have been able to recreate it for the specific user with no one else logged in.
It gets to the 100% progress but the output window never appears. For a user that posting works for, I get the window requesting where I wish to display/output the results.
Hi,
If this is user specific, it may mean this user has activity records that are stuck and causing a problem.
Here are steps to clear stuck activity records:
1. Make a backup of the DYNAMICS database and get all users out of all companies (you need have all users out to ensure all stuck activity records are found/removed).
2. Run the following scripts to view activity records (no records should be returned when all users are out):
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION
3. If records were returned when users all users are out, run the following scripts to clear the activity records:
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
4. Have the problem user try to post again and verify whether the problem persists.
I hope this helps!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (