Log File Initialized... 11/18/2024 12:06:15 AM
11/18/2024 12:06:15 AM: 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)
11/18/2024 12:10:57 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 12:15:42 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 12:33:28 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 1:00:15 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 1:16:52 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 1:38:27 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 2:08:41 AM: 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)
11/18/2024 2:08:50 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 2:15:51 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 2:15:56 AM: Empty path name is not legal.
System.ArgumentException: Empty path name is not legal.
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic)
11/18/2024 2:15:58 AM: Empty path name is not legal.
System.ArgumentException: Empty path name is not legal.
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic)
11/18/2024 2:16:07 AM: Empty path name is not legal.
System.ArgumentException: Empty path name is not legal.
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetImage(FileDownload FileLogic)
11/18/2024 2:27:39 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 2:30:09 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 2:32:57 AM: 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)
11/18/2024 2:32:57 AM: **************************** Error at Login Request for User bbtravels.tours99, Message: Invalid Credentials ****************************
11/18/2024 2:33:16 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 2:34:01 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 2:54:56 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 3:14:37 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 3:26:07 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 3:37:33 AM: 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)
11/18/2024 3:37:33 AM: **************************** Error at Login Request for User Sufyan.Shaheen, Message: Invalid Credentials ****************************
11/18/2024 3:39:10 AM: 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)
11/18/2024 3:39:10 AM: **************************** Error at Login Request for User Sufyan.Shaheen, Message: Invalid Credentials ****************************
11/18/2024 3:39:24 AM: 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)
11/18/2024 3:39:24 AM: **************************** Error at Login Request for User Shaheen.Sufyan, Message: Invalid Credentials ****************************
11/18/2024 3:41:43 AM: 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)
11/18/2024 3:41:43 AM: **************************** Error at Login Request for User Sufyan.Shaheen, Message: Invalid Credentials ****************************
11/18/2024 3:42:00 AM: 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)
11/18/2024 3:42:00 AM: **************************** Error at Login Request for User Sufyan.Shaheen, Message: Invalid Credentials ****************************
11/18/2024 3:42:16 AM: 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)
11/18/2024 3:42:16 AM: **************************** Error at Login Request for User Sufyan.Shaheen, Message: Invalid Credentials ****************************
11/18/2024 3:43:03 AM: No User Account found on given Email Address
ZealERP.ZealFramework.Utils.ZealException: No User Account found on given Email Address
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ForgetPassword(User record)
   at ZealERP.ZealTakaful.Controllers.NewSecurity.UserController.<>c__DisplayClass15_0.<ForgetPassword>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
