Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Kannan Saravanan (KannanS6)
GE

GE
IN
KannanS6 Member since 2013 1 post
GE
Posted: Jul 20, 2015
Last activity: Jul 21, 2015
Posted: 20 Jul 2015 6:49 EDT
Last activity: 21 Jul 2015 1:04 EDT
Closed

DB Error - No more data to read from socket during 7.1.7 installation

The installation fails most of the times at this step due to DB error as given below -  java.sql.SQLRecoverableException: No more data to read from socket

We had done this before in the same environment but now it fails consistently 4 times at the step  V6 archive - Started import of application bundle component pr4_rule_07.10.01.zip (58 of 83)...out 83 zip

 

1) Any inputs to the avoid this error or there any time out settings to be set for jdbc explicitly in the scripts?

Environment: Oracle Proprietary information hidden

ojdbc7.jar 

------------

[java] 2015-07-17 11:47:58,482 [                main] [          ] [                    ] (         internal.util.MoveLog) INFO    - Operation Status: Completed import of application bundle component pr4_rule_OtherTables_07.10.01.zip (57 of 83).

     [java] 2015-07-17 11:47:58,482 [                main] [          ] [                    ] (         internal.util.MoveLog) INFO    -      Imported 57 of 83 archives (68.67%) 18:53 minutes remaining
     [java] 2015-07-17 11:47:58,485 [                main] [          ] [                    ] (         internal.util.MoveLog) INFO    - Operation Status: Started import of application bundle component pr4_rule_07.10.01.zip (58 of 83)...
     [java] 2015-07-17 11:47:58,487 [                main] [          ] [                    ] (y.internal.PRRuleMgmtUtilsImpl) INFO    - pr4_rule_07.10.01.zip is v6 Archive
     [java] Caught SQLException while reading prprivate.jar!com/pega/pegarules/deploy/internal/util/OptimizationCandidateListImpl$CandidateImpl.class
     [java] java.sql.SQLRecoverableException: No more data to read from socket
     [java]     at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:453)
     [java]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:390)
     [java]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
     [java]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
     [java]     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:929)
     [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
     [java]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
     [java]     at com.pega.pegarules.configdbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:99)
     

------------

Tried the resume.sh script to start from where the installation left but that too failed as below

2) Is this resume.sh script supposed to start from where the last installation was left or failed due to timeout or network issues etc?

3) Should we always do the manual cleanup and restart from beginining everytime it fails 

4) Are there any out of box scripts to wipe out the data from the split schema tables or anything generated under the schema/generated/oracledate that should be run to wipe the data or objects?

 

