Log File Initialized... 2/6/2025 12:28:00 AM 2/6/2025 12:28:00 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.btnLogin_Click(Object sender, EventArgs e) 2/6/2025 12:28:21 AM: select a.Title, a.FirstName,gd.description as EMPLOYEETYPE, a.MiddleName, a.LastName,shift.SHIFT_NAME, a.Gender, a.PersonType, a.NationalIdentifier, a.EmployeeNumber, a.OldEmployeeNumber,a.PROFILE_PIC , a.EmployeeStatus, a.ProfilePic,a.MARITAL_STATUS,a.PersonalCellNo2,a.LINKED_IN_ADDRESS,a.DRIVING_LICENSE,a.BirthCity, a.MaritalStatus, a.BirthCountry, a.Nationality, a.Religion, a.BloodGroup,a.Filer, a.FatherName, a.MotherName, a.CurrentAddress, a.PermanentAddress, a.EOBI, a.MedicalID, a.InsuranceID, a.Email, a.OfficialAddress, a.OfficialEmail, a.Extension, a.LandLine, a.PersonalCellNo, a.OfficialCellNo, a.FBID, a.SkypeID, a.WhatsApp, a.Active, a.EmployeeID , to_char(a.LICENSE_EXPIRY_DATE,'dd/MM/yyyy')LICENSE_EXPIRY_DATE,a.EC_NAME_1,a.EC_PHONE_1,a.EC_RELATION_1,a.EC_ADDRESS_1,a.EC_NAME_2,a.EC_PHONE_2,a.EC_RELATION_2,a.EC_ADDRESS_2,c.OrganizationName,e.PositionName,a.BIRTHDAY_ALERT,b.SupervisorNo,f.Name GradeName, d.Name LocationName, g.Name PayrollName, a.ORG_ID ,to_char(a.CNICExpiry,'dd/mm/yyyy') CNICExpiry ,to_char(a.ProbationEndDate,'dd/mm/yyyy') ProbationEndDate ,to_char(a.ConfirmationDate,'dd/mm/yyyy') ConfirmationDate ,to_char(a.BirthDate,'dd/mm/yyyy') BirthDate ,to_char(a.DateOfJoining,'dd/mm/yyyy') DateOfJoining ,to_char(a.EndDate,'dd/mm/yyyy') EndDate , a.FirstName||' '||a.MiddleName||' '||a.LastName EmployeeName , s.FirstName||' '||s.MiddleName||' '||s.LastName SupervisorName, to_char(a.VALID_UP_TO,'dd/MM/yyyy') VALID_UP_TO, a.PASSPORT_NO from Employee a left outer join Assignments b on (a.EmployeeID = b.EmployeeID and a.ORG_ID=b.ORG_ID) left outer join ATT_SHIFT_T shift on (a.ORG_ID=shift.ORG_ID and shift.SHIFT_ID=B.SHIFTID) left outer join Locations d on (b.LocationID = d.ID and d.ORG_ID=a.ORG_ID) left outer join Organizations c on (b.OrganizationID = c.OrganizationID and c.ORG_ID=a.ORG_ID) left outer join Position e on (b.OrganizationID = e.OrganizationID and b.PositionID = e.PositionID and e.ORG_ID=a.ORG_ID) left outer join Grades f on (b.GradeID = f.GradeID and A.ORG_ID=f.ORG_ID) left outer join PayRollCalander g on (b.PayRollCalanderID = g.PayRollCalanderID) left outer join Employee s on (s.EmployeeId = b.SupervisorNo AND s.ORG_ID=a.ORG_ID) left join GEN_PARAM_SETUPHD_T g on g.ORG_ID = a.ORG_ID AND g.SETUP_NAME = 'Person Type' and g.application_id=22 left join GEN_PARAM_SETUP_DTL_T gd on g.ORG_ID = gd.ORG_ID AND gd.APPLICATION_ID = g.APPLICATION_ID and g.SETUP_ID = gd.SETUP_ID AND gd.ABBREVIATION = to_char(a.PERSONTYPE) WHERE a.ORG_ID=5 and (b.gradeid in (select distinct gradeid from grades_user_mapping where org_id='5' and employee_id=8) or b.gradeid is null) 2/6/2025 12:28:21 AM: Error in route [api/EmployeeSetup/GetData] class: EmployeeSetupController: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "A"."PASSPORT_NO": invalid identifier 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) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query) at ZealERP.ZealTakaful.Services.HCM.EmployeeSetupService.GetData(String ORG_ID, String USER_ID, String AppId) at ZealERP.ZealTakaful.Controllers.HCM.EmployeeSetupController.<>c__DisplayClass4_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 2/6/2025 12:28:50 AM: select a.Title, a.FirstName,gd.description as EMPLOYEETYPE, a.MiddleName, a.LastName,shift.SHIFT_NAME, a.Gender, a.PersonType, a.NationalIdentifier, a.EmployeeNumber, a.OldEmployeeNumber,a.PROFILE_PIC , a.EmployeeStatus, a.ProfilePic,a.MARITAL_STATUS,a.PersonalCellNo2,a.LINKED_IN_ADDRESS,a.DRIVING_LICENSE,a.BirthCity, a.MaritalStatus, a.BirthCountry, a.Nationality, a.Religion, a.BloodGroup,a.Filer, a.FatherName, a.MotherName, a.CurrentAddress, a.PermanentAddress, a.EOBI, a.MedicalID, a.InsuranceID, a.Email, a.OfficialAddress, a.OfficialEmail, a.Extension, a.LandLine, a.PersonalCellNo, a.OfficialCellNo, a.FBID, a.SkypeID, a.WhatsApp, a.Active, a.EmployeeID , to_char(a.LICENSE_EXPIRY_DATE,'dd/MM/yyyy')LICENSE_EXPIRY_DATE,a.EC_NAME_1,a.EC_PHONE_1,a.EC_RELATION_1,a.EC_ADDRESS_1,a.EC_NAME_2,a.EC_PHONE_2,a.EC_RELATION_2,a.EC_ADDRESS_2,c.OrganizationName,e.PositionName,a.BIRTHDAY_ALERT,b.SupervisorNo,f.Name GradeName, d.Name LocationName, g.Name PayrollName, a.ORG_ID ,to_char(a.CNICExpiry,'dd/mm/yyyy') CNICExpiry ,to_char(a.ProbationEndDate,'dd/mm/yyyy') ProbationEndDate ,to_char(a.ConfirmationDate,'dd/mm/yyyy') ConfirmationDate ,to_char(a.BirthDate,'dd/mm/yyyy') BirthDate ,to_char(a.DateOfJoining,'dd/mm/yyyy') DateOfJoining ,to_char(a.EndDate,'dd/mm/yyyy') EndDate , a.FirstName||' '||a.MiddleName||' '||a.LastName EmployeeName , s.FirstName||' '||s.MiddleName||' '||s.LastName SupervisorName, to_char(a.VALID_UP_TO,'dd/MM/yyyy') VALID_UP_TO, a.PASSPORT_NO from Employee a left outer join Assignments b on (a.EmployeeID = b.EmployeeID and a.ORG_ID=b.ORG_ID) left outer join ATT_SHIFT_T shift on (a.ORG_ID=shift.ORG_ID and shift.SHIFT_ID=B.SHIFTID) left outer join Locations d on (b.LocationID = d.ID and d.ORG_ID=a.ORG_ID) left outer join Organizations c on (b.OrganizationID = c.OrganizationID and c.ORG_ID=a.ORG_ID) left outer join Position e on (b.OrganizationID = e.OrganizationID and b.PositionID = e.PositionID and e.ORG_ID=a.ORG_ID) left outer join Grades f on (b.GradeID = f.GradeID and A.ORG_ID=f.ORG_ID) left outer join PayRollCalander g on (b.PayRollCalanderID = g.PayRollCalanderID) left outer join Employee s on (s.EmployeeId = b.SupervisorNo AND s.ORG_ID=a.ORG_ID) left join GEN_PARAM_SETUPHD_T g on g.ORG_ID = a.ORG_ID AND g.SETUP_NAME = 'Person Type' and g.application_id=22 left join GEN_PARAM_SETUP_DTL_T gd on g.ORG_ID = gd.ORG_ID AND gd.APPLICATION_ID = g.APPLICATION_ID and g.SETUP_ID = gd.SETUP_ID AND gd.ABBREVIATION = to_char(a.PERSONTYPE) WHERE a.ORG_ID=5 and (b.gradeid in (select distinct gradeid from grades_user_mapping where org_id='5' and employee_id=8) or b.gradeid is null) 2/6/2025 12:28:50 AM: Error in route [api/EmployeeSetup/GetData] class: EmployeeSetupController: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "A"."PASSPORT_NO": invalid identifier 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) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query) at ZealERP.ZealTakaful.Services.HCM.EmployeeSetupService.GetData(String ORG_ID, String USER_ID, String AppId) at ZealERP.ZealTakaful.Controllers.HCM.EmployeeSetupController.<>c__DisplayClass4_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 2/6/2025 12:31:03 AM: select a.Title, a.FirstName,gd.description as EMPLOYEETYPE, a.MiddleName, a.LastName,shift.SHIFT_NAME, a.Gender, a.PersonType, a.NationalIdentifier, a.EmployeeNumber, a.OldEmployeeNumber,a.PROFILE_PIC , a.EmployeeStatus, a.ProfilePic,a.MARITAL_STATUS,a.PersonalCellNo2,a.LINKED_IN_ADDRESS,a.DRIVING_LICENSE,a.BirthCity, a.MaritalStatus, a.BirthCountry, a.Nationality, a.Religion, a.BloodGroup,a.Filer, a.FatherName, a.MotherName, a.CurrentAddress, a.PermanentAddress, a.EOBI, a.MedicalID, a.InsuranceID, a.Email, a.OfficialAddress, a.OfficialEmail, a.Extension, a.LandLine, a.PersonalCellNo, a.OfficialCellNo, a.FBID, a.SkypeID, a.WhatsApp, a.Active, a.EmployeeID , to_char(a.LICENSE_EXPIRY_DATE,'dd/MM/yyyy')LICENSE_EXPIRY_DATE,a.EC_NAME_1,a.EC_PHONE_1,a.EC_RELATION_1,a.EC_ADDRESS_1,a.EC_NAME_2,a.EC_PHONE_2,a.EC_RELATION_2,a.EC_ADDRESS_2,c.OrganizationName,e.PositionName,a.BIRTHDAY_ALERT,b.SupervisorNo,f.Name GradeName, d.Name LocationName, g.Name PayrollName, a.ORG_ID ,to_char(a.CNICExpiry,'dd/mm/yyyy') CNICExpiry ,to_char(a.ProbationEndDate,'dd/mm/yyyy') ProbationEndDate ,to_char(a.ConfirmationDate,'dd/mm/yyyy') ConfirmationDate ,to_char(a.BirthDate,'dd/mm/yyyy') BirthDate ,to_char(a.DateOfJoining,'dd/mm/yyyy') DateOfJoining ,to_char(a.EndDate,'dd/mm/yyyy') EndDate , a.FirstName||' '||a.MiddleName||' '||a.LastName EmployeeName , s.FirstName||' '||s.MiddleName||' '||s.LastName SupervisorName, to_char(a.VALID_UP_TO,'dd/MM/yyyy') VALID_UP_TO, a.PASSPORT_NO from Employee a left outer join Assignments b on (a.EmployeeID = b.EmployeeID and a.ORG_ID=b.ORG_ID) left outer join ATT_SHIFT_T shift on (a.ORG_ID=shift.ORG_ID and shift.SHIFT_ID=B.SHIFTID) left outer join Locations d on (b.LocationID = d.ID and d.ORG_ID=a.ORG_ID) left outer join Organizations c on (b.OrganizationID = c.OrganizationID and c.ORG_ID=a.ORG_ID) left outer join Position e on (b.OrganizationID = e.OrganizationID and b.PositionID = e.PositionID and e.ORG_ID=a.ORG_ID) left outer join Grades f on (b.GradeID = f.GradeID and A.ORG_ID=f.ORG_ID) left outer join PayRollCalander g on (b.PayRollCalanderID = g.PayRollCalanderID) left outer join Employee s on (s.EmployeeId = b.SupervisorNo AND s.ORG_ID=a.ORG_ID) left join GEN_PARAM_SETUPHD_T g on g.ORG_ID = a.ORG_ID AND g.SETUP_NAME = 'Person Type' and g.application_id=22 left join GEN_PARAM_SETUP_DTL_T gd on g.ORG_ID = gd.ORG_ID AND gd.APPLICATION_ID = g.APPLICATION_ID and g.SETUP_ID = gd.SETUP_ID AND gd.ABBREVIATION = to_char(a.PERSONTYPE) WHERE a.ORG_ID=5 and (b.gradeid in (select distinct gradeid from grades_user_mapping where org_id='5' and employee_id=8) or b.gradeid is null) 2/6/2025 12:31:03 AM: Error in route [api/EmployeeSetup/GetData] class: EmployeeSetupController: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "A"."PASSPORT_NO": invalid identifier 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) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query) at ZealERP.ZealTakaful.Services.HCM.EmployeeSetupService.GetData(String ORG_ID, String USER_ID, String AppId) at ZealERP.ZealTakaful.Controllers.HCM.EmployeeSetupController.<>c__DisplayClass4_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 2/6/2025 12:33:37 AM: select a.Title, a.FirstName,gd.description as EMPLOYEETYPE, a.MiddleName, a.LastName,shift.SHIFT_NAME, a.Gender, a.PersonType, a.NationalIdentifier, a.EmployeeNumber, a.OldEmployeeNumber,a.PROFILE_PIC , a.EmployeeStatus, a.ProfilePic,a.MARITAL_STATUS,a.PersonalCellNo2,a.LINKED_IN_ADDRESS,a.DRIVING_LICENSE,a.BirthCity, a.MaritalStatus, a.BirthCountry, a.Nationality, a.Religion, a.BloodGroup,a.Filer, a.FatherName, a.MotherName, a.CurrentAddress, a.PermanentAddress, a.EOBI, a.MedicalID, a.InsuranceID, a.Email, a.OfficialAddress, a.OfficialEmail, a.Extension, a.LandLine, a.PersonalCellNo, a.OfficialCellNo, a.FBID, a.SkypeID, a.WhatsApp, a.Active, a.EmployeeID , to_char(a.LICENSE_EXPIRY_DATE,'dd/MM/yyyy')LICENSE_EXPIRY_DATE,a.EC_NAME_1,a.EC_PHONE_1,a.EC_RELATION_1,a.EC_ADDRESS_1,a.EC_NAME_2,a.EC_PHONE_2,a.EC_RELATION_2,a.EC_ADDRESS_2,c.OrganizationName,e.PositionName,a.BIRTHDAY_ALERT,b.SupervisorNo,f.Name GradeName, d.Name LocationName, g.Name PayrollName, a.ORG_ID ,to_char(a.CNICExpiry,'dd/mm/yyyy') CNICExpiry ,to_char(a.ProbationEndDate,'dd/mm/yyyy') ProbationEndDate ,to_char(a.ConfirmationDate,'dd/mm/yyyy') ConfirmationDate ,to_char(a.BirthDate,'dd/mm/yyyy') BirthDate ,to_char(a.DateOfJoining,'dd/mm/yyyy') DateOfJoining ,to_char(a.EndDate,'dd/mm/yyyy') EndDate , a.FirstName||' '||a.MiddleName||' '||a.LastName EmployeeName , s.FirstName||' '||s.MiddleName||' '||s.LastName SupervisorName, to_char(a.VALID_UP_TO,'dd/MM/yyyy') VALID_UP_TO, a.PASSPORT_NO from Employee a left outer join Assignments b on (a.EmployeeID = b.EmployeeID and a.ORG_ID=b.ORG_ID) left outer join ATT_SHIFT_T shift on (a.ORG_ID=shift.ORG_ID and shift.SHIFT_ID=B.SHIFTID) left outer join Locations d on (b.LocationID = d.ID and d.ORG_ID=a.ORG_ID) left outer join Organizations c on (b.OrganizationID = c.OrganizationID and c.ORG_ID=a.ORG_ID) left outer join Position e on (b.OrganizationID = e.OrganizationID and b.PositionID = e.PositionID and e.ORG_ID=a.ORG_ID) left outer join Grades f on (b.GradeID = f.GradeID and A.ORG_ID=f.ORG_ID) left outer join PayRollCalander g on (b.PayRollCalanderID = g.PayRollCalanderID) left outer join Employee s on (s.EmployeeId = b.SupervisorNo AND s.ORG_ID=a.ORG_ID) left join GEN_PARAM_SETUPHD_T g on g.ORG_ID = a.ORG_ID AND g.SETUP_NAME = 'Person Type' and g.application_id=22 left join GEN_PARAM_SETUP_DTL_T gd on g.ORG_ID = gd.ORG_ID AND gd.APPLICATION_ID = g.APPLICATION_ID and g.SETUP_ID = gd.SETUP_ID AND gd.ABBREVIATION = to_char(a.PERSONTYPE) WHERE a.ORG_ID=5 and (b.gradeid in (select distinct gradeid from grades_user_mapping where org_id='5' and employee_id=8) or b.gradeid is null) 2/6/2025 12:33:37 AM: Error in route [api/EmployeeSetup/GetData] class: EmployeeSetupController: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "A"."PASSPORT_NO": invalid identifier 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) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query) at ZealERP.ZealTakaful.Services.HCM.EmployeeSetupService.GetData(String ORG_ID, String USER_ID, String AppId) at ZealERP.ZealTakaful.Controllers.HCM.EmployeeSetupController.<>c__DisplayClass4_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 2/6/2025 12:40:36 AM: select a.Title, a.FirstName,gd.description as EMPLOYEETYPE, a.MiddleName, a.LastName,shift.SHIFT_NAME, a.Gender, a.PersonType, a.NationalIdentifier, a.EmployeeNumber, a.OldEmployeeNumber,a.PROFILE_PIC , a.EmployeeStatus, a.ProfilePic,a.MARITAL_STATUS,a.PersonalCellNo2,a.LINKED_IN_ADDRESS,a.DRIVING_LICENSE,a.BirthCity, a.MaritalStatus, a.BirthCountry, a.Nationality, a.Religion, a.BloodGroup,a.Filer, a.FatherName, a.MotherName, a.CurrentAddress, a.PermanentAddress, a.EOBI, a.MedicalID, a.InsuranceID, a.Email, a.OfficialAddress, a.OfficialEmail, a.Extension, a.LandLine, a.PersonalCellNo, a.OfficialCellNo, a.FBID, a.SkypeID, a.WhatsApp, a.Active, a.EmployeeID , to_char(a.LICENSE_EXPIRY_DATE,'dd/MM/yyyy')LICENSE_EXPIRY_DATE,a.EC_NAME_1,a.EC_PHONE_1,a.EC_RELATION_1,a.EC_ADDRESS_1,a.EC_NAME_2,a.EC_PHONE_2,a.EC_RELATION_2,a.EC_ADDRESS_2,c.OrganizationName,e.PositionName,a.BIRTHDAY_ALERT,b.SupervisorNo,f.Name GradeName, d.Name LocationName, g.Name PayrollName, a.ORG_ID ,to_char(a.CNICExpiry,'dd/mm/yyyy') CNICExpiry ,to_char(a.ProbationEndDate,'dd/mm/yyyy') ProbationEndDate ,to_char(a.ConfirmationDate,'dd/mm/yyyy') ConfirmationDate ,to_char(a.BirthDate,'dd/mm/yyyy') BirthDate ,to_char(a.DateOfJoining,'dd/mm/yyyy') DateOfJoining ,to_char(a.EndDate,'dd/mm/yyyy') EndDate , a.FirstName||' '||a.MiddleName||' '||a.LastName EmployeeName , s.FirstName||' '||s.MiddleName||' '||s.LastName SupervisorName, to_char(a.VALID_UP_TO,'dd/MM/yyyy') VALID_UP_TO, a.PASSPORT_NO from Employee a left outer join Assignments b on (a.EmployeeID = b.EmployeeID and a.ORG_ID=b.ORG_ID) left outer join ATT_SHIFT_T shift on (a.ORG_ID=shift.ORG_ID and shift.SHIFT_ID=B.SHIFTID) left outer join Locations d on (b.LocationID = d.ID and d.ORG_ID=a.ORG_ID) left outer join Organizations c on (b.OrganizationID = c.OrganizationID and c.ORG_ID=a.ORG_ID) left outer join Position e on (b.OrganizationID = e.OrganizationID and b.PositionID = e.PositionID and e.ORG_ID=a.ORG_ID) left outer join Grades f on (b.GradeID = f.GradeID and A.ORG_ID=f.ORG_ID) left outer join PayRollCalander g on (b.PayRollCalanderID = g.PayRollCalanderID) left outer join Employee s on (s.EmployeeId = b.SupervisorNo AND s.ORG_ID=a.ORG_ID) left join GEN_PARAM_SETUPHD_T g on g.ORG_ID = a.ORG_ID AND g.SETUP_NAME = 'Person Type' and g.application_id=22 left join GEN_PARAM_SETUP_DTL_T gd on g.ORG_ID = gd.ORG_ID AND gd.APPLICATION_ID = g.APPLICATION_ID and g.SETUP_ID = gd.SETUP_ID AND gd.ABBREVIATION = to_char(a.PERSONTYPE) WHERE a.ORG_ID=5 and (b.gradeid in (select distinct gradeid from grades_user_mapping where org_id='5' and employee_id=8) or b.gradeid is null) 2/6/2025 12:40:36 AM: Error in route [api/EmployeeSetup/GetData] class: EmployeeSetupController: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "A"."PASSPORT_NO": invalid identifier 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) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query) at ZealERP.ZealTakaful.Services.HCM.EmployeeSetupService.GetData(String ORG_ID, String USER_ID, String AppId) at ZealERP.ZealTakaful.Controllers.HCM.EmployeeSetupController.<>c__DisplayClass4_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 2/6/2025 12:42: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) 2/6/2025 12:44:23 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) 2/6/2025 1:17:43 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) 2/6/2025 1:44:17 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) 2/6/2025 1:47:41 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) 2/6/2025 2:19:03 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) 2/6/2025 2:25:47 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) 2/6/2025 3:00:55 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) 2/6/2025 3:12:47 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) 2/6/2025 3:27: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) 2/6/2025 3:46: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) 2/6/2025 3:50: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) 2/6/2025 5:55:44 AM: 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.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response) 2/6/2025 5:55:44 AM: 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.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response) 2/6/2025 6:14: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) 2/6/2025 6:20:26 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) 2/6/2025 6:22: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) 2/6/2025 8:27:31 AM: 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.Services.ILAS.IllustrationHeaderUtility.GetDocObjFromReferenceKey(String key) at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetDocObj(String ReferenceKey, OracleCommand transaction) at ZealERP.ZealTakaful.Reports.ADNTIllustartion.ADNTIllustartion.PrepareReport() 2/6/2025 8:27:31 AM: 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.Services.ILAS.IllustrationHeaderUtility.GetDocObjFromReferenceKey(String key) at ZealERP.ZealTakaful.Services.ILAS.IllustrationHeaderUtility.GetDocObj(String ReferenceKey, OracleCommand transaction) at ZealERP.ZealTakaful.Reports.ADNTIllustartion.ADNTIllustartion.PrepareReport() 2/6/2025 10:41:42 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) 2/6/2025 10:07:19 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) 2/6/2025 11:10:44 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)