Lightspeed editor does not update

Hi,

I have a database of 70+ tables, when I add a new table and try to drag it to the Lightspeed model via visual studio, it doesn't appear in the model - I have to keep trying to drag it for many times (sometimes 30 times!). Is this a know issue for you? Can I do something from my side to resolve this issue?

Many thanks

Hi,

This is certainly not a known issue. Out of interest, can you clarify:

1. It does eventually work?
2. What version of Visual Studio are you using?
3. When it does work, did you drag over parts, or was it still dropping all the tables at once?

Kind regards,

John-Daniel Trask

Hi,

Thanks for the quick reply. for your questions:

1. Yes, after many tries it work eventually
2. I'm using vs2013 and vs2010 - the problem happens in both
3. I drag only the new table.

Here is the output exception I get:

Exception while processing Server Explorer drag: MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation at MySql.Data.MySqlClient.TimedStream.StopTimer() at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 columns) at MySql.Data.MySqlClient.Driver.FetchDataRow(Int32 statementId, Int32 columns) at MySql.Data.MySqlClient.ResultSet.GetNextRow() at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlDataReader.Read() at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception) at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex) at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex) at MySql.Data.MySqlClient.MySqlDataReader.Read() at MySql.Data.MySqlClient.ISSchemaProvider.GetTable(String sql) at MySql.Data.MySqlClient.ISSchemaProvider.GetForeignKeys(String[] restrictions) at MySql.Data.MySqlClient.SchemaProvider.GetSchemaInternal(String collection, String[] restrictions) at MySql.Data.MySqlClient.ISSchemaProvider.GetSchemaInternal(String collection, String[] restrictions) at MySql.Data.MySqlClient.SchemaProvider.GetSchema(String collection, String[] restrictions) at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName, String[] restrictionValues) at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName) at Mindscape.LightSpeed.Generator.Extraction.MySql5.d16.MoveNext() at Mindscape.LightSpeed.Generator.Extraction.ForeignKeyInfo.Merge(IEnumerable1 foreignKeys) at Mindscape.LightSpeed.Generator.Extraction.Provider1.AddRelationshipsToEntities(TConnection connection, Dictionary2 entities, IList1 tablesToFullyPopulate) at Mindscape.LightSpeed.Generator.Extraction.Provider1.PopulateTypeModel(TypeModel model, TConnection connection, Boolean pluralise, IList1 tablesToFullyPopulate) at Mindscape.LightSpeed.Generator.Extraction.Provider1.ExtractModel(Boolean pluralise, IList1 tablesToFullyPopulate) at Mindscape.LightSpeed.Generator.Integration.EntityExtractor.PopulateTypeModel(IList1 tableNames, Boolean pluralisedInDatabase) at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, IDesignTimeNamingStrategy namingStrategy, ILightSpeedDataSource connection, IEnumerable1 tableNames, IGenerationLog log) at Mindscape.LightSpeed.Generator.Integration.DiagramDragDropHandler.<>cDisplayClass6.b__4(DragObject dragObject, IGenerationLog log) at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

Hi John-Daniel

Any updates regarding this issue?

Thanks