Excel Transfer from iSeries ERROR

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

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    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
    I believe the OS400 ver is V4R4 while the CA is V6R1.
    165 pointsBadges:
    report
  • As400novice
    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
    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
    50,385 pointsBadges:
    report
  • graybeard52
    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
    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
    50,385 pointsBadges:
    report
  • ToddN2000
    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)
    12,700 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following