Log File Initialized... 5/10/2024 1:34:34 AM 5/10/2024 1:34:34 AM: Cache Cleared.... 5/10/2024 1:35:08 AM: Cache Cleared.... 5/10/2024 5:29:22 AM: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 5/10/2024 5:29:22 AM: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 5/10/2024 5:29:32 AM: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 5/10/2024 5:29:32 AM: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 5/10/2024 5:30:38 AM: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 5/10/2024 5:30:38 AM: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 9300\. will result in 706775\. which is greater than 700000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 5/10/2024 5:33:27 AM: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 5/10/2024 5:33:27 AM: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 5/10/2024 5:33:36 AM: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 5/10/2024 5:33:36 AM: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 700000\. You have already Policies amount of 697475\. and adding more 5200\. will result in 702675\. which is greater than 700000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 5/10/2024 9:13:47 PM: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at ZealERP.ZealTakaful.Reports.PremiumRegisterIL.PremiumRegisterIL.PrepareReport() 5/10/2024 11:02:50 PM: SELECT a.*,b.BENEFICIARY_NAME NAME_OF_BENEFICIARY2, c.FIRST_NAME ||' '||c.MIDDLE_NAME||' '||c.LAST_NAME AS NAME_OF_INSURED2 , c.dob BIRTHDATE,d.DOC_REFERENCE_NO APPLICATION_NO2 FROM IL_DOC_CLIENT_ANNX_04_T a left join IL_DOC_BENEFICIARY_T b ON (a.ORG_ID=b.ORG_ID and a.BRANCH_ID=b.BRANCH_ID and a.MAIN_PRODUCT_CODE=b.MAIN_PRODUCT_CODE and a.SUB_PRODUCT_CODE=b.SUB_PRODUCT_CODE and a.TAKAFUL_TYPE=b.TAKAFUL_TYPE and a.DOCUMENT_TYPE=b.DOCUMENT_TYPE and a.RECORD_TYPE=b.RECORD_TYPE and a.DOCUMENT_YEAR=b.DOCUMENT_YEAR and a.ISSUE_COUNT=b.ISSUE_COUNT and a.ENDORSEMENT_NO=b.ENDORSEMENT_NO and a.APPLICATION_ID=b.APPLICATION_ID and a.DOCUMENT_NO=b.DOCUMENT_NO left join IL_DOC_CLIENT_PERS_INFO_T c ON (a.ORG_ID=c.ORG_ID and a.BRANCH_ID=c.BRANCH_ID and a.MAIN_PRODUCT_CODE=c.MAIN_PRODUCT_CODE and a.SUB_PRODUCT_CODE=c.SUB_PRODUCT_CODE and a.TAKAFUL_TYPE=c.TAKAFUL_TYPE and a.DOCUMENT_TYPE=c.DOCUMENT_TYPE and a.RECORD_TYPE=c.RECORD_TYPE and a.DOCUMENT_YEAR=c.DOCUMENT_YEAR and a.ISSUE_COUNT=c.ISSUE_COUNT and a.ENDORSEMENT_NO=c.ENDORSEMENT_NO and a.APPLICATION_ID=c.APPLICATION_ID and a.DOCUMENT_NO=c.DOCUMENT_NO and c.CLIENT_CODE='' left join IL_DOC_HEADER_T d ON (a.ORG_ID=d.ORG_ID and a.BRANCH_ID=d.BRANCH_ID and a.MAIN_PRODUCT_CODE=d.MAIN_PRODUCT_CODE and a.SUB_PRODUCT_CODE=d.SUB_PRODUCT_CODE and a.TAKAFUL_TYPE=d.TAKAFUL_TYPE and a.DOCUMENT_TYPE=d.DOCUMENT_TYPE and a.RECORD_TYPE=d.RECORD_TYPE and a.DOCUMENT_YEAR=d.DOCUMENT_YEAR and a.ISSUE_COUNT=d.ISSUE_COUNT and a.ENDORSEMENT_NO=d.ENDORSEMENT_NO and a.APPLICATION_ID=d.APPLICATION_ID and a.DOCUMENT_NO=d.DOCUMENT_NO where a.ORG_ID = :ORG_ID and a.BRANCH_ID = :BRANCH_ID and a.MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and a.SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE and a.TAKAFUL_TYPE = :TAKAFUL_TYPE and a.DOCUMENT_TYPE = :DOCUMENT_TYPE and a.DOCUMENT_NO = :DOCUMENT_NO and a.RECORD_TYPE = :RECORD_TYPE and a.DOCUMENT_YEAR = :DOCUMENT_YEAR and a.ISSUE_COUNT = :ISSUE_COUNT and a.ENDORSEMENT_NO = :ENDORSEMENT_NO and a.APPLICATION_ID = :APPLICATION_ID params: ORG_ID=0, BRANCH_ID=0, MAIN_PRODUCT_CODE=0, SUB_PRODUCT_CODE=0, TAKAFUL_TYPE=, DOCUMENT_TYPE=, DOCUMENT_NO=, RECORD_TYPE=, DOCUMENT_YEAR=, ISSUE_COUNT=, ENDORSEMENT_NO=, APPLICATION_ID= 5/10/2024 11:02:50 PM: ORA-00907: missing right parenthesis Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00907: missing right parenthesis at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) 5/10/2024 11:02:50 PM: ORA-00907: missing right parenthesis Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00907: missing right parenthesis at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters) at ZealERP.ZealTakaful.Reports.AnnextureReport.Annexture02.PrepareReport() 5/10/2024 11:02:58 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:02:58 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:04:10 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:04:10 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:04:51 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:04:51 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:08:11 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:08:11 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:12:00 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:12:00 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:12:24 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:12:24 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:25:20 PM: Thread was being aborted. System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at System.Web.HttpResponse.Redirect(String url) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 5/10/2024 11:25:37 PM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:25:37 PM: Please Enter User Id ZealERP.ZealFramework.Utils.ZealException: Please Enter User Id at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:26:24 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:26:24 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:31:38 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e) 5/10/2024 11:31:38 PM: Invalid Credentials ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record) at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password) at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)