SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64140: Importing and restoring an archive fails due to different dimension IDs in SAS® Risk and Finance Workbench

DetailsHotfixAboutRate It

In SAS Risk and Finance Workbench, when you import and restore an archive, the action fails due to different dimension IDs. When you import an archive in this scenario, the following pop-up message appears:

The request failed to complete due to internal server error.
Remediation: Check the request to ensure it is valid.  If so, contact your system administrator to help diagnose the issue.

When you restore an archive in this scenario, an error exception like the following occurs in the middle-tier log:

ERROR com.sas.stress.rest.controller.ControllerExceptionHandler - Generic exception handling for
request: https:// < path > /SASRiskandFinanceWorkbench/rest/archives/imports/ < identifier > =?commit=false
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback;
SQL [INSERT INTO project_dimension (project_definition_sk, dimension_definition_sk) VALUES (?, ?)];
ERROR: insert or update on table "project_dimension" violates foreign key constraint "project_dimension_dimension_definition_sk_fkey"
  Detail: Key (dimension_definition_sk)=(6) is not present in table "dimension_definition".;
nested exception is org.postgresql.util.PSQLException: ERROR: insert or update on table "project_dimension" violates foreign key
constraint "project_dimension_dimension_definition_sk_fkey"
  Detail: Key (dimension_definition_sk)=(6) is not present in table "dimension_definition".
 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:249)
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
 at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
 at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818)
 at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)
 at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882)
 at com.sas.stress.rest.services.ConfigService.createProjectDimensions(ConfigService.java:1353)
 at com.sas.stress.rest.services.ConfigService.createProject(ConfigService.java:197)
 at com.sas.stress.rest.services.archive.ArchiveImporter.importProject(ArchiveImporter.java:1400)
 at com.sas.stress.rest.services.archive.ArchiveImporter.importProjectAndItsData(ArchiveImporter.java:762)
 at com.sas.stress.rest.services.archive.ArchiveImporter.doImportObject(ArchiveImporter.java:731)
   ...more lines...

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Risk and Finance WorkbenchMicrosoft® Windows® for x643.19.4 TS1M5
Linux for x643.19.4 TS1M5
* 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.