Preparing Project For FIN 5.0
Prior to migrating, we want to prepare the project and make sure we're ready to start the migration process as smoothly as possible. There are several things to go through and complete below.
1) Syncing Point and History Time Zones
First, the user will have to upload the trio file called finRewriteHisTzSync. After downloading the file, the user will then go to Legacy Folio and select Import to upload the trio file.
The finRewriteHisTzSync trio file contains the following:
- func - finRewriteHisTzSync
- func - finRewriteHisTzSyncCommit
- job - progress (this appears in the job app under log > "by progress" and/or "by status" > doneOk once its done if the finRewriteHisTzSync() has been executed)
Once uploaded, the user must confirm that the site timezones are set correctly. Then run this func in Legacy Folio finRewriteHisTzSync() that will then sync all the points and histories with the correct time zones in case there are any mismatches.
2) Removing Orphan Records
Then the user needs to run the Remove Orphan Records tool to make sure there are no orphan records floating around in the database.
3) Removing Duplicate Extensions
The user will want to remove any duplicate extensions if they exist. Do this only when you can restart the FIN Stack service after executing the below.
- Go to legacy folio and query for "ext"
- Then you can sort by 'ext' column to see if there are any duplicates
- If there are duplicates, select one of each and delete them (only do this if you can restart service after in the next step 4)
- Then you need to empty the trash and restart service. Look at the next step on Emptying Trash.
4) Emptying Trash
The user will have to clear the trash. They will go to Trash tab in Legacy Folio or HTML version and select Empty Trash. Another way is to run "folioEmptyTrash()" in folio and that should also clear it.
5) Compact and Backup
While still in Legacy Folio, the user will also need to compact the database and create a new backup snapshot. Toggle to Snapshots tab in Legacy Folio and select to Compact. Once compacting database is done, create a new snapshot and download it somewhere on the server outside of FIN Stack directory.
6) User Time Zones
Go to the users app and make sure each user has the timezone property configured. If not, configure the user with a timezone.
7) Quick Run Through
Then make a quick run through to make sure everything looks good. Look at a few history trends, graphics, programs, etc to make sure all looks good.
8) Heap Space
The user will want to take a note of their current Heap Space if it was modified. If it was never modified, then no need to check it. If it has been modified to something other than 512, the user will need to make sure that FIN 5 is configured with the same amount of Heap Space otherwise it will fail as it tries to migrate the large database over. Here is a doc on how to change the memory heap.
9) Custom Pods
Last thing is if there are any custom pod(s) being utilized in the project? It can be something custom we made as part of a contract deal or any that your development team might have done. If any are being used, they need to be updated to be compatible in FIN 5.0. It's best to have this done before migrating if its really important to have. It won't break the build, it just won't be visible to use in FIN 5.0 nor migrated over if not updated.
Once the user has done the above, they are ready for the Migration Process.