[Anthill-pro] New Recipient Generator - Did not find
sequencenamed: NOTIFICATION_RECIPIENT_GEN
Steve Boone
sbb at urbancode.com
Tue Apr 15 13:55:30 CDT 2008
It's a bug.
Currently, you will have to run some SQL against the derby database.
UPDATE HI_LO_SEQ SET SEQ_NAME = 'NOTIFICATION_RECIPIENT_GEN' WHERE SEQ_NAME
= 'NOTIFICATION_RECIPIENT_SCRIPT';
You will need to be able to connect to the Derby database.
You can use DBvisualiser to access the DB and then remove the user, or edit
the database however you like. In my opinion this is the easiest way.
You can download the program from http://www.minq.se/products/dbvis/
Connection string: jdbc:derby://localhost:11366/data
login: anthill3
password: password
Also, the driver you will want to use is in the server\lib directory. It is
derbyclient.jar
On Tue, Apr 15, 2008 at 2:46 PM, Wes Bramhall <WesB at widen.com> wrote:
> I just encountered this on a fresh install of 3.4.12 trying to setup a
> fixed recipient. I'm using derby. How would I go about fixing this?
>
>
>
> Thanks,
>
> -Wes
>
>
>
> *From:* anthill-pro-bounces at lists.urbancode.com [mailto:
> anthill-pro-bounces at lists.urbancode.com] *On Behalf Of *Steve Boone
> *Sent:* Tuesday, April 15, 2008 11:30 AM
> *To:* AnthillPro user and support list.
> *Subject:* Re: [Anthill-pro] New Recipient Generator - Did not find
> sequencenamed: NOTIFICATION_RECIPIENT_GEN
>
>
>
> 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
>
>
>
> _______________________________________________
> 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/e8d44a9e/attachment-0001.htm
More information about the Anthill-pro
mailing list