IBM Support

** Troubleshooting ** Unable to determine database version. Invalid Object name 'xfrango'

Troubleshooting


Problem

Customer has recently restored a SQL database on their database server. They are trying to connect the new database to their Controller application server. Administrator launches 'Controller Configuration' from the Start Menu. Administrator opens 'Database Connections' section. Administrator highlights new connection name, and clicks on green 'play' icon ('Run' button'). This launches 'Database Conversion Utility' (also known as 'DbConv'). Administrator notices that the 'Db Version - Actual' is set to zero (0) instead of the expected version (for example 712) If they try to use the 'Run Steps' option (to upgrade the database), they receive an error. Also, all users receive an error when logging into Controller, if they select this database. However, if they create a brand-new database instead, then the 'Run Steps' process works OK, and users can logon to this new (blank) database.

Symptom

The error message will vary slightly, depending on Controller version:

Controller 8.x:


    Unable to determine database version. Invalid Object name 'xfrango'.


Controller 10.x:
    Error. com.microsoft.sqlserver.jdbc.sqlserverexception: Invalid Object name 'Xfrango'

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0;10.1.1;10.1;8.5.1;8.5;8.4;8.3","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

1041105

Document Information

Modified date:
08 May 2025

UID

swg21366714

Page Feedback