COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: nishant.thakar on 17 Mar 2015 05:30:51 AM

Title: Unable to Connect to datasource with AR8MSWIN1256 character set
Post by: nishant.thakar on 17 Mar 2015 05:30:51 AM
Hi,
I have the data Source connection which is configured to Oracle with AR8MSWIN1256 character set.
In FM I am able to connect to the data source but while importing table it is throwing below mentioned error;

RQP-DEF-0177 An error occurred while performing operation 'sqlColumns' status = '-9'.
UDA - SQL - 0107 A general exception has occurred during the operation "columns".
                    ORA -00911: Invalid character

I am trying to fetch arabic data and also tried changing the model language to Arabic. But no success.

Please help!


Update: To update on the same if I change the SQL type to Native or Pass-Through, I am able to fetch data but Cognos SQL is giving problems.

Thanks in Advance!