Extract and Reload of entities/trees to fix corruption
Hi there,
Performing an extract and reload with clear entities is one of the fixes to a corrupted db, depending on how the database was corrupted; however when entity members were deleted manually, obviously there will be empty index numbers in between without a member. As a consequence, BOARD reassigns the empty index to the members coming in during reload. On this example, only extract and reload with clear on entities is the only solution. Only clearing the cubes did not help.
Are there other techniques to fix the corrupted database that avoids Extract and Reload with clear on Entities?
Thanks,
Paola
Answers
-
Hi Paola,
it's allways depending to the kind of corruption.
In some cases it can help to delete all Relationships and create those from scratch, in other cases it might be helpful to change the cube structure (of some cubes) to force board to use a new sparsity unique id.
Unfortunetly there isnt a receipt with steps to do, cause different root causes need different solution strategies
regard
Björn
3 -
You could map all entities used in selections on reports and procedures, then carefully try to reconstruct the missing indices on each of them, restoring the right order in the csv file extracted. This way you could reload the correct positions and avoid selection problems.
But it's a mess anyway... the only approach is NOT to delete manually single items, it shouldn' be possible even via admin entity panel!!
1
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 325 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 192 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP