Hi all,
I am getting the following error message when simply trying to test a SQL Query in Framework Manager Query subject RETURNED_ITEM:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'.
UDA-SQL-0196 The table or view "gosales.GOSL.gosl.RETURNED_ITEM" was not found in the dictionary.
UDA-SQL-0196 The table or view "gosales.GOSL.gosl.ORDER_HEADER" was not found in the dictionary.
UDA-SQL-0196 The table or view "gosales.GOSL.gosl.ORDER_DETAILS" was not found in the dictionary.
Could someone explain the meaning and rectification of this type of error
Thanks
who's the owner for the go_sales tables? dbo or gosl?
You can test it by executing in sql server the following statement:
select * from GOSL.ORDER_HEADER
if this statement doesn't work the order_header table has a different owner. You'll have to go into FM and change the schema name for each connection to correspond to the correct owner. e.g. change GOSL to dbo
The owner is actually dbo and after changing the schema name from GOSL to dbo it works fine.
Thank u very much ;D