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 number
JR31938
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-06
Closed date
2009-02-24
Last modified date
2009-02-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 February 2009