Forum topic

Folks,

We're just printing transcripts, and we've having a problem saving individualised Transcript Notes. So, the field "Transcript General Memo" which would appear on all transripts works fine. But if I try to use the "Transcript Memo by Type" field (for any of the transcripts), when I try to save the Student Record I get the following error:

--

*** Error on action - SAVE_Student ***
com.quinsoft.zeidon.ZeidonDbException: Duplicate entry '3' for key 'USTUDENTTRANSCRIPTMEMO_ID2410313' EI = nazsis.mStudent.StudentTranscriptMemo Keys: ID=3; SQL => INSERT INTO STUDENTTRANSCRIPTMEMO ( ID, TRANSCRIPTTYPE, FK_ID_STUDENT, z_MEMO ) VALUES ( ? , ? , ? , ? ); Value 1 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@70b6d7ed [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 2 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@2b86f58a [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 3 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@5c11bd87 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] Value 4 : com.quinsoft.zeidon.dbhandler.BoundAttributeData@eae54b3 [com.quinsoft.zeidon.dbhandler.BoundAttributeData] EntityDef : nazsis.mStudent.StudentTranscriptMemo
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:305)
com.quinsoft.zeidon.vml.VmlOperation.CommitMultipleObjectInstances(VmlOperation.java:5294)
org.nazarene.nazsis.zGLOBALT_Operation.SAVE_Student_G(zGLOBALT_Operation.java:3219)
org.nazarene.nazsis.zGLOBALT_Operation.SAVE_StudentData_G(zGLOBALT_Operation.java:2443)
org.nazarene.nazsis.nReg_Dialog.SAVE_Student(nReg_Dialog.java:10009)
org.apache.jsp.nRegAcademics_jsp._jspService(nRegAcademics_jsp.java:3605)
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)

--

This is problematic because we have students who take multiple degrees, and some memos should only appear on their Graduate Transcript, for example.

Rob