JR34263: SEQ.FILE --> TRANSFORMER --> ORAOCI_LOAD INCORRECT ROW/COLUMN IN WARNING MSG

APAR status

• Closed as program error.

Error description

• customer has a simple job, Seq.file ---> Transformer --->
  Oracle_OCI_Load.
  It outputs
  
  Warning Transformer_2: row 4 column 1 cannot be converted. See
  next Oracle error message.
  Information Transformer_2: ORA-01722: Invalid number
  
  But actually the data "row 1 column 4" has problem, not "row 4
  column 1", customer says.
  It looks like the number of column is displayed as "row", the
  number of row is displayed as "column".
  Though I have not reproduced it, has this problem already been
  reported?
  
  In Japanese warning message, the order of row/column is like
  this:
   "row 4 column 1 cannot be converted. See next Oracle error
  message."
  Is it possible that number of row is passed to "column" and
  number of column is passed to "row" only for Japanease message?
  
  On my test, I compared the job log by Oracle Bulk Load with
  the job log by ORAOCI.
  The data is like the following, and the first column is Char,
  length 10.
  And hte 2nd one is Decimal, length 10. So the Row 4 Column
  2 should be rejected by the job.
  
          11111111112222222222
          11111111112222222222
          11111111112222222222
          11111111112222222222
          1111111111aaaaaaaaaa
  
  ORAOCI job shows like the following:
  
            Item #: 17
            Event ID: 66
            Timestamp: 2009-09-18 00:09:38
            Type: Warning
            User Name: dsadm
            Message Id: -2
            Message: test_job_ORAOCI..Transformer_13:
  DBMS.CODE=ORA-01722
            Row 4, Link "DSLink15"
            Row is rejected
  
  But the job with Oracle Bulk Load shows the following message.
  Number of Row and Column seem to be not correct:
  
            Item #: 16
            Event ID: 15
            Timestamp: 2009-09-18 00:11:26
            Type: Warning
            User Name: dsadm
            Message Id: Unknown
            Message: test_job_ORABulkLoad..Oracle_OCI_Load_12: Row
  2 Column 4 cannot be converted.
            See next Oracle error message.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Japanese language customer of Oracle OCI Plugin.
  ****************************************************************
  PROBLEM DESCRIPTION:
  This message belongs to Oracle Bulk Load Plugin:
  The column %1 in row %2 cannot be converted. See next Oracle
  error message for details.
       During translation, the
  Japanese message switched "column"   and "row", so the
  resulting message was like this:       Row %1 column %2
  cannot be converted. See next Oracle error     message for
  details.
         This is incorrect translation.
  ****************************************************************
  RECOMMENDATION:
  Apply the patch.
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• The parameters %1 and %2 were reversed in the Japanese
  translation.  It now says:
  Row %2 column %1 cannot be converted. See next Oracle error
  message for details.
  

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:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSY

     UP