Forum topic

Folks,

I'm getting the following error on the Luther King House server whenever a search includes a specific record. You'll see it seems to have noted the problem in there (helpful!) being an invalid format of the email address, but I'm not able to update it to test, since I can't access the record at all due to the error. 

Thank-you!

Rob

*** Error on action - PerformFindProspect ***
Invalid value for attribute LodDef = nazsis.fProspct2 Table = PERSON EntityDef = nazsis.fProspct2.Person SQL => SELECT PERSON.ID, PERSON.LASTNAME, PERSON.FIRSTNAME, PERSON.MIDDLENAME, PERSON.SUFFIX, PERSON.DATEOFBIRTH, PERSON.EMAILADDRESS, PERSON.PREFERREDEMAIL, PERSON.SCHOOLEMAIL, PERSON.WORKEMAIL, PERSON.PHOTO, PERSON.CAMPUSID, PERSON.GENDER, PERSON.HOMEPHONE, PERSON.MOBILEPHONE, PERSON.CALLBACKDATE, PERSON.CHURCHDENOMINATION, PERSON.CIP_SUBCATEGORY, PERSON.CONTACTPREFERENCE, PERSON.CONVERTEDKEY, PERSON.DECEASED, PERSON.DECEASEDDATE, PERSON.DRIVERSLICENSENUMBER, PERSON.DRIVERSLICENSESTATE, PERSON.EMERGENCYCONTACTADDRESSCITY, PERSON.EMERGENCYCONTACTADDRESSLINE1, PERSON.EMERGENCYCONTACTADDRESSSTATE, PERSON.EMERGENCYCONTACTADDRESSZIPCODE, PERSON.EMERGENCYCONTACTHOMEPHONE, PERSON.EMERGENCYCONTACTMOBILEPHONE, PERSON.EMERGENCYCONTACTNAME, PERSON.EMERGENCYCONTACTRELATIONSHIP, PERSON.EMERGENCYCONTACTWORKPHONE, PERSON.EXTENSION, PERSON.FAX, PERSON.FISCALIDRG, PERSON.HIDESSN, PERSON.INTERNATIONALHOMEPHONE, PERSON.INTERNATIONALMOBILEPHONE, PERSON.INTERNATIONALWORKPHONE, PERSON.LASTDUPLICATEANALYZEDDATE, PERSON.MAIDENNAME, PERSON.MAJORNAME, PERSON.MARITALSTATUS, PERSON.MARITALSTATUSDATE, PERSON.MASTERPROMISSORYSIGNEDDATE, PERSON.OCCUPATION, PERSON.OCCUPATIONCODE, PERSON.PARENTSEMAILADDRESS, PERSON.PREFEREDFIRSTNAME, PERSON.PREFIX, PERSON.PREVIOUSNAME, PERSON.RETIREDPASTORFLAG, PERSON.SALUTATION, PERSON.SSN, PERSON.STATUS, PERSON.TITLE, PERSON.USERNAME, PERSON.WEBPASSWORD, PERSON.WORKEMAILADDRESS, PERSON.WORKPHONE, PERSON.CREATEDBY, PERSON.CREATEDDATETIME, PERSON.MODIFIEDDATETIME, PERSON.LASTMODIFIEDBY, PERSON.EMERGENCYCONTACTLASTUPDDATETIME, PERSON.INSTID, PERSON.GOVERNMENTID, PERSON.ORDAINEDFLAG, PERSON.PATRONTYPE, PERSON.PATRONBARCODE, PERSON.FK_ID_ADDRESS, PERSON.FK_ID_CHURCH, PERSON.FK_ID_EXTRACURRICULARACTIVITY, PERSON.FK_ID_FINAIDPROFILE, PERSON.FK_ID_PERSON, PERSON.FK_ID_TRUSTEE, PERSON.z_NOTE, PERSON.EMERGENCYCONTACTNOTE, PERSON.CONVERTEDSTRING, DEMOGRAPHICS.ID, DEMOGRAPHICS.PLACEOFBIRTHCITY, DEMOGRAPHICS.PLACEOFBIRTHSTATEPROVINCE, DEMOGRAPHICS.PLACEOFBIRTHCOUNTRY, DEMOGRAPHICS.CITIZENSHIPCODE, DEMOGRAPHICS.PRIMARYLANGUAGE, DEMOGRAPHICS.ALIENREGNUMBER, DEMOGRAPHICS.PREFERREDLANGUAGE, DEMOGRAPHICS.IPEDS_ETHNICITY, DEMOGRAPHICS.ETHNICITY, DEMOGRAPHICS.NEWETHNICITYRACE, DEMOGRAPHICS.NATIONOFCITIZENSHIP, DEMOGRAPHICS.VISACLASSIFICATION, DEMOGRAPHICS.VISAEXPIRATION, DEMOGRAPHICS.PASSPORTEXPIRATION, DEMOGRAPHICS.SPECIALACCOMMODATIONSREQUESTED, DEMOGRAPHICS.FATHERDECEASED, DEMOGRAPHICS.MOTHERDECEASED, DEMOGRAPHICS.PARENTSDIVORCED, DEMOGRAPHICS.PARENTSSEPARATED, DEMOGRAPHICS.FATHERREMARRIED, DEMOGRAPHICS.MOTHERREMARRIED, DEMOGRAPHICS.MOTHERCOLLEGEGRAD, DEMOGRAPHICS.FATHERCOLLEGEGRAD, DEMOGRAPHICS.FIRSTGENERATIONCOLLEGESTUDENT, DEMOGRAPHICS.PARENTISALUMNI, DEMOGRAPHICS.FATHERISALUM, DEMOGRAPHICS.MOTHERISALUM, DEMOGRAPHICS.SIBLINGISALUM, DEMOGRAPHICS.SIBLINGSATTEND, DEMOGRAPHICS.PARENTISPASTOR, DEMOGRAPHICS.PARENTISMISSIONARY, DEMOGRAPHICS.FATHERINFULLTIMEMINISTRY, DEMOGRAPHICS.MOTHERINFULLTIMEMINISTRY, DEMOGRAPHICS.SPECIALCIRCUMSTANCES, DEMOGRAPHICS.CREATEDDATETIME, DEMOGRAPHICS.MODIFIEDDATETIME, DEMOGRAPHICS.CREATEDBY, DEMOGRAPHICS.LASTMODIFIEDBY, DEMOGRAPHICS.ACADEMICDIVISION, DEMOGRAPHICS.ANNIVERSARYDATE, DEMOGRAPHICS.ETHNICITYHISPANIC, DEMOGRAPHICS.ETHNICITYAMERINDIAN, DEMOGRAPHICS.ETHNICITYASIAN, DEMOGRAPHICS.ETHNICITYBLACK, DEMOGRAPHICS.ETHNICITYPACIFIC, DEMOGRAPHICS.ETHNICITYWHITE, DEMOGRAPHICS.ETHNICITYOPTIONGIVEN, DEMOGRAPHICS.FK_ID_PERSON FROM PERSON LEFT JOIN DEMOGRAPHICS ON DEMOGRAPHICS.FK_ID_PERSON = PERSON.ID WHERE PERSON.ID = ? ; DB: jdbc:mysql://localhost:3306/gnecsis_lkh4?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&useLegacyDatetimeCode=false&serverTimezone=Europe/London&useSSL=false Column = PERSON.EMAILADDRESS AttributeDef = nazsis.fProspct2.Person.eMailAddress Value = (PUBDB)claire_hamer@hotmail.com Value must be a valid email address
com.quinsoft.zeidon.domains.EmailAddressDomain.validateInternalValue(EmailAddressDomain.java:60)
com.quinsoft.zeidon.standardoe.AttributeValue.setInternalValue(AttributeValue.java:163)
com.quinsoft.zeidon.standardoe.AttributeInstanceImpl.setInternalValue(AttributeInstanceImpl.java:342)
com.quinsoft.zeidon.dbhandler.JdbcHandler.setAttribute(JdbcHandler.java:420)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.loadAttributes(JdbcHandler.java:964)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.processRow(JdbcHandler.java:828)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.loadEntities(JdbcHandler.java:761)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.access$300(JdbcHandler.java:728)
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeLoad(JdbcHandler.java:384)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.loadEntity(AbstractSqlHandler.java:1375)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activateChildren(ActivateOiFromDB.java:254)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.singleActivate(ActivateOiFromDB.java:338)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:167)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:113)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:42)
com.quinsoft.zeidon.standardoe.ActivateObjectInstance.activate(ActivateObjectInstance.java:102)
com.quinsoft.zeidon.standardoe.AbstractTaskQualification.activateObjectInstance(AbstractTaskQualification.java:127)
com.quinsoft.zeidon.vml.zVIEW.activateObjectInstance(zVIEW.java:553)
com.quinsoft.zeidon.vml.VmlOperation.ActivateObjectInstance(VmlOperation.java:5045)
org.nazarene.nazsis.nFindD_Dialog.PerformFindProspect(nFindD_Dialog.java:21434)
org.apache.jsp.nFindDProspectFind_jsp._jspService(nFindDProspectFind_jsp.java:2584)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
main.java.org.nazarene.nazsis.HstsFilter.doFilter(HstsFilter.java:65)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
java.base/java.lang.Thread.run(Thread.java:1583)