Problem Note 64140: Importing and restoring an archive fails due to different dimension IDs in SAS® Risk and Finance Workbench
 |  |  |  |  |
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...
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Risk and Finance Workbench | Microsoft® Windows® for x64 | 3.1 | 9.4 TS1M5 | ||
| Linux for x64 | 3.1 | 9.4 TS1M5 | ||||
A fix for this issue for SAS Risk and Finance Workbench 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D4L.html#64140A fix for this issue for SAS Risk and Finance Workbench 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C5N.html#64140
When you import an archive, you see the following pop-up message: "The request failed to complete due to internal server error." When you restore an archive, you see the following message: "ERROR com.sas.stress.rest.controller.ControllerExceptionHandler..."
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2019-06-28 10:11:40 |
| Date Created: | 2019-04-30 18:19:36 |