Current Position:Home > OIM 10g : SQL Script to Delete or Cancel process instance tasks for user resources

OIM 10g : SQL Script to Delete or Cancel process instance tasks for user resources

Update:10-11Source: network consolidation
Advertisement
Hello,
I have users with a resource with a process instance that have a large number (1000) of task instance related to reconciliations (Reconciliation Update Received).
And when trying to revoke this resource, OIM take a long time to perfom this job, it is due to the fact that all this taks are canceled one by one...
My question is : I want to perform manualy using a script this cancel of all this tasks, or maybe better, delete all this tasks when there'are too many, can someone provide me this sql scripts.
Thanks in advance.

The Best Answer

Advertisement
I'm running this script into an adapter with the following code :
public boolean clearTaskInstances(String user_key, String process_name, String task_name) throws OIMException {
  $logger.debug("Utils.clearTaskInstances() : Inside deleting task instances debug 1");
  tcDataProvider provider = getOIMConnection().getDataBase();
  $logger.debug("Utils.clearTaskInstances() : Inside deleting task instances debug 2");
String query = "DELETE FROM OSI WHERE OSI.MIL_KEY=" +  
  "(SELECT MIL.MIL_KEY FROM MIL WHERE MIL.TOS_KEY=" +
  "(SELECT TOS_KEY FROM TOS LEFT JOIN PKG ON PKG.PKG_KEY=TOS.PKG_KEY WHERE PKG.PKG_NAME=" +
  "'" + process_name + "') AND MIL.MIL_NAME='" + task_name + "'" +
  "AND OSI.ORC_KEY IN (SELECT ORC.ORC_KEY FROM ORC WHERE ORC.USR_KEY='" + user_key +"'))";
  $logger.debug("Utils/clearTaskInstance : Delete Query = " + query);
  PreparedStatementUtil preparedStatement = new PreparedStatementUtil();
   preparedStatement.setStatement(provider, query);
   try {
   preparedStatement.executeUpdate();
  $logger.debug("Utils/clearTaskInstance : Delete Query executed");
  return true;
  } catch (Exception e) {
  $logger.error("Utils/clearTaskInstance : Error while executing Delete Query : " + e);
  return false;
, but this generate 18M of SQL error logs !!
The same SQL request in SQL Dev works fine, the same code with OIM 11gR2 works fine too, the problem seems to be only with OIM 9.1.
The first lines in the logs are :
DEBUG,12 Jul 2013 09:03:20,972,[XELLERATE.CUSTOM],connection object created
DEBUG,12 Jul 2013 09:03:20,972,[XELLERATE.CUSTOM],Utils.clearTaskInstances() : Inside deleting task instances debug 2
DEBUG,12 Jul 2013 09:03:20,972,[XELLERATE.CUSTOM],Utils/clearTaskInstance : Delete Query = DELETE FROM OSI WHERE OSI.MIL_KEY=(SELECT MIL.MIL_KEY FROM MIL WHERE MIL.TOS_KEY=(SELECT TOS_KEY FROM TOS LEFT JOIN PKG ON PKG.PKG_KEY=TOS.PKG_KEY WHERE PKG.PKG_NAME='SMC Prov Process') AND MIL.MIL_NAME='Reconciliation Update Received'AND OSI.ORC_KEY IN (SELECT ORC.ORC_KEY FROM ORC WHERE ORC.USR_KEY='78'))
ERROR,12 Jul 2013 09:03:46,641,[XELLERATE.CUSTOM],Utils/clearTaskInstance : Error while executing Delete Query : com.thortech.xl.dataaccess.tcDataSetException: Data Access Error
ERROR,12 Jul 2013 09:03:47,047,[XELLERATE.SERVER],Class/Method: tcScheduleItem/getMilestoneInfo Error : ScheduleItem has  No Milestone.
ERROR,12 Jul 2013 09:03:47,050,[XELLERATE.DATABASE],select orc.orc_status, orc.pkg_key from orc orc where orc.orc_key =
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
  at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
  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:1035)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
  at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)
  at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1378)
  at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
  at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479)
  at com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.checkApprovalProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.eventPreInsert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelORC(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperationsSession.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.revokeObjects(tcUserOperations_voj9p2_EOImpl.java:2285)
  at Thor.API.Operations.tcUserOperationsClient.revokeObjects(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(SecurityManager.java:121)
  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 $Proxy60.revokeObjects(Unknown Source)
  at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.revokeProvisionedResources(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 com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.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:56)
  at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
ERROR,12 Jul 2013 09:03:47,051,[XELLERATE.DATABASE],Class/Method: tcDataBase/readPartialStatement encounter some problems: ORA-00936: missing expression
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
  at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
  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:1035)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
  at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)
  at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1378)
  at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
  at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479)
  at com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.checkApprovalProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.eventPreInsert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelORC(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperationsSession.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.revokeObjects(tcUserOperations_voj9p2_EOImpl.java:2285)
  at Thor.API.Operations.tcUserOperationsClient.revokeObjects(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(SecurityManager.java:121)
  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 $Proxy60.revokeObjects(Unknown Source)
  at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.revokeProvisionedResources(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 com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.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:56)
  at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
ERROR,12 Jul 2013 09:03:47,052,[XELLERATE.SERVER],Class/Method: tcScheduleItem/checkApprovalProcess encounter some problems: Data Access Error
com.thortech.xl.dataaccess.tcDataSetException: Data Access Error
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.checkApprovalProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.eventPreInsert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelORC(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperationsSession.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.revokeObjects(tcUserOperations_voj9p2_EOImpl.java:2285)
  at Thor.API.Operations.tcUserOperationsClient.revokeObjects(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(SecurityManager.java:121)
  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 $Proxy60.revokeObjects(Unknown Source)
  at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.revokeProvisionedResources(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 com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.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:56)
  at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Data AccessException:
com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL: select orc.orc_status, orc.pkg_key from orc orc where orc.orc_key = Description: ORA-00936: missing expression
SQL State: 42000Vendor Code: 936Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException
  at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataBase.createException(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.checkApprovalProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.eventPreInsert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelORC(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperationsSession.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.revokeObjects(tcUserOperations_voj9p2_EOImpl.java:2285)
  at Thor.API.Operations.tcUserOperationsClient.revokeObjects(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(SecurityManager.java:121)
  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 $Proxy60.revokeObjects(Unknown Source)
  at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.revokeProvisionedResources(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 com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.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:56)
  at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Source SQL Exception:
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
  at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
  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:1035)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
  at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)
  at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1378)
  at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
  at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479)
  at com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.checkApprovalProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.eventPreInsert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelORC(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperationsSession.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.revokeObjects(tcUserOperations_voj9p2_EOImpl.java:2285)
  at Thor.API.Operations.tcUserOperationsClient.revokeObjects(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(SecurityManager.java:121)
  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 $Proxy60.revokeObjects(Unknown Source)
  at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.revokeProvisionedResources(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 com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.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:56)
  at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
ERROR,12 Jul 2013 09:03:47,054,[XELLERATE.DATABASE],Error: Error Keyword: DAE.UNKNOWN_CODE
Description: An unknown error code was passed.
Remedy: Contact your system adminstrator.
Action: E
Severity: C
Help URL:
Detail:
com.thortech.xl.dataaccess.tcDataSetException: Data Access Error
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.checkApprovalProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcScheduleItem.eventPreInsert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
  at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelORC(Unknown Source)
  at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelProcess(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source)
  at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperationsSession.revokeObjects(Unknown Source)
  at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.revokeObjects(tcUserOperations_voj9p2_EOImpl.java:2285)
  at Thor.API.Operations.tcUserOperationsClient.revokeObjects(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(SecurityManager.java:121)
  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 $Proxy60.revokeObjects(Unknown Source)
  at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.revokeProvisionedResources(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 com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.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:56)
  at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Data AccessException:
com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL: select orc.orc_status, orc.pkg_key from orc orc where orc.orc_key = Description: ORA-00936: missing expression
SQL State: 42000Vendor Code: 936Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException
  at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataBase.createException(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
  at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
  • OIM 10g : SQL Script to Delete or Cancel process instance tasks for user resources Update:10-11

    Hello, I have users with a resource with a process instance that have a large number (1000) of task instance related to reconciliations (Reconciliation Update Received). And when trying to revoke this resource, OIM take a long time to perfom this job

  • Cancel process instance CE 7.2 Update:10-11

    Hi, it is not possible to cancel some of the process instances shown in NWA->manage processes. If I try there is an error and the default trace shows the following: Error while resuming process instance '2713e1d90ae511e0c1de0000001532c2'. [EXCEPTION]

  • Cancel Process from task Update:11-30

    Hello, I did some research but did not find something like this. I need to cancel a process from within a task, for that, I defined a decision after the task verifying if the user clicked the "Cancel" button, and send it to a terminate event. Th

  • Programatically deleting the completed process instances Update:11-30

    Hi, I have too many completed process instances in my dev system. Deleting them using "Administration -> Archiving and Deleting" is very cumbersome and also giving lots of errors. Is it possible to delete all the completed/erroneous process i

  • Removed SQL 2012 AV group leaves phantom processes consuming large amounts of resource Update:11-30

    Hi, I have been experiencing performance degradation on some production servers that previously were part of a SQL 2012 High availability Group. I recently used a small window of opportunity to test the HADRON groups on some of my SQL Servers. Unusua

  • How to delete GP process instance? Update:10-11

    Good day! Am I able to delete an GP process instance? I can stop it by using IGPRuntimeManager.stopProcess, but I need to completly remove it - like it's possible from the GP Administartion page... Are there any undocument features? May be reflection

  • SQL Script in XE Cancels during Execution without returning any error(s) Update:11-30

    Hi all; I'm running a SQL script with a drop table and create table statement along with several hundred insert statements to load data into this table in a Oracle 10g XE database. There's a total of 213 SQL command lines in the script. (1 Drop Tbl/1

  • Delete oimGroup membership of the oim user using Script (oim 9.1). Update:10-11

    Hi All, I want to remove oim users' particular oim group membership, Is there any problem, if I use the following script to delete user group information from USg table? delete from usg where usr_key in (select usr_key from usr where usr_login in ('x

  • Unable to upload sql scripts in oracle database express edition 10g Update:10-11

    Hi! To start, I inform you that I am beginner with Oracle. I installed Oracle 10g Express Edition on my Ubuntu 9.10 like this: :~$ dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb :~$ /etc/init.d/oracle-xe configure and I keep default value. Then I

  • Inserting sql scripts in Oracle Warehouse Builder 10g Update:11-30

    Dear all, Can anyone please tell me if we can use a process flow to insert scripts in OWB 10g.. If so, how can i do it?? I am having a problem to insert sql scripts in OWB 10g r2. Infact, i have to write a script and insert it in OWB to populate data