Print Page - error when validating the report

Title: error when validating the report
Post by: johny.cbi on 25 Sep 2008 07:56:23 AM

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

Title: Re: error when validating the report
Post by: Suraj on 25 Sep 2008 09:04:37 AM

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

Title: Re: error when validating the report
Post by: johny.cbi on 25 Sep 2008 09:12:40 AM

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

Title: Re: error when validating the report
Post by: Suraj on 25 Sep 2008 02:02:28 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: johny.cbi on 25 Sep 2008 07:56:23 AM