Discussion

12
Replies
389
Views
RaneshBh Member since 2006 5 posts
Capgemini India
Posted: 4 years ago
Last activity: 3 years 5 months ago
Closed

Caught exception "PegaBulkMover:: SQLException loading database" while running migrate.sh

while running the migrat.sh scripts to migrate rule tables to the new schema, we got the below error while inserting data in the last table. All other tables have been migrated successfully in the new schema and have all the data.

Thu Apr 21 04:27:33 EDT 2016 (INFO): Column Index: 44 Name: PZINSKEY 12 VARCHAR2 Not Nullable 255

Thu Apr 21 04:27:33 EDT 2016 (INFO): Column Index: 45 Name: PZPVSTREAM 2004 BLOB Nullable 4000

Thu Apr 21 04:27:33 EDT 2016 (INFO): PegamoveData: SQL Statement Generated: Insert into PEGA_RULES.PR4_RULE_FILE (PXCREATEDATETIME, PXCREATEOPNAME, PXCREATEOPERATOR, PXCREATESYSTEMID, PXHOSTID, PXINSID, PXINSNAME, PXINSTANCELOCKEDBY, PXINSTANCELOCKEDDATETIME, PXINSTANCELOCKEDKEY, PXOBJCLASS, PXUPDATEDATETIME, PXUPDATEOPNAME, PXUPDATEOPERATOR, PXUPDATESYSTEMID, PYAPPLICATIONNAME, PYBASERULE, PYBUNDLETYPE, PYBUNDLENAME, PYCIRCUMSTANCEDATEPROP, PYCIRCUMSTANCEDATE, PYCIRCUMSTANCEPROP, PYCIRCUMSTANCETYPE, PYCIRCUMSTANCEVAL, PYCLASSNAME, PYFILENAME, PYFILETYPE, PYFILECHECKSUM, PYINTERFACE, PYLABEL, PYMETHODSTATUS, PYRELATIVEPATH, PYRULEAVAILABLE, PYRULEENDS, PYRULENAME, PYRULESET, PYRULESETVERSION, PZRULESETVERSIONMAJOR, PZRULESETVERSIONMINOR, PZRULESETVERSIONPATCH, PYRULESTARTS, PYSORTDATECIRCUMWITHINRSMAJOR, PZIMPLEMENTATIONKEY, PZINSKEY, PZPVSTREAM) Values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Thu Apr 21 04:27:36 EDT 2016 (INFO): PegaBulkMover: Loaded 1000 out of 12132 Rows

Thu Apr 21 04:27:39 EDT 2016 (INFO): PegaBulkMover: Loaded 2000 out of 12132 Rows

Thu Apr 21 04:27:43 EDT 2016 (INFO): PegaBulkMover: Loaded 3000 out of 12132 Rows

Thu Apr 21 04:27:47 EDT 2016 (INFO): PegaBulkMover: Loaded 4000 out of 12132 Rows

Thu Apr 21 04:27:52 EDT 2016 (INFO): PegaBulkMover: Loaded 5000 out of 12132 Rows

Thu Apr 21 04:27:57 EDT 2016 (INFO): PegaBulkMover: Loaded 6000 out of 12132 Rows

Thu Apr 21 04:28:01 EDT 2016 (INFO): PegaBulkMover: Loaded 7000 out of 12132 Rows

Thu Apr 21 04:28:07 EDT 2016 (INFO): PegaBulkMover: Loaded 8000 out of 12132 Rows

Thu Apr 21 04:28:12 EDT 2016 (INFO): PegaBulkMover: Loaded 9000 out of 12132 Rows

Thu Apr 21 04:28:19 EDT 2016 (INFO): PegaBulkMover: Loaded 10000 out of 12132 Rows

Thu Apr 21 04:28:21 EDT 2016 (INFO): Encountered exception during processing!

null

at java.nio.Buffer.nextPutIndex(Buffer.java:513)

at java.nio.DirectByteBuffer.put(DirectByteBuffer.java:291)

at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:921)

at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:567)

at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:222)

PegaBulkMover:: SQLException loading Database.

at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:1080)

at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:567)

at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:222)

We are upgrading from 6.2 sp1 to 7.1.9 in tomcat and oracle 11g

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn