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.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 7.0;Impromptu 7.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

113765

Document Information

Modified date:
09 May 2025

UID

swg21332965

Page Feedback