CosmicNerd
Technical User
I am trying to set up Data Manager networking across two servers in Cognos 10.2.1 . When I try to run a Data Movement task I get the error
"UDA-SQL-0107 A general exception has occurred during the operation "columns". ORA-00942: table or view does not exist UDA-SQL-0196 The table or view "dsb_sequence" was not found in the dictionary".
This does not happen on a single-server configuration and is referring to the Data Manager catalog. It is as if it needs qualification on the table name. I am suspecting the configuration is not right somewhere.
This is on Windows 2008. Do I need to install with 'run as administrator'?
Anyone help?
Acestar Solutions Limited
Cognos development and on-site training
"UDA-SQL-0107 A general exception has occurred during the operation "columns". ORA-00942: table or view does not exist UDA-SQL-0196 The table or view "dsb_sequence" was not found in the dictionary".
This does not happen on a single-server configuration and is referring to the Data Manager catalog. It is as if it needs qualification on the table name. I am suspecting the configuration is not right somewhere.
This is on Windows 2008. Do I need to install with 'run as administrator'?
Anyone help?
Acestar Solutions Limited
Cognos development and on-site training