Upgrade script from iDash 11.4 to 12.0.01.01 takes a very long time to complete.
Article ID: 69723
Updated On:
Products
Issue/Introduction
The iDash installation script takes a very long time to complete the upgrade of iDash from 11.4 to 12.0.01.01.
Resolution
To avoid such a tedious update of the iDash DB event table and save time, it is recommended to back up the event table, delete all rows in the table, perform the upgrade and then repopulate the table from the back up. Your DBA can use native DB tools to perform the back up and reinsertion of the data.
This will save a lot of time as the upgrade will simply drop the obsolete column and create the new one without having to update any rows in the table.
Additional Information
The upgrade performs SQL commands that updates the iDash DB event table. It drops the pid table and creates a new jc_pid table.
As is the nature of SQL commands of this type, this operation is performed row by row. If there are millions of rows in the event table, this operation could take several hours.
Feedback