-----

     [java] 2015-07-17 07:53:02,449 [                main] [          ] [                    ] (rnal.archive.ApplicationBundle) INFO    - Skipping archive 'pr4_rule_OtherTables_07.10.01.zip' (to resume on 'pr4_rule_07.10.01.zip')
     [java] 2015-07-17 07:53:02,449 [                main] [          ] [                    ] (         internal.util.MoveLog) INFO    -      pr4_rule_OtherTables_07.10.01.zip : Imported already
     [java] 2015-07-17 07:53:02,449 [                main] [          ] [                    ] (rnal.archive.ApplicationBundle) INFO    - Resuming import on 'pr4_rule_07.10.01.zip')
     [java] 2015-07-17 07:53:02,449 [                main] [          ] [                    ] (rnal.archive.ApplicationBundle) INFO    - Moving resume step to 'pr4_rule_07.10.01.zip')
     [java] 2015-07-17 07:53:02,457 [                main] [          ] [                    ] (         internal.util.MoveLog) INFO    - Operation Status: Started import of application bundle component pr4_rule_07.10.01.zip (58 of 83)...
     [java] 2015-07-17 07:53:02,458 [                main] [          ] [                    ] (y.internal.PRRuleMgmtUtilsImpl) INFO    - pr4_rule_07.10.01.zip is v6 Archive
     [java] 2015-07-17 07:53:10,551 [                main] [          ] [                    ] (rnal.archive.ApplicationBundle) INFO    - Importing 58 of 83 : pr4_rule_07.10.01.zip (Upgrade Mode)
     [java] 2015-07-17 07:53:10,585 [                main] [          ] [                    ] (      internal.mgmt.EngineImpl) INFO    - PegaRULES Embedded Edition 7.10 (ML7)
     [java] 2015-07-17 07:53:10,585 [                main] [          ] [                    ] (      internal.mgmt.EngineImpl) INFO    - coreAssemblyCached_717_644: 2014-11-26 14.24 EST
     [java] 2015-07-17 07:53:10,585 [                main] [          ] [                    ] (      internal.mgmt.EngineImpl) INFO    - Now starting the PegaRULES Embedded Environment...
     [java] 2015-07-17 07:53:10,609 [                main] [          ] [                    ] (      etier.impl.EngineStartup) INFO    - JVM Information:
     [java] 2015-07-17 07:53:10,609 [                main] [          ] [                    ] (      etier.impl.EngineStartup) INFO    -     Vendor: Oracle Corporation, JVM version: 1.7.0_79
     [java] 2015-07-17 07:53:10,609 [                main] [          ] [                    ] (      etier.impl.EngineStartup) INFO    -     VM Name: Java HotSpot(TM) 64-Bit Server VM(build 1.7.0_79-b15)
     [java] 2015-07-17 07:53:10,609 [                main] [          ] [                    ] (      etier.impl.EngineStartup) INFO    - Host OS Information:
     [java] 2015-07-17 07:53:10,609 [                main] [          ] [                    ] (      etier.impl.EngineStartup) INFO    -     OS: Linux, version: 2.6.18-348.18.1.el5
     [java] 2015-07-17 07:53:10,609 [                main] [          ] [                    ] (      etier.impl.EngineStartup) INFO    -     Architecture: amd64
     [java] 2015-07-17 07:53:10,609 [                main] [          ] [                    ] (      etier.impl.EngineStartup) INFO    - PegaRULES Enterprise Tier 7.10 (ML7)

     [java] 2015-07-17 07:54:57,996 [0758v01.cloud.ge.com] [          ] [                    ] (bi.DeclarativeCacheManagerImpl) INFO    - Setting EnabledGlobalDeclarativeCachePreLoad to NONE as minimal startup is enabled.
     [java] 2015-07-17 07:54:59,815 [0758v01.cloud.ge.com] [          ] [                    ] (      etier.impl.EngineStartup) ERROR   - PegaRULES initialization failed. Server: pwnld0758v01.cloud.ge.com
     [java] com.pega.pegarules.pub.context.InitializationFailedError: PRNodeImpl init failed
     [java]     at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:392)
     [java]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.getThreadAndInitialize(PRSessionProviderImpl.java:1905)
     [java]     at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineStartup.initEngine(EngineStartup.java:657)
     [java]     at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:165)
     [java]     at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.doStartup(EngineImpl.java:138)
     [java]     at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngineImpl(EngineImpl.java:240)
     [java]     at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngine(EngineImpl.java:119)
     [java]     at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngine(EngineImpl.java:112)
     [java]     at com.pega.pegarules.deploy.internal.archive.ParUtilsImpl.ensureEngineStarted(ParUtilsImpl.java:273)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentRunner.<init>(DeploymentRunner.java:76)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentUtility.runMethodWithRequestor(DeploymentUtility.java:86)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentUtility.runMethodWithRequestor(DeploymentUtility.java:77)
     [java]     at com.pega.pegarules.deploy.internal.util.ImportImpl.runWithRequestor(ImportImpl.java:2747)
     [java]     at com.pega.pegarules.deploy.internal.util.ImportImpl.importArchive(ImportImpl.java:1280)
     [java]     at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1524)
     [java]     at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:645)
     [java]     at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:278)
     [java]     at com.pega.pegarules.deploy.external.util.Application.main(Application.java:459)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java]     at java.lang.reflect.Method.invoke(Method.java:606)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)
     [java]     at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)
     [java]     at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)
     [java]     at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
     [java] Caused by: com.pega.pegarules.pub.context.PRSecurityException: Unable to construct authorization core due to authorization failure
     [java]     at com.pega.pegarules.session.internal.authorization.SessionAuthorization.<init>(SessionAuthorization.java:245)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRRequestorBase.allocateSessionAuthorization(PRRequestorBase.java:537)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRRequestorImpl.allocateSessionAuthorization(PRRequestorImpl.java:2009)
     [java]     at com.pega.pegarules.session.internal.authorization.Authorization.reset(Authorization.java:432)
     [java]     at com.pega.pegarules.session.internal.authorization.Authorization.reset(Authorization.java:381)
     [java]     at com.pega.pegarules.session.internal.authorization.Authorization.onBeforeThreadUse(Authorization.java:1624)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.ThreadPassivation.configureThreadImpl(ThreadPassivation.java:316)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRThreadBase.configureThread(PRThreadBase.java:176)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.<init>(PRThreadImpl.java:131)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.acquire(PRThreadImpl.java:146)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.RequestorThreadSync.getOrCreateThread(RequestorThreadSync.java:175)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.RequestorThreadSync.getOrCreateThread(RequestorThreadSync.java:162)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.RequestorThreadSync.getOrCreateThread(RequestorThreadSync.java:158)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.RequestorPassivation.configureRequestorImpl(RequestorPassivation.java:477)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRRequestorBase.configureRequestor(PRRequestorBase.java:480)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRRequestorImpl.<init>(PRRequestorImpl.java:299)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRRequestorImpl.acquire(PRRequestorImpl.java:323)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.MultiThreadRequestorFactory.acquire(MultiThreadRequestorFactory.java:61)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.NodeRequestorMgt.createRequestorImpl(NodeRequestorMgt.java:1476)
     [java]     at com.pega.pegarules.session.internal.mgmt.base.NodeRequestorMgt.createRequestorImpl(NodeRequestorMgt.java:1456)
     [java]     at com.pega.pegarules.session.internal.mgmt.PRNodeImpl.initializeSystem(PRNodeImpl.java:773)
     [java]     at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:371)
     [java]     ... 26 more
     [java] Caused by: com.pega.pegarules.pub.context.InvalidConfigurationException: Data-Admin-Requestor instance "prpc!BATCH" not found
     [java] From: (B7A221B135982DD76221C1E77DC4F5CB7) 
     [java]     at com.pega.pegarules.session.internal.authorization.SessionAuthorization.reset(SessionAuthorization.java:446)
     [java]     at com.pega.pegarules.session.internal.authorization.SessionAuthorization.<init>(SessionAuthorization.java:241)
     [java]     ... 47 more

 

 

