IBM Support

RS01469: DB2 SQL EXCEPTION DURING RULE SYNCHRONIZATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following error is thrown when synchronizing rule project
    from RD to DC:
    -----
    java.sql.SQLException: DB2 SQL Error: SQLCODE=-302,
    SQLSTATE=22001,
    SQLERRMC=null, DRIVER=4.11.69
    -----
    
    From the corresponding DB2 log, it is found that the following
    statement causes the sqlexception:
    
    SELECT PROJECT, ELTORIGINALID, TYPE FROM DB2ADMIN.BRSTUDIO WHERE
    UUID = '<long file name>.xls'
    
    This excel file is used to create dynamic domain in one of the
     BOM entry.
    If the excel file is placed in other non ODM related folder or
    rename (to a shorter filename), the SQL exception will not
    happen.
    
    The exception is thrown because the file length is longer than
    the UUID column size and this only happens when DB2 database.
    

Local fix

  • Use a shorter name for the resource file
    

Problem summary

  • Some element do not have an UUID and should be treated
    specifically. the name cannot be used by default.
    

Problem conclusion

  • The code processing element without UUID is fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    RS01469

  • Reported component name

    WS DECISION CTR

  • Reported component ID

    5725B6900

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-02

  • Closed date

    2014-01-31

  • Last modified date

    2014-01-31

  • 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

  • Fixed component name

    WS DECISION CTR

  • Fixed component ID

    5725B6900

Applicable component levels

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
03 November 2021