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.

I have the same question (0)

All responses (11)

Answers (0)

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

In the link which you have shared, have you followed steps which we have highlighted below?

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

Installation steps

On the previously created Application share, (not the LocalAgent share folder), create a new folder called selfservicepackages in the root directory of the share location.

On each AOS computer, create an easily accessible directory, such as C:/selfservicepackages.

On one AOS computer (which one does not matter), run the following PowerShell script.

PowerShell Copy

.\RetailUpdateDatabase.ps1 -envName '<Environment name>' -AosUrl 'https://<My Environment Name>.com/namespaces/AXSF/’ - SendProductSupportTelemetryToMicrosoft

Important

The above steps apply to version 10.0 and later. For the original 8.1.3 release of Retail on-premises functionality, the original version of the script delimiters must be used.

PowerShell Copy

.\RetailUpdateDatabase.ps1 -DatabaseServer '<Database server name for AOS database>' -DatabaseName '<Database name for AOS database>' -envName '<Environment name>' -RetailSelfServicePackages '<Local path of Retail self-service packages, such as **C:/selfservicepackages**>’ -SendProductSupportTelemetryToMicrosoft

The parameter -envName should be known based on creation when the environment is generated.

The legacy parameters -DatabaseServer and -DatabaseName should be known based on the environment setup.

The parameter -SendProductSupportTelemetryToMicrosoft is a required value to enable telemetry to Microsoft. This is critical to maximize support from Microsoft.

This script will perform a variety of actions, including updating the Retail Service user and role and updating Retail registry keys.

On each AOS computer, run the following PowerShell script.

PowerShell Copy

.\RetailUpdateDatabase.ps1 -RetailSelfServicePackages 'C:\RetailSelfService\Packages'

Note

The parameter -RetailSelfServicePackages is the full path location created in the beginning of this step (C:/selfservicepackages).

Kind Regards

Surya

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
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 ?

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
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:

Was this reply helpful? Yes No
Ansar Basha 1,582 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

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No