"Invalid object name 'dmversion'" when publishing data mart, caused by the Datamart database server (target) being a different type from the (source) Controller database server

Technote (troubleshooting)


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.


Invalid object name 'dmversion'


There are several possible causes for the same error message.

  • TIP: For more examples, see separate IBM Technote #1969506.

This Technote specifically relates to the scenario where the cause is that the data mart (target) database server is not of the same type as the Cognos Controller database server (source).
  • For example you may be trying to publish data from a MS SQL database (source) into an Oracle database (target).

Resolving the problem

Make sure that the Cognos Controller database server (source) is of the same type as the (target) Datamart database server.

Related information

1969506 - ** Troubleshooting ** Invalid object name 'dm

Document information

More support for:

Cognos Controller

Software version:

8.3, 8.4, 8.5, 8.5.1, 10.1, 10.1.1, 10.2.0, 10.2.1

Operating system(s):


Software edition:

All Editions

Reference #:


Modified date:


Translate my page

Content navigation