[Anthill-pro] 3.5.0 PersistenceRuntimeException deleting agent
Pacileo, Kenneth
kenneth_pacileo at uhc.com
Mon May 12 07:50:15 CDT 2008
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.UserDataInconsistentExcept
ion
at
com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersXMLMarshall
er.postRead(RepositoryUsersXMLMarshaller.java:311)
at
com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersXMLMarshall
er.readStream(RepositoryUsersXMLMarshaller.java:228)
at
com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersDaoSql.rest
ore(RepositoryUsersDaoSql.java:212)
at
com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersDaoSql.rest
oreRepositoryUsers(RepositoryUsersDaoSql.java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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(Un
itOfWorkDefault.java:390)
at
com.urbancode.anthill3.persistence.UnitOfWork.executeDelegate(UnitOfWork
.java:860)
at
com.urbancode.anthill3.domain.repositoryusers.RepositoryUsersFactory.res
tore(RepositoryUsersFactory.java:43)
at
com.urbancode.anthill3.services.repositoryusers.RepositoryUsersService.s
tart(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.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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].[/].[Contr
ollerServlet] - 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:1
87)
at
com.urbancode.anthill3.web.util.Conversation.unbind(Conversation.java:49
)
at
com.urbancode.anthill3.web.controller.ControllerServlet.doPost(Controlle
rServlet.java:463)
at
com.urbancode.anthill3.web.controller.ControllerServlet.doGet(Controller
Servlet.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(Applica
tionFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.jav
a:78)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter.j
ava:132)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
com.urbancode.anthill3.web.util.AuthorityFilter.doFilter(AuthorityFilter
.java:67)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
com.urbancode.anthill3.web.security.DisableSessionUrlFilter.doFilter(Dis
ableSessionUrlFilter.java:127)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
com.urbancode.anthill3.web.security.SecureSessionFilter.doFilter(SecureS
essionFilter.java:114)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.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:1
51)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87
4)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.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(UnitOfWorkD
efault.java:177)
at
com.urbancode.anthill3.persistence.UnitOfWork.commit(UnitOfWork.java:701
)
at
com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:1
78)
... 34 more
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index::
2
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
2)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:14
6)
at
oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(Oracl
ePreparedStatement.java:1711)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
dStatement.java:3311)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:3400)
at
com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepa
redStatement.java:183)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
tingPreparedStatement.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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.urbancode.com/pipermail/anthill-pro/attachments/20080512/ac79877d/attachment-0001.htm
More information about the Anthill-pro
mailing list