FSR to CDM Migration Utility

[mooninsc]

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.

[Andi]

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

[mooninsc]

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