UDA-SQL-0333 The table "PUB.tablename" was not found in the dictionary

[jeeva]

Hi,

we are getting the error when we validating the Datasource query subject in cognos 10.2 Framework manager. actually we applied filter in query subject1 as shown below.

querysubject1.column in (querysubject2.column). here query subject1 belongs to one data base and another query subject2 belongs to another database (Progress openedge 11.4 Database)

error :
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0327 An invalid object name was detected in the SQL request.
UDA-SQL-0333 The table "PUB.tablename" was not found in the dictionary


please suggest me to fix this issue.

thanks.

[Raghuvir]

Hi,

we are getting the error when we validating the Datasource query subject in cognos 10.2 Framework manager. actually we applied filter in query subject1 as shown below.

querysubject1.column in (querysubject2.column). here query subject1 belongs to one data base and another query subject2 belongs to another database (Progress openedge 11.4 Database)

error :
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.


UDA-SQL-0327 An invalid object name was detected in the SQL request.
UDA-SQL-0333 The table "PUB.tablename" was not found in the dictionary


please suggest me to fix this issue.

thanks.

Hi,

Please refer the below link. Hope it helps.

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

Regards