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 ...
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 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)
************** 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
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.
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?
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?