IBM Support

Error - Invalid object name 'dmversion' - when publishing Data Mart to Cognos BI format

Troubleshooting


Problem

User clicks on 'Transfer - Publish Data and Structures - Publish Data Mart'. User selects a template that has a target of 'Cognos BI'. User ticks 'Generate' and selects 'Period' and 'Structures' and then clicks 'Run', but receives an error message.

Symptom

Screen message:

    Error
    Invalid object name 'dmversion'.
    OK

Event Viewer (Application Log):
    Event Type: Warning
    Event Source: Cognos Controller
    Event Category: None
    Event ID: 0
    Date: 31/08/2007
    Time: 14:15:56
    User: N/A
    Computer: SERVERNAME
    Description:
    Error occured at 31/08/2007 14:15:56 in Cognos Controller, Error No=-2147217865, Source=DMPublishD.GetPublishDBVersion, Description=Invalid object name 'dmversion'., HelpFile= HelpContext=0

Cause

There are several potential scenarios:

  • Scenario #1 - The administrator has not run the DmConv utility for this particular database connection
    • This utility populates the corresponding 'Data Mart database' with the correct/required tables.
  • Scenario #2 - The user has not recently run a Database Optimise.
    • This is necessary to create relevant tables (inside the 'application repository database') required for the data mart publish.
  • Scenario #3 - The value of the 'provider' in the 'database connections' and 'database connections for publish to datamart' sections is not identical.
    • For example, these 2 values are in a different case.
    • TIP: In some environments, the values for these providers are case-sensitive.
  • Scenario #4 - Known limitation of Controller.
    • It is not possible to publish data from one database format (e.g. SQL) to a different database format (e.g. Oracle or DB2).

Resolving The Problem

Scenario #1
Check that there is a valid corresponding database connection inside 'Database Conversion Utility'. Then click 'run' on the database connection, and choose the Data Mart database. Click on 'run steps'.

    Steps:
    1. Logon to the application server
    2. From the 'Start Menu', launch 'Controller Configuration'
    3. Open 'Database Connections for publish to data mart'
    4. Ensure that this section is correctly filled in, and (important) click 'save' to register this in the system
    5. Open 'Database Connections' and highlight the relevant connection name (for example 'Controller_LIVE')
    6. Click on 'Run' button to launch 'Database Conversion Utility'
    7. Click on 'DmConv' tab
    8. Click on the 'browse' button and locate the relevant UDL file (for example C:\Program Files\cognos\c8\DMData\Controller_Live.udl). IMPORTANT: Note that there is more than one UDL file - the one we are looking for here is NOT the same as the one for the main database (located inside the '...\data\' folder).
    9. Look at 'DM Version'. Notice that the 'DmConv' value (for example '26' for Controller 8.2 RTM) is higher than the 'actual' value (for example 'zero')
    10. Click 'Run Steps' and then click 'Yes' to confirm
    11. After seeing the message ALL PROCESSES COMPLETE, click close.

Scenario #2

Choose 'single user' mode in Controller, and run a database optimise.

Scenario #3

Launch 'Controller Configuration' from the Start Menu, and open the section 'Database Connection'. Copy the value for 'provider' (for example 'SQLOLEDB.1') into the clipboard, and paste it into the corresponding section inside 'Database connections for publish to datamart'. Save and re-test.

Scenario #4

It is not possible to publish data from one database format (e.g. SQL) to a different database format (e.g. Oracle or DB2).

1035260-How to use the 'DmConv' tab inside Controller Configuration to publish CognosBI Data Mart.pdf1035260-How to use the 'DmConv' tab inside Controller Configuration to publish CognosBI Data Mart.pdf

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Framework Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4.1;8.4;8.3;10.1","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1;8.5;8.4;8.3;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1035260

Document Information

Modified date:
28 November 2022

UID

swg21371098

Page Feedback