IBM Support

Error -2147217865 Cannot drop the table 'xmenu' because it does not exist in the system catalog

Troubleshooting


Problem

I.T. administrator has restored a Controller database on their Microsoft SQL server. Administrator logs onto the Controller application server, and launches 'Controller Configuration' from the Start Menu. Next, the user navigates to 'Web Services server' - 'Database Connections' and chooses a database connection (for example 'ControllerLIVE'). User clicks on green 'run' icon ('play' button) to launch the 'Database Conversion Utility'. User notices that the 'Actual' value for 'DB Version' is 0 (zero), not the expected value (for example '711'). User clicks on 'Create Db' or 'Run Steps'. User receives an error message.

Symptom

There are several potential error messages that might appear, such as:

    INFORMATION: Unable to determine current database version
    error -2147217865 (Hex 80040E37);
    Cannot drop the table 'xmenu', because it does not exist or you do not have permission.

and/or
    DBConv Error. Unable to determine database version.
    Error -2147217865 Cannot drop the table 'xmenu' because it does not exist in the system catalog.

and/or
    'Unable to detect current DB version'

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5;8.4;8.3;8.2","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","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

1040325

Document Information

Modified date:
09 May 2025

UID

swg21347969

Page Feedback