Cannot refresh report

[Former Member]

i have a linked .xlsx input file defined via ODBC(rdo) of about 74k rows.

All text columns columns are restricted to 255 chars.

I have created a report and it works fine.

But when i try to refresh with latest data, However everytime i refresh the

report with the new data, i always get the message

"Failed to retrieve data from the database",

followed by

"Details: 22001:[Microsoft][ODBC Excel Driver] The field

is too small to accept the amount of data you attempted to add.

Try inserting or pasting less data. [Database Vendor Code: -1047]

How do i get around this issue ? different connection type ? driver ?

[former_member183750]

Hello John

The error: Database Vendor Code: -1047, is being passed from the DB client, through the report engine - unmodified. E.g.; search your database documentation for the error. Or use Google. First hit I got when googling the error:

http://help.sap.com/businessobject/product_guides/errors/12/0/en/html/topic180.html

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces