Cubit Estimating error connecting to database

To resolve Cubit Estimating error connecting to the database

This article is related to the below error:

Potential stack trace

System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> Buildsoft.Utilities.BuildsoftApplicationException: Error connecting to database

   at Buildsoft.PhoenixTakeOff.DataAccess.DataTransaction.#967FA07451FADF7D()

   at Buildsoft.PhoenixTakeOff.DataAccess.Queries.QuerySetBase.ExecuteNonQuery(String query, CommandType commandType, IDbDataParameter[] parameters)   at Buildsoft.PhoenixTakeOff.DataAccess.Queries.Original.MultiPurposeQuerySet.UpdateChildrenOrderInTradeContainer(Int32 containerId, Int32[] order)   at Buildsoft.PhoenixTakeOff.BusinessLogic.TakeOffBusinessLogic.#13DA2AFB1C1C920C(TradeContainerData ​, Int32 ​, Boolean ​, ConcurrentBag`1 ​)   at Buildsoft.PhoenixTakeOff.BusinessLogic.TakeOffBusinessLogic.#27F950E40130F61D.#D215CB00491020BA(TradeNodeData ​)

   at System.Threading.Tasks.Parallel.<>c__DisplayClassf`1.<ForWorker>b__c()

   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)

   at System.Threading.Tasks.Task.<>c__DisplayClass11.<ExecuteSelfReplicating>b__10(Object param0)

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)

   at System.Threading.Tasks.Task.Wait()

   at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 loca  at Buildsoft.PhoenixTakeOff.DataAccess.Queries.QuerySetBase.ExecuteNonQuery(String query, CommandType commandType, IDbDataParameter[] parameters)  at Buildsoft.PhoenixTakeOff.DataAccess.Queries.Original.MultiPurposeQuerySet.UpdateChildrenOrderInTradeContainer(Int32 containerId, Int32[] order)

Problem:

The database has failed to connect to the SQL server and has terminated the connection

Resolution:

Increase database connection timeout.

 1. Go to the location where Cubit Estimating is installed (C:\Program Files\Buildsoft\Cubit).

2. Open Cubit.exe.config

3. Find the DbConnectionTimeout setting as below. If it doesn't exist, add it to the config file.

<setting name =”DbConnectionTimeOut”seralizeA=”String

<value>150</value>

</setting>

4. Set the value to be higher until the issue is resolved (start with 250).

Fig 1. Timeout