When trying to share reports in Smart Reporting, “arhost” parameter is not updated on the basis of Custom Parameters configuration (Administration > Configuration > System > Custom Parameter).

After using "Enable report sharing via URL" option in AdminConsole page (i.e. http(s)://SmartReporting_host:<port>/AdminConsole/#/), the values of Custom Parameters are not reflected when sharing reports or on hyperlink fields.

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

Currently, there is no direct way to update arhost from EXTERNALURLPARAMS.

It is necessary to run the following query to update the arhost parameter in database.

1. Query to verify the EXTERNALURLPARAMS 

select * from configuration
where configcode = 'EXTERNALURLPARAMS'

2. Query to update the EXTERNALURLPARAMS

update configuration
set ConfigData='arhost=<hostname>&port=0&midtier=<hostname>:<port>&protocol=http'
where  configcode = 'EXTERNALURLPARAMS'

Note: This parameter is different for each client org, add client org reference in where clause for multi-tenancy Onboarding.

Use following query to get client organization ID from Organization table:

select * from SmartReportingConfig where display_name = 'Client Organization Name'

Use following query for multi-tenancy using the client org ID obtained from above query:

update configuration
set ConfigData='arhost=<hostname>&port=0&midtier=<hostname>:<port>&protocol=http'
where configcode = 'EXTERNALURLPARAMS' and IpOrg = <client org ID>

3. Restart Smart Reporting service to take changes in effect.