An “Invalid object name” error occurs when TIBCO ActiveMatrix ® Adapter for Database (ADB) Adapter works with SQL Server 2000, 2005 and 2008.

An “Invalid object name” error occurs when TIBCO ActiveMatrix ® Adapter for Database (ADB) Adapter works with SQL Server 2000, 2005 and 2008.

book

Article ID: KB0085756

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

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”.

Issue/Introduction

An “Invalid object name” error occurs when TIBCO ActiveMatrix ® Adapter for Database (ADB) Adapter works with SQL Server 2000, 2005 and 2008.