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 number
JR34263
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-14
Closed date
2009-09-23
Last modified date
2009-12-15
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
[{"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.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 December 2009