Dynamics Community Forum Thread Details

Inventory lookup for sales under MPOS (retail) showing application error (AX 2012 R3 CU11)

Dear all,

Could you please help is resovling the above issue. I can create, fetch customer and can receive pending transfer order on the MPOS but couldnt able to make sales as the inventory lookup is not working as expected. Please find below error fyr.

Dynamics-Error: Unhandled App error: Invalid parameter;
StackTrace: ; ErrorUrl: 'ms-appx://microsoft.dynamics.retail.pos/Commerce.Core.js'; ErrorObject: '' 1693490511397mS

If I'm trying to search product from search option then another error log is coming as shown below.

The Commerce Runtime Request with request id 'ffe7e0de-aeaa-6484-304b-c4ef06a6daa3' and request url 'crt://online/ProductManager/Search' failed. Error: {/odata.error/:{/code/:/Microsoft_Dynamics_Server_Internal_Error/,/message/:{/value/:/{///DatabaseErrorCode///:0,///Message///:///Failed to read from the database. See inner exception for details////r///DatabaseErrorCode: 0///,///CausedByConnectionError///:false,///ErrorResourceId///:///Microsoft_Dynamics_Commerce_Runtime_CriticalStorageError///,///Data///:{},///InnerException///:{///ErrorCode///:0,///Message///:///Violation of PRIMARY KEY constraint 'PK__#AC8C112__A9A5B3BBACC1BCA8'. Cannot insert duplicate key in object 'dbo.@tvp_SearchedProductIds'. The duplicate key value is (5637224826).////r///The statement has been terminated.///,///Data///:{},///InnerException///:{///ClientConnectionId///:///dfb08ecf-eea1-4b32-97e9-a7aaccde026b///,///Class///:14,///LineNumber///:35,///Number///:2627,///Procedure///:///GETPRODUCTSBYKEYWORD///,///Server///:///GT-AXAOS-SRV////////MSSQLSERVERAOS///,///State///:1,///ErrorCode///:-2146232060,///Message///:///Violation of PRIMARY KEY constraint 'PK__#AC8C112__A9A5B3BBACC1BCA8'. Cannot insert duplicate key in object 'dbo.@tvp_SearchedProductIds'. The duplicate key value is (5637224826).////r///The statement has been terminated.///,///Data///:{///HelpLink.ProdName///:///Microsoft SQL Server///,///HelpLink.ProdVer///:///12.00.5000///,///HelpLink.EvtSrc///:///MSSQLServer///,///HelpLink.EvtID///:///2627///,///HelpLink.BaseHelpUrl///:///http://go.microsoft.com/fwlink///,///HelpLink.LinkId///:///20476///}}}}/}}}.

Thank you

Quick Links