Discussion

12
Replies
394
Views
Ranesh Bhattacharya (RaneshBh)
Capgemini India
Lead System Architect
Capgemini India
IN
RaneshBh Member since 2006 5 posts
Capgemini India
Posted: April 21, 2016
Last activity: April 6, 2018
Posted: 21 Apr 2016 6:38 EDT
Last activity: 6 Apr 2018 19:26 EDT
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

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.