Supply chain | Supply Chain Management, Commerce

Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

(0) Share

Report

Posted on by Amr Moheeb

I'm working on an on-premises commerce setup, I used the below link for setup but I couldn't find values in channel deployment form after initialize.

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/deploy-retail-onprem

Go to Retail and Commerce > Headquarters setup > Parameters > Commerce parameters.
On the General tab, select the Initialize link to configure seed data for Commerce functionality.

I tried to check dbo.RETAILSELFSERVICEPACKAGEINFO table on AXDB but it's empty.

All responses (11)

Answers (0)

Ansar Basha 1,580 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

Hello Khalid,

Thank you for sharing the solution, it worked well.

Thanks & Regards,

Ansar Basha.S
Suggested answer

Ahmer Khalid 117 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

Hi Ansar,

I am hardcode environment name on the RetailUpdateDatabase.PS1 file

Thanks

Ahmer Khalid
Ansar Basha 1,580 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

Hello Ahmed,

We are facing same error, Can you share how you resolved the issue.

Thanks & Regards,

Ansar Basha.S
SergeyP 2,928 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

HI Ahmer Khalid ,

Can you debug that script and confirm that the very first error is taking place at the line # 365 from my below screenshot?

If so, I think that the $ServiceFabricAppdetails was not initialized at the line # 364 (in my screenshot's numberings). If I'm right then validate if $envName corresponds to your environment name, additionally you might want to try hardcoding there your environment name instead of using the variable. Basically the idea is to make sure that the call to Get-ServiceFabricApplicationObject does return the application's parameters which can be accessed later in the script.

While troubleshooting the above you can also grab the Application Name from the Service Fabric Local Cluster Manager, in my case the Environment Name is dogfood:
Ahmer Khalid 117 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

Hi Sergey,

I am executing the below command with errors.

PS C:\InfrastructureScripts\Scripts\VMs\MSD-365-AOS01> .\RetailUpdateDatabase.ps1 -envName 'UAT' -AosUrl 'xyz.com/.../' -SendProductSupportTelemetryToMicrosoft
Cannot index into a null array.
At C:\InfrastructureScripts\Scripts\VMs\MSD-365-AOS01\RetailUpdateDatabase.ps1:368 char:5
+ $CommonClusterId = $ServiceFabricAppDetails.ApplicationParameters ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : NullArray

You cannot call a method on a null-valued expression.
At C:\InfrastructureScripts\Scripts\VMs\MSD-365-AOS01\RetailUpdateDatabase.ps1:102 char:9
+ $stringArray = $AppDetailValues.CommonClusterId.Split("\")
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

CommonClusterId cannot be split into 3 strings
At C:\InfrastructureScripts\Scripts\VMs\MSD-365-AOS01\RetailUpdateDatabase.ps1:105 char:13
+ Throw "CommonClusterId cannot be split into 3 strings";
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: (CommonClusterId... into 3 strings:String) [], RuntimeException
+ FullyQualifiedErrorId : CommonClusterId cannot be split into 3 strings
SergeyP 2,928 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

I am unable to execute the RetailUpdateDatabase.ps1 scripts.

What exactly command you are running and what issues are you seeing?
Ahmer Khalid 117 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

Is it resolved ?
Commerce - On premises 15 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

Hi Surya,

I am unable to execute the RetailUpdateDatabase.ps1 scripts. Can you please guide me for this

Thanks

Ahmer Khalid
Surya Thonangi on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

HI Amr,

It would be great if you can create a support ticket for tihs issue.

Kind Regards

Surya
Amr Moheeb 15 on at

Like (0)

Report

RE: Installation steps for Retail channel components in an on-premises environment dbo.RETAILSELFSERVICEPACKAGEINFO table empty after intialize

Hi Surya, yes I did the above steps but the table dbo.RETAILSELFSERVICEPACKAGEINFO still empty.