Hai all,
I am getting this exception when I try to create a new user in Jetspeed1.4
If any body got any idea why this exception please let me know, I am stuck with this
probs.
Cheers,
Nishar.
java.sql.SQLException: ORA-02292: integrity constraint
(SYSTEM.TURBINE_USER_GROUP_ROLE_FK_1) violated - child record found
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code))
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code))
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:322)
at com.workingdogs.village.Record.saveWithDelete(Unknown Source)
at com.workingdogs.village.Record.save(Unknown Source)
at com.workingdogs.village.Record.save(Unknown Source)
at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:700)
at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:563)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doDelete(BaseTurbineUserPeer.java:461)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doDelete(BaseTurbineUserPeer.java:436)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.removeUser(TurbineUserManagement.java:402)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addDefaultPSML(TurbineUserManagement.java:364)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:326)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:141)
at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:237)
at
org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:208)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:510)
at org.apache.turbine.Turbine.doPost(Turbine.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:159)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:286)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:106)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:499)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:278)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:105)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:67)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:123)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:313)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:242)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
rethrown as org.apache.torque.TorqueException: ORA-02292: integrity constraint
(SYSTEM.TURBINE_USER_GROUP_ROLE_FK_1) violated - child record found
at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:705)
at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:563)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doDelete(BaseTurbineUserPeer.java:461)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doDelete(BaseTurbineUserPeer.java:436)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.removeUser(TurbineUserManagement.java:402)
rethrown as org.apache.jetspeed.services.security.UserException: Failed to remove
account 'nishar': ORA-02292: integrity constraint
(SYSTEM.TURBINE_USER_GROUP_ROLE_FK_1) violated - child record found
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.removeUser(TurbineUserManagement.java:406)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addDefaultPSML(TurbineUserManagement.java:364)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:326)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:141)
at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:237)
at
org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:208)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:510)
at org.apache.turbine.Turbine.doPost(Turbine.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:159)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:286)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:106)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:499)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:278)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:105)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:67)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:123)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:313)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:242)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
