SCInstall.bat timeout

SCInstall.bat timeout

  
Hi,

I'm installing the platform 4.2 in a virtual machine. Also in this virtual machine there's an Sql Server 2005 where the outsystems db is installed.

In the configuration tool, the create/upgrade database works fine and also every test connection.

When installing the scinstall.bat an error occurrs:

Publishing Extension(s)...
Reading Service Center oml file information...
Adding Service Center eSpace to database...
Compiling Service Center eSpace...
Operation timed out. Retrying...
Message 1
Id : InternalError_TimeoutExpired
Type : Error
Message : Timeout Expired
Submitable : True
Details : An internal timeout has ocurred.
HelpRef : 2063
ExtraInfo : Exception Details:
[1] Timeout Expired: An internal timeout has ocurred.
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, C
ontextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
[2] System.Data.SqlClient.SqlException: Timeout expired. The timeout period ela
psed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData,
Boolean moreInfo)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, Run
Behavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBe
havior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, S
tring method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behav ior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteReader(IDbCommand cm
d, String description, Boolean isApplication, Boolean transformParameters, Boole
an skipLog)
at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteReader(IDbCommand cm d)
at OutSystems.HubEdition.Compiler.DBCompiler.GetDbSchemaFieldDataSqlServer_Ma
inColumnData(IDbTransaction tran, String tableName)
at #Ln.#Vo.#vB(String tableName, ArrayList& fieldDefs, ArrayList& secKeys, Ar
rayList& indexes)
at #Ln.#So.#nB(Boolean systemEntities)
at OutSystems.HubEdition.Compiler.Espace.#mD()
at OutSystems.HubEdition.Compiler.Espace.#lD()

Need your help.
Hi Tiago

the inner exception shows a SQL timeout error.

I suggest you increase the default query timeout value in the OutSystems Configuration Tool, under the database tab. The default is 30 seconds. Set it to 60 or 90 seconds.

If the problem persists, checkout the event viewer application log for additional errors or warnings.

Cheers
It worked. Thank you.
Hi guys,

I'm having a timeout error when pressing Configuration Tool's "Create/Upgrade Database" button. I already tried to increase Default Query Timeout value but it keeps hitting the 30sec default threshold. Any other way to increase this timeout?



Thanks!
..it seems that Configuration Tool 9.0.1.15 is not applying the proper QueryTimeOut changes. After changing the following property in machine.config the query ran without any problems.