07:39:16 PM
Virmati.Banking.CBS.CBSProc.bLimitAccount.GetLimitdetailsList --> Virmati.Banking.CBS.CBSData.dLimitAccount.GetLimitDetailsList --> DataCommon.OpenDataTable -select sum(amount) as totlmt, isnull(sum(drawingpower),0)  -isnull((select isnull(sum(frozenamount),0) from frozenlimit f where f.acno=1002005014672 and '07/18/2024' between f.frozenfrom and f.frozenupto and f.authorised=1 and IsNull(f.status,0)<>9),0) as totdp, sum(stockvalue) as totstock, insamt=(select isnull(sum(insuranceamount),0) from insurancemaster i where acno=1002005014672 and IsNull(i.status,0)<>9  and i.renewaldate is not null and i.renewaldate>='07/18/2024'),  min(renewaldate) as lmtrendt, min(docrenewaldate) as docrendt, min(sanctiondate) as lmtsancdt,min(stockrenewaldate) as stkrendt,min(DocumentDate) as DocDate    from LimitAccount l where acno=1002005014672 and IsNull(status,0)<>9 and l.authorised=0    --> .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.dLimitAccount.GetLimitDetailsList(Double pAcno, Int32 pBranchId, Object& ForDate, Boolean mShowSecondDate, Boolean mBankNature, Boolean pDoNotCheckRenewCond);   at Virmati.Banking.CBS.CBSProc.bLimitAccount.GetLimitDetailsList(Double pAcNo, Int32 pBranchId, Object& ForDate, Boolean mShowSecondDate, Boolean mBankNature, Boolean pDoNotCheckRenewCond)


07:39:16 PM
Virmati.Banking.CBS.CBSProc.bAccountMaster.FillProperties --> Virmati.Banking.CBS.CBSProc.bLimitAccount.GetLimitdetailsList --> Virmati.Banking.CBS.CBSData.dLimitAccount.GetLimitDetailsList --> DataCommon.OpenDataTable -select sum(amount) as totlmt, isnull(sum(drawingpower),0)  -isnull((select isnull(sum(frozenamount),0) from frozenlimit f where f.acno=1002005014672 and '07/18/2024' between f.frozenfrom and f.frozenupto and f.authorised=1 and IsNull(f.status,0)<>9),0) as totdp, sum(stockvalue) as totstock, insamt=(select isnull(sum(insuranceamount),0) from insurancemaster i where acno=1002005014672 and IsNull(i.status,0)<>9  and i.renewaldate is not null and i.renewaldate>='07/18/2024'),  min(renewaldate) as lmtrendt, min(docrenewaldate) as docrendt, min(sanctiondate) as lmtsancdt,min(stockrenewaldate) as stkrendt,min(DocumentDate) as DocDate    from LimitAccount l where acno=1002005014672 and IsNull(status,0)<>9 and l.authorised=0    --> .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.CBSProc.bLimitAccount.GetLimitDetailsList(Double pAcNo, Int32 pBranchId, Object& ForDate, Boolean mShowSecondDate, Boolean mBankNature, Boolean pDoNotCheckRenewCond);   at Virmati.Banking.CBS.CBSProc.bAccountMaster.FillProperties()


07:39:16 PM
Virmati.Banking.CBS.CBSProc.bAccountMaster.GetRecord --> Virmati.Banking.CBS.CBSProc.bAccountMaster.FillProperties --> Virmati.Banking.CBS.CBSProc.bLimitAccount.GetLimitdetailsList --> Virmati.Banking.CBS.CBSData.dLimitAccount.GetLimitDetailsList --> DataCommon.OpenDataTable -select sum(amount) as totlmt, isnull(sum(drawingpower),0)  -isnull((select isnull(sum(frozenamount),0) from frozenlimit f where f.acno=1002005014672 and '07/18/2024' between f.frozenfrom and f.frozenupto and f.authorised=1 and IsNull(f.status,0)<>9),0) as totdp, sum(stockvalue) as totstock, insamt=(select isnull(sum(insuranceamount),0) from insurancemaster i where acno=1002005014672 and IsNull(i.status,0)<>9  and i.renewaldate is not null and i.renewaldate>='07/18/2024'),  min(renewaldate) as lmtrendt, min(docrenewaldate) as docrendt, min(sanctiondate) as lmtsancdt,min(stockrenewaldate) as stkrendt,min(DocumentDate) as DocDate    from LimitAccount l where acno=1002005014672 and IsNull(status,0)<>9 and l.authorised=0    --> .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.CBSProc.bAccountMaster.FillProperties();   at Virmati.Banking.CBS.CBSProc.bAccountMaster.GetRecord(Double& AccountNumber, Boolean blnGetShadowBalance)


07:39:16 PM
Virmati.Banking.CBS.CBSProc.bAccounts.GetRecord --> Virmati.Banking.CBS.CBSProc.bAccountMaster.GetRecord --> Virmati.Banking.CBS.CBSProc.bAccountMaster.FillProperties --> Virmati.Banking.CBS.CBSProc.bLimitAccount.GetLimitdetailsList --> Virmati.Banking.CBS.CBSData.dLimitAccount.GetLimitDetailsList --> DataCommon.OpenDataTable -select sum(amount) as totlmt, isnull(sum(drawingpower),0)  -isnull((select isnull(sum(frozenamount),0) from frozenlimit f where f.acno=1002005014672 and '07/18/2024' between f.frozenfrom and f.frozenupto and f.authorised=1 and IsNull(f.status,0)<>9),0) as totdp, sum(stockvalue) as totstock, insamt=(select isnull(sum(insuranceamount),0) from insurancemaster i where acno=1002005014672 and IsNull(i.status,0)<>9  and i.renewaldate is not null and i.renewaldate>='07/18/2024'),  min(renewaldate) as lmtrendt, min(docrenewaldate) as docrendt, min(sanctiondate) as lmtsancdt,min(stockrenewaldate) as stkrendt,min(DocumentDate) as DocDate    from LimitAccount l where acno=1002005014672 and IsNull(status,0)<>9 and l.authorised=0    --> .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.CBSProc.bAccountMaster.GetRecord(Double& AccountNumber, Boolean blnGetShadowBalance);   at Virmati.Banking.CBS.CBSProc.bAccounts.GetRecord(Double AcnoID, Object& SerialNumber, Int16 pIntRateForPremature, Single pPreMatRate, Boolean blnGetShadowBalance, Boolean blnGetCustomerdetails)