Author Topic: FSR to CDM Migration Utility  (Read 5501 times)

Offline mooninsc

  • Associate
  • **
  • Join Date: Jan 2014
  • Posts: 2
  • Forum Citizenship: +0/-0
FSR to CDM Migration Utility
« 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.

Offline Andi

  • Associate
  • **
  • Join Date: Aug 2013
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: FSR to CDM Migration Utility
« Reply #1 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

Offline mooninsc

  • Associate
  • **
  • Join Date: Jan 2014
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: FSR to CDM Migration Utility
« Reply #2 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