COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos Disclosure Management => Topic started by: mooninsc on 05 Feb 2014 07:42:35 AM

Title: FSR to CDM Migration Utility
Post by: mooninsc on 05 Feb 2014 07:42:35 AM
I have an error trying to logon to the FSR database (first step in the CDM Migration Utility). I can't seem to find it or think what it might mean. Does anyone have any insight?

2014-02-05 08:14:40,945 [1] DEBUG Ibm.CognosDM.Migration.UI.App - (null) Setting the system current culture : en-US ? ? ? 
2014-02-05 08:15:39,537 [5] ERROR Ibm.CognosDM.Migration.UI.Managers.AppManager - (null) FsrDbSchema table has more than one row. ? ? ?  System.InvalidOperationException: FsrDbSchema table has more than one row.

The database is a SQL Server 2005 db.
Title: Re: FSR to CDM Migration Utility
Post by: Andi on 05 Feb 2014 08:02:54 AM
Hi mooninsc,

Can you please post some more details to help narrow down the issue?
- On the FSR Database, can you do a "SELECT *" on the  TXVersion table
- Log in FSR while connected to this database, go to Help-> About, and take a screenshot of the about window.
- What is the version of the migration tool used?

Thank you

Andi
Title: Re: FSR to CDM Migration Utility
Post by: mooninsc on 05 Feb 2014 11:40:39 AM
Thanks Andi,

Those questions made me take a look at the TXVERSION table and I had two rows in there.

That was my problem.

That occured because I moved this database from version 2008 to 2005 and used the generate scripts option to do that. I ran the script to populate this table twice.

moon