IBM Support

IV84808: IBM TRIRIGA SQL FOR WF_EVENT AND INSTANCE_ID CAUSES ORA-01438 - VALUE LARGER THAN SPECIFIED PRECISION ALLOWED FOR THIS COLUMN

Subscribe

You can track all active APARs for this component.

 

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