APAR status
Closed as program error.
Error description
Patch for OCI Date conversion failure OraOci fails with OCI DATE conversion failed. CAUSE OF PROBLEM: Conversion of Date string from oracle to DataStage format not being done properly.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Oracle OCI Stage **************************************************************** PROBLEM DESCRIPTION: Using the Oracle OCI Stage to populate an Oracle table, when the table is empty, i can populate it with no problem. If it has data, and one of the date fields has a date with a year in the range of XX32 - XX99, the job doesn't work raising the error "OCI Date Conversion Failed", I get the same error when performing OCI stage. **************************************************************** RECOMMENDATION: Install the recommended patch: patch_JR29355_server_windows.zip ****************************************************************
Problem conclusion
Problem has been fixed in a patch patch_JR29355_server_windows.zip for 8.0.1 fp1.
Temporary fix
Comments
This change is included in 8.0.1 Fix Pack 2.
APAR Information
APAR number
JR29355
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-05-21
Closed date
2008-07-30
Last modified date
2012-03-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSN
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:
30 March 2012