Direct links to fixes
APAR status
Closed as fixed if next.
Error description
Systems cannot fire & run any Workflow because the WF_EVENT.INSTANCE_ID field cannot accept values with more than 10 digits. The WF_EVENT.INSTANCE_ID field has precision of 10 and the value tried to be pushed in it has 11 positions. See a sample of the error message printed on the server.log message below: YYYY-MM-DD HH:MM:SS,mmm ERROR [com.tririga.architecture.security.dataaccess.AuthenticationDAO] (WebContainer : 0) EXCEPTION com.tririga.platform.persistence.PersistenceException: Error executing sql: Sql[SQL=INSERT INTO WF_EVENT (INSTANCE_ID, BO_TYPE_ID, BO_ID, BO_VERSION, EVENT_ID, NEXT_BO_TYPE_ID, NEXT_BO_ID, NEXT_BO_VERSION, USER_ID, DEPARTMENT_ID, COMPANY_ID, PROJECT_ID, CREATED_BY, CREATED_DATE, MODULE_ID, NEXT_MODULE_ID, ASSOC_STRING, FROM_INTEGRATION, IR_ID, IE_ID, IE_NAME) VALUES (12345678901,123456,123456,123,'WF USER LOGIN',0,0,0,123456,0,123456,1,0,getDate(),7,0,'',0,123456,12345 678901,'WF USER LOGIN'),DB transaction ID=(None)] Caused by: PreparedStatementCallback; SQL [INSERT INTO WF_EVENT (INSTANCE_ID, BO_TYPE_ID, BO_ID, BO_VERSION, EVENT_ID, NEXT_BO_TYPE_ID, NEXT_BO_ID, NEXT_BO_VERSION, USER_ID, DEPARTMENT_ID, COMPANY_ID, PROJECT_ID, CREATED_BY, CREATED_DATE, MODULE_ID, NEXT_MODULE_ID, ASSOC_STRING, FROM_INTEGRATION, IR_ID, IE_ID, IE_NAME) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,getDate(),?,?,?,?,?,?,?)]; ORA-01438: value larger than specified precision allowed for this column ; nested exception is java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column at com.tririga.platform.persistence.Sql$8.handleError(Sql.java:934) at com.tririga.platform.persistence.Sql.handleError(Sql.java:131) (...) Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO WF_EVENT (INSTANCE_ID, BO_TYPE_ID, BO_ID, BO_VERSION, EVENT_ID, NEXT_BO_TYPE_ID, NEXT_BO_ID, NEXT_BO_VERSION, USER_ID, DEPARTMENT_ID, COMPANY_ID, PROJECT_ID, CREATED_BY, CREATED_DATE, MODULE_ID, NEXT_MODULE_ID, ASSOC_STRING, FROM_INTEGRATION, IR_ID, IE_ID, IE_NAME) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,getDate(),?,?,?,?,?,?,?)]; ORA-01438: value larger than specified precision allowed for this column ; nested exception is java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column at org.springframework.jdbc.support.SQLExceptionSubclassTranslator. doTranslate(SQLExceptionSubclassTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra nslator.translate(AbstractFallbackSQLExceptionTranslator.java:72 )
Local fix
NA
Problem summary
Some ID columns are too small to hold large ID values.
Problem conclusion
Resolved an issue where synchronous workflows could be not added to the queue because the storage of the ID number was too small.
Temporary fix
Comments
APAR Information
APAR number
IV84808
Reported component name
TRI APPLCATION
Reported component ID
5725F26AB
Reported release
342
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-05-13
Closed date
2016-05-17
Last modified date
2016-05-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
999
Fix information
Applicable component levels
R350 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"342","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
30 March 2022