error when validating the report

[johny.cbi]

I'm getting wierd errors when I validate the report

Error when validating:
UDA-QOS-0006 Error
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
ORA-00972: identifier is too long

when I run the report, it is working with out any errors

the problem is when I validate the report


Thanks for any ideas

[Suraj]

Are you using direct sql?
I get that error when I use direct sql with a column name that's too long.

[johny.cbi]

I'm using sql directly (oracle)
even I checked in the data base, all items are less than 30 charecters

I'm getting this error when I validate the report

[Suraj]

Rename the data items in your sql statement with some abbreviation.