Hi.
We are using WTX 8.4 command-server at Linux, and we have run into a problem using DBQUERY together with Oracle database.
 
In our DBQUERY we do a select-statement, and fetch the first 10000 rows of the table. This mapping has worked well for a long time - but 'suddenly' the mapping ended in error - and with the "ORA-01406: fetched column value was truncated"-message. We checked for errors/changes in the database without finding anything - the db-table had the exact same content.

We had to create a 'workaround'-mapping where we performed two select-statements fetching 5000 rows instead of 1x10000 rows. This solved the problem - and this could indicate the problem to be a buffersize/memory-type of error. The problem is solved - BUT it is not very satisfying to have to solve the problem this way....

After a lot of troubleshooting and google-search, we came across something looking a bit similar described for the IBM Infosphere Information Server-product:
JR50102: WHILE READING DATA THE ORACLE CONNECTOR RECEIVED ORACLE ERROR ORA-01406 AND FETCHED COLUMN VALUE WAS TRUNCATED WITH NULL (ibm.com)

Could our problem be something related? And if so - how should we fix it?

..or maybe the problem is something completely different?? 

All suggestions are welcome!

------------------------------
Ole Haavard Haug-Larsen
------------------------------

#IBMSterlingTransformationExtender
#DataExchange

According to IBM's Product Cycle, WTX 8.4 came out in 12/2011 and supported was ended in 10/2017.
IBM product lifecycle - IBM Support

------------------------------
Rex Chan
------------------------------

Original Message:
Sent: Mon April 25, 2022 11:59 AM
From: Ole Haavard Haug-Larsen
Subject: DBQUERY- "ORA-01406"-error when fetching from DB

Hi.
We are using WTX 8.4 command-server at Linux, and we have run into a problem using DBQUERY together with Oracle database.
 
In our DBQUERY we do a select-statement, and fetch the first 10000 rows of the table. This mapping has worked well for a long time - but 'suddenly' the mapping ended in error - and with the "ORA-01406: fetched column value was truncated"-message. We checked for errors/changes in the database without finding anything - the db-table had the exact same content.

We had to create a 'workaround'-mapping where we performed two select-statements fetching 5000 rows instead of 1x10000 rows. This solved the problem - and this could indicate the problem to be a buffersize/memory-type of error. The problem is solved - BUT it is not very satisfying to have to solve the problem this way....

After a lot of troubleshooting and google-search, we came across something looking a bit similar described for the IBM Infosphere Information Server-product:
JR50102: WHILE READING DATA THE ORACLE CONNECTOR RECEIVED ORACLE ERROR ORA-01406 AND FETCHED COLUMN VALUE WAS TRUNCATED WITH NULL (ibm.com)

Could our problem be something related? And if so - how should we fix it?

..or maybe the problem is something completely different?? 

All suggestions are welcome!

------------------------------
Ole Haavard Haug-Larsen
------------------------------

#DataExchange
#IBMSterlingTransformationExtender

I should probably point out we are using the 8.4.1-version - but it's still 'overtime'.
We are in the process of updating to ITX 10.1.1 - which is the reason why we already have asked for - and received some input from you, Rex (via Carsten Grønning & Co). 😉

But the DBQUERY-problem can be relevant for other versions of WTX/ITX as well?

------------------------------
Ole Haavard Haug-Larsen
------------------------------

Original Message:
Sent: Tue April 26, 2022 02:46 AM
From: Rex Chan
Subject: DBQUERY- "ORA-01406"-error when fetching from DB

According to IBM's Product Cycle, WTX 8.4 came out in 12/2011 and supported was ended in 10/2017.
IBM product lifecycle - IBM Support

------------------------------
Rex Chan

Original Message:
Sent: Mon April 25, 2022 11:59 AM
From: Ole Haavard Haug-Larsen
Subject: DBQUERY- "ORA-01406"-error when fetching from DB

