Error while releasing order

(0) Share

Report

Posted on by sprasana

Today while trying to release a order from Salespad following error occured:

Cannot insert duplicate key row in object ‘dbo.DEX_LOCK’ with unique index ‘PK_DEX_LOCK’. The duplicate key value is (-xxxxxx, dbo.SOP10100), whats the possible reason for it?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Beat Bucher GP Gee... 28,061 Moderator on at

Like (1)

Report
Copy link

Link copied!

You should contact your SalesPad partner..

This looks like an integration issue with SP to GP.. the value -xxxxxx makes me think that it tries to reserve the next SO number, but fails. Or 2 users at the same time trying to enter a new Sales Order and there is no exclusive lock from SP...

Was this reply helpful? Yes No
sprasana 46 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I read dex_lock is associated with dex_session in tempdb, which keep tracks user session logged in, -xxxxxx is number in dex_row_id of sop101000 table, which keep tracks identity of individual user. Is there any way to fix the issue for that particular document by clearing session like that?

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes you can..

Here is the Microsoft KB article on how to achieve this:

support.microsoft.com/.../how-to-remove-all-the-inactive-sessions-from-the-dex-lock-table-in-the

Was this reply helpful? Yes No
sprasana 46 on at

Like (0)

Report
Copy link

Link copied!

One more thing on this...I asked the particular person who is having issue with above error to log out and log in again from salespad, why that is not solving the issue? logging out doesn't clear the session from dex_session table?? Even that person logged out and logged in again and created new document.

Was this reply helpful? Yes No
Verified answer

Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

As I stated earlier, this seems to be a SalesPad integration issue.. not sure how the SalesPad client is handling the dex_lock & des_session table entries.

You should contact your SalesPad integration partner..

Was this reply helpful? Yes No
sprasana 46 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for your support and prompt responses.

Was this reply helpful? Yes No