You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by "Aliyar, Nishar" <ni...@schema.de> on 2002/08/14 18:15:56 UTC
Exception when new user creation ......Urgent
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Exception when new user creation ......Urgent
Posted by David Sean Taylor <da...@bluesunrise.com>.
There seems to be a problem when you create the PSML, which then throws an
exception, the transaction tries to rollback by deleting the user from the
db, and then you finally get the exception below. The root of the problem is
that the PSML fails to create, yet its unfortunate that we don't have the
original stack trace which was actually printed out to the console. See the
method addDefaultPSML where it prints the stack trace. Modify this and
change the stack trace to go to the log file, or just send us the stacktrace
from the console.
catch (Exception e)
{
e.printStackTrace();
removeUser(new UserNamePrincipal(user.getUserName()));
throw new UserException("Failed to create profile for new user
", e);
}
Also, are you using DB PSML?
The secondary problem seems to be that the cascading delete option wasn't
properly generated. Make sure that the torque generated sql file has the
cascade delete option:
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USER_ID)
REFERENCES TURBINE_USER (USER_ID) ON DELETE CASCADE;
(I also use Oracle, and it generated correctly for me)
And, when using Oracle, make sure that you set this to false:
services.JetspeedSecurity.programmatic.cascade.delete=false
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>