JR31366: WHEN HAVING "CONV01 = ICONV(DATEANDTIME[1, POS-1], "D")" IN THE ROUTINE, ERROR HAPPENS.

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 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