Log File Initialized... 9/7/2024 10:37:29 AM
9/7/2024 10:37:29 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)
9/7/2024 10:37:29 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)
9/7/2024 10:38:22 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)
9/7/2024 10:38:22 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)
9/7/2024 10:38:58 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)
9/7/2024 10:38:58 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)
9/7/2024 8:23:57 PM: select 
                c.BENEFIT_DESC  BenefitsRequired,
                CASE WHEN nob.description = 'Salary Factor' then nob.description || ' x '|| TRIM(TO_CHAR(to_number(ben.FLAT_AMOUNT), '999,999,999,999,999')) 
                WHEN nob.description = 'Flat Amount for All' then nob.description || ' ('|| TRIM(TO_CHAR(to_number(ben.FLAT_AMOUNT), '999,999,999,999,999')) || ')'
                WHEN nob.description = 'Category and Salary Slab' then nob.description || ' Based'
                WHEN nob.description = 'Category' then nob.description || ' Based'
                WHEN nob.description = 'Salary Slab' then nob.description || ' Based'
                WHEN nob.description = 'Percent of Basic Benefit' THEN ben.PERCENT_OF_BASIC || ' Percent of Basic Benefit Min ' || ben.SA_FROM || ', Max ' || ben.SA_TO
                ELSE '-' END AS BasisofCoverage 
	            FROM TK_DOC_HEADER_T a 
                left outer join  GLAS_DOC_BENEFIT_T Ben ON (a.ORG_ID = ben.ORG_ID and a.BRANCH_ID = ben.BRANCH_ID and a.product_code = ben.product_code and
                a.sub_product_code = ben.sub_product_code and a.takaful_type = ben.takaful_type and a.document_type = ben.document_type and a.record_type = ben.record_type
                and a.document_no = ben.document_no and a.document_year = ben.document_year and a.issue_count = ben.issue_count and a.endorsement_no = ben.endorsement_no and a.application_id = ben.application_id)
                LEFT OUTER JOIN GLAS_BENEFIT_SETUP_T c ON (ben.benefit_code = c.benefit_code and ben.org_id = c.org_id and c.application_id = ben.application)
                LEFT OUTER JOIN (SELECT e.APPLICATION_ID,e.ORG_ID,ABBREVIATION,DESCRIPTION FROM
				GEN_PARAM_SETUPHD_T e, GEN_PARAM_SETUP_DTL_T f
				where e.ORG_ID=f.ORG_ID and e.APPLICATION_ID=f.APPLICATION_ID and e.SETUP_ID=f.SETUP_ID
				and e.SETUP_NAME='SUM INSURED BASIS' ) nob ON (nob.ORG_ID = a.org_id AND nob.APPLICATION_ID = '11' AND nob.ABBREVIATION = ben.SUM_INSURED_BASIS)
                where a.org_id = '' and a.GDH_DOC_REFERENCE_NO ='' and a.Document_type = '' and a.ISSUE_COUNT = '' order by c.benefit_desc asc
9/7/2024 8:23:57 PM: ORA-00904: "BEN"."APPLICATION": invalid identifier
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "BEN"."APPLICATION": 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)