Share
Report
10G'day experts!
I'm currently having issues related to activating the MPOS in my OneBox VM environment. The issue is specifically related to the authentication of a worker and resolving the external identity, as certain stored procedures are not present on the customer's DB I've downloaded, yet they are present on the AxDB that comes with the VM environment and I'm not sure how the external identities are resolved in their UAT environment (where the DB has been created from).
Steps I've taken include:
-
Downloading and restoring a customer's DB from LCS to the VM environment, full data sync from VS and everything in D365 works perfectly
-
Initialize commerce scheduler
-
Updated the identity providers to the correct information and worker, ran a full 9999 job for the correct Channel DB group
-
Retail provisioning tool with the correct account
When entering the information required in MPOS I get the message 'Database error'
From Event Viewer I can see that stored procedures 'crt.GETSTAFFIDBYEXTERNALIDENTITY'. and 'crt.HASEXTERNALIDENTITY' are two procedures required (that are present on the AxDB). Duplicating them from the AxDB to the CustomerDB I'm using works up untill where the view 'crt.RETAILSTAFFEXTERNALIIDENTITYVIEW' is required which cannot be replicated in the CustomerDB due to certain columns not being available.
Has anyone come across this issue or maybe any suggestions on how to resolve the issue as I've exhausted all other avenues?
Thanks!
All responses (
Answers (
