Skip to main content

Support Article

Migrate.bat fails with Java I/O error

SA-21645

Summary



While updating from 7.1.9 to 7.2 using command line, the migrate.bat script fails with an error.


Error Messages



[java] An I/O error occurred while sending to the backend.
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:412)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:1099)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:603)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:258)
[java]
[java] PegaBulkMover:: SQLException loading Database.
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:1116)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:603)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:258)
[java]

BUILD FAILED
C:\...\115042_Pega72UPDATE\scripts\migrateSystem.xml:644: The following error occurred while executing this line:
C:\...\115042_Pega72UPDATE\scripts\migrateSystem.xml:39: Java returned: 8


Steps to Reproduce



1. Update migrate.properties to move the rules from existing rules schema to newly created rules schema.
2. Run Migrate.bat.


Root Cause



A defect or configuration issue in the operating environment caused this issue. This error indicates a java I/O issue between the database and where the script is being run from. As an example, a firewall can cause an issue like this.

Resolution



The migrate script will need to be run again, preferably from the server that hosts the DB to limit network latency and prevent similar types of issues.

 

Suggest Edit

Published April 1, 2016 - Updated October 8, 2020

Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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