APAR status
Closed as program error.
Error description
Job with Oracle EE stage only works when date is sent in the format "DD-MON-RR" even if database setting for NLS_DATE_FORMAT is different. I upgraded from DataStage 7.5.1A to DataStage 7.5.3 and at 7.5.3 I can no longer send dates as "MM-DD-YYYY". A simple job sending in the date as "MM-DD-YYYY" no longer works at 7.5.3. The job aborts with the error: ORA-01843: not a valid month If I send the date as "DD-MON-RR" the job is successful.
Local fix
Send date in "DD-MON-RR" format. This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: Only those with NLS_DATE_FORMAT set in their env. **************************************************************** PROBLEM DESCRIPTION: ob with Oracle EE stage only works when date is sent in the format "DD-MON-RR" even if database setting for NLS_DATE_FORMAT is different. age 7.5.1A to DataStage 7.5.3 and at 7.5.3ates as "MM-DD-YYYY". A simple job sending in the date as "MM-DD-YYYY" no longer works at 7.5.3. The job aborts with the error: ORA-01843: not a valid month If I send the date as "DD-MON-RR" the job is successful. **************************************************************** RECOMMENDATION: Appy patch provided. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
The operator is altering the session properties territory and language. These actions are not warranted and are causing user environmentvariable NLS_DATE_FORMAT overridden. Setting NLS_NUMERIC_CHARACTERS with int program is necessary andsufficient.
Temporary fix
Comments
APAR Information
APAR number
JR33219
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
753
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-03
Closed date
2009-06-29
Last modified date
2010-12-09
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
R753 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":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010