Share
Report
1,422Dear 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
All responses (
Answers (
