Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"Connection reset by peer: socket write error" error messages in Planning_WebApp.log file

JBM_In_AusMar 18 2015 — edited Mar 20 2015

All,

For some rather obscure reason, we started experiencing database blocking issues out of the blue and the DBA has reported multiple emails generated on the MS SQL Server instance to that effect.

The following are some of the latest entries in our Planning_WebApp.log file on our PLNHOST1 server generated on Fri 13/03/2015 (what are the odds of getting these error messages on Fri the 13th?!?!) at around 02:07AM:

[2015-03-13T02:07:44.727+11:00] [Planning0] [NOTIFICATION] [HSP-04036] [oracle.EPMHSP.sql] [tid: 25] [userId: <anonymous>] [ecid: 00iRuTdpY7xFw00Fzzw0w00001TK0000HO,1:27324] [APP: PLANNING#11.1.2.0] [URI: /HyperionPlanning/SmartView] [SRC_CLASS: com.hyperion.planning.sql.HspSQLImpl] [SRC_METHOD: executeUpdate] An error occurred executing query SQL_DELETE_EXPIRED_EXTERNAL_ACTIONS with parameters [100][[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddo.c(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddn.f(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddn.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.h(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspExtChangeHandler.actionPoller(HspExtChangeHandler.java:126)
at com.hyperion.planning.event.HspExtChangeHandler.run(HspExtChangeHandler.java:58)

]]
[2015-03-13T02:07:44.727+11:00] [Planning0] [ERROR] [HSP-18754] [oracle.EPMHSP.event] [tid: 25] [userId: <anonymous>] [ecid: 00iRuTdpY7xFw00Fzzw0w00001TK0000HO,1:27324] [APP: PLANNING#11.1.2.0] [URI: /HyperionPlanning/SmartView] [SRC_CLASS: com.hyperion.planning.event.HspExtChangeHandler] [SRC_METHOD: actionPoller] An error occurred connecting to the database or recreating connections.[[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddo.c(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddn.f(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddn.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.h(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspExtChangeHandler.actionPoller(HspExtChangeHandler.java:126)
at com.hyperion.planning.event.HspExtChangeHandler.run(HspExtChangeHandler.java:58)

]]
[2015-03-13T02:25:30.491+11:00] [Planning0] [NOTIFICATION] [HSP-04036] [oracle.EPMHSP.sql] [tid: 25] [userId: <anonymous>] [ecid: 00iRuTdpY7xFw00Fzzw0w00001TK0000HO,1:27324] [APP: PLANNING#11.1.2.0] [URI: /HyperionPlanning/SmartView] [SRC_CLASS: com.hyperion.planning.sql.HspSQLImpl] [SRC_METHOD: executeUpdate] An error occurred executing query SQL_DELETE_EXPIRED_EXTERNAL_ACTIONS with parameters [100][[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspExtChangeHandler.actionPoller(HspExtChangeHandler.java:126)
at com.hyperion.planning.event.HspExtChangeHandler.run(HspExtChangeHandler.java:58)

]]
[2015-03-13T02:25:30.491+11:00] [Planning0] [NOTIFICATION] [HSP-04036] [oracle.EPMHSP.sql] [tid: 26] [userId: <anonymous>] [ecid: 00iRuW2l0XKFw00Fzzw0w00001TK0000N8,1:27325] [APP: PLANNING#11.1.2.0] [URI: /HyperionPlanning/SmartView] [SRC_CLASS: com.hyperion.planning.sql.HspSQLImpl] [SRC_METHOD: executeUpdate] An error occurred executing query SQL_DELETE_EXPIRED_EXTERNAL_ACTIONS with parameters [100][[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspExtChangeHandler.actionPoller(HspExtChangeHandler.java:126)
at com.hyperion.planning.event.HspExtChangeHandler.run(HspExtChangeHandler.java:58)

]]
[2015-03-13T02:25:30.491+11:00] [Planning0] [ERROR] [HSP-18754] [oracle.EPMHSP.event] [tid: 25] [userId: <anonymous>] [ecid: 00iRuTdpY7xFw00Fzzw0w00001TK0000HO,1:27324] [APP: PLANNING#11.1.2.0] [URI: /HyperionPlanning/SmartView] [SRC_CLASS: com.hyperion.planning.event.HspExtChangeHandler] [SRC_METHOD: actionPoller] An error occurred connecting to the database or recreating connections.[[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspExtChangeHandler.actionPoller(HspExtChangeHandler.java:126)
at com.hyperion.planning.event.HspExtChangeHandler.run(HspExtChangeHandler.java:58)

]]
[2015-03-13T02:25:30.491+11:00] [Planning0] [ERROR] [HSP-18754] [oracle.EPMHSP.event] [tid: 26] [userId: <anonymous>] [ecid: 00iRuW2l0XKFw00Fzzw0w00001TK0000N8,1:27325] [APP: PLANNING#11.1.2.0] [URI: /HyperionPlanning/SmartView] [SRC_CLASS: com.hyperion.planning.event.HspExtChangeHandler] [SRC_METHOD: actionPoller] An error occurred connecting to the database or recreating connections.[[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspExtChangeHandler.actionPoller(HspExtChangeHandler.java:126)
at com.hyperion.planning.event.HspExtChangeHandler.run(HspExtChangeHandler.java:58)

]]
[2015-03-13T02:25:30.507+11:00] [Planning0] [NOTIFICATION] [HSP-04036] [oracle.EPMHSP.sql] [tid: 27] [userId: <anonymous>] [ecid: 0000KkBmp7YEkJG6yz3j6G1L0FY8000002,0] [APP: PLANNING#11.1.2.0] [SRC_CLASS: com.hyperion.planning.sql.HspSQLImpl] [SRC_METHOD: executeUpdate] An error occurred executing query SQL_SYSDB_DELETE_EXPIRED_EXTERNAL_ACTIONS with parameters [100][[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspSysExtChangeHandler.actionPoller(HspSysExtChangeHandler.java:113)
at com.hyperion.planning.event.HspSysExtChangeHandler.run(HspSysExtChangeHandler.java:54)

]]
[2015-03-13T02:25:30.507+11:00] [Planning0] [ERROR] [HSP-18754] [oracle.EPMHSP.event] [tid: 27] [userId: <anonymous>] [ecid: 0000KkBmp7YEkJG6yz3j6G1L0FY8000002,0] [APP: PLANNING#11.1.2.0] [SRC_CLASS: com.hyperion.planning.event.HspSysExtChangeHandler] [SRC_METHOD: actionPoller] An error occurred connecting to the database or recreating connections.[[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspSysExtChangeHandler.actionPoller(HspSysExtChangeHandler.java:113)
at com.hyperion.planning.event.HspSysExtChangeHandler.run(HspSysExtChangeHandler.java:54)

]]

And then some more entries generated today at around 03:06AM:

[2015-03-18T03:06:19.505+11:00] [Planning0] [NOTIFICATION] [HSP-04036] [oracle.EPMHSP.sql] [tid: 25] [userId: <anonymous>] [ecid: 0000KkajBZOEkJG6yz3j6G1L1xt6000002,0] [APP: PLANNING#11.1.2.0] [SRC_CLASS: com.hyperion.planning.sql.HspSQLImpl] [SRC_METHOD: executeUpdate] An error occurred executing query SQL_SYSDB_DELETE_EXPIRED_EXTERNAL_ACTIONS with parameters [100][[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspSysExtChangeHandler.actionPoller(HspSysExtChangeHandler.java:113)
at com.hyperion.planning.event.HspSysExtChangeHandler.run(HspSysExtChangeHandler.java:54)

]]
[2015-03-18T03:06:19.505+11:00] [Planning0] [ERROR] [HSP-18754] [oracle.EPMHSP.event] [tid: 25] [userId: <anonymous>] [ecid: 0000KkajBZOEkJG6yz3j6G1L1xt6000002,0] [APP: PLANNING#11.1.2.0] [SRC_CLASS: com.hyperion.planning.event.HspSysExtChangeHandler] [SRC_METHOD: actionPoller] An error occurred connecting to the database or recreating connections.[[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Connection reset by peer: socket write error
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddb.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)
at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)
at com.hyperion.planning.event.HspSysExtChangeHandler.actionPoller(HspSysExtChangeHandler.java:113)
at com.hyperion.planning.event.HspSysExtChangeHandler.run(HspSysExtChangeHandler.java:54)

The closest & most logical explanation I could find for the "Connection reset by peer: socket write error" was contained in the Oracle server connection reset by peer socket write error - Database Administrators Stack Exchange  page. Apparently, this type of error could be caused by network issues, etc.

Worth noting is the following information about our Hyperion environment:

- We have 3 4-core servers (ESSHOST1, PLNHOST1 and FNDHOST1) running MS Windows Server 2008 R2 Enterprise (64-bit) each with 16GB RAM which reside on vmWare;

- Spread across the 3 servers are the various applications making up Oracle Hyperion Planning Plus v11.1.2.3.50x (with the latest patches available as at late Feb 2015 applied for Planning, Essbase, EAS, FR, WA, Foundation, etc);

- Also, we have WebLogic 10.3.6 installed on the FNDHOST1 server;

- Powering the Oracle Hyperion Planning Plus and WebLogic applications is Java v1.6.0_85 installed & configured on all 3 servers;

- MS SQL Server 2008 is our RDBMS and it resides on MS Windows Server 2008 R2 Enterprise (64-bit);

- Various configuration changes have been applied as per the Oracle® EPM Fusion Edition Infrastructure Performance Tuning Guide for v11.1.2.3;

Has anyone ever come across this type of error? If yes, what would your recommendations be to address this issue?

Many thanks in advance.

JBM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2015
Added on Mar 18 2015
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
1 comment
2,991 views