******************** time ********************
2022-10-25 14:45:37


******************** query ********************
SELECT COALESCE((SELECT CASE COUNT(*) % 30 WHEN 0 THEN COUNT(*) / 30 ELSE COUNT(*) / 30 +1 END FROM __Project__ p WHERE p.Id > 0 AND p.FPId = 1  AND p.Id NOT IN (SELECT ProjectId FROM dbo.__GetUnAccessProject__(1, 3))  AND p.Id IN (SELECT acc.PrjId FROM __AccVsPrj__ acc WHERE acc.FPId = 1 AND acc.FullId = '1110010001')  ), 0)


******************** message ********************
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)


******************** InnerException ********************
System.ComponentModel.Win32Exception (121): The semaphore timeout period has expired.


******************** StackTrace ********************
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1075
   at Dapper.SqlMapper.QueryRowImpl[T](IDbConnection cnn, Row row, CommandDefinition& command, Type effectiveType) in /_/Dapper/SqlMapper.cs:line 1187
   at Dapper.SqlMapper.QueryFirstOrDefault[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 774
   at BaseServices.SysDataAccessLayer.ExecuteQueryFirstOrDefault[T](IDbConnection& dbConnection, String query, Int32& errIndex, Object param, IDbTransaction dbTransaction) in C:\dev\project\tadbirapplications_service\BaseServices\Services\Implementation\SysDataAccessLayer.cs:line 2173
   at BaseServices.Services.Implementation.AccountingRepository.LookupProjects(APIHeader header, String accountFullId, String inputFilter, Int32 pageNumber, Int32 pageSize, Int32 sort) in C:\dev\project\tadbirapplications_service\BaseServices\Services\Implementation\AccountingRepository.cs:line 590