--------

 

To see attachments, please log in.
Installation and Deployment

Posted: 9 years ago
Posted: 20 Jul 2015 12:45 EDT
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

could you please check the database table mapping for history classes.

If it is PR_HISTORY then update to PC_HISTORY_WORK & share your observations

To see attachments, please log in.
Posted: 9 years ago
Posted: 20 Jul 2015 12:55 EDT
Veera Gangababu Gollapalli (Gangababu)
PEGA
Principal Technical Solutions Engineer
PEG
IN

Can you please check the jdbc driver and re-run the installation again. It would always recommended to clean schema before re-running it. You can drop statements in scripts folder of distribution media.

Please take a look into the below article.

http://www.oracleracexpert.com/2013/02/java-sql-exception-no-more-data-to-read.html

 

To see attachments, please log in.
Posted: 9 years ago
Posted: 20 Jul 2015 16:04 EDT
Kannan Saravanan (KannanS6)
GE

GE
IN

sahup1 and gollg thanks for your responses but they are never close to the RCA, I believe I did mentioned that this is Linux 5.9, Split schema, JDK 1.7, Oracle Proprietary information hidden and driver is ojdbc7.jar.

Any one else had this issues or other experts have any comments?

To see attachments, please log in.
Posted: 9 years ago
Posted: 20 Jul 2015 22:59 EDT
Vamshi Krishna (VamshiKassety)
Services Australia
Vamshi Krishna
Services Australia
AU

I am not a expert with Databases and havent seen this issue any time before, by googling I found following query to be executed

 

alter session set “_optimizer_join_elimination_enabled”=false;

 

Also, Some other posts suggested downgrading JDK to 6 from 7 resolved the issue, have a look

http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error

 

Try and let us knnow if any of the above works

 

Vamshi

 

To see attachments, please log in.
Posted: 9 years ago
Posted: 21 Jul 2015 1:04 EDT
Veera Gangababu Gollapalli (Gangababu)
PEGA
Principal Technical Solutions Engineer
PEG
IN

Can you run the installation from command line and provide the minimum and maximum heap space. Incase if memory is not enough while running installation.

 >> Java –jar PRPC_Setup.jar -xms:3072m -xmx:4096m

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice