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.