The following documentation is available for the Post-Upgrade Tasks of the deployment guide for SAS Solution for IFRS 17 v09.2023 Update 4: Deployment Guide | Performing Post-Upgrade Tasks | Migrate the Solution Report Mart Data.

The Content Deployment Tool might fail when running the Report Mart migration script (install_upgrade_rpt_sample.sas).

As a result, the following error occurs in the cr_tool.log file.

MPRINT(_TMP_FETCH_SL_DIM_.IRM_REST_RGF_EXPORT_SUBLEDGER.IRM_REST_REQUEST):   proc http url = 
"https://myhostname.mydomain.com:443/SASRiskGovernanceFramework/groovyService.
jsp?script=/getSubledgerConfig.groovy&cpb0Ui=fae&cp
b3Ui=true&rgfContentId=rmc&objectKey=&subledger_key.&ticket=ST-322-E8t5nMnSYD7KqY71IPdnvZd-cgI-ssq42au" method = "POST" headerin = 
__hin__ headerout = __hout_ out = bodyOut ct = "application/json" clear_cache ;
MPRINT(_TMP_FETCH_SL_DIM_.IRM_REST_RGF_EXPORT_SUBLEDGER.IRM_REST_REQUEST):   run;

 

NOTE: 500 Internal Server Error
NOTE: PROCEDURE HTTP used

 

      Timestamp           [date time] PM

 

ERROR: The server response returned HTTP/1.1 500.

 

Response from the Server:

objectKey: , rgfContentId: rmc are both required. Full parameter string was: script=/getSubledgerConfig.groovy&cpb0Ui=fae&cpb3Ui=tru

e&rgfContentId=rmc&objectKey=&subledger_key.&ticket=ST-322-E8t5nMnSYD7KqY71IPdnvZd-cgI-ssq42au

The SAS Web Server access log reports a failed request:

<SASConfig>/<Lev#>/Web/WebServer/logs/access_<date-time>.log

 

127.0.0.1 - - [date:time -0400] "POST /SASRiskGovernanceFramework/groovyService.jsp?script=/getSubledgerConfig.groovy&cpb0Ui=fae&cpb3Ui=true&rgfContentId=rmc&
objectKey=&subledger_key.&ticket=ST-322-E8t5nMnSYD7KqY71IPdnvZd-cgI-ssq42au HTTP/1.1" 500 226

The request also occurs in the SASServer8_1 localhost access log

<SASConfig>/<Lev#>/Web/WebAppServer/SASServer8_1/logs/localhost_access_log.<date>.txt

127.0.0.1 - - [date:time -0400] "POST /SASRiskGovernanceFramework/groovyService.jsp?script=/getSubledgerConfig.groovy&cpb0Ui=fae&cpb3Ui=true&rgfContentId=rmc&
object
Key=&subledger_key.&ticket=ST-322-E8t5nMnSYD7KqY71IPdnvZd-cgI-ssq42au HTTP/1.1" 500 226

In addition, the following error occurs in the SASRiskGovernanceFrameworkMidTier.log file

<SASConfig>/<Lev#>/Web/Logs/SASServer8_1/SASRiskGovernanceFrameworkMidTier.log

SASRiskGovernanceFramework [date time],048 [tomcat-http--12] ERROR getSubledgerConfig [] - objectKey: , rgfContentId: rmc are both required. Full parameter string was: script=/getSubledgerConfig.groovy&cpb0Ui=fae&cpb3Ui=true&rgfContentId=rmc&
objectKey=&subledger_key.&ticket=ST-322-E8t5nMnSYD7KqY71IPdnvZd-cgI-ssq42au

Cause

The subledger_key does not resolve, which might be due to a customization.

Workaround

There is no workaround for this issue.

Resolution

A new version of the Report Mart migration script is available in a new SAS^® Solution for IFRS 17 v09.2023 package download from Downloads | SAS Solution for IFRS 17 v09.2023.

A copy of the script is attached to this article: install_upgrade_rpt_sample.sas.

Note: This script does not rely on the old SLAM User Interface. The script contains some additional updates that should improve the overall behavior. Replace the old version of the script with the attached version before proceeding, which should be located on the Compute-tier machine:

<SASConfig>/<Lev#>/AppData/SASIRM/fa.ifrs17.09.2023/rgf/sas/config/install_
upgrade_rpt_sample.sas