AnsweredAssumed Answered

Wich process causing this error ?

Question asked by MauricioLobao4213392 on Jun 3, 2016
Latest reply on Apr 7, 2017 by Georgy N Joseph

Hello all,

How can I identify wich process is causing the bellow error in bg-log ?

Thanks

 

WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Statement Id: omp.dynamic.select-object.map::task:NIKU.ALL:1:prprojectid

WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) SQL statement: SELECT         s0.prid odf_pk, s0.prProjectID AS prprojectid FROM   prtask s0  WHERE (   s0.prid=?  and (exists(select 'x' from (select sec.user_id from cmn_sec_chk_user_r_v0 sec where 1 = 1 and sec.object_id=663 and sec.permission_code='ProjectViewTasks' ) odf_view_all where odf_view_all.user_id = ?) or prtask.prprojectid in (select sec.object_instance_id from cmn_sec_chk_user_v0 sec where 1 = 1 and sec.object_id=663 and sec.permission_code='ProjectViewTasks'  and sec.user_id = ? )))

WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Parameter 1: 5734745

WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Parameter 2: 5002548

WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Parameter 3: 5002548

ERROR 2016-06-03 17:26:15,047 [Event Handler pool-4-thread-8] expr.omp (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) An error occurred when trying to evaluate start condition.

com.niku.bpm.BpmException: com.niku.union.omp.persistence.jdbc.exception.NestedSQLException:  

--- The error occurred while applying a parameter map. 

--- Check the omp.dynamic.select-object.map::task:NIKU.ALL:1:prprojectid-DynamicParameterMap. 

--- Check the statement (query failed). 

--- Cause: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier

 

Caused by: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier

 

        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.createReferencedObjectInfo(OMPExpressionDataService.java:394)

        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.getExprEvalMetaData(OMPExpressionDataService.java:607)

        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionAdapter.getExpressionVariables(OMPExpressionAdapter.java:75)

        at com.niku.odf.exprbuilder.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:158)

        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionEvaluator.evaluateAutoStartCondition(OMPExpressionEvaluator.java:85)

        at com.niku.bpm.engine.exprevaluator.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:125)

        at com.niku.bpm.eventmgr.ObjectEventHandler.processEventToAutoStartProcesses(ObjectEventHandler.java:230)

        at com.niku.bpm.eventmgr.ObjectEventHandler.fireEvent(ObjectEventHandler.java:63)

        at com.niku.bpm.eventmgr.messageserver.BaseEventHandler.fireEvent(BaseEventHandler.java:27)

        at com.niku.bpm.eventmgr.messageserver.BaseEventHandler.run(BaseEventHandler.java:77)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

Caused by: com.niku.union.omp.persistence.jdbc.exception.NestedSQLException:  

--- The error occurred while applying a parameter map. 

--- Check the omp.dynamic.select-object.map::task:NIKU.ALL:1:prprojectid-DynamicParameterMap. 

--- Check the statement (query failed). 

--- Cause: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier

 

Caused by: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier

 

        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:223)

        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:136)

        at com.niku.omp.rt.core.service.engine.core.OMPSqlExecutorDelegate.selectByCriteria(OMPSqlExecutorDelegate.java:853)

        at com.niku.omp.rt.core.service.engine.core.OMPSessionImpl.selectByCriteria(OMPSessionImpl.java:139)

        at com.niku.omp.rt.core.service.engine.core.OMPDbContextImpl.selectByCriteria(OMPDbContextImpl.java:154)

        at com.niku.omp.rt.core.service.controller.AbstractBaseOperation.readInstance(AbstractBaseOperation.java:53)

        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.findReferencedObjectPk(OMPExpressionDataService.java:459)

        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.createReferencedObjectInfo(OMPExpressionDataService.java:287)

        ... 12 more

Caused by: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier

 

        at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)

        at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)

        at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)

        at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)

        at com.ca.clarity.jdbc.oracle.ddal.a(Unknown Source)

        at com.ca.clarity.jdbc.oracle.ddal.a(Unknown Source)

        at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)

        at com.ca.clarity.jdbc.oraclebase.dde3.x(Unknown Source)

        at com.ca.clarity.jdbc.oraclebase.dde3.t(Unknown Source)

        at com.ca.clarity.jdbc.oraclebase.dddz.execute(Unknown Source)

        at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:497)

        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

        at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$1fb861df.execute(<generated>)

        at com.niku.omp.rt.core.service.engine.core.OMPSqlExecutor.executeQuery(OMPSqlExecutor.java:241)

        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:254)

        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:199)

        ... 19 more

WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Statement Id: omp.dynamic.select-object.map::task:NIKU.ALL:1:prprojectidWARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) SQL statement: SELECT         s0.prid odf_pk, s0.prProjectID AS prprojectid FROM   prtask s0  WHERE (   s0.prid=?  and (exists(select 'x' from (select sec.user_id from cmn_sec_chk_user_r_v0 sec where 1 = 1 and sec.object_id=663 and sec.permission_code='ProjectViewTasks' ) odf_view_all where odf_view_all.user_id = ?) or prtask.prprojectid in (select sec.object_instance_id from cmn_sec_chk_user_v0 sec where 1 = 1 and sec.object_id=663 and sec.permission_code='ProjectViewTasks'  and sec.user_id = ? )))WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Parameter 1: 5734745WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Parameter 2: 5002548WARN  2016-06-03 17:26:15,046 [Event Handler pool-4-thread-8] com.niku (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) Parameter 3: 5002548ERROR 2016-06-03 17:26:15,047 [Event Handler pool-4-thread-8] expr.omp (clarity:OI309030:27438943__7931F2C9-2C3B-41CA-A193-8AF82A025642:none) An error occurred when trying to evaluate start condition. com.niku.bpm.BpmException: com.niku.union.omp.persistence.jdbc.exception.NestedSQLException:   --- The error occurred while applying a parameter map.  --- Check the omp.dynamic.select-object.map::task:NIKU.ALL:1:prprojectid-DynamicParameterMap.  --- Check the statement (query failed).  --- Cause: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier
Caused by: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier
        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.createReferencedObjectInfo(OMPExpressionDataService.java:394)        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.getExprEvalMetaData(OMPExpressionDataService.java:607)        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionAdapter.getExpressionVariables(OMPExpressionAdapter.java:75)        at com.niku.odf.exprbuilder.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:158)        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionEvaluator.evaluateAutoStartCondition(OMPExpressionEvaluator.java:85)        at com.niku.bpm.engine.exprevaluator.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:125)        at com.niku.bpm.eventmgr.ObjectEventHandler.processEventToAutoStartProcesses(ObjectEventHandler.java:230)        at com.niku.bpm.eventmgr.ObjectEventHandler.fireEvent(ObjectEventHandler.java:63)        at com.niku.bpm.eventmgr.messageserver.BaseEventHandler.fireEvent(BaseEventHandler.java:27)        at com.niku.bpm.eventmgr.messageserver.BaseEventHandler.run(BaseEventHandler.java:77)        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)        at java.lang.Thread.run(Thread.java:745)Caused by: com.niku.union.omp.persistence.jdbc.exception.NestedSQLException:   --- The error occurred while applying a parameter map.  --- Check the omp.dynamic.select-object.map::task:NIKU.ALL:1:prprojectid-DynamicParameterMap.  --- Check the statement (query failed).  --- Cause: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier
Caused by: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier
        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:223)        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:136)        at com.niku.omp.rt.core.service.engine.core.OMPSqlExecutorDelegate.selectByCriteria(OMPSqlExecutorDelegate.java:853)        at com.niku.omp.rt.core.service.engine.core.OMPSessionImpl.selectByCriteria(OMPSessionImpl.java:139)        at com.niku.omp.rt.core.service.engine.core.OMPDbContextImpl.selectByCriteria(OMPDbContextImpl.java:154)        at com.niku.omp.rt.core.service.controller.AbstractBaseOperation.readInstance(AbstractBaseOperation.java:53)        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.findReferencedObjectPk(OMPExpressionDataService.java:459)        at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionDataService.createReferencedObjectInfo(OMPExpressionDataService.java:287)        ... 12 moreCaused by: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "PRTASK"."PRPROJECTID": invalid identifier
        at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)        at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)        at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)        at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)        at com.ca.clarity.jdbc.oracle.ddal.a(Unknown Source)        at com.ca.clarity.jdbc.oracle.ddal.a(Unknown Source)        at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)        at com.ca.clarity.jdbc.oraclebase.dde3.x(Unknown Source)        at com.ca.clarity.jdbc.oraclebase.dde3.t(Unknown Source)        at com.ca.clarity.jdbc.oraclebase.dddz.execute(Unknown Source)        at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)        at java.lang.reflect.Method.invoke(Method.java:497)        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)        at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$1fb861df.execute(<generated>)        at com.niku.omp.rt.core.service.engine.core.OMPSqlExecutor.executeQuery(OMPSqlExecutor.java:241)        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:254)        at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:199)        ... 19 more

Outcomes