Hyperion Data Integration Management (DIM) Error: "[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'TABLE_NAME'." in Variable Defined from SQL Query (Doc ID 818978.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Data Integration Management - Version 9.2.0.3.00 and later
Information in this document applies to any platform.

Symptoms

Error while executing query[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'TABLE_NAME'.

When refreshing a variable that is assigned using a query like:

SELECT Value
FROM TABLE_NAME
WHERE Condition1 = 'ONESHOT'


Microsoft SQL Server 2005

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms