Clarity PPM

Expand all | Collapse all

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

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

    Posted 01-24-2011 02:53 PM
    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


  • 2.  RE: [CA Clarity][Oracle JDBC Driver]Connection reset by peer: socket write

    Posted 01-28-2011 11:17 AM
    Hi,

    Was there any schedule shutdown or abnormal shutdown on your database server.

    Best Regards,
    Dhruvin


  • 3.  RE: [CA Clarity][Oracle JDBC Driver]Connection reset by peer: socket write

    Posted 03-30-2011 09:41 AM
    Hello Mustafa,

    have you managed to solve this problem?
    I'm facing the same error.

    Version/Build 12.1.0.5840


  • 4.  Re: [CA Clarity][Oracle JDBC Driver]Connection reset by peer: socket write er

    Posted 12-04-2016 11:08 PM

    Hi,

    I'm facing the same error and this is an production system too.

    How to solve the problem?

    Thanks in advance.



  • 5.  Re: [CA Clarity][Oracle JDBC Driver]Connection reset by peer: socket write er

    Posted 12-05-2016 02:05 AM

    This post seems to be 6 year old. Can you please post a new thread.