Hi,
We have Clarity 12.0.6 on Windows2003+sp1 and Oracle 10g on remote server.
We get an error at some process steps on running process.
We get this error especially after restar of BG services and Run Event-waiting Steps.
There is no any firewall between App and DB.
We've gat these actions.
1.We have opened an issue to ca support, but no solution yet.
2.Disabled firewall between App and DB
3.Updated JDBC drivers.
This is an production system we need urgent help PLEASE !!!
The error log;
BPM-0507: Internal Process Engine Error. Contact your site administrator (An error occurred while evaluating the expression: '( incident.thisIncident.ztac_kgbtyenistatu == lookup("ZTAC_KGBTVAKASTATU", "iptaledildi") )').
------------
com.niku.bpm.BpmException: callPMD - Cannot execute statement: bpm.getObjectsInvolvedInExpression
at com.niku.bpm.engine.persistence.ExprEvalPersistenceUtils.callPMD(ExprEvalPersistenceUtils.java:509)
at com.niku.bpm.engine.persistence.ExprEvalPersistenceUtils.getOdfObjectsInExpr(ExprEvalPersistenceUtils.java:205)
at com.niku.bpm.engine.exprevaluator.ExprEvaluatorDataService.getExprEvalMetaData(ExprEvaluatorDataService.java:92)
at com.niku.odf.exprbuilder.ExpressionEvaluator.getExpressionVariables(ExpressionEvaluator.java:239)
at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionAdapter.getExpressionVariables(OMPExpressionAdapter.java:123)
at com.niku.odf.exprbuilder.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:155)
at com.niku.bpm.engine.exprevaluator.omp.OMPExpressionEvaluator.evaluateStepCondition(OMPExpressionEvaluator.java:175)
at com.niku.bpm.engine.exprevaluator.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:199)
at com.niku.bpm.engine.rules.PostConditionTransitionPipeline.evaluatePostConditions(PostConditionTransitionPipeline.java:199)
at com.niku.bpm.engine.rules.PostConditionTransitionPipeline.execute(PostConditionTransitionPipeline.java:79)
at com.niku.bpm.engine.rules.Pipeline.run(Pipeline.java:221)
Caused by: com.niku.union.persistence.DBConnectionException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Connection reset by peer: socket write error
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1818)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2334)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:701)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:610)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)
at com.niku.bpm.engine.persistence.ExprEvalPersistenceUtils.callPMD(ExprEvalPersistenceUtils.java:497)
... 10 more
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Connection reset by peer: socket write error
at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ca.clarity.jdbc.oracle.net8.OracleNet8NSPTDAPacket.appendTTISubPacket(Unknown Source)
at com.ca.clarity.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$f4cfba5a.execute(<generated>)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2313)
... 15 more