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. Anyone help?
I think this is one you will need to log with IBM support. Sorry!!
MF.