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.
Published April 1, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.