Cognos Sync Utility: not able to publish a revised model
Symptoms
When trying to publish a new model using the Cognos Sync Utility, I get an error with the code RQP-DEF-0177:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOption' status ='-56'.
UDA-SQL-0115 Inappropriate SQL statement.
Invalid object name 'udfcode'
Reason
When configuring the Data Source Connection in Cognos Adminstration, 'ContentStore' was used for database name instead of 'Changepoint'.
Resolution
Reconfigure the data source connection to use the Changepoint database.