Problem Note 66152: The Content Release post-deployment script install_post_rgf_server_restart.sas in SAS® Risk Stratum fails and generates an error
In SAS Risk Stratum, the Content Release post-deployment script install_post_rgf_server_restart.sas fails and displays the following error in the corresponding log:
"Response from the Server:
{"errorCode":0,"message":"One or more validation errors occurred.","details":["Object with source system \"RMC\" and ID \"10179_1000
0_10002\" already exists in the database"],"remediation":"","links":[],"version":1,"httpStatusCode":400}"
This error occurs because the first run of the script creates the link instance and all subsequent runs are not checking if it already exists and, instead, trying to create the same link instance id.
This problem happens when you run the script more than once.
To work around this issue, the simplest solution is to remove the existing link instance or instances that are are causing the error.
You can use the sample XLSX worksheet that is available on the Downloads tab to unload the link instances that are referenced in the log. Use this file on the Unload page (accessed from SAS® Risk Governance Framework by selecting Administration ► Data) to unload the link instance.
In addition, you can add other link instances to the XLSX worksheet if there are additional errors about other existing link instances.
Operating System and Release Information
SAS System | SAS Risk Stratum | Microsoft® Windows® for x64 | v03.2020 | v06.2020 | 9.4 TS1M6 | 9.4 TS1M6 |
Linux for x64 | v03.2020 | v06.2020 | 9.4 TS1M6 | 9.4 TS1M6 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The following error is generated when the install_post_rgf_server_restart.sas post-deployment script fails: "Object with source system \"RMC\" and ID \"10179_1000 0_10002\" already exists in the database"
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2020-06-19 11:42:43 |
Date Created: | 2020-06-18 10:27:03 |