A new Flexera Community experience is coming on November 25th. Click here for more information.
- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Knowledge Base
- :
- Re-index the database when upgrading Flexnet Manager Suite
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
- Article History
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Summary
Re-index the database when upgrading Flexnet Manager SuiteSynopsis
Upgrade Doc suggests re-indexing the database after running the database update script (mgsDatabaseUpdate.exe).1) Can the Reindex script be run on FNMPDatawarehouse and ContentStore database or is it only for IM and FNMP database?
2) Can we proceed with the upgrade if the re-indexing fails at this time. Can the database be re-indexed after the upgrade at a later time?
Discussion
1) ReIndexAll.sql should only be executed on databases that are managed directly by the FNMS product. This was only intended to be executed on IM and FNMP. However, it should not hurt the FNMPDatawarehouse.
Therefore, the ReIndexAll.sql should be able to be executed on FNMPDatawarehouse.
The ReIndexAll.sql should NOT be executed on ContentStore, because ContentStore (or similar naming ones) is the Cognos database and is managed directly by the Cognos product.
2) It should be okay to upgrade if the re-indexing fails. Then it should be okay to re-index after the upgrade at a later time, but only on databases that are managed directly by FNMS, ie IM or FNMP.
Jun 07, 2018 02:09 AM
