Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: kskanth on 21 Jul 2010 11:02:19 AM

Title: I am unable to import tables into the FM
Post by: kskanth on 21 Jul 2010 11:02:19 AM
Hi all,

I am able to connect to Database successfully both in the SQL+ and FM.
But I am unable to imort the table into my metadata source..
It pops up the following error message.. Pls help me

RQP-DEF-0177 An error occurred while performing operation 'sqlOpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "open result".
ORA-01008: not all variables bound
Title: Re: I am unable to import tables into the FM
Post by: Arsenal on 21 Jul 2010 11:38:58 AM
FM is not generating the error - I believe the error is coming from your Oracle database.

I would think that there's something wrong with the table architecture and your DBA needs to look at it. Can you do a select * on the concerned tables and columns?
Title: Re: I am unable to import tables into the FM
Post by: kskanth on 21 Jul 2010 11:48:00 AM
No I cannot select the tables or columns

whenever I click '+' beside the table name it generates the following error

RQP-DEF-0120 Database connection is dropped
Title: Re: I am unable to import tables into the FM
Post by: blom0344 on 21 Jul 2010 12:14:23 PM
check:

http://www-01.ibm.com/support/docview.wss?uid=swg21342929

and send it to the DBA
Text only | Text with Images