APAR status
Closed as program error.
Error description
Job: Seq.File -> Transformer -> Seq.File | V Seq.File when the job runs, we find "Abnormal termination of stage nnxxmmTransformer detected " in the log on DS Director and Access Violation in Windows' Event Viewer. This problem does not happen on every machine, it looks like machine-dependent or environment-dependent. The problem seems to happen in "conv01 = Iconv(DateAndTime[1, pos-1], "D")" used in the customer's routine. Now the customer has the following questions: Q1. conditions - under which conditions this problem could happen? There are other customer's who are using "D" in ICONV. But this is not known-problem. So he is thinking that this problem happens the combination of "D" in ICONV and something. Could you please tell us which conditions causes this problem? Q2. extent of the impact Please tell us on which DataStage version and on which OS this problem could happen. Q3. root cause Please give us the detail explanation. "This problem may be in the area of format qualifiers. " and we understood there must be the problem in the code area of manipulating the DATE format from the NLS.LC.TIME file. But he would like to know what actually happens when the problem occurs.
Local fix
The customer avoids this problem using "conv01 = Iconv(DateAndTime[1, pos-1], "D4/YMD")" instead of "conv01 = Iconv(DateAndTime[1, pos-1], "D")". But he has other customers. He is thinking to request a patch for this issue if this problem could happen in other customer's environments too. In order to confirm it, he is now asking the root cause of this issue and asking for answers about the questions. This fix is included in 8.0.1 fixpack 3
Problem summary
**************************************************************** USERS AFFECTED: Potentially all versions of DataStage and InformationServer on all platforms. **************************************************************** PROBLEM DESCRIPTION: The problem could occur when using ICONV with dates where the length of the separator in the date field is smaller than the length of the corresponding format delimiter. (For example, if the separator in the date field is /, the format delimiters are '^x5E74',^x6708','^x65E5', and the date string is 2007/7/6) **************************************************************** RECOMMENDATION: Upgrade to DataStage 753 Windows patch or future releases of InformationServer 801FP3 and 81FP2 This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
The problem was that when processing a date string delimiter andcomparing it against a format delimiter, the number of characters remaining in the date string was not checked before using strncmp. The problem will be fixed in 801FP3 and 81FP2 releases.
Temporary fix
Comments
APAR Information
APAR number
JR31366
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
753
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-12-09
Closed date
2009-02-24
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:
Modules/Macros
SERVER
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R753 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":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010