COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: masha2008 on 18 Nov 2008 04:02:36 PM

Title: RQP-DEF-0177
Post by: masha2008 on 18 Nov 2008 04:02:36 PM
Everytime I run a report I get this error

UDA-SQL-0107 A general exception has occurred during the operation "prepare". [NCR][ODBC Teradata Driver][Teradata Database] Name is longer than 30 characters.

Can someone explain How can I fix it and what exactly does it mean

Thank you
Title: Re: RQP-DEF-0177
Post by: lindero on 19 Nov 2008 03:44:21 AM
Hi Masha,

first of all. It is great to hear that some other customers are using Cognos on top of Teradata. It is too bad, that there aren't so many.

Now to your querstion:
Do you use NativeSQL in your report? If so, then check the length of your aliases of the projected columns. They must not be longer than 30 characters.

If you are interested in knowledge sharing we can change some mails from time to time bit biliterally.

cheers