AnsweredAssumed Answered

[CA Clarity][Oracle JDBC Driver]Connection reset by peer: socket write er

Question asked by mustafa.sakli on Jan 24, 2011
Latest reply on Dec 5, 2016 by Suman Pramanik
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

Outcomes