SUPPORT / SAMPLES & SAS NOTES
Problem Note 61126: "ERROR: duplicate key value violates unique constraint" might occur when you edit a SAS® Risk and Finance Workbench project that contains a package
 |  |  |  |  |
In SAS Risk and Finance Workbench, changing the date, name, or description in a project might cause an error like the following:
ERROR: duplicate key value violates unique constraint "sheet_definition_project_definition_sk_sheet_template_sk_key"
Detail: Key (project_definition_sk, sheet_template_sk)=(24, 144) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sheet_definition_project_definition_sk_sheet_template_sk_key"
Detail: Key (project_definition_sk, sheet_template_sk)=(24, 144) already exists.
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
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:840)
at com.sas.stress.rest.services.ConfigService.createSheet(ConfigService.java:1214)
at com.sas.stress.rest.services.ConfigService.createSheets(ConfigService.java:1164)
at com.sas.stress.rest.services.ConfigService.updateProject(ConfigService.java:365)
Detail: Key (project_definition_sk, sheet_template_sk)=(24, 144) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sheet_definition_project_definition_sk_sheet_template_sk_key"
Detail: Key (project_definition_sk, sheet_template_sk)=(24, 144) already exists.
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
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:840)
at com.sas.stress.rest.services.ConfigService.createSheet(ConfigService.java:1214)
at com.sas.stress.rest.services.ConfigService.createSheets(ConfigService.java:1164)
at com.sas.stress.rest.services.ConfigService.updateProject(ConfigService.java:365)
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 | 2.3 | 3.1 | 9.4 TS1M4 | 9.4 TS1M5 |
| Linux for x64 | 2.3 | 3.1 | 9.4 TS1M4 | 9.4 TS1M5 | ||