A SAS Infrastructure for Risk Management instance fails with the following errors:
ERROR com.sas.solutions.risk.irm.server.jobflowexec.JobFlowExecutor - Caught exception in preparing the execution of flow instance
java.lang.RuntimeException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at com.sas.solutions.risk.irm.server.persistence.PoolingDataAccessService.save(PoolingDataAccessService.java:113)
…..
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
…..
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into data_path (DATA_PATH, DATA_PATH_KEY) values ('/app/sas/config/compute/Lev1/AppData/SASIRM/pa/pool/_1833095/GLOBAL.SYSTEM_OPTION.SAS7BDAT', 1926751) was aborted: ERROR: duplicate key value violates unique constraint "ix_data_path"
Detail: Key (data_path)=(/app/sas/config/compute/Lev1/AppData/SASIRM/pa/pool/_1833095/GLOBAL.SYSTEM_OPTION.SAS7BDAT) already exists. Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:154)
…..
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ix_data_path"
Detail: Key (data_path)=(/app/sas/config/compute/Lev1/AppData/SASIRM/pa/pool/_1833095/GLOBAL.SYSTEM_OPTION.SAS7BDAT) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2268)
... 23 more
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Infrastructure for Risk Management | Microsoft® Windows® for x64 | 3.6 | 9.4 TS1M6 | ||
Linux for x64 | 3.6 | 9.4 TS1M6 |
A fix for this issue for SAS Infrastructure for Risk Management 3.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G2T.html#70645A fix for this issue for SAS Infrastructure for Risk Management 3.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G2T.html#70645Type: | Problem Note |
Priority: | medium |
Date Modified: | 2024-03-28 10:51:33 |
Date Created: | 2024-02-05 15:58:23 |