11/18/2024 3:44:28 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 3:48:07 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 4:24:08 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 5:03:38 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 5:44:28 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 6:17:21 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 6:24:30 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 6:26:21 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 6:28:27 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 6:29:46 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 6:30:45 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 6:45:15 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 7:06:18 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 8:06:35 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 9:49:11 AM: SELECT a.AML_RISK_PROFILE risk_Categorization,  MASTER_REF_NO SCHEME_ID,   b.VAT_REG_NO NTN, CASE WHEN a.ISSUE_COUNT = 1 then to_char(a.GDH_COMM_DATE,'dd-Mon-yyyy') ELSE null END AS FirstStartDate, ea.zip_code PostalCode,  case 
                when trunc(a.GDH_EXPIRY_DATE) >= trunc(sysdate) then 'Active' 
                when ADD_MONTHS(trunc(a.GDH_EXPIRY_DATE), 1) >= TRUNC(SYSDATE) then 'Grace' 
                else 'In-Active' end as POLICYSTATUS,
                b.CLIENT_DESC as participantName,
                to_char(a.GDH_COMM_DATE,'dd-Mon-yyyy') AS PolStartDate, 
                to_char(a.GDH_EXPIRY_DATE,'dd-Mon-yyyy') AS PolEndDate,
                e.CONTACT_NAME ContactPersonName,
                e.EMAIL CPEmail,
                e.MOBILE_NO CPContactNo,
                ea.ADDRESS1 || ' ' || ea.ADDRESS2  cpaddress,      
                c.CITY_NAME CPCITY,
                ea.FAX1 || ' , ' || ea.FAX2 CPFax,
                e.landline_no CPTel,
                count(*) NoofLives,
                ch.AGENT_ID AgentCode,
                ch.AGENT_NAME AgentName,
                sum(ins1.GROSS_CONT_AFTER_DISC * 1) GrossCont
                FROM 
                tk_doc_header_t a
                LEFT OUTER JOIN GLAS_CLIENT_SETUP_T b ON (a.ORG_ID = b.ORG_ID AND a.PPS_PARTY_CODE = b.CLIENT_CODE)
                LEFT OUTER JOIN GLAS_DOC_INSURED_ITEMS_T i ON (a.ORG_ID = i.ORG_ID AND a.BRANCH_ID = i.BRANCH_ID AND a.product_code = i.product_code AND a.sub_product_code = i.sub_product_code
                AND a.takaful_type = i.takaful_type AND a.document_type = i.document_type AND a.record_type = i.record_type AND a.document_no = i.document_no AND a.document_year = i.document_year
                AND a.issue_count = i.issue_count AND a.endorsement_no = i.endorsement_no AND a.application_id = i.application_id)
                LEFT OUTER JOIN GLAS_DOC_ITEM_INSTALLMENTS_T ins ON (I.ORG_ID = ins.ORG_ID AND I.BRANCH_ID = ins.BRANCH_ID AND I.product_code = ins.product_code AND i.sub_product_code = ins.sub_product_code AND i.takaful_type = ins.takaful_type AND i.document_type = ins.document_type AND ins.record_type  = 'O' AND i.document_no = ins.document_no AND i.document_year = ins.document_year AND i.issue_count = ins.issue_count AND i.endorsement_no = iNS.endorsement_no AND i.application_id = ins.application_id AND ins.ITEM_NO = i.ITEM_NO)
                LEFT OUTER JOIN GLAS_DOC_ITEM_INSTALLMENTS_T ins1 ON (ins.ORG_ID = ins1.ORG_ID AND ins.BRANCH_ID = ins1.BRANCH_ID AND ins.product_code = ins1.product_code AND ins.sub_product_code = ins1.sub_product_code AND ins.takaful_type = ins1.takaful_type AND ins.document_type = ins1.document_type AND i.RECORD_TYPE = ins1.record_type AND ins.document_no = ins1.document_no AND ins.document_year = ins1.document_year AND ins.issue_count = ins1.issue_count AND ins.endorsement_no = iNS1.endorsement_no AND ins.application_id = ins1.application_id AND ins.ITEM_NO  = ins1.ITEM_NO and ins.serial_no=ins1.serial_no)
                LEFT OUTER JOIN GLAS_CLIENT_BUS_UNIT_T bus ON (bus.ORG_ID = a.ORG_ID AND bus.CLIENT_CODE = a.PPS_PARTY_CODE) 
                LEFT OUTER JOIN GLAS_CLIENT_CONTACTPERSON_T e ON (e.ORG_ID = a.ORG_ID AND e.CLIENT_CODE = a.PPS_PARTY_CODE AND e.BUS_UNIT_CODE = bus.BUS_UNIT_CODE)
                LEFT OUTER JOIN ENTITY_ADDRESS_T ea ON (a.org_id = ea.org_id AND e.BUS_UNIT_CODE = ea.ENTITY_CODE AND ea.ENTITY_TYPE = 'CLTBR')
                LEFT OUTER JOIN COUNTRY_CITY_T c ON (ea.COUNTRY_CODE = ea.COUNTRY_CODE AND c.STATE_CODE = ea.STATE_CODE AND c.CITY_CODE = ea.CITY_CODE) 
                LEFT OUTER JOIN am_agent_t ch ON (a.ORG_ID = ch.ORG_ID AND a.PRODUCER_CODE = ch.AGENT_ID)
                LEFT OUTER JOIN AM_AGENT_PARTNER_BRANCHES_T ap ON (ap.ORG_ID = a.ORG_ID AND ap.AGENT_ID = a.PRODUCER_CODE)
                LEFT OUTER JOIN AM_PARTNER_BRANCHES_T apbt ON (apbt.ORG_ID = a.ORG_ID AND apbt.partner_id = ap.partner_id AND apbt.PARTNER_BRANCH_ID = ap.branch_id)
                LEFT OUTER JOIN AM_PARTNER_REGION_T re ON (re.ORG_ID = a.ORG_ID AND re.PARTNER_ID = apbt.PARTNER_ID AND re.PARTNER_REGION_ID = APBT.REGION_ID)
                LEFT OUTER JOIN AM_AGENT_CHANNEL_MODEL_T acm ON (acm.ORG_ID = APBT.ORG_ID AND ACM.AGENT_ID = CH.AGENT_ID AND acm.PARTNER_ID = re.PARTNER_ID)
                LEFT OUTER JOIN AM_DISTRIBUTION_CHANNEL_T dc ON (dc.ORG_ID = ACM.ORG_ID AND dc.CHANNEL_ID = ACM.CHANNEL_ID)
                WHERE a.Document_type = 'P' AND a.POSTING_TAG = 'Y' AND re.PARTNER_REGION_ID = AND dc.CHANNEL_ID = AND b.client_code = AND ch.AGENT_ID = AND a.MASTER_REF_NO =''  AND a.Document_type = 'P' 
                AND a.GDH_EXPIRY_DATE BETWEEN '' AND ''
                GROUP BY ea.FAX1,ea.FAX2,c.CITY_NAME,ea.ADDRESS1,ea.ADDRESS2,a.AML_RISK_PROFILE, e.landline_no, a.MASTER_REF_NO, b.CLIENT_DESC, to_char(a.GDH_COMM_DATE,'dd-Mon-yyyy'), to_char(a.GDH_EXPIRY_DATE,'dd-Mon-yyyy'),
                ch.AGENT_ID, ch.AGENT_NAME, e.CONTACT_NAME, e.EMAIL, e.MOBILE_NO, ea.zip_code, a.ISSUE_COUNT, b.VAT_REG_NO,
                case when trunc(a.GDH_EXPIRY_DATE) >= trunc(sysdate) then 'Active' 
                when ADD_MONTHS(trunc(a.GDH_EXPIRY_DATE), 1) >= TRUNC(SYSDATE) then 'Grace' 
                else 'In-Active' end
11/18/2024 9:49:11 AM: ORA-00936: missing expression
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression
   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)
11/18/2024 9:49:11 AM: ORA-00936: missing expression
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query)
   at ZealERP.ZealTakaful.Reports.CustomerMasterGL.CustomerMaster.PrepareReport()
11/18/2024 9:49:11 AM: ORA-00936: missing expression
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query)
   at ZealERP.ZealTakaful.Reports.CustomerMasterGL.CustomerMaster.PrepareReport()
11/18/2024 10:10:20 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
11/18/2024 11:23:23 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)