RS01469: DB2 SQL EXCEPTION DURING RULE SYNCHRONIZATION

Operational Decision Manager V8.0.1.2 Fix Pack
Operational Decision Manager V8.5.1.1 Fix Pack

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 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