07:02:30 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction);   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose);   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady);   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted);   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest);   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery();   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj)


07:02:30 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj);   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP(dTransactions& pobjDB, Int64 pCardTrnAuto, dTrnFinInc objdTrnFinInc)


07:02:30 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 129) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction);   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose);   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady);   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted);   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest);   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery();   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj)


07:02:30 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 129) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj);   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP(dTransactions& pobjDB, Int64 pCardTrnAuto, dTrnFinInc objdTrnFinInc)


07:02:30 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 124) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction);   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose);   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady);   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted);   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest);   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery();   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj)


07:02:30 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 124) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj);   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP(dTransactions& pobjDB, Int64 pCardTrnAuto, dTrnFinInc objdTrnFinInc)


07:02:31 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 125) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction);   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose);   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady);   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted);   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest);   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery();   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj)


07:02:31 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 125) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj);   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP(dTransactions& pobjDB, Int64 pCardTrnAuto, dTrnFinInc objdTrnFinInc)


07:02:32 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 129) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction);   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose);   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady);   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted);   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest);   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery();   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj)


07:02:32 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 129) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj);   at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP(dTransactions& pobjDB, Int64 pCardTrnAuto, dTrnFinInc objdTrnFinInc)


08:02:42 PM
DataCommon.OpenDataTable -SELECT BranchCode,Code,ProductCode,MinimumProductDay,ClearNetBalance,AgainstClearing,Roundoff,LastAccountNumber,TODoption,ClearingOption,WithdrawalPassing,CreditInterestRate,MinCreditInterestRate,MaxCreditInterestRate,CreditInterestRoundOff,MinInterestTopay,DebitInterestRate,MinDebitInterestRate,MaxDebitInterestRate,DebitInterestRoundOff,DebitInterestTocharge,MinDebitInterestTocharge,AgainstClgInterestRate,minAgainstClgRate,maxAgainstClgRate,AgainstClgInterestTocharge,MinAgainstClgInterestTocharge,PenalInterestRate,minPenalRate,maxPenalRate,PenalInterestTocharge,MinPenalInterestTocharge,InterestApplyDays,NextInterestDueDate,TaxRateOnInterestRate,TaxRateOnInterestAmount,AcountClosingCharges,MinimumBalance,ChargesAppliedDate,Int7Cumm,Live,ChargesType,FreeLeafs,ChargePerLeafs,ChargeMinBalance,NoofMonthForCharges,ChargesCutOffDate,InterestRatePattern,HolidayInterest,InterestAfterMaturity,NoOfPartWithdrawal,MinAmountWithdrawal,InMultipleOfAmount,MaxAmountPartWithdrawal,ReceiptNumber,ReceiptAlpha,PassbookCharges,GLAcForPBCharges,PBChargesAmt,CrCashTrnsLimit,CrOtherLimit,DrCashTrnsLimit,DrOtherLimit,TaxRateOnDrInterest,TDSRateOnCrInterest,FirstEntryCashAllowed,FirstEntryClgAllowed,FirstEntryTrfAllowed,MinFirstEntryCashAmt,MinFirstEntryClgAmt,MinFirstEntryTrfAmt,StartingDate,EndingDate,AllowIntOnPartMth,MaximumProductDay,IntroducerReqd,MaxLimitAmount,TODAllowed,MaxLimitPeriodDays,MinLimitAmt,MaxLimitAmt,MinBalanceWithChqBook,CurrencyCode,LateIntApplicable,LateIntRoundOff,MinLateInterest,ApplyLateIntOn,LateIntAcno,ReceivableAccounting,ChargesPayableAccount,PenalPayableAccount,CreatePartyVoucher,ReceivableEntry,ReceivedCPI,CheckTDBalForChg,TDBalanceForMinBal,passunderdiswithlimit,PassbookPrintingAllow,MinBalForIntCal,IsForMobile,CalcMinBalChgAcClose,CalcAvgBalChgAcClose,NominalMemberLoanLimit,minbalchgtype,MinDueInstalmentPartWithdrawal,SBCAIntLastProvisionDate,SBCAIntProvisionAmt,IntAsPerRepaySch,AllowTrnWithoutChqNo,CalcPeriodicChargeAcClose,MinLimitAmount,ChkFolioForSBInt,MaxFolioForSBInt,IntroEligiblePeriod  FROM AccountTypeBranchParameters where code = 14 and BranchCode = 1002 and UPPER(CurrencyCode) = 'INR' --> .Net SqlClient Data Provider -->  --> Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding., ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "AccountTypeBranchParameters"
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction);   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose);   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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted);   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest);   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry);   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method);   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method);   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior);   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior);   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable);   at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, DataTable& dtTable, String TableName, Boolean pCloseConn)


