Discussion

5
Replies
2389
Views
KannanS6 Member since 2013 1 post
GE
Posted: 5 years ago
Last activity: 5 years 3 months ago
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 11.2.0.4

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

 

 

--------

 

Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn