Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Unexpected packet error during 2nd migration step

SA-31628

Summary



Receiving an IO Error: Unexpected packet while running the Migrate.bat file.


Error Messages



[java] Wed Dec 14 19:47:18 EST 2016 (INFO): PegaBulkMover: 181000 of 181333 dumped
[java] Wed Dec 14 19:47:18 EST 2016 (INFO): PegaBulkMover: 181333 of 181333 dumped
[java] Wed Dec 14 19:47:18 EST 2016 (INFO):
[java] Wed Dec 14 19:47:18 EST 2016 (INFO): PegaBulkMover: Exported 181333 Rows for table PR_INDEX_WARNINGS requiring 114372 KB of space.
[java] Wed Dec 14 19:47:18 EST 2016 (INFO): PegaBulkMover: completed
[java] Wed Dec 14 19:47:18 EST 2016 (INFO):
[java] Wed Dec 14 19:47:18 EST 2016 (INFO): Database Tables dumped using 730 MB space.
[java] Wed Dec 14 19:47:18 EST 2016 (INFO):
[java] Wed Dec 14 19:47:18 EST 2016 (INFO): Processed 7 of 69 table(s)
[java] Wed Dec 14 19:47:19 EST 2016 (INFO): Rows in PR4_RULE to Dump 269640
[java] Wed Dec 14 19:47:19 EST 2016 (INFO): Fetch Data Count: 100
[java] Wed Dec 14 19:47:19 EST 2016 (INFO): Number of Columns per Row: 147

...
[java] Wed Dec 14 19:47:26 EST 2016 (INFO): PegaBulkMover: 1000 of 269640 dumped
...

[java] Wed Dec 14 19:59:37 EST 2016 (INFO): PegaBulkMover: 22000 of 269640 dumped
[java] Wed Dec 14 20:00:37 EST 2016 (INFO): PegaBulkMover: 23000 of 269640 dumped
[java] Wed Dec 14 20:01:48 EST 2016 (INFO): PegaBulkMover: 24000 of 269640 dumped
[java] Wed Dec 14 20:02:03 EST 2016 (INFO): Encountered exception during processing!
[java] IO Error: Unexpected packet
[java] at oracle.jdbc.driver.T4CConnection.getBytes(T4CConnection.java:3644)
[java] at oracle.sql.BLOB.getBytes(BLOB.java:552)
[java] at oracle.sql.BLOB.getBytes(BLOB.java:309)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.dumpDatabaseTable(PegaBulkMover.java:900)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:740)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:366)
[java]
[java] PegaBulkMover:: SQLException querying Database on column index 130
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.dumpDatabaseTable(PegaBulkMover.java:992)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:740)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:366)
[java]

BUILD FAILED
e:\Pega_Installs\115290_Pega722\scripts\migrateSystem.xml:608: The following error occurred while executing this line:
e:\Pega_Installs\115290_Pega722\scripts\migrateSystem.xml:39: Java returned: 8

Total time: 32 minutes 2 seconds
Exiting with Error


Steps to Reproduce



Execute migrate.bat file.


Root Cause



A defect or configuration issue in the operating environment:

The 11.2.0.1.0 version of the ORACLE JDBC driver is the root cause.

Resolution



Make the following change to the operating environment:
​ 
Upgrade to ORACLE JDBC
 driver 11.2.0.3.0 or later and rerun migrate.bat.

 

Suggest Edit

Published December 26, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us