[GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7

[Adrien Monteleone]

Yes, I think 7zip can decompress the file. Check the wiki, or maybe a Windows user on the list can help out with doing so.

One thing to consider, how do you normally open your GnuCash data file to start working in it?

Do you open the GnuCash app and let it open the last used file automatically, or do you click the data file itself?

If the latter, are you 100% certain you are looking at a copy of the data file that is current and not one before you created the sub-accounts? That is, did you at one time have only the main Hydro account and then later refactored those transactions to sub-accounts? Perhaps you opened an older copy of the data file before that refactoring.

Regards,
Adrien

> On Dec 16, 2019 w51d350, at 10:12 AM, Paul Kroitor <paul at kroitor.ca> wrote:
> 
> Thanks David,
> 
> I'm on Win 10, fully patched. I did try to look at the XML data files. Unfortunately I had turned on compression and thus they're not human readable unless someone knows a simple Windows decompression command line (ideally with 7zip, which is already on the box).
> 
> There are several other place in the CoA that go three levels deep, and none of those have disappeared. The Hydro account, as far as I remember, *was* a placeholder account when it was set up (I wouldn't have wanted entries into it), but it no longer is.
> 
> I do have all the relevant backup and log files, and am very comfortable working with them. I'm considering restoring the old data file, rolling back to 3.5, and then trying to reproduce the issue. However, it's a fair bit of work at a very busy time of year, and, as I've mentioned elsewhere, it isn't all that hard to repair manually.
> 
> At your suggestion I've looked at the logfile from the first 3.7 open, which is interesting but not entirely clear to me. Here are my observations:
> 
>  1.  There are indeed entries for the three missing sub-accounts: for each sub-account, there are four pairs of two entries each. All eight entries for a sub-account are identical except for the mod field. Thus
> ===== START
> B ......(seven guids and dates)..... Auto   Main Hydro .....
> B ......(seven guids and dates)..... Auto   Main Hydro .....
> ===== END
> ===== START
> R ......( seven guids and dates)..... Auto   Main Hydro .....
> R ......( seven guids and dates)..... Auto   Main Hydro .....
> ===== END
> ===== START
> B ......(seven guids and dates)..... Auto   Main Hydro .....
> B ......(seven guids and dates)..... Auto   Main Hydro .....
> ===== END
> ===== START
> R ......(seven guids and dates)..... Auto   Main Hydro .....
> R ......(seven guids and dates)..... Auto   Main Hydro .....
> ===== END
> 
> Then we get
> 
>  *   Eight apparently unrelated entries about a different account
>  *   A group just like the above but for "Retreat" rather than Main Hydro
>  *   Eight apparently unrelated entries about a different account
>  *   A group just like the above for "A-Frame"
> (Main Hydro, Retreat, and A-Frame being the three missing sub-accounts)
> 
> 
>  1.  These all seem to be about pending automatic entries: there were entries due for creation for all three missing accounts as well as the other accounts interspersed above (but the sub-accounts in the interspersed entries have not disappeared).
> 
> 
> 
>  1.  The titles don't seem to accurately correspond to the data (or maybe they correspond to different record types than are in this log). The titles, after acc_guid, are: "acc_name num description notes memo action reconciled amount value date_reconciled", but the data lines end in "Auto Main Hydro n 0/1 0/100 1970-01-01 00:00:00". Only the first and last of these fields actually correspond.
> All-in-all I don't see any smoking gun in the log - it seems to me the log file entries I'm seeing might just be normal entries for the scheduled transactions - EXCEPT that there are no dollar amounts anywhere.
> 
> Paul