[Anthill-pro] New Recipient Generator - Did not find sequence named: NOTIFICATION_RECIPIENT_GEN

Steve Boone sbb at urbancode.com
Tue Apr 15 11:30:00 CDT 2008


Peter,

You can run this SQL to clear it up.

UPDATE HI_LO_SEQ SET SEQ_NAME = 'NOTIFICATION_RECIPIENT_GEN' WHERE SEQ_NAME
= 'NOTIFICATION_RECIPIENT_SCRIPT';

On Tue, Apr 15, 2008 at 3:11 AM, Lanser, Peter <Peter.Lanser at 3beg.at> wrote:

> Hi,
>
> when trying to create a new Recipient Generator I get the error "Did not
> find sequence named: NOTIFICATION_RECIPIENT_GEN" (excption stack trace see
> below).
>
> I'm using AHP 3.4.12 with MySQL.
>
> I tried it with a fresh install - same error. AHP comes with three
> Recipient Generators. A quick check on the table HI_LO_SEQ showed that there
> is no sequence named NOTIFICATION_RECIPIENT_GEN.
>
> Regards,
> Peter
>
> 2008-04-15 09:04:58,225 DEBUG
> com.urbancode.anthill3.persistence.UnitOfWorkDefault - Did not find sequence
> named: NOTIFICATION_RECIPIENT_GEN
> com.urbancode.anthill3.domain.persistent.PersistenceException: Did not
> find sequence named: NOTIFICATION_RECIPIENT_GEN
>        at
> com.urbancode.anthill3.domain.persistent.HiLoIdentityGenerator.grab(HiLoIdentityGenerator.java:109)
>        at
> com.urbancode.anthill3.domain.persistent.HiLoIdentityGenerator.generateIdentity(HiLoIdentityGenerator.java:72)
>        at
> com.urbancode.anthill3.domain.persistent.HiLoIdentityGenerator.assignIdentity(HiLoIdentityGenerator.java:62)
>        at
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.commit0(UnitOfWorkDefault.java:144)
>        at
> com.urbancode.anthill3.persistence.UnitOfWork.commit(UnitOfWork.java:701)
>        at
> com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:178)
>        at
> com.urbancode.anthill3.web.util.Conversation.unbind(Conversation.java:49)
>        at
> com.urbancode.anthill3.web.controller.ControllerServlet.doPost(ControllerServlet.java:463)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.java:78)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter.java:132)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.util.AuthorityFilter.doFilter(AuthorityFilter.java:67)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.security.DisableSessionUrlFilter.doFilter(DisableSessionUrlFilter.java:127)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.security.SecureSessionFilter.doFilter(SecureSessionFilter.java:114)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>        at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>        at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>        at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>        at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>        at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>        at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>        at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>        at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>        at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>        at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>        at java.lang.Thread.run(Thread.java:534)
> 2008-04-15 09:04:58,225 TRACE
> com.urbancode.anthill3.persistence.UnitOfWork - 2409003 unbindThread()
> http-0.0.0.0-8080-Processor25, threadCount: 0
> 2008-04-15 09:04:58,225 ERROR
> org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/].[ControllerServlet]
> - Servlet.service() for servlet ControllerServlet threw exception
> com.urbancode.anthill3.domain.persistent.PersistenceRuntimeException:
> com.urbancode.anthill3.domain.persistent.PersistenceException: Did not find
> sequence named: NOTIFICATION_RECIPIENT_GEN
>        at
> com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:187)
>        at
> com.urbancode.anthill3.web.util.Conversation.unbind(Conversation.java:49)
>        at
> com.urbancode.anthill3.web.controller.ControllerServlet.doPost(ControllerServlet.java:463)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.java:78)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter.java:132)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.util.AuthorityFilter.doFilter(AuthorityFilter.java:67)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.security.DisableSessionUrlFilter.doFilter(DisableSessionUrlFilter.java:127)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> com.urbancode.anthill3.web.security.SecureSessionFilter.doFilter(SecureSessionFilter.java:114)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>        at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>        at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>        at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>        at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>        at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>        at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>        at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>        at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>        at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>        at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>        at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>        at java.lang.Thread.run(Thread.java:534)
> Caused by: com.urbancode.anthill3.domain.persistent.PersistenceException:
> Did not find sequence named: NOTIFICATION_RECIPIENT_GEN
>        at
> com.urbancode.anthill3.domain.persistent.HiLoIdentityGenerator.grab(HiLoIdentityGenerator.java:109)
>        at
> com.urbancode.anthill3.domain.persistent.HiLoIdentityGenerator.generateIdentity(HiLoIdentityGenerator.java:72)
>        at
> com.urbancode.anthill3.domain.persistent.HiLoIdentityGenerator.assignIdentity(HiLoIdentityGenerator.java:62)
>        at
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.commit0(UnitOfWorkDefault.java:144)
>        at
> com.urbancode.anthill3.persistence.UnitOfWork.commit(UnitOfWork.java:701)
>        at
> com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:178)
>        ... 33 more
>
> 3 Banken EDV
> DI (FH) Peter Lanser
> Anwendungsentwicklung
> Kompetenzzentrum Linz
> A-4020 Linz, Untere Donaulände 28
> http://www.3beg.at
> Tel.: +43 (732) 7802 2588
> Fax: +43 (732) 7802 44 2588
> Mobil: +43 (699) 16 123 550
> E-Mail: peter.lanser at 3beg.at
>
> Hinweis:
> Diese Nachricht und eventuelle Dateianhänge sind vertraulich und nur für
> den (die) darin angegebenen Adressaten bestimmt. Jeder Gebrauch, jede
> Weitergabe oder Vervielfältigung durch andere als den (die) bestimmten
> Adressaten ist verboten. Sollten Sie diese Sendung irrtümlich erhalten
> haben, verständigen Sie bitte unverzüglich per E-Mail den Absender und
> löschen Sie die Sendung samt allfälligen Dateianhängen aus Ihrem System. Der
> Austausch von Nachrichten via E-Mail dient ausschließlich zu
> Informationszwecken. Das Unternehmen 3BEG gibt daher weder via E-Mail
> rechtliche Erklärungen ab noch nimmt sie solche an; ausgenommen davon sind
> jene Fälle, in denen dies gesondert gegenteilig vereinbart wurde.
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.urbancode.com/pipermail/anthill-pro/attachments/20080415/0eb9df57/attachment-0001.htm


More information about the Anthill-pro mailing list