SIMS SQL 2012 Migration Failing

[Snuffkins]

Hi All,

 

I'm in the process of migrating from SQL 2008 R2 on a 2008R2 Server to SQL 2012 on a 2012 R2 server. I'm using the migration tools and the first part seemed to go ok when running on the original SQL server. However, now I've come to run it on 2012 and it fails at Configure SIMS Database with the below:

 

 

27/05/2015 09:41:37 Info Migration Started on BHA-SQL-01 by administrator

-----------------STEPS---------------------------

Copy Database Backup File From F:\SQL 2012 Migration to T:\SimsNet

Install Server Applications

Restore SIMS Database BHA-SQL-01\BHASQLSVR | SIMS

Configure SIMS Database

-----------------STEPS---------------------------

27/05/2015 09:42:04 Info START: Copy Database Backup File

27/05/2015 09:42:37 Info SUCCEED: Copy Database Backup File

27/05/2015 09:42:37 Info START: Install Server Applications

27/05/2015 09:42:43 Info SUCCEED: Install Server Applications

27/05/2015 09:42:43 Info START: Restore SIMS Database

27/05/2015 09:43:54 Info SUCCEED: Restore SIMS Database

27/05/2015 09:43:54 Info START: Configure SIMS Database

27/05/2015 09:44:41 ***STOP*** FAIL: Configure SIMS Database

-----------------ERRORS-------------

Could not find method 'CreateManagedTask' for type 'SIMS.ScheduledTasks.SQLFunctionInterface' in assembly 'SIMSScheduler'

Could not find method 'GetManagedTaskNames' for type 'SIMS.ScheduledTasks.SQLFunctionInterface' in assembly 'SIMSScheduler'

Could not find method 'GetManagedScheduledTasks' for type 'SIMS.ScheduledTasks.SQLFunctionInterface' in assembly 'SIMSScheduler'

Could not find method 'UpdateManagedTask' for type 'SIMS.ScheduledTasks.SQLFunctionInterface' in assembly 'SIMSScheduler'

Could not find method 'UpdateManagedTaskParameters' for type 'SIMS.ScheduledTasks.SQLFunctionInterface' in assembly 'SIMSScheduler'

Could not find method 'DeleteManagedTask' for type 'SIMS.ScheduledTasks.SQLFunctionInterface' in assembly 'SIMSScheduler'

 

 

 

I was just wondering if anyone had seen this before. There doesn't seem to be anything of any use in the event logs either.

[vikpaw]

Maybe some of the installer files are old or incomplete. Worth re-downloading the tool again just in case. There was an updated one released not long ago.

This was another problem someone had related to disk space, it looks like you've gone further than that already, but just in case worth checking. http://www.edugeek.net/forums/mis-systems/154263-simssqlapplicationssetup-exe-unable-install-due-lack-space.html

[Snuffkins]

In the end i did it manually although when i attached the SIMS DB it gave me the same error at the end. I was wondering whether it was something to do with the issues with B2B and the Spring Upgrade. I've got sims working on the new server, but i get a fault code when looking at the B2B scheduled tasks. Having checked that code there's a patch to resolve it, which i need to apply.

 

I guess though if I'd applied that patch prior to using the migration tools it would have worked ok.

[Snuffkins]

That is what was causing the migration to fail by the looks of it. Had to apply patch 20419 to resolve the B2B scheduled tasks error once I'd migrated manually. Tried on a test server and it would have solved the migration tools issue as well or seems to have done. So if anyone else has waited as long as we have to do the migration and they're getting this error then that's why.

[ianriley1986]

I had same issue when migrating to SQL 2014. This from Capita resolved it for me:-

 

Can you please go to your setups folder and then run SIMSSQLApplicationSetup and point it towards a brand new folder. Once it has finished running then copy the contents and paste them into your old SQL binn folder and your new SQL binn folder replacing all the files it asks you too. Do not run the SIMSSQLapplicationSetup.exe directly to both the binn folders as it may skip over the files instead of replacing them.

 

Once you have done this then run the migration again and make sure you are using the SA account to run it.

[lollettuk]

Ran into this problem today:

 

Could not find method 'CreateManagedTask' for type...

 

I believe the version of DBAttach in SIMSSQLApplicationSetup.exe included with SQL Migration is out of date.

 

Simple fix: Overwrite the SIMSSQLApplicationSetup.exe in the SQLMigration folder with your latest version from the SIMS Setups folder.

[Meldrew]

Ran into this problem today:

 

Could not find method 'CreateManagedTask' for type...

 

I believe the version of DBAttach in SIMSSQLApplicationSetup.exe included with SQL Migration is out of date.

 

Simple fix: Overwrite the SIMSSQLApplicationSetup.exe in the SQLMigration folder with your latest version from the SIMS Setups folder.

 

Just hit this today as I'm just now upgrading to 2014. What wasn't clear to me (but I can see in hindsight), was that it appears SQLMigration.exe itself runs the SIMSSQLApplicationSetup.exe sitting alongside it. I was manually running a newer version of SIMSSQLApplicationSetup, which it kept downgrading for me.

 

Hope this helps someone else.

 

Meldrew