"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
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.
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.
More support for:
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): Windows
Software edition: All Editions
Reference #: 1619910
Modified date: 2015-10-26