[FM]Error Message when testing SQL of Query Subject

[Taboka]

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

[sir_jeroen]

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

[Taboka]

The owner is actually dbo and after changing the schema name from GOSL to dbo it works fine.
Thank u very much    ;D