Problem Note 64045: You see an error message in SAS® Enterprise Case Management when you click the Refresh Report Mart Labels menu option
 |  |  |  |
When you click Administration ► Refresh Report Mart Labels in SAS Enterprise Case Management, you might encounter the following error:
When the problem occurs, the SASEntCaseManagement6.3.log contains errors similar to the following:
2019-01-09 15:10:17,804 [tomcat-http--5] com.sas.solutions.casemgmt.web.action.ExceptionHandler - An error occurred in the system. Current
user: "sasdemo". URL: "/SASEntCaseManagement/Administration.do?command=refreshLabels".
2019-01-09 15:10:17,804 [tomcat-http--5] com.sas.solutions.casemgmt.web.action.ExceptionHandler - java.lang.RuntimeException:
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.69.24] Batch failure. The batch was submitted, but at least one
exception occurred on an individual member of the batch.
user: "sasdemo". URL: "/SASEntCaseManagement/Administration.do?command=refreshLabels".
2019-01-09 15:10:17,804 [tomcat-http--5] com.sas.solutions.casemgmt.web.action.ExceptionHandler - java.lang.RuntimeException:
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.69.24] Batch failure. The batch was submitted, but at least one
exception occurred on an individual member of the batch.
You are also likely to see the following exception in the SASEntCaseManagement6.3.log:
2019-01-09 15:10:17,843 [tomcat-http--33] com.sas.solutions.casemgmt.web.action.ExceptionHandler -
java.lang.RuntimeException: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/sas/solutions/casemgmt/dao/sql/Label.xml.
--- The error occurred while applying a parameter map.
--- Check the insertColumnLabel-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302
java.lang.RuntimeException: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/sas/solutions/casemgmt/dao/sql/Label.xml.
--- The error occurred while applying a parameter map.
--- Check the insertColumnLabel-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302
This problem occurs when your SAS Enterprise Case Management database is DB2, and a label display value is too long for the associated column.
To work around the problem, execute and commit the following ALTER commands on your SAS Enterprise Case Management DB2 database:
ALTER TABLE ECM_TABLE_LABEL ALTER COLUMN LABEL_TXT SET DATA TYPE VARCHAR(400);
ALTER TABLE ECM_COLUMN_LABEL ALTER COLUMN LABEL_TXT SET DATA TYPE VARCHAR(400);
ALTER TABLE ECM_COLUMN_LABEL ALTER COLUMN LABEL_TXT SET DATA TYPE VARCHAR(400);
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Case Management | Linux for x64 | 6.3_M1 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 6.3_M1 | 9.4 TS1M3 | ||||
| 64-bit Enabled AIX | 6.3_M1 | 9.4 TS1M3 | ||||
| Microsoft® Windows® for x64 | 6.3_M1 | 9.4 TS1M3 | ||||
You see "An error has occurred in the system" message when you refresh the report mart labels. The problem occurs when your SAS Enterprise Case Management database is DB2, and a label display value is too long for the associated column.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-05-03 15:38:18 |
| Date Created: | 2019-04-16 09:41:52 |