Commerce Server Catalog - Source:Microsoft OLE DB Provider for SQL ServerDescription:Invalid object name 'dbo.Th

Author

Source:Microsoft OLE DB Provider for SQL ServerDescription:Invalid object name 'dbo.Th

Lance

2005-03-14, 5:54 pm

Hi,
I am having a problem exporting a product catalog. The SQL server has two
stores set up on it: one for live transactions and one for staging. The
staging DB is just a restore from the live DB. When I attempt to export a
catalog from the staging DB using the Catalog Manager, I get the following
error:

Source:Microsoft OLE DB Provider for SQL ServerDescription:Invalid object
name 'dbo.ThomasCamp_ClassTypes'.

This error is not replicated in the Event Log. It is only seen in the
Catalog Manager.

Now, I know that this object is a view in both DBs, and I can manually query
from it and it seems to return valid sets, so why does SQL server think that
it doesn't exist?

Thanks,
Lance