Wich process causing this error ?

[Anon Anon]

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

[Deactivated User]

Can you identify it in Administration - Processes - Initiated as the one having errored out?

[Jeanne Gaskill]

Hi Mauricio,

 

First of all if this is a one-time error, it will be difficult, if not impossible to chase back to the exact process causing this error.  However, if you see this fairly often, you could turn on the following debugs:

 

com.niku.bpm.engine

com.niku.bpm.expr.omp

 

You should be able to use the thread names to follow what is happening to the process.  CA PPM Support can also help you with interpreting the logs.

 

There is a chance that you will need a third debug to help decipher this issue as well since the problem is occurring in the event manager threads.  But based on the error, I think the first two debugs will give you enough information to chase back to the process instance id and or the step instance id of the process causing this issue.

 

Don't forget to remove these debugs when you are done since they will add a lot of unnecessary clutter to your logs with information that is only needed under certain situations.  It will also make it more difficult to see problems the errors and fatal errors that are most important when you do face issues with your bg.

 

If you are not comfortable with adding and removing debugs or with reading logs of this type, please open a case with support and we will be happy to help you.

 

Sincerely yours,

 

Jeanne Gaskill

[Jeanne Gaskill]

Martti's suggestion is also a good one.  Look for errors in the Initiated Processes log on the same date and time as the error in the log.

 

But if you can't find the error there, the debugs are probably your best bet.

 

Jeanne

[System]

Hi Mauricio - Did one of the responses help answer your question? If so please mark as Correct Answer. Thanks!

[Anon Anon]

Thanks all!

[Neil Goodwin]

We are getting this in our BG log constantly after upgrade from 14.3 patch 3 to 14.3 patch 8.  Has anyone determined the cause?  We are also having gel processed failed post patch 8 with a generic "unable to update" error.

[Suman Pramanik]

This is a known bug in 14.3 version CLRT-81085 

[Neil Goodwin]

Great thanks Suman. Support sent me the defect info and as expected it is benign.

[Suman Pramanik]

Hi Neil,

 

Yes its benign but does flood the logs  

 

Regards

Suman Pramanik

[Neil Goodwin]

Yes, it does flood the logs for sure.

 

Regards,

Neil Goodwin

Sabre | Product Lifecycle Management | Corporate IT

Office: 682-605-6145 | Cell: 214-490-9914

[Georgy]

Hi SumanPramanik,

 

We face the same issue after upgrade to v14.3. Thanks for informing about the bug number above. But as it is flooding the BG logs a lottttt, is there any way we can suppress these WARN/ERROR messages by some appropriate logging configuration in CSA, without the danger of suppressing the really needed ones?  Any ideas?

 

Regards,

Georgy

[Anon Anon]

Hi Suman,

 

Do you have the link to descripton of this bug ?

 

Thanks.