Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
Resolution:
Description:
============
The ADB Adapter throws the "Invalid object name" error when it is accessing the table in SQL Server, whose owner/schema is not “dbo”.
Environment:
===========
All versions of TIBCO ActiveMatrix ® Adapter for Database (ADB) Adapter on all Platforms.
SQL Server 2000, 2005 and 2008
Symptoms:
========
1). Login user is TIBCOEAI with server role “System Administrators” in SQL Server 2000, and “sysadmin” in SQL Server 2005 and 2008. The User’s default schema is TIBCOEAI in SQL Server 2005 and 2008.
2). Configure ADB with subscription service to operate on the table “TIBCOEAI.Table1”.
3). When invoking the subscription service with a BW process, the "Invalid object name" error will happen.
4). The error detail is “Error [Database] AEADB-100004
DBError: Database driver code: 42S02
Database server code: 208
Database driver message: [tibcosoftwareinc][ODBC SQL Server Driver][SQL Server]Invalid object name 'Table1'.”
Cause:
=====
When the login user is enabled with the server role “System Administrators” in SQL Server 2000, and “sysadmin” in SQL Server 2005 and 2008, the default owner/schema of the table will change to “dbo” and the ADB adapter can not access the table “TIBCOEAI.Table1”in run time.
Resolution:
==========
Follow either of these two steps:
1). Remove the role “System Administrators” or “sysadmin” of the USER in SQL Server.
2). Create the table and set owner/schema to “dbo”.