Page 1 of 1

Check Content Store database version

Posted: Tue Sep 06, 2016 3:43 pm
by yingchai
Currently, we have TM1 system running in two environments:

Environment 1:
TM1 version: TM1 10.2.2 FP4
Authentication: CAM
Content Manager configuration was setup using Cognos Controller (where the IBM Cognos services is running).
The Content Store database was created using MS SQL Server 2012.

Environment 2:
TM1 version: TM1 10.2.2 FP4
Authentication: CAM
Content Manager configuration was setup using Cognos BI (where the IBM Cognos services is running).
The Content Store database was created using MS SQL Server 2012.

So, here's the problem. After I backup the Content Store database from the first environment, restore it to the second environment, and restart IBM Cognos services in second environment, I got an error:
CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. Incompatible Content Manager version in Content Store database.

Which table in the Content Store database that stores the Content Manager version? Is it possible to edit the version value?

Re: Check Content Store database version

Posted: Tue Sep 06, 2016 4:48 pm
by BariAbdul
This might help.Please have a look:

http://www-01.ibm.com/support/docview.w ... wg21660204
CMSYSPROPS :This table has the Content Store Version
Thanks

Re: Check Content Store database version

Posted: Wed Sep 07, 2016 7:39 am
by yingchai
BariAbdul wrote:This might help.Please have a look:

http://www-01.ibm.com/support/docview.w ... wg21660204
CMSYSPROPS :This table has the Content Store Version
Thanks
Thanks for the hint. I was looking at NC_DB_VERSION table which leads me to the wrong version number.