Scribe Upgrade to 7.9.2 workbench error



We are working on a scribe upgrade project. The client has scribe insight 7.8.0, we need to upgrade to 7.9.2. however, after we upgraded in test environment, we see two issues so far, not sure if they are related.


Can you please look into it?


  1. The workbench crashes when create a XML connection.



  1. Workbench throws error when we try to open an existing dts.




See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.


************** Exception Text **************

Scribe.DRS.DRSException (0x80040380): [37000] Incorrect syntax near 's'. Unclosed quotation mark after the character string ')'.

   at Scribe.OleDBAdapter.Database.DoExecuteSQLWithOptions(ADPDatabase adpDB, String sQuery, Int32 eOptions, Int16 iConnectionType, String& sRetVal)

   at ADP.ADPDatabase.Execute(String SQLCommand, Int16 options)

   at Scribe.DTS.DataProvider.SaveDRSProperties(ADPDatabase db, IntPtr book, F1Book f1Book, IntPtr comBook, Int32 rowOffset, Int32 colOffset)

   at Scribe.DTS.DataProvider.SaveToDB(IntPtr book, F1Book f1Book, IntPtr comBook, Int32 rowOffset, Int32 colOffset)

   at Scribe.DTS.DataProvider.SaveLabel()

   at Scribe.DTS.ResolveConnection.btnNext_Click(Object 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(MouseEventArgs 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.Control.ControlNativeWindow.OnMessage(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

(3) Answers