Excel Transfer from iSeries ERROR
Hi. I have created a query on the iSeries machine and then stored the results in a database file (pf). I then try to transfer the file to excel using the iAccess plugin. However I get the following error: CWBDB0052 - Error during data conversion. Any help would be greatly appreciated. Thanks
Software/Hardware used:
AS400 - 9401
Software/Hardware used:
AS400 - 9401
ASKED:
June 7, 2010 1:01 PM
UPDATED:
June 11, 2010 2:09 AM
Answer Wiki:
I did a Google search and found a web page that indicates you may have a null value in your physical file you are accessing. You may need to correct the data to prevent the error.
<a href="http://www-01.ibm.com/support/docview.wss?uid=nas1b08a6514ef19b0a486256dce005ddca0">Message CWBDB0052 Is Received during iSeries Access Data Transfer</a>
To see all answers submitted to the Answer Wiki: View Answer History.
I wouldn’t expect null values at first, though they do need to be considered. I’d first ensure that the QCCSID system value was set correctly and that the query result file had a reasonable CCSID. If the data is being generated and then transferred as CCSID 65535, it should be corrected.
If a reasonable CCSID is set, then I’d look for nulls.
I see this is a 9401. What version of OS/400 is installed and what version of Client Access is used?
Tom
Thank you both for your input.
I have checked the QCCSID… the value is set to 65535 (which based on what I’ve read means the data is not converted).
Therefore what value should I set it to?
I believe the OS400 ver is V4R4 while the CA is V6R1.
Another bit of info: I tried the ‘transfer to excel’ again but this time Instead of manually entering the file name to be transferred, I selected browse instead. The system log on screen appears but after entering my details I get the same Error during data conversion.
Other files transfer ok?
If so, it might be the data .. something that would look like a date to excel but wasn’t valid
like 02/29/11?
Phil
This usually is a data issue. Alpha chars in a numeric field, for example. Also, do you have the option to store numerics in an char column checked? Check that the columns line up correctly with the database.
Was this a join query – two files – one reported even when the matching entry in the other is missing? Including fields from both files? This type of query would/could return null values. These would explain your problem.
Phil