08:02:42 PM
Virmati.Banking.CBS.CBSData.dAccountTypeBR.GetRecord --> DataCommon.OpenDataTable -SELECT BranchCode,Code,ProductCode,MinimumProductDay,ClearNetBalance,AgainstClearing,Roundoff,LastAccountNumber,TODoption,ClearingOption,WithdrawalPassing,CreditInterestRate,MinCreditInterestRate,MaxCreditInterestRate,CreditInterestRoundOff,MinInterestTopay,DebitInterestRate,MinDebitInterestRate,MaxDebitInterestRate,DebitInterestRoundOff,DebitInterestTocharge,MinDebitInterestTocharge,AgainstClgInterestRate,minAgainstClgRate,maxAgainstClgRate,AgainstClgInterestTocharge,MinAgainstClgInterestTocharge,PenalInterestRate,minPenalRate,maxPenalRate,PenalInterestTocharge,MinPenalInterestTocharge,InterestApplyDays,NextInterestDueDate,TaxRateOnInterestRate,TaxRateOnInterestAmount,AcountClosingCharges,MinimumBalance,ChargesAppliedDate,Int7Cumm,Live,ChargesType,FreeLeafs,ChargePerLeafs,ChargeMinBalance,NoofMonthForCharges,ChargesCutOffDate,InterestRatePattern,HolidayInterest,InterestAfterMaturity,NoOfPartWithdrawal,MinAmountWithdrawal,InMultipleOfAmount,MaxAmountPartWithdrawal,ReceiptNumber,ReceiptAlpha,PassbookCharges,GLAcForPBCharges,PBChargesAmt,CrCashTrnsLimit,CrOtherLimit,DrCashTrnsLimit,DrOtherLimit,TaxRateOnDrInterest,TDSRateOnCrInterest,FirstEntryCashAllowed,FirstEntryClgAllowed,FirstEntryTrfAllowed,MinFirstEntryCashAmt,MinFirstEntryClgAmt,MinFirstEntryTrfAmt,StartingDate,EndingDate,AllowIntOnPartMth,MaximumProductDay,IntroducerReqd,MaxLimitAmount,TODAllowed,MaxLimitPeriodDays,MinLimitAmt,MaxLimitAmt,MinBalanceWithChqBook,CurrencyCode,LateIntApplicable,LateIntRoundOff,MinLateInterest,ApplyLateIntOn,LateIntAcno,ReceivableAccounting,ChargesPayableAccount,PenalPayableAccount,CreatePartyVoucher,ReceivableEntry,ReceivedCPI,CheckTDBalForChg,TDBalanceForMinBal,passunderdiswithlimit,PassbookPrintingAllow,MinBalForIntCal,IsForMobile,CalcMinBalChgAcClose,CalcAvgBalChgAcClose,NominalMemberLoanLimit,minbalchgtype,MinDueInstalmentPartWithdrawal,SBCAIntLastProvisionDate,SBCAIntProvisionAmt,IntAsPerRepaySch,AllowTrnWithoutChqNo,CalcPeriodicChargeAcClose,MinLimitAmount,ChkFolioForSBInt,MaxFolioForSBInt,IntroEligiblePeriod  FROM AccountTypeBranchParameters where code = 14 and BranchCode = 1002 and UPPER(CurrencyCode) = 'INR' --> .Net SqlClient Data Provider -->  --> Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, DataTable& dtTable, String TableName, Boolean pCloseConn);   at Virmati.Banking.CBS.CBSData.dAccountTypeBR.GetRecord(Int16 AccountTypeID, Int32 BranchID, String CurrencyCode, DataTable dt)