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.
Please try the if any of the below options resolve the issue.
1) PR4_RULE_FILE table contains RULE-FILE-BINARY, RULE-FILE-TEXT, RULE-FILE-FORM etc type of class instances. Check if there is any huge number of same files are there in multiple rulesets and try to skim those rulesets and clean up the lower version RULE-FILE instances from this table.
2) Since it failed exactly while after importing 10K records, looks like there might be some threshold. Please verify if there is any application specific RULE-FILE-* instances created and see how to minimize them below 10K during migration .
Dhev, do we have limitation while loading "pr4_rule_file"? after removing unwanted stuff from table, it has been migrated. also i feel migrate script need few more logging details, non-db exception like above is difficult troubleshoot.
I don't think there is any limitation in the number of rows of the table. We had a project with more than 120K rows successfully migrate the pr4_rule_file table by the scripts without any issues. The limitation may be in the BLOB size as we had plenty of large documents attached in the Application, Use Cases, Requirement rule instances.