Error Update the database schema in the designer

Posts   
 
    
Posts: 497
Joined: 08-Apr-2004
# Posted on: 26-Jun-2008 10:36:48   

Hi,

When trying to update the schema for our database, we've started receiving an error (posted below).

This database was previously working without problem. We have recently started working with synonyms, but after we got this error, we tried removing them all and refreshing again, but still get the error.

We're still on 2.0 (Final December 6th 2006), since we're at the end of a large release we're going to wait until we ship before we upgrade to 2.6.

Any ideas?

Message
Index was outside the bounds of the array.

Source
SD.LLBLGen.Pro.DBDrivers.SqlServerDBDriver

Stack Trace:
•   -----[Core exception]--------------------
•      at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerSchemaRetriever.RetrieveAllTablesViewsSynonymsAndFields(SqlConnection connectionSqlServer)
•      at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerSchemaRetriever.RetrieveSchema(String connectionString, IDBSchema schemaToRetrieve, SchemaFetchFlags fetchFlags)
•      at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerCatalogRetriever.RetrieveSchemas(String connectionString, IDBCatalog catalogToRetrieve, SchemaFetchFlags fetchFlags)
•      at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerDBDriver.PopulateSelectedCatalogs(Hashtable callBacks, Hashtable connectionElements, SchemaFetchFlags fetchFlags, Hashtable properties)
•      at SD.LLBLGen.Pro.Gui.Forms.MainWindow.RefreshCatalogs(Boolean unattended, Hashtable catalogsToRefresh)
•      at SD.LLBLGen.Pro.Gui.Forms.MainWindow.RefreshAllCatalogs(Boolean unattended)
•      at SD.LLBLGen.Pro.Gui.Forms.MainWindow.OnProjectExplorerCatalogsRefreshClicked(Object sender, CatalogRefreshEventArgs e)
•      at SD.LLBLGen.Pro.Gui.Forms.ProjectExplorer._menuItemCatalogsRefresh_Click(Object sender, EventArgs e)
•      at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
•      at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
•      at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
•      at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
•      at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
•      at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
•      at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
•      at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
•      at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
•      at System.Windows.Forms.Control.WndProc(Message& m)
•      at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
•      at System.Windows.Forms.ToolStrip.WndProc(Message& m)
•      at System.Windows.Forms.ToolStripDropDown.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)

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 26-Jun-2008 11:06:23   

This bug was solved in July 2007. Please download the latest release of v.2.0.

Posts: 497
Joined: 08-Apr-2004
# Posted on: 26-Jun-2008 13:01:49   

Great, thanks very much for the info.