IBM Support

Error : Invalid object name, Could not use view or function because of binding errors

Troubleshooting


Problem

Error: DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'. DMS-E-SS_PARSER, An error was detected during processing of the SQL request. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'orig_db.dbo.COMMISSIONS'. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not use view or function 'dbo.COMMISSION_DOCS' because of binding errors. [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. after a database was moved from one machine to another and renamed. Created a new ODBC DSN and a new Database Definition. Edited the Impromptu Catalog to point to the new database. Some reports are returning errors saying it cannot find database objects, and are referencing the old database name.

Resolving The Problem

The errors were the result of querying a database View, which had SQL that still referred to the old database name. Editing the View on the database to query the new database resolved the issue.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 7.0;Impromptu 7.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

113765

Document Information

Modified date:
15 June 2018

UID

swg21332965

Page Feedback