When you are unable to access a remote object, the following error message appears:
Error 11214 Remote object object does not exist.
The problem may be in the local proxy table definition or in the table itself on the remote server.
Verify that:
The object has been defined in Component Integration Services.
To confirm, run:
sp_help object_name
If the object does not exist, create the object in Component Integration Services.
If the object has been defined in Component Integration Services, the definition is correct.
Table names can have four parts with the format server.dbname.owner.tablename. The dbname part is not valid for DB2, Oracle, or InfoHUB servers.
If the object definition is incorrect, delete it using sp_dropobjectdef, and define it correctly using sp_addobjectdef.
If the local object definition is correct, check the table on the remote server, to verify that:
Permissions are set to allow access to both the database and table.
The database has been marked suspect.
The database is available.
You can access the remote table using a native tool (for example, SQL*Plus on Oracle).
