Thursday, October 15, 2015

java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock oracle identity manager


Steps to overcome the issue;

Try to close all open and active sessions to DB. before doing this commit/rollback all the changes you have done before hen rerun the case.


ERROR,15 Oct 2015 11:46:18,164,[XELLERATE.ACCOUNTMANAGEMENT],Class/Method: tcUserOperationsBean/updateUserData encounter some problems: Error occurred while updating u ser.
ERROR,15 Oct 2015 11:46:18,166,[XELLERATE.ACCOUNTMANAGEMENT],Class/Method: tcUserOperationsBean/updateUserData encounter some problems: ORA-02049: timeout: distributed  transaction waiting for lock

java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
        at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
        at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:274)
        at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:504)
        at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.updateUserData(Unknown Source)
        at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.updateUser(Unknown Source)
        at com.thortech.xl.ejb.beans.tcUserOperationsSession.updateUser(Unknown Source)
        at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.updateUser(tcUserOperations_voj9p2_EOImpl.java:2950)
        at Thor.API.Operations.tcUserOperationsClient.updateUser(Unknown Source)
        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:597)
        at Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(Unknown Source)
        at weblogic.security.Security.runAs(Security.java:41)
        at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source)
        at Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source)
        at $Proxy59.updateUser(Unknown Source)
        at com.thortech.xl.webclient.actions.tcManageUserAction.editUser(Unknown Source)
        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:597)
        at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
        at com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source)
        at com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source)
        at com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at com.turkcell.iglo.ui.filter.RedirectFilter.doFilter(RedirectFilter.java:47)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at com.turkcell.iglo.ui.filter.AccessFilter.doFilter(AccessFilter.java:65)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(Unknown Source)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
ERROR,15 Oct 2015 11:46:18,172,[XELLERATE.WEBAPP],Class/Method: tcActionBase/execute encounter some problems: {1}
java.lang.NullPointerException
        at com.thortech.xl.webclient.actions.tcManageUserAction.editUser(Unknown Source)
        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:597)
        at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
        at com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source)
        at com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source)
        at com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at com.turkcell.iglo.ui.filter.RedirectFilter.doFilter(RedirectFilter.java:47)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at com.turkcell.iglo.ui.filter.AccessFilter.doFilter(AccessFilter.java:65)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(Unknown Source)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

Wednesday, October 14, 2015

Stopping & Starting oim managed servers and Weblogic Console

To Start OIM_MANAGED_SERVER

go to <DOMAIN_HOME>user_projects/domains/IDM_Domain/bin folder and type

nohup ./startManagedWeblogic.sh oim_server1 &

To Stop OIM_MANAGED_SERVER

go to <DOMAIN_HOME>user_projects/domains/IDM_Domain/bin folder and type

nohup ./stopManagedWeblogic.sh oim_server1 &


To Start Weblogic Administration Console

go to <DOMAIN_HOME>user_projects/domains/IDM_Domain/bin folder and type

nohup ./startWeblogic.sh & 


To Stop Weblogic Administration Console

nohup ./startWeblogic.sh & 
OR
Go to Weblogic Adminstration Console, Goto Servers under IDM_Domain->Environment and Click Control tab. Then select checkbox next to AdminServer. This will make the Shutdown button enabled. Then Force Shutdown Now. This will kill the Admin Console process. After stopping Admin Server you no longer have the ability to reach to the Console. To start the server again follow the steps above.

See the screen shot below.