Hi.
We are using WTX 8.4 command-server at Linux, and we have run into a problem using DBQUERY together with Oracle database.
 
In our DBQUERY we do a select-statement, and fetch the first 10000 rows of the table. This mapping has worked well for a long time - but 'suddenly' the mapping ended in error - and with the "ORA-01406: fetched column value was truncated"-message. We checked for errors/changes in the database without finding anything - the db-table had the exact same content.

We had to create a 'workaround'-mapping where we performed two select-statements fetching 5000 rows instead of 1x10000 rows. This solved the problem - and this could indicate the problem to be a buffersize/memory-type of error. The problem is solved - BUT it is not very satisfying to have to solve the problem this way....

After a lot of troubleshooting and google-search, we came across something looking a bit similar described for the IBM Infosphere Information Server-product:
JR50102: WHILE READING DATA THE ORACLE CONNECTOR RECEIVED ORACLE ERROR ORA-01406 AND FETCHED COLUMN VALUE WAS TRUNCATED WITH NULL (ibm.com)

Could our problem be something related? And if so - how should we fix it?

..or maybe the problem is something completely different?? 

All suggestions are welcome!

------------------------------
Ole Haavard Haug-Larsen
------------------------------

#DataExchange
#IBMSterlingTransformationExtender

I don't know if this issue is addressed in 10.1 or not.  Once you have installed 10.1 in your development environment, I suggest you open a ticket with support.  They should be able to search in their database to provide you with more information.

------------------------------
Rex Chan
------------------------------

Original Message:
Sent: Tue April 26, 2022 03:24 AM
From: Ole Haavard Haug-Larsen
Subject: DBQUERY- "ORA-01406"-error when fetching from DB

I should probably point out we are using the 8.4.1-version - but it's still 'overtime'.
We are in the process of updating to ITX 10.1.1 - which is the reason why we already have asked for - and received some input from you, Rex (via Carsten Grønning & Co). 😉

But the DBQUERY-problem can be relevant for other versions of WTX/ITX as well?

------------------------------
Ole Haavard Haug-Larsen

Original Message:
Sent: Tue April 26, 2022 02:46 AM
From: Rex Chan
Subject: DBQUERY- "ORA-01406"-error when fetching from DB

According to IBM's Product Cycle, WTX 8.4 came out in 12/2011 and supported was ended in 10/2017.
IBM product lifecycle - IBM Support

------------------------------
Rex Chan

Original Message:
Sent: Mon April 25, 2022 11:59 AM
From: Ole Haavard Haug-Larsen
Subject: DBQUERY- "ORA-01406"-error when fetching from DB

Hi.
We are using WTX 8.4 command-server at Linux, and we have run into a problem using DBQUERY together with Oracle database.
 
In our DBQUERY we do a select-statement, and fetch the first 10000 rows of the table. This mapping has worked well for a long time - but 'suddenly' the mapping ended in error - and with the "ORA-01406: fetched column value was truncated"-message. We checked for errors/changes in the database without finding anything - the db-table had the exact same content.

We had to create a 'workaround'-mapping where we performed two select-statements fetching 5000 rows instead of 1x10000 rows. This solved the problem - and this could indicate the problem to be a buffersize/memory-type of error. The problem is solved - BUT it is not very satisfying to have to solve the problem this way....

After a lot of troubleshooting and google-search, we came across something looking a bit similar described for the IBM Infosphere Information Server-product:
JR50102: WHILE READING DATA THE ORACLE CONNECTOR RECEIVED ORACLE ERROR ORA-01406 AND FETCHED COLUMN VALUE WAS TRUNCATED WITH NULL (ibm.com)

Could our problem be something related? And if so - how should we fix it?

..or maybe the problem is something completely different?? 

All suggestions are welcome!

------------------------------
Ole Haavard Haug-Larsen
------------------------------

#IBMSterlingTransformationExtender
#DataExchange