Clarity

Expand all | Collapse all

Wich process causing this error ?

Jump to Best Answer
  • 1.  Wich process causing this error ?

    Posted 06-03-2016 04:34 PM

    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



  • 2.  Re: Wich process causing this error ?

    Posted 06-03-2016 05:56 PM

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



  • 3.  Re: Wich process causing this error ?

    Broadcom Employee
    Posted 06-03-2016 06:03 PM

    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



  • 4.  Re: Wich process causing this error ?
    Best Answer

    Broadcom Employee
    Posted 06-03-2016 06:06 PM

    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



  • 5.  Re: Wich process causing this error ?

    Former Employee
    Posted 06-07-2016 06:41 PM

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



  • 6.  Re: Wich process causing this error ?

    Posted 06-15-2016 09:56 AM

    Thanks all!



  • 7.  Re: Wich process causing this error ?

    Posted 09-26-2016 04:56 PM

    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.



  • 8.  Re: Wich process causing this error ?

    Broadcom Employee
    Posted 09-26-2016 06:12 PM

    This is a known bug in 14.3 version CLRT-81085 



  • 9.  Re: Wich process causing this error ?

    Posted 09-26-2016 07:50 PM

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



  • 10.  Re: Wich process causing this error ?

    Broadcom Employee
    Posted 09-26-2016 08:01 PM

    Hi Neil,

     

    Yes its benign but does flood the logs  

     

    Regards

    Suman Pramanik



  • 11.  Re: Wich process causing this error ?

    Posted 09-26-2016 08:07 PM

    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



  • 12.  Re: Wich process causing this error ?

    Posted 04-07-2017 01:38 AM

    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



  • 13.  Re: Wich process causing this error ?

    Posted 09-27-2016 08:48 AM

    Hi Suman,

     

    Do you have the link to descripton of this bug ?

     

    Thanks.