Excel Transfer from iSeries ERROR

As400novice

165 pts.

Tags:

AS/400

IBM iSeries

Microsoft Access import/export

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

Asked: June 7, 2010 1:01 PM Last updated: June 11, 2010 2:09 AM

Answer Wiki

Last updated: June 11, 2013 1:06 AM GMT

Chris Leonard4,300 pts.
History
Contributors
- Ordered by most recent
- Chris Leonard4,300 pts.
- hafwhit1,175 pts.

Thanks. We'll let you know when a new response is added.

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

Message CWBDB0052 Is Received during iSeries Access Data Transfer

Discuss This Question: 8 Replies

TomLiotta Jun 7, 2010 10:10 PM GMT

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

125,585 pointsBadges:

report
As400novice Jun 10, 2010 7:45 AM GMT

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?

165 pointsBadges:

report
As400novice Jun 10, 2010 7:58 AM GMT

I believe the OS400 ver is V4R4 while the CA is V6R1.

165 pointsBadges:

report
As400novice Jun 10, 2010 8:38 AM GMT

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.

165 pointsBadges:

report
philpl1jb Jun 10, 2010 9:18 AM GMT

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

54,090 pointsBadges:

report
graybeard52 Jun 11, 2010 1:14 AM GMT

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.

3,115 pointsBadges:

report
philpl1jb Jun 11, 2010 2:09 AM GMT

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

54,090 pointsBadges:

report
ToddN2000 Jun 11, 2013 3:07 PM GMT

Are you transferring into an existing pre defined Excel worksheet or is this new? Check the PF you created and look at the field definitions. Do they look correct? Can you view the file on the I-series without any problems? Can you transfer other files ok? Does your file have any fields defined in the query that may have exceeded you size definition? (ex. from doing a calculation)

100,375 pointsBadges:

report