Folks,
I'm getting the following error when trying to send out an email to a group of students. Slightly odd in that I have successfully sent out an email to this contact group previously (this Saturday past, indeed) and didn't get the error.
--
*** Error on action - EmailWithContactEntry ***
com.quinsoft.zeidon.ZeidonDbException: Incorrect string value: '\xF0\x9F\x98\x8E" ...' for column 'z_NOTE' at row 1 EI = nazsis.mCntHist.ContactActivity Keys: ID=392; SQL => INSERT INTO CONTACTACTIVITY ( ID, TYPE, RESULTCODE, COMPLETEDDATETIME, EMAILSUBJECTLINE, FUNCTIONALAREA, PRIVATETOAREA, CREATEDDATETIME, MODIFIEDDATETIME, CREATEDBY, LASTMODIFIEDBY, FK_ID_ACTIVITY, FK_ID_CHURCH, FK_ID_EVENT, FK_ID_DOCUMENT, FK_ID_VENDOR, FK_ID_Z_USER, PK2_ID_PERSON, FK_ID_DONOR, FK_ID_STUDENT, FK_ID_PERSON, FK_ID_EMPLOYEE, FK_ID_SCHOOL, FK_ID_ORGANIZATION, PRIID_STUDENT, FK_ID_FINAIDSOURCE, FK_ID_FUND, USEREMAILRECIPIENTS, HEALTHSERVICESNOTE, z_NOTE ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ); Value 1 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@608cb789 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 2 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@6c7aed9c [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 3 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@2f04895a [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 4 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@6d1fa6d6 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 5 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@682a6403 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 6 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@53877297 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 7 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@58427fe4 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 8 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@48fb4b2c [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 9 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@73ca244c [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 10 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@1b31e368 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 11 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@50c702b5 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 12 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@427781aa [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 13 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@603d25ec [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 14 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@7483b020 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 15 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@1c39c6af [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 16 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@62bd6e53 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 17 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@6ba625ad [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 18 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@2cd8a49 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 19 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@50132801 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 20 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@59d51ba6 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 21 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@384d67c [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 22 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@6df59b87 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 23 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@246fe518 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 24 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@5596d218 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 25 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@7004d9e0 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 26 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@31ec4dc4 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 27 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@6a7029c4 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 28 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@9952080 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 29 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@5f88338b [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 30 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@c59c7d3 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] EntityDef : nazsis.mCntHist.ContactActivity
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeStatement(JdbcHandler.java:867)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.executeStatement(AbstractSqlHandler.java:1674)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.insertEntity(AbstractSqlHandler.java:228)
com.quinsoft.zeidon.standardoe.CommitToDbUsingGenkeyHandler.commitCreates(CommitToDbUsingGenkeyHandler.java:293)
com.quinsoft.zeidon.standardoe.AbstractCommitToDb.commitView(AbstractCommitToDb.java:81)
com.quinsoft.zeidon.standardoe.CommitToDbUsingGenkeyHandler.commit(CommitToDbUsingGenkeyHandler.java:115)
com.quinsoft.zeidon.standardoe.CommitMultipleOIs.commit(CommitMultipleOIs.java:512)
com.quinsoft.zeidon.standardoe.TaskImpl.commitMultipleOis(TaskImpl.java:318)
com.quinsoft.zeidon.standardoe.TaskImpl.commitMultipleOis(TaskImpl.java:299)
com.quinsoft.zeidon.standardoe.ViewImpl.commit(ViewImpl.java:387)
com.quinsoft.zeidon.vml.zVIEW.commit(zVIEW.java:116)
com.quinsoft.zeidon.vml.VmlOperation.CommitObjectInstance(VmlOperation.java:5247)
org.nazarene.nazsis.nEmail_Dialog.EmailWithContactEntry(nEmail_Dialog.java:395)
org.apache.jsp.nEmailEmail_jsp._jspService(nEmailEmail_jsp.java:530)
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)
--
Thanks!
Rob
Thank you for letting us know. We will look into it and get back to you soon.
Dana
*GNECsis Support Specialist*
What did you put in as the note? If you don't want to post it here, you can email to gnecsishelp@nazarene.org. Something that you added is being read as an invalid character.
Senior Software Developer
Global Ministry Center - Church of the Nazarene
Ah, right - it was a message from the marketing team and I had copy/pasted, so *of course* it had an emoji in it. I'll avoid that in future.
On a (possibly?) related note, however, when I attempt to manually add a Contact History item to an account, I get the following error:
--
type Exception report
message An exception occurred processing JSP page /nCntHstDContactEvent.jsp at line 557
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /nCntHstDContactEvent.jsp at line 557
554: else
555: {
556: VmlOperation.SetZeidonSessionAttribute( null, task, "nCntHstDContactEvent", "nCntHstD.PostBuildContactEvent" );
557: nOptRC = nCntHstD.PostBuildContactEvent( new zVIEW( vKZXMLPGO ) );
558: if ( nOptRC == 2 )
559: {
560: View vView;
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:579)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
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.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
com.quinsoft.zeidon.InvalidAttributeValueException: Invalid value for attribute
New value = 09:39
Domain = nazsis.Time [org.nazarene.nazsis.domains.TimeDomainLPLR]
Context = HH:MM AM
AttributeDef = nazsis.mCntHist.ContactActivity.wCompletedTime
Value = 09:39
Invalid Date: Value '09:39' needs to be in the following format 'HH:MM AM'.
org.nazarene.nazsis.domains.DateTimeDomainLPLR.convertExternalValue(DateTimeDomainLPLR.java:124)
com.quinsoft.zeidon.standardoe.AttributeValue.set(AttributeValue.java:199)
com.quinsoft.zeidon.standardoe.AttributeInstanceImpl.setValue(AttributeInstanceImpl.java:314)
com.quinsoft.zeidon.standardoe.AttributeInstanceImpl.setValue(AttributeInstanceImpl.java:327)
com.quinsoft.zeidon.vml.VmlOperation.SetAttributeFromString(VmlOperation.java:4686)
org.nazarene.nazsis.nCntHstD_Dialog.PostBuildContactEvent(nCntHstD_Dialog.java:611)
org.apache.jsp.nCntHstDContactEvent_jsp._jspService(nCntHstDContactEvent_jsp.java:691)
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.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
--
We haven't really been using Contact History up to now, so I hadn't noticed! Let me know if you'd like me to make this a seperate thread.
Robert Rae
Admissions
Nazarene Theological College, Manchester (UK)
This is fine. I can notify the team about it. They can respond here no problem.
Thanks for taking time to share.
Dana
*GNECsis Support Specialist*