IBM Support

Cannot drop the table 'tablename..hy__1', because it does not exist in the system catalog

Troubleshooting


Problem

Publish job fails with the following error. [Error Message -] The call to 'JobBegin' on 'Publish_25.Implementation' was not successful. Unable to execute the statement.Cannot drop the table 'tablename..hy__1', because it does not exist in the system catalog., Error number -2147217865 was raised by Microsoft OLE DB Provider for SQL Server. Native RDBMS error 3701 The SQL was: DROP TABLE tablename..hy__1 Cannot drop the table 'tablename..hy__1', because it does not exist in the system catalog. Number: -2147217865 Line Number: 160

[{"Product":{"code":"SSEH6Q","label":"Cognos Planning for Series 7"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Planning - Contributor 7.1;Planning - Contributor 7.2;Planning - Contributor 7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"","label":""}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

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

1005387

Document Information

Modified date:
09 May 2025

UID

swg21343975