+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, FMS migration - help!! (surprise) in Technical; Got through all the preliminary stages of the migration fine, without a single hitch. Then click Migrate and a lovely ...
  1. #1

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    FMS migration - help!! (surprise)

    Got through all the preliminary stages of the migration fine, without a single hitch.

    Then click Migrate and a lovely message comes up
    "Migration has failed to complete successfully"
    1. Re-attach an empty SQL server FMS database
    2. Review the migration log file
    3. Seek assistance from support

    The utility seemed to have caused a system exception to do with ODBC. General Error, attempted 2 active database requests..?! This is after examining the migration log.

    At one point, before quitting the utility through up a message about login failed for user ccsfms_sysman.

    Has anybody seen this, or any idea of what just happened...

    and it was going so well....this might be a long day...



    SQLConvLOg.txt contents

    **********************************
    Data Migration From Sybase to MS SQL
    Execute 06 December 2007 12:26:27
    Performed By: Administrator
    Computer Name: EDMUND
    **********************************

    06/12/2007 12:26:46...Connecting to Sybase...
    06/12/2007 12:26:52...Sybase Connected.
    06/12/2007 12:27:16...Connecting to MS SQL database...
    06/12/2007 12:27:17...MS SQL connection sucessful
    06/12/2007 12:27:48...Viewing Terms and Conditions.
    06/12/2007 12:29:19...Terms and Conditions Accepted.
    06/12/2007 12:29:20...4 Patches to Run
    06/12/2007 12:29:20...280 tables referenced
    06/12/2007 12:29:20...Disabling MS SQL Foreign Keys + Triggers
    06/12/2007 12:29:26...MS SQL Foreign Keys + Triggers Disabled
    06/12/2007 12:29:26...Deleting MS SQL records.
    06/12/2007 12:29:29...MS SQL records deleted
    06/12/2007 12:29:30...bp.income_expenditure_plan >> income_expenditure_plan
    06/12/2007 12:29:30...bp.income_expenditure_plan: Record count = 0
    06/12/2007 12:29:30...ereg.insurance >> insurance
    06/12/2007 12:29:30...ereg.insurance: Record count = 0
    06/12/2007 12:29:30...ereg.depreciation_profile >> depreciation_profile
    06/12/2007 12:29:31...System exception: System.Data.Odbc.OdbcException: ERROR [HY000] [Sybase][ODBC Driver]General error: attempted two active database requests
    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)
    at System.Data.Odbc.OdbcDataReader.Read()
    at System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping)
    at System.Data.Common.DataAdapter.FillFromReader(Data Set dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
    at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
    at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
    at MSSQLconversionUtility.frmConvert.f_MigrateData(Od bcCommand syb_select, SqlCommand aSqlCommand, Int32 intTableCount)
    at MSSQLconversionUtility.frmConvert.TransferDataFrom SybaseToMSSQL()
    06/12/2007 12:32:07...MS SQL connection closed
    06/12/2007 12:32:08...SYBASE connection closed

  2. #2

    Join Date
    Aug 2008
    Posts
    4
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    HOW DID YOU FIX IT

    GETTINGTHIS MESSAGE IN QUITE A FEW OF THE SCHOOLS IM TRYING TO MIGRATE
    DID YOU GET A SOLUTION YOU CAN REMEBER??
    CHEERS

  3. #3

    Join Date
    Jul 2008
    Posts
    276
    Thank Post
    24
    Thanked 10 Times in 9 Posts
    Blog Entries
    2
    Rep Power
    18
    Quote Originally Posted by macuil View Post
    GETTINGTHIS MESSAGE IN QUITE A FEW OF THE SCHOOLS IM TRYING TO MIGRATE
    DID YOU GET A SOLUTION YOU CAN REMEBER??
    CHEERS
    I think you need to buy a new keyboard, the CAPS LOCK seems to be stuck on

  4. #4
    wagnerk's Avatar
    Join Date
    Jun 2007
    Location
    Northants
    Posts
    806
    Thank Post
    63
    Thanked 166 Times in 135 Posts
    Rep Power
    46
    Have you contacted Sims about this? And are you using their step by step guide? If not, I believe I still have it somewhere, if you want.

    For me the only reason the FMS migration failed the first time round was because there was a user name that had spaces in it, don't know if that'll help.

    -Ken

  5. #5

    Join Date
    Aug 2008
    Posts
    4
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Wink Thanks for replies

    Yes I have been following step by step guide.
    Its worked in about 40ish schools no problem
    but the above log error is coming up in about 20.
    Have had some feedback from capita website suggesting stripping out and reinstalling SQLany server but seemed like a lot of work.

    Looking for a quick fix

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Re-Run
    S:\Setups\FMS\FMSApplicationSetup.exe

    The near last page will say where it's installing it to, make sure the files are going to the correct location, THEN delete the fms file (after detaching it) then reattach the new FRESH blank db. Re import, also, if your having trouble with the Anywhere client, get it to run with the background (forgot the exact term) so you can see the actual client (interactive with the background!)

    Other then that, contact your LEA and ask them to migrate it.

  7. Thanks to matt40k from:

    macuil (20th August 2008)

  8. #7

    Join Date
    Aug 2008
    Posts
    4
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    thanks

    I'll try all that.
    unfortunately I work for the LEA, thats why i've got nearly 70 schools to do!

  9. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Didn't see that

    Why have you left it soo late? What LEA is that?
    Do you have a good internet connect to each school\remote access?

    I would try my previous post, key is 1GB ram at least.

    Edit:
    06/12/2007 12:29:31...System exception: System.Data.Odbc.OdbcException: ERROR [HY000] [Sybase][ODBC Driver]General error: attempted two active database requests

    Tis to do with SQL Anywhere rubbish, run the client as interactive with the desktop, your see where it goes wrong. Make sure all the settings are correct.
    Last edited by matt40k; 20th August 2008 at 10:14 AM. Reason: RE-READ

  10. #9

    Join Date
    Aug 2008
    Posts
    4
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    NEELB in Northern Ireland same for the other 4 education boards here as we are all under one umbrella.
    Priorities (rolling out and setting up 30,000 laptops for teachers) meant we weren't given it to do until 3rd week of july!
    Did you get this last summer?
    Yeah access to machines is good 2 mb lines 8 gig ram in blade servers.

    I'll try this again this avo

  11. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    We've actually only just send it out about a month or so ago. Was rather shock it too this long to get the powers that be, to agree the "new business" project.

  12. #11

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,136
    Thank Post
    215
    Thanked 1,258 Times in 789 Posts
    Blog Entries
    4
    Rep Power
    507
    Reboot the server and make sure no-one logs onto fms before trying again.

    Looks like there might be a data connection that didn't close properly

SHARE:
+ Post New Thread

Similar Threads

  1. FMS Migration - SA
    By ndavies in forum MIS Systems
    Replies: 5
    Last Post: 10th December 2007, 12:13 PM
  2. Net slowdown : why is this a surprise?
    By contink in forum IT News
    Replies: 5
    Last Post: 20th November 2007, 07:17 PM
  3. Sophos SQL Migration
    By randle in forum Windows
    Replies: 2
    Last Post: 19th November 2007, 03:47 PM
  4. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 12:00 PM
  5. FMS migration
    By ndavies in forum MIS Systems
    Replies: 3
    Last Post: 3rd November 2007, 02:45 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •