IT Process Automation

Expand all | Collapse all

Seeing errors in the log when doing a simple select object operation.

Jump to Best Answer
  • 1.  Seeing errors in the log when doing a simple select object operation.

    Posted 06-21-2016 08:39 AM

    I've been seeing a lot of these errors in the log when doing a simple SDM select object operation. The operator appears to be configured correctly and the operation completes successfully but under the hood there is definitely something not happy here. Is there anything that can be done about this?

     

    Many thanks!

     

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [cr] failed - ReferenceError: "cr" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [ref_num] failed - ReferenceError: "ref_num" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.combo_name] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [summary] failed - ReferenceError: "summary" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [category.sym] failed - ReferenceError: "category" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [status.sym] failed - ReferenceError: "status" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [description] failed - ReferenceError: "description" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [log_agent.combo_name] failed - ReferenceError: "log_agent" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.email_address] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.supervisor_contact_uuid] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.supervisor_contact_uuid.last_name] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.supervisor_contact_uuid.first_name] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.supervisor_contact_uuid.email_address] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [group.supervisor_contact_uuid] failed - ReferenceError: "group" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [group.supervisor_contact_uuid.first_name] failed - ReferenceError: "group" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [group.supervisor_contact_uuid.last_name] failed - ReferenceError: "group" is not defined. (#2)

    2016-06-21 08:13:15,880 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [group.supervisor_contact_uuid.email_address] failed - ReferenceError: "group" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [group.id] failed - ReferenceError: "group" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.supervisor_contact_uuid.userid] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [group.supervisor_contact_uuid.userid] failed - ReferenceError: "group" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [customer.userid] failed - ReferenceError: "customer" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [zph_justification] failed - ReferenceError: "zph_justification" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [web_url] failed - ReferenceError: "web_url" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [zph_initialrequestdate] failed - ReferenceError: "zph_initialrequestdate" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [zph_developerstestdate] failed - ReferenceError: "zph_developerstestdate" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [zph_comments] failed - ReferenceError: "zph_comments" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [zph_requesttype] failed - ReferenceError: "zph_requesttype" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [priority] failed - ReferenceError: "priority" is not defined. (#2)

    2016-06-21 08:13:15,942 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [8b-a59113cfff8f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [zph_targetproductiondate] failed - ReferenceError: "zph_targetproductiondate" is not defined. (#2)

    2016-06-21 08:13:16,739 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [ae-cb0ba969f61f] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [sid__] failed - ReferenceError: "sid__" is not defined. (#2)

    2016-06-21 08:13:18,442 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [05-8041f6d78ca9] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [sid__] failed - ReferenceError: "sid__" is not defined. (#2)

    2016-06-21 08:13:57,115 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [c4-cff2fd689b92] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [ACK] failed - ReferenceError: "ACK" is not defined. (#2)



  • 2.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-21-2016 08:46 AM

    I should add that leading up to the error I'm seeing the following...

     

    java.lang.NullPointerException

      at com.optinuity.c2o.workflowengine.WorkflowManager.getEvalContext(WorkflowManager.java:3883)

      at com.optinuity.c2o.workflowengine.InterpreterSvcOptUtil.getEvaluationContext(InterpreterSvcOptUtil.java:161)

      at com.optinuity.c2o.workflowengine.InterpreterSvcOptUtil.getEvaluationContext(InterpreterSvcOptUtil.java:139)

      at com.optinuity.c2o.workflowengine.WaitConditionInterpreterSvcOptRunner.run(WaitConditionInterpreterSvcOptRunner.java:176)

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



  • 3.  Re: Seeing errors in the log when doing a simple select object operation.
    Best Answer

    Posted 06-23-2016 08:30 AM

    Hi Joel,

     

    Take a look at the following Knowledge Document:

     

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec612011.aspx

     

    I believe these errors are occurring because of extra values that are filled in somewhere but not in use.  The above is on the JDBC operator and on the wizard screens.  Even if you select one database type, PAM still evaluates all the other values under each database type.  Make sure to remove any extra info in the operator that is not in use and that should get rid of these errors.



  • 4.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-23-2016 08:50 AM

    I'm a little confused here. I'm not using a direct query to the database as depicted in the KB article but rather one of the out of the box commands provided for PAM/SDM integration which leans itself on a SOAP call.



  • 5.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-23-2016 09:07 AM

    This has me thinking though... We have custom fields that we are using. I'm wondering if we are running into a similar sort of issue because we are requesting custom fields that the out of the box soap operator never accounted for?

     

    Thank you Andrew! I have a trail to follow now.



  • 6.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-23-2016 11:13 AM

    So I disconnected my SDM select operator essentially accepting to throwing the baby out with the bathwater for getting at the information I need and attempted to use a more direct to the metal approach by selecting directly off the server and implemented that approach outlined in the KB article above. In the end this replaces the Soap related errors that I was seeing before with a whole new set of SQL errors in my logs:

     

    See below:

    2016-06-23 11:01:10,761 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [32-ce46224e5e93] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [Server] failed - ReferenceError: "Server" is not defined. (#2)

    2016-06-23 11:02:16,278 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [d6-7ab13c69dbb5] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [Server] failed - ReferenceError: "Server" is not defined. (#2)

    2016-06-23 11:06:55,345 ERROR [com.optinuity.c2o.bean.C2OSimpleValue] [25-a6fd0afad1ad] C2OString.evaluate: exception: com.optinuity.c2o.bean.C2OEvaluationException: Evaluation of [Server] failed - ReferenceError: "Server" is not defined. (#2)



  • 7.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-24-2016 10:13 AM

    Hi Joel,

     

    This is the same issue as referenced in the knowledge doc.  "Server" is a default value for the Hypersonic database type.

     

    Andy



  • 8.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-24-2016 10:19 AM

    Ok, So should I be abandoning using SOAP in PAM altogether for all of my calls to get data off of SDM then to eliminate these errors and use a SQL call now? I must be missing something here.



  • 9.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-24-2016 10:35 AM

    I was just explaining your latest error regarding the "Server" value.

     

    These errors can be ignored so switching the process around should not be necessary.



  • 10.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-24-2016 10:42 AM

    Gotcha, At the heart of the matter is that we have this series of soap calls that we make to assemble some information about the request to make some decisions in how we approach our workflow in PAM. These Soap calls are all generated using the out of the box select object operator not direct SQL communication. These operators are generating the errors per my first comment. My colleague has mentioned that these errors might just be acceptable fall out coming off the operation but at this point I don't have anything to base that assumption off of. Either way at the end of the day I'd like to eliminate all the errors that this process generates prior to going live. Thanks for taking a stab at the matter Andrew. I do appreciate the attention on it.



  • 11.  Re: Seeing errors in the log when doing a simple select object operation.

    Posted 06-28-2016 08:40 AM

    Sure Joel. 

     

    I'm still guessing that there is something that the operator properties has filled in that isn't in use, but that PAM is reporting in the logs anyway. But if the above suggestions have not helped to pinpoint the error messages, it might be worth opening a support issue so we can help you dig into it a little deeper.