+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SIMS FMS - 6.85 to 6.91 upgrade, DBAttach gives unhandled exception in Technical; I have successfully installed the 6.83 to 6.85 upgrade and have moved on to the 6.91 installation. I have installed ...
  1. #1
    nry
    nry is offline
    nry's Avatar
    Join Date
    Jul 2009
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS FMS - 6.85 to 6.91 upgrade, DBAttach gives unhandled exception

    I have successfully installed the 6.83 to 6.85 upgrade and have moved on to the 6.91 installation.

    I have installed SQL Server 2005 Express from the FMS CD and have installed the 6.91 software. I am at the stage where I need to run dbattach and can successfully enter the server name, username and password.

    I then enter a database name and choose the CCSFMS.MDF file and click attach. After a few seconds I am given a pop-up error box which states:

    SIMS Database Management Utility
    A unhandled exception has occured in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will be shut down immediately.

    The details of this error are:

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.Data.SqlClient.SqlException: General network error. Check your network documentation.
    at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
    at System.Data.SqlClient.SqlCommand.ExecuteScalar()
    at DbAttach.dbHelper.isNewSecurity(String dbname)
    at DbAttach.InterfaceModeForm.buttonAttach_Click(Obje ct sender, EventArgs e)
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
    at System.Windows.Forms.Button.WndProc(Message& m)
    at System.Windows.Forms.ControlNativeWindow.OnMessage (Message& m)
    at System.Windows.Forms.ControlNativeWindow.WndProc(M essage& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2379
    CodeBase: file:///c:/winnt/microsoft.net/framework/v1.1.4322/mscorlib.dll
    ----------------------------------------
    DbAttach
    Assembly Version: 1.4.10.24588
    Win32 Version: 1.4.10.24588
    CodeBase: file:///D:/binn/DbAttach.exe
    ----------------------------------------
    System.Windows.Forms
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2365
    CodeBase: file:///c:/winnt/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
    ----------------------------------------
    System
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2380
    CodeBase: file:///c:/winnt/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
    ----------------------------------------
    System.Drawing
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2327
    CodeBase: file:///c:/winnt/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
    ----------------------------------------
    System.Data
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2365
    CodeBase: file:///c:/winnt/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
    ----------------------------------------
    System.EnterpriseServices
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2326
    CodeBase: file:///c:/winnt/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.dll
    ----------------------------------------
    System.Xml
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2371
    CodeBase: file:///c:/winnt/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just in time (JIT) debugging, the config file for this
    application or machine (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
    <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the machine
    rather than being handled by this dialog.

    I cannot find anything relating to this specific error in the knowledge base from Capita and yet again they've pointed me to Professional Services as they no longer support the upgrade.

    I'm currently told I should have a file called FMSSQLApplicationSetup.exe to run to confirm the DBUpgrade files are installed correctly, but I'm not even at that stage yet nor do I have that file, only the new FMSApplicationSetup.exe which kicks off the 6.91 install again.

  2. #2
    nry
    nry is offline
    nry's Avatar
    Join Date
    Jul 2009
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Checking Event Viewer I can see this error:

    Error: 50000 Severity: 22 State: 127 Error ASSEMBLY SIMSSqlUtilities Does not exist, Please Run SIMSSQLApplicationSetup.exe and install to C:\Program Files\Microsoft SQL Server Express\MSSQL.2\MSSQL\binn

    Still unsure what this SIMSSqlApplicationSetup.exe file is though?

  3. #3
    nry
    nry is offline
    nry's Avatar
    Join Date
    Jul 2009
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    More digging around...I restored a SIMSSqlApplicationSetup.exe from our old admin server (which had SIMS on too). Running this and installing to the directory from the Event Viewer error does not fix things, it still complains in the same manner. Is there perhaps a different version of this setup exe that I need?

SHARE:
+ Post New Thread

Similar Threads

  1. Problem with batch backup or SIMS.net using DBAttach
    By GreenICT in forum MIS Systems
    Replies: 5
    Last Post: 18th August 2009, 08:48 AM
  2. SIMS FMS - 6.83 to 6.85 upgrade issues
    By nry in forum MIS Systems
    Replies: 11
    Last Post: 11th August 2009, 11:06 AM
  3. SIMS: dropping logins when using dbAttach
    By Oops_my_bad in forum MIS Systems
    Replies: 4
    Last Post: 6th February 2009, 06:15 PM
  4. SIMS FMS Manager upgrade
    By cjohnsonuk in forum MIS Systems
    Replies: 11
    Last Post: 5th March 2008, 08:51 PM
  5. Replies: 1
    Last Post: 8th November 2007, 12:44 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
  •