How to upgrade a CDM database (manually)

Technote (troubleshooting)


Problem(Abstract)

Restored an earlier database on environment that has already been upgraded.
Database needs to be upgraded, to match the required version, before it can be access from CDM.

Symptom

2013-07-01 14:37:53,041 [7] ERROR Ibm.CognosDM.Services.Exceptions.CdmErrorHandler - (null) Exception Token: 'baee3d9b-074b-420a-86bd-2863f38d502d'.DB schema mismatch.

Known schema version: '10.2.1.17.8'. Actual schema version: '10.2.1.17.5' ? ? ? Ibm.CognosDM.Repositories.DbSchemaMismatchException: Exception Token: 'baee3d9b-074b-420a-86bd-2863f38d502d'.DB schema mismatch.
Known schema version: '10.2.1.17.8'. Actual schema version: '10.2.1.17.5'
at Ibm.CognosDM.Repositories.NHibernate.DbSchemaVersion.CheckForCompatibility()
at Ibm.CognosDM.BusinessLogic.Activation.NHibernateUnitOfWorkFactory.GetSessionFactory()
at Ibm.CognosDM.BusinessLogic.Activation.NHibernateUnitOfWorkFactory.CreateUnitOfWork(Nullable`1 loggedInUserId)
at Ibm.CognosDM.BusinessLogic.Activation.CdmActivationContext.get_UnitOfWork()
at Ibm.CognosDM.BusinessLogic.Activation.CdmActivationContext.get_RepositoryFactory()
at Ibm.CognosDM.BusinessLogic.Activation.CdmActivationContext.get_BusinessLogicFactory()
at Ibm.CognosDM.Services.Security.SessionServiceContainer.ResolveServiceInstance(ICdmActivationContext activationContext)
at Ibm.CognosDM.Services.InstanceProvider.GetInstance(InstanceContext instanceContext)
at System.ServiceModel.InstanceContext.GetServiceInstance(Message message)
at System.ServiceModel.Dispatcher.InstanceBehavior.EnsureServiceInstance(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

(Note. In this example, the error message indicates that the known version is 10.2.1 IF1 and the actual database version is 10.2.1)


Cause

Database and application are not on the same version.

Known schema version = CDM application version
Actual schema version = Database version


Environment

CDM 10.2.x.x

Resolving the problem

Upgrade the database to match the application version.

STEPS:
1. Open a command prompt
2. Navigate to "DBDeploymentTool" folder: cd C:\inetpub\wwwroot\CognosDM-Server\Tools\DBDeploymentTool>
3. Run the appropriate command:
- CDM CORE Database: Ibm.CognosDM.DeployDatabase.exe /S <SQL_Server> /DB <Core_DB> /VTS "core" /VT "CdmDBVersionInfo" /AP "Ibm.CognosDM.Database.dll" /UPGRADE
- CDM CACHE Database: Ibm.CognosDM.DeployDatabase.exe /S <SQL_Server> /DB <Cache_DB> /VT "CdmDBVersionInfo" /VTS "cache" /AP "Ibm.CognosDM.CacheDatabase.dll" /UPGRADE
- CDM XBRL Database: Ibm.CognosDM.DeployDatabase.exe /S <SQL_Server> /DB <XBRL_DB> /VT "DatabaseInfo" /VTS "xbrl" /AP "Ibm.CognosDM.Xbrl.Database.dll" /UPGRADE
Note. Replace "<>" according to your environment
4. Restart CognosDM-Server IIS application (ie: iisreset, or reboot application server)

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Disclosure Management
Cognos Disclosure Management

Software version:

10.2.1

Operating system(s):

Windows

Reference #:

1642704

Modified date:

2014-05-26

Translate my page

Machine Translation

Content navigation