Cannot Update Object (Data Source error)

[bibat]

Hi Coguru's,

I have a Framework Model that was designed by someone...I am facing a error, when I try to Update the Object.
it throws an error message "BMT-MD-5002 The object 't_f_XYZ' of type 'table or view' does not exist in the data source"

Also, When I  try to import any new table it create a additional Data Source under data source like XYZ, XYZ1, XYZ2...

Anyone, Any clues? Plzz?

Version: 10.1.1

[Lynn]

Are you able to query the particular table from the database directly outside of Cognos? Could it be a permission issue?

The additional data source problem might be due to different schema properties for the data source. I think by default it will come in with the schema name you select it from which may be different from the schema on the original data source definition. Edit the new one to refer to the original schema name and delete the new schema.

[bibat]

Hi Lynn,
Thanks for the reply.
Yes, I can run queries on SQL directly.

Yes I tried that as well...If I change/delete the newly created Datasource and point it to original it again throws same error
"BMT-MD-5002 The object 't_f_XYZ' of type 'table or view' does not exist in the data source"

[Lynn]

Take a look at the schema property for your old/new data sources. Are they the same or different? Are you logging in to the database with the same login and password that Cognos logs in with? Your permissions might differ from what the Cognos login permissions are set for.

What database are you using? Sometimes Oracle might be using synonyms so even if you have permission to see the object in the new schema you may not have permission to the synonym in the original schema.

So even though you can query the table directly are you sure you are querying it from the same schema that your data source is looking at? You can generate the native SQL to see just what it is doing and then log in using the same credentials that Cognos uses. Help from your DBA might be a good way to get to the bottom of it quickly.