[Anthill-pro] 3.5.0 PersistenceRuntimeException deleting agent
Steve Boone
sbb at urbancode.com
Thu May 22 12:12:31 CDT 2008
Ken,
This was a bug and it has been fixed. I believe it was released in 3.5.1
On Mon, May 12, 2008 at 8:50 AM, Pacileo, Kenneth <kenneth_pacileo at uhc.com>
wrote:
> I upgraded our test environment to 3.5.0_12839 last week. This
> environment has three agents; one on each of Windows, Solaris and AIX. After
> the upgrade I reinstalled the Solaris agent to a new directory. I then
> stopped the old Solaris agent and started the new one. When I try to delete
> the old agent from the Admin Web UI, I get a "PersistenceRuntimeException:
> Error deleting object in database". I tried restarting the server and saw an
> error restoring an object from the database. The full stack trace from the
> server for the restart error and agent delete error is below. What needs to
> be done to fix this?
>
>
>
> Regards,
>
> Ken
>
>
>
> Ken Pacileo
>
> UnitedHealth Group IT
>
> Kenneth_Pacileo at uhc.com
>
> Office: 860-702-5136
>
>
>
> 2008-05-12 07:32:12,834 WARN
> com.urbancode.anthill3.main.server.AnthillServer - Shutting down server...
>
> 2008-05-12 07:32:13,131 WARN
> com.urbancode.anthill3.services.event.EventService - 3 EventListeners left
> registered at shutdown
>
> 2008-05-12 07:32:45,850 ERROR
> com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersDaoSql - Error
> restoring object from database: null
>
> com.urbancode.anthill3.domain.repositoryusers.UserDataInconsistentException
>
> at
> com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersXMLMarshaller.postRead(RepositoryUsersXMLMarshaller.java:311)
>
> at
> com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersXMLMarshaller.readStream(RepositoryUsersXMLMarshaller.java:228)
>
> at
> com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersDaoSql.restore(RepositoryUsersDaoSql.java:212)
>
> at
> com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersDaoSql.restoreRepositoryUsers(RepositoryUsersDaoSql.java:54)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:324)
>
> at
> com.urbancode.anthill3.domain.persistent.Dao.executeDelegate(Dao.java:90)
>
> at
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.executeDelegate0(UnitOfWorkDefault.java:390)
>
> at
> com.urbancode.anthill3.persistence.UnitOfWork.executeDelegate(UnitOfWork.java:860)
>
> at
> com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersFactory.restore(RepositoryUsersFactory.java:43)
>
> at
> com.urbancode.anthill3.services.repositoryusers.RepositoryUsersService.start(RepositoryUsersService.java:50)
>
> at
> com.urbancode.anthill3.main.server.AnthillServer.run(AnthillServer.java:215)
>
> at
> com.urbancode.anthill3.main.server.AnthillServer.main(AnthillServer.java:107)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:324)
>
> at com.urbancode.anthill3.launcher.Launcher.main(Launcher.java:86)
>
> 2008-05-12 07:33:07,944 INFO org.apache.catalina.core.StandardEngine -
> Starting Servlet Engine: Apache Tomcat/5.5.25
>
> 2008-05-12 07:34:04,054 INFO
> com.urbancode.anthill3.services.workflow.WorkflowService - Recovering
> workflows.....
>
> 2008-05-12 07:34:04,351 INFO
> com.urbancode.anthill3.services.workflow.WorkflowService - Workflow recovery
> complete
>
> 2008-05-12 07:34:42,679 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: Error
> deleting object in database
>
> 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
> com.urbancode.anthill3.web.controller.ControllerServlet.doGet(ControllerServlet.java:160)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>
> 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:
> Error deleting object in database
>
> at
> com.urbancode.anthill3.domain.persistent.DaoSql.delete(DaoSql.java:355)
>
> at
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.commit0(UnitOfWorkDefault.java:177)
>
> at
> com.urbancode.anthill3.persistence.UnitOfWork.commit(UnitOfWork.java:701)
>
> at
> com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:178)
>
> ... 34 more
>
> Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1711)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3311)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
>
> at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPreparedStatement.java:183)
>
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
>
> at
> com.urbancode.anthill3.domain.persistent.DaoSql.delete(DaoSql.java:348)
>
> ... 37 more
>
>
>
>
>
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity to
> which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
>
> _______________________________________________
> 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/20080522/415b2ce6/attachment-0001.htm
More information about the Anthill-pro
mailing list