This project is read-only.

Deployment Update Timeout

Topics: Developer Forum
Feb 2, 2007 at 11:17 AM
Hi,

I'm a new user of Sharpmap an MssqlSpatial.

Initial deployment on a new database works without any problems. I read in this wiki that updates should be possible by just deploying again, but I'm running into a SQL Timeout Exception after a couple minutes of waiting.
If I undeploy first and then deploy again, it succeeds, but the stored procedures seem to be messed up then, because those with table names have disappeared.
Right now I'm creating a new database for each update and restore my tables. The database file hast about 1GB.

Why doesn't the automatic update work? Am I doing something wrong?


Thanks

Jo
Feb 2, 2007 at 3:14 PM
In order to trace the source of the timeout, I need you paste here the full error message, please.

Best regards,
Ricardo Stuven.
Feb 2, 2007 at 4:49 PM
This discussion has been copied to Work Item 7928. You may wish to continue further discussion there.
Feb 5, 2007 at 7:58 AM
Hi
thanks for the quick response. For completion reasons, here is the error message:

D:\MsSqlSpatial\MsSqlSpatial\src\MsSqlSpatialConsole\bin\Release>msscmd.exe -dep
loy -server=localhost -db=GeoBayernSpatial

Unbehandelte Ausnahme: System.Data.SqlClient.SqlException: Timeout ist abgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs überschritten oder der Server reagiert nicht.
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
bei System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
bei System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
bei System.Data.SqlClient.TdsParserStateObject.ReadByte()
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei MsSqlSpatial.GeometryTable.ExecuteAddConstraintSRID(SqlCommand command, String schemaName, String tableName, String columnName, Int32 srid)
bei Deployment.RecreateAssemblyDependiencies(SqlCommand command) in D:\MsSqlSpatial\MsSqlSpatial\src\MsSqlSpatialConsole\Deployment.cs:Zeile 119.
bei Deployment.DeployAssembly(String assemblyFilename, String connectionString, String database, String deployPermission) in D:\MsSqlSpatial\MsSqlSpatial\src\MsSqlSpatialConsole\Deployment.cs:Zeile 51.
bei MsSqlSpatialConsole.Program.DeployAssembly(String connectionString, String database, ArgParser arg) in D:\MsSqlSpatial\MsSqlSpatial\src\MsSqlSpatialConsole\Program.cs:Zeile 93.
bei MsSqlSpatialConsole.Program.Main(String[] args) in D:\MsSqlSpatial\MsSqlSpatial\src\MsSqlSpatialConsole\Program.cs:Zeile 60.

Thanks,

Jo
Feb 5, 2007 at 6:31 PM
hello Jo,

Do you have a SqlExpress instance installed? Then use localhost\SqlExpress.

regards
Christian
Feb 8, 2007 at 9:11 AM
Hi Christian,

I don't have an instance name. I'm using the developer edition which is accessible via the default name (MSSQLSERVER) and therefore doesn't need an instance name specified.

The issue was resolved already. After the update (change set 17637) everything worked fine.

Jo