JR31938: DRS STAGE ORA-01480: TRAILING NULL MISSING FROM STR BIND VALUE ERROR, SIMILAR TO E117163

APAR status

• Closed as program error.

Error description

• DRS Stage ORA-01480: trailing null missing from STR bind value
  error, similar to e117163.  Additionally when jobs does run
  without aborting corrupted data is passed through to database.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of DRS Plugin with RDBMS type Oracle using character or
  binary column types.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Writing Oracle data results in errors, with message from DRS
  Stage "ORA-01480: trailing null missing from STR bind value"
  ****************************************************************
  RECOMMENDATION:
  Apply the patch for this APAR JR31938.
  ****************************************************************
  

Problem conclusion

• Fix found in 751A and APAR patch for 8011.
  APAR fix also planned for 8.1 and 8012.
  

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

• SERVER
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSY

     UP

• R810 PSY

     UP