ORA-04052: error occurred when looking up remote object

Product:
Cognos Controller 10.1.1 and 10.3
Oracle database
Microsoft Windows 2008 R2 server

Symptom:
When you publish to DataMart from inside Cognos controller you get an error message.

You have inside Cognos Controller configuration setup a DataMart connection for you Controller database like this:

Error message:
ORA-04052: error occurred when looking up remote object FRANGO.DMTEMPLATE@DMPUBLISH.COMPANYX.COM

Possible Solution:
Start SQL Developer and connect to the controller data schema.

The connection string is not updated correct inside the database from the Controller configuration setup.
Then do this commands (you need to edit the connection for your environment)

DROP DATABASE LINK “DMPUBLISH.COMPANYX.COM”;

CREATE DATABASE LINK “DMPUBLISH.COMPANYX.COM”;
CONNECT TO FRANGO
IDENTIFIED BY <PASSWORD>

USING ‘
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = LX1234.COMPANYX.COM) (PORT = 1521))
( CONNECT_DATA =
( SERVER = DEDICATED)
( SERVICE_NAME = IT0123.COMPANYX.COM)
)
)  ‘ ;

Then after this update – try the DataMart function inside Cognos controller again.