EnglishEnglish
EnglishEnglishFrenchFrenchGermanGermanItalianItalianPortuguesePortugueseRussianRussianSpanishSpanish

Forum topic

3 posts / 0 new
Log in to post comments
Last post
Tue, 04/21/2020 - 20:02
#1
Robert Rae
Last seen: 1 week 1 day ago
Joined: 08/20/2019 - 16:32
Advanced Search Error (Luther King House)

Good morning! Clare at LKH has reported a problem with her Student > Advanced Search function:

--

1) As a first check, I was trying to search for all active students associated with each degree track through the main search page in academics>student search, to check that our students were correctly linked to their degree tracks. The Full-time PhD student report worked.  (Degree track:  PhD (FT) )  The part-time PhD degree track (PhD (PT)) student query appeared to be having problems with an email address - 'suzannethompson@talktalk.net' – and it came up with this error report:

*** Error on action - PerformFindStudent ***
com.quinsoft.zeidon.InvalidAttributeValueException: Invalid value for attribute LodDef = nazsis.fStudent2 Table = PERSON EntityDef = nazsis.fStudent2.Person SQL => SELECT ID, LASTNAME, FIRSTNAME, MIDDLENAME, SUFFIX, PREFIX, CAMPUSID, PREFEREDFIRSTNAME, MAIDENNAME, SALUTATION, GENDER, MARITALSTATUS, HOMEPHONE, WORKPHONE, FAX, MOBILEPHONE, EXTENSION, EMAILADDRESS, TITLE, DATEOFBIRTH, OCCUPATION, CHURCHDENOMINATION, OCCUPATIONCODE, RETIREDPASTORFLAG, CONTACTPREFERENCE, PREFERREDEMAIL, GOVERNMENTID, FK_ID_ADDRESS, FK_ID_CHURCH, FK_ID_DONOR, FK_ID_EXTRACURRICULARACTIVITY, FK_ID_FINAIDPROFILE, FK_ID_PERSON, FK_ID_TRUSTEE, z_NOTE FROM PERSON WHERE PERSON.ID = ? ; DB: jdbc:mysql://localhost:3306/gnecsis_lkh4?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false Column = PERSON.EMAILADDRESS AttributeDef = nazsis.fStudent2.Person.eMailAddress Value = 'suzannethompson@talktalk.net' Value must be a valid email address XOD: nazsisbin/fStudent2.XOD
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.standardoe.AttributeInstanceImpl.setInternalValue(AttributeInstanceImpl.java:40)
com.quinsoft.zeidon.dbhandler.JdbcHandler.setAttribute(JdbcHandler.java:449)
com.quinsoft.zeidon.dbhandler.JdbcHandler.loadAttributes(JdbcHandler.java:568)
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeLoad(JdbcHandler.java:369)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.loadEntity(AbstractSqlHandler.java:1334)
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:5021)
org.nazarene.nazsis.nFindD_Dialog.PerformFindStudent(nFindD_Dialog.java:13104)
org.apache.jsp.nFindDStudentList_jsp._jspService(nFindDStudentList_jsp.java:2240)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)

2) I then tried searching for “Thompson” (in advanced search) – all other fields blank – and I get this error report:

*** Error on action - PerformFindStudent ***
com.quinsoft.zeidon.InvalidAttributeValueException: Invalid value for attribute LodDef = nazsis.fStudent2 Table = PERSON EntityDef = nazsis.fStudent2.Person SQL => SELECT ID, LASTNAME, FIRSTNAME, MIDDLENAME, SUFFIX, PREFIX, CAMPUSID, PREFEREDFIRSTNAME, MAIDENNAME, SALUTATION, GENDER, MARITALSTATUS, HOMEPHONE, WORKPHONE, FAX, MOBILEPHONE, EXTENSION, EMAILADDRESS, TITLE, DATEOFBIRTH, OCCUPATION, CHURCHDENOMINATION, OCCUPATIONCODE, RETIREDPASTORFLAG, CONTACTPREFERENCE, PREFERREDEMAIL, GOVERNMENTID, FK_ID_ADDRESS, FK_ID_CHURCH, FK_ID_DONOR, FK_ID_EXTRACURRICULARACTIVITY, FK_ID_FINAIDPROFILE, FK_ID_PERSON, FK_ID_TRUSTEE, z_NOTE FROM PERSON WHERE PERSON.ID = ? ; DB: jdbc:mysql://localhost:3306/gnecsis_lkh4?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false Column = PERSON.EMAILADDRESS AttributeDef = nazsis.fStudent2.Person.eMailAddress Value = 'suzannethompson@talktalk.net' Value must be a valid email address XOD: nazsisbin/fStudent2.XOD
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.standardoe.AttributeInstanceImpl.setInternalValue(AttributeInstanceImpl.java:40)
com.quinsoft.zeidon.dbhandler.JdbcHandler.setAttribute(JdbcHandler.java:449)
com.quinsoft.zeidon.dbhandler.JdbcHandler.loadAttributes(JdbcHandler.java:568)
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeLoad(JdbcHandler.java:369)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.loadEntity(AbstractSqlHandler.java:1334)
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:5021)
org.nazarene.nazsis.nFindD_Dialog.PerformFindStudent(nFindD_Dialog.java:13104)
org.apache.jsp.nFindDStudentList_jsp._jspService(nFindDStudentList_jsp.java:2240)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)

I’ve also tried searching for this person by their email address -  suzannethompson@talktalk.net - in advanced search and just get “No results found”.

--

Thanks for your help!

Status: 
Resolved
No votes yet
Top
Tue, 04/28/2020 - 16:55
Robert Rae
Last seen: 1 week 1 day ago
Joined: 08/20/2019 - 16:32
Folks,

Folks,

Any update on this? It looks like the specific email address is giving presenting a problem for some reason, but because of that LKH can't get into the record to change it. 

R

No votes yet

Robert Rae
Admissions
Nazarene Theological College, Manchester (UK)

Top
Thu, 04/30/2020 - 23:57
kbible
Last seen: 20 min 59 sec ago
Joined: 01/22/2019 - 10:07
This has been fixed.  The

This has been fixed.  The data was imported with quotes around it, so wasnt a proper email address.  Any emails entered in to the system directly would be checked for format before acceptance, so this was just an import issue.  I have removed the quotes from this one, and verified no other emails have quotes.

No votes yet

Senior Software Developer
Global Ministry Center - Church of the Nazarene

Top