Log File Initialized... 4/28/2024 12:19:56 AM
4/28/2024 12:19:56 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.Reports.ClaimDischarge.ClaimDischargeRe.PrepareReport()
4/28/2024 8:13:14 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.Reports.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 8:17: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
4/28/2024 8:17: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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
4/28/2024 8:18:14 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
4/28/2024 8:18:14 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.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
4/28/2024 8:18:19 AM: Please Enter Password
ZealERP.ZealFramework.Utils.ZealException: Please Enter Password
   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)
4/28/2024 8:18:19 AM: Please Enter Password
ZealERP.ZealFramework.Utils.ZealException: Please Enter Password
   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)
4/28/2024 11:17:16 AM: Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Number of days finished to make changes
   at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeUpdate(SaveDataModel record, OracleCommand command)
   at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass25_0.<Update>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
4/28/2024 11:17:16 AM: Error.. Number of days finished to make changes
ZealERP.ZealFramework.Utils.ZealException: Error.. Number of days finished to make changes
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealFramework.Services.DBService.Update(SaveDataModel record)
   at ZealERP.ZealFramework.Services.DBService.UpdateSecure(SaveDataModel record)
   at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass7_0.<UpdateDataSecure>b__0()
4/28/2024 2:48:45 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.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 2:48:57 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.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 2:54:36 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.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 2:54: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.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 2:55:05 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.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 2:55:25 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.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 2:56:21 PM: Please Enter Password
ZealERP.ZealFramework.Utils.ZealException: Please Enter Password
   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)
4/28/2024 2:56:21 PM: Please Enter Password
ZealERP.ZealFramework.Utils.ZealException: Please Enter Password
   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)
4/28/2024 2:58:59 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.TravelPolicy.TravelPolicySD.PrepareReport()
4/28/2024 7:25:15 PM: select distinct 0 SrNo, a.endorsement_no,  case when sysdate < GDH_EXPIRY_DATE then 'Active' else 'Lapsed' end Policy_status,a.alteration_type,  nod4.description ,  MAX(EA.ADDRESS1) || ' ' || MAX(EA.ADDRESS2) Address, MAX(CCT.city_nAME) CITY, MAX(CONTACT_NAME) ContactPerson, AGENT_ID AgentCode, AGENT_NAME AgentName, 
                MAX(ct.EMAIL) EmailAddress,MAX( MOBILE_NO) CellNumber, MAX(LANDLINE_NO) TelNumber, nob3.Description RiskCategorization, MAX(EA.ZIP_CODE) PostalCode, MAX(FAX1) FaxNumber,  to_char(GDH_EXPIRY_DATE, 'dd-Mon-yyyy') PolEndDate, to_CHAR(GDH_COMM_DATE,'dd-Mon-yyyy') PolStartDate, to_char(GDH_COMM_DATE,'dd-Mon-yyyy') FirstStartDate,
				 
              to_number(nvl(instl.GROSS_CONTRIBUTION, 0)) GrossContribution, 
      ct.CONTACT_NAME , a.MASTER_REF_NO SchemeId , cs.CLIENT_DESC ParticipantName 
                FROM TK_DOC_HEADER_T a 
	            INNER JOIN AM_AGENT_T agt ON (agt.ORG_ID = a.ORG_ID AND agt.AGENT_ID = a.PRODUCER_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_INSTALLMENTS_T instl on instl.ORG_ID = a.ORG_ID AND instl.BRANCH_ID= a.BRANCH_ID and instl.PRODUCT_CODE = a.PRODUCT_CODE and instl.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE 
                and instl.TAKAFUL_TYPE= a.TAKAFUL_TYPE and instl.DOCUMENT_TYPE = a.DOCUMENT_TYPE and instl.DOCUMENT_NO = a.DOCUMENT_NO and instl.RECORD_TYPE= a.RECORD_TYPE and instl.DOCUMENT_YEAR= a.DOCUMENT_YEAR 
                and instl.ISSUE_COUNT= a.ISSUE_COUNT and instl.ENDORSEMENT_NO= a.ENDORSEMENT_NO and instl.APPLICATION_ID = a.APPLICATION_ID
                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 (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 f.APPLICATION_ID = '12'
				and e.SETUP_NAME='OCCUPATIONAL CLASS' ) nob3 ON (nob3.ORG_ID = a.org_id  AND nob3.ABBREVIATION = a.OCCUPATIONAL_CLASS)   

            	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 f.APPLICATION_ID = '12'
				and e.SETUP_NAME='PAYMENT MODE' ) nod4 ON (nod4.ORG_ID = a.org_id  AND nod4.ABBREVIATION = a.PAYMENT_MODE)   
                LEFT OUTER JOIN GLAS_CLIENT_SETUP_T cs on A.PPS_PARTY_CODE = cs.CLIENT_CODE and a.org_id = cs.org_id
                LEFT OUTER JOIN  GLAS_CLIENT_BUS_UNIT_T BU on  BU.ORG_ID=A.ORG_ID and BU.CLIENT_CODE =cs.CLIENT_CODE 
                lEFT OUTER JOIN GLAS_CLIENT_CONTACTPERSON_T CT on  CT.ORG_ID=cs.ORG_ID and CT.CLIENT_CODE =cs.CLIENT_CODE and ct.BUS_UNIT_CODE = Bu.BUS_UNIT_CODE and ct.CONTACT_TYPE = 'P' and ct.CATEGORY = 'P'  
                LEFT OUTER JOIN  ENTITY_ADDRESS_T EA on  EA.ORG_ID=ct.ORG_ID and EA.ENTITY_CODE =BU.BUS_UNIT_CODE and ENTITY_TYPE='CLTBR' 
                LEFT OUTER JOIN  GLAS_ALTERATION_TYPE_SETUP_T T on (T.ORG_ID=a.ORG_ID and t.ALTERATION_TYPE=a.ALTERATION_TYPE)

                LEFT OUTER JOIN COUNTRY_CITY_T CCT on EA.COUNTRY_CODE = cct.COUNTRY_CODE AND EA.STATE_CODE = CCT.STATE_CODE AND EA.CITY_CODE = CCT.CITY_CODE  where a.org_id= and a.document_type='P'    and ct.CONTACT_TYPE = 'P' and ct.CATEGORY = 'P'  and a.record_type ='O' and a.application_id =11 AND trunc(a.GDH_COMM_DATE) between '' AND '' and instl.POST_DATE is not null   and (a.ALTERATION_TYPE !='ALT_NF' or a.ALTERATION_TYPE is null) GROUP BY  I.Item_Status, i.item_no,  AGENT_NAME ,AGENT_ID, a.alteration_type,             GDH_EXPIRY_DATE , GDH_COMM_DATE,nod4.description, ct.CONTACT_NAME, a.MASTER_REF_NO,  cs.CLIENT_DESC, I.ITEM_STATUS, nob3.description , a.endorsement_no, a.GDH_COMM_DATE, A.GDH_EXPIRY_DATE  , instl.GROSS_CONTRIBUTION          ORDER BY a.MASTER_REF_NO
4/28/2024 7:25:15 PM: 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)
4/28/2024 10:41:36 PM: 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)
4/28/2024 10:41:42 PM: 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)
4/28/2024 10:46:02 PM: 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)
4/28/2024 11:29:28 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.PamentAuthorizationMemo.PamentAuthorizationMemoRe.PrepareReport()