Dynamics 365 LCS tricks – Fix your Retail Database

I have seen a lot off issue after applying new software or after restoring a database the retail database is not update anymore.

To solve these issue I suggest you follow these steps, to get it all working. I always start looking if the connection string to the retail database is correct. Unfortunately, MS has hided this field on update 3.

Extend the Form

But we can make this field visible again easily by extending the next form

On this extension we set the property visible true on control ConnectionStingGroup

The form on your VM is located her: https://usnconeboxax1aos.cloud.onebox.dynamics.com/?cmp=DAT&mi=RetailCDXDataStore

Now we are able to see the connection string, document this string for all your environment.

 

When the connecting string is correct, remove all download sessions and batches that are related to retail database synchronization.

Finally do a full sync on the retail database (job 9999)

Did you know?

On the AOS machine a lot of addition event logging is available on retail:

In case the events stay empty: trust you communicating to a different retail DB. In case you see errors, investigate them.

Database plumbing

In case you have a database restore, work always this way. Rename you axdb to axdb_old, restore your new database in axdb and finally update the data with the content from axdb_old

use Axdb

update  axdb.dbo.RetailTransactionServiceProfile set SERVICEHOSTURL =

(select SERVICEHOSTURL from  axdb_old.dbo.RetailTransactionServiceProfile)

update  axdb.dbo.RetailTransactionServiceProfile set AZURERESOURCE =

(select AZURERESOURCE from  axdb_old.dbo.RetailTransactionServiceProfile)

update axdb.dbo.RETAILCONNDATABASEPROFILE set CONNECTIONSTRING = (select CONNECTIONSTRING from axdb_old.dbo.RETAILCONNDATABASEPROFILE)

update  axdb.dbo.RetailChannelProfileProperty set VALUE =

(select VALUE from axdb_old.dbo.RetailChannelProfileProperty where KEY_ = 1) where KEY_ = 1

update  axdb.dbo.RetailChannelProfileProperty set VALUE =

(select VALUE from axdb_old.dbo.RetailChannelProfileProperty where KEY_ = 2) where KEY_ = 2

update  axdb.dbo.RetailChannelProfileProperty set VALUE =

(select VALUE from axdb_old.dbo.RetailChannelProfileProperty where KEY_ = 7) where KEY_ = 7

 

 

Comments1

Leave a Comment!

Your email address will not be published. Required fields are marked *