
#1
Posted 03 May 2018 - 07:15 PM
#2
Posted 03 May 2018 - 09:41 PM
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#3
Posted 05 June 2018 - 01:56 PM
Sorry TomH, seen your note, but then things at home caused need to drop this problem for a while. When I got back to it, I'd forgot your offer... I'm 75?
Problem seems solved: RM for some reason multiplies any notes attached to any place location. In my 15 month old backup, my original place location note of 4.3 pages (MS Word) had become 124 pages, having been multiplied 22 times. When I clicked on the problematic location in the Place List, it would take up to 10 seconds to open; when the note was reduced to it's original 4.3 pages, it opened immediately.
The problem identified, I went back to a recent Back-Up, restored it, made a new Place Name, then had to manually change more than 3500 individual facts from the Problematic Name to the New Place Name, so that each fact was divorced from the problem. (Note that at one point I had tried to use "Search & Replace", but that carried the problem.) With every fact changed to a good place location, I tried to copy everyone to a new file, but RM gedcomed the move and the problem place was also moved to the new file, but I did find how to easily move everybody to the new file.
I'm quite disappointed with RM. All these years I had been using the Database Tools, specifically Test Database Integrity which one would think would catch this flaw, but all it does is leave one with a false sense of "Guess everything is OK"
Again, Thanks for your offer to help.
#4
Posted 05 June 2018 - 03:49 PM
Dave, I am a little confused as to whether your problem has been cleared. Second para says "solved" but you then go on describing things that you did but the problem persisted.
Yes, "check database integrity" tests that the database structure is intact and that its table indexes are not mispointing. It does not test for screwy data. Sounds like that particular place had/caused a problem for a very long time. With it identified, SQLite could be used to replace the 3500 uses of it by another in a few seconds. Or used to inspect your data for the cause and come up with a query that would identify other such instances.
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#5
Posted 05 June 2018 - 06:10 PM
Problem is solved. All personal facts related to the problem location, were changed to a new location, that completed the whole list of people had to be moved to a new file, leaving the now unused faulty location behind; this caused a minor problem, as Drag & Drop Everyone took the problem to the new file. I overcame this. The new file is clear of the problem.
Also tagged with one or more of these keywords: Place List, freezes
Product Support - Current Versions →
RootsMagic 7 →
Issues →
RM7 under Windows 10-1909 starts to come up and then freezesStarted by wfb, 13 Dec 2020 ![]() |
|
![]() |
||
General →
RootsMagic Wish List →
Print Primary Place & Place Detail Media rather than listStarted by Vyger, 24 Jun 2018 ![]() |
|
![]() |
||
General →
RootsMagic Wish List →
Reverse Geocoding - to County or Not to CountyStarted by Vyger, 28 Feb 2018 ![]() |
|
![]() |
||
General →
RootsMagic Wish List →
Place List Management [Again]Started by Vyger, 19 Feb 2018 ![]() |
|
![]() |
||
General →
RootsMagic Wish List →
Unused placesStarted by DerickH, 30 Nov 2015 ![]() |
|
![]() |