tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/86933-repeated-freezing-on-a-specific-investmentInfinite Kind: Discussion 2023-05-05T18:40:31Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-29T19:31:56Z2023-01-29T19:31:57ZRepeated freezing on a specific investment.<div><p>Is there a built in equivalent in MoneyDance for file validate?</p>
<p>I have an investment account that freezes up MD completely (all MD windows become non-responsive).</p>
<p>Backdrop - I'm cleaning up imported investment transactions that didn't come in clean. Specifically a security named "^" which seems to be where, in Quicken, there was "MiscInc" transactions categorized as Interest Income. These imported into MD in the Register (not bank reg) as "DivInc" with no security and a category of Interest Income. DivInc is supposed to be tied to a security, but since this was simple account interest, my fix was to create Bank Register transactions a simple Interest Income category and delete the rogue DivInc. After I cleaned up is when the freezing happens.</p>
<p>Steps:<br>
Launch Moneydance<br>
Scroll down to investments<br>
Click on the investment account<br>
Click on "Securities Detail"<br>
Change to security 'B' in the drop down (there are only 3 securities; A,B,& C where A is the ^ security I cleaned up, B is the one that causes the hang, and C works fine)<br>
Click on one of the transactions on the left side of the detail pane.<br>
Freeze.</p>
<p>Need to use a force quit. I'd like to run a file integrity check if possible (unless I'm just being overly jaded as a former quicken user :D )</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-29T20:06:01Z2023-01-29T20:06:01ZRepeated freezing on a specific investment.<div><p>Right.</p>
<ol>
<li>
<p>run toolbox extension. In security tools run the check hierarchical security feature. Any problems?</p>
</li>
<li>
<p>Make it freeze up, then force quit. Then locate errlog.txt file on disk (before you relaunch MD) and upload that here.</p>
</li>
<li>
<p>Do the securities in question have splits and do any buy then sell txns span the split dates?</p>
</li>
</ol></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-29T20:16:22Z2023-01-29T20:16:22ZRepeated freezing on a specific investment.<div><ol>
<li>Clarification. It’s on the account tools menu and called:<br>
‘ FIX - Non-Hierarchical Security Acct Txns (& detect Orphans)’</li>
</ol></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-29T20:33:05Z2023-01-29T20:33:05ZRepeated freezing on a specific investment.<div><p>Also read this:<br>
<a href="https://infinitekind.tenderapp.com/discussions/problems/84228-ui-blocks-forever-in-getcostbasis-when-opening-investment-account">https://infinitekind.tenderapp.com/discussions/problems/84228-ui-bl...</a></p>
<p>Does this apply?</p>
<p>And poss run the (last) script on post 14</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-30T03:55:20Z2023-01-30T03:55:22ZRepeated freezing on a specific investment.<div><p>Thanks.<br>
1) I'm running Toolbox v1056 and cannot find the item you mention. I'm looking in "MENU: Accounts and Categories tools" (and checked others but can't find "FIX - Non-Hierarchical....."</p>
<p>2) did that, and searched my whole computer for errlog.txt and received no results.</p>
<p>3) No splits that I can see in the register for the security.</p>
<p>The extra post I need to dig in tomorrow. Getting late and too many beers during the games :D</p>
<p>FYI - Mac version 12.6, MD version 2022.5 (4091).</p>
<p>ps. I received the notice about the new update but have not updated until this problem is resolved or until someone says the update is meant to fix.</p>
<p>Thanks for the help!</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-30T04:15:56Z2023-01-30T04:15:57ZRepeated freezing on a specific investment.<div><p>some additional info.</p>
<p>I corrected all the erroneous MiscInc transactions that didn't have a security attached, and attempted to "Remove Security" on the blank value in the Securities Detail pane. It gave me a very ominous warning about are you sure you want to delete "the name of the investment account". I made a copy of my datafile and tried it. The account remained and it correctly removed the blank security.</p>
<p>Interestingly, prior to deletion, it displayed in the drop down the following securities (in this order)<br>
A (the null value)<br>
B (the security hanging up)<br>
C</p>
<p>Now it displays<br>
C<br>
B</p>
<p>and B is still the security hanging. Just mentioning because I find it odd the sort order changed and am wondering if position in the list is playing a part.</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-30T08:43:49Z2023-01-30T08:43:49ZRepeated freezing on a specific investment.<div><p>Sorry - typo - it's in transaction tools - try there.</p>
<p>Also, not that you have toolbox installed, go to help/console and look for this:</p>
<pre>
<code>-----------------------------------------------------
Toolbox - quick information:
-----
MD CONSOLE FILE LOCATION: '/Users/xxx/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt'
MD CONFIG/PREFERENCES LOCATION: '/Users/xxx/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/config.dict'</code>
</pre>
<p>It will tell you where to look for errlog.txt file after you force quit MD...</p>
<p>??</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-30T16:07:20Z2023-01-30T16:07:20ZRepeated freezing on a specific investment.<div><p>STEP1. Go to Tools/Security and make sure for each security that there is something set in the SecurityID, SecurityName and TickerSymbol fields (even if dummy info) - i.e. don't leave blank.</p>
<p>Then you may need all these in toolbox:</p>
<p>Transaction tools menu: "FIX - Non-Hierarchical Security Acct Txns (& detect Orphans)"</p>
<p>Security Tools menu: "FIX - Detect and fix Investment Security records not properly linked to Security Master records"</p>
<p>Security Tools menu: "FIX - Detect and merge/fix duplicate Securities within same Investment Account(s)"</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T01:30:40Z2023-01-31T01:30:43ZRepeated freezing on a specific investment.<div><p>Step 1 - Toolbox. "Congrats - I found no non-hierarchical / invalid txns".... woohoo! :D</p>
<p>Step 2 - I found the file location, but I walked the directory and it flat out doesn't exist.<br>
MD CONSOLE FILE LOCATION: '/Users/myname/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt'<br>
MD CONFIG/PREFERENCES LOCATION: '/Users/myname/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/config.dict'</p>
<p>There is no com.infinitekind.moneydance folder in my user library. Which seems impossible but I've got hidden files turned on (shift + cmd + .) and I still can't find it. I must be missing something, my MD preferences are saving somewhere......</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T01:33:37Z2023-01-31T01:33:38ZRepeated freezing on a specific investment.<div><p>Further update.</p>
<p>Congrats messages on all</p>
<p>Transaction tools menu: "FIX - Non-Hierarchical Security Acct Txns (& detect Orphans)"</p>
<p>Security Tools menu: "FIX - Detect and fix Investment Security records not properly linked to Security Master records"</p>
<p>Security Tools menu: "FIX - Detect and merge/fix duplicate Securities within same Investment Account(s)"</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T08:16:52Z2023-01-31T08:16:52ZRepeated freezing on a specific investment.<div><p>'/Users/myname/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/config.dict' Will be a called something different if you walk in finder. The infinite kind but will be called Moneydance. So look around a bit.</p>
<p>However if you run terminal and then:<br></p>
<pre>
<code>Open “/Users/myname/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt”</code>
</pre>
<p>It should open.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T08:19:08Z2023-01-31T08:19:08ZRepeated freezing on a specific investment.<div><p>Ok. Well you need it to freeze, then force quit, and I need that log file.</p>
<p>Another route. Launch toolbox. Top right. Open md folder. Open console. It should show you the folder.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T09:32:11Z2023-01-31T22:24:59ZRepeated freezing on a specific investment.<div><p>If you want to try some more direct troubleshooting, email me:<br>
….</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T21:50:00Z2023-01-31T21:50:07ZRepeated freezing on a specific investment.<div><p>Finally found errlog.txt - MacOS is weird....</p>
<p>Anyway, doesn't look like any obvious errors to me. Obfuscated personal info, otherwise the paste is intact.</p>
<p>Starting Moneydance 2022.5 (4091) at Tue Jan 31 16:39:41 EST 2023<br>
Settings Folder: /Users/username/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance<br>
OS: Mac OS X 12.6 x86_64username<br>
Architecture: intel64<br>
Java: 18.0.1 (Eclipse Adoptium)<br>
Is in sandbox: true; restricted file access: false<br>
Library path: /Applications/Moneydance.app/Contents/MacOS:/Applications/Moneydance.app/Contents/PlugIns/vm.jdk/Contents/Home/lib:/Applications/Moneydance.app/Contents/MacOS:/Applications/Moneydance.app/Contents/PlugIns/vm.jdk/Contents/Home/Frameworks<br>
initialized extension moneyforesight in 0.474 seconds<br>
initialized extension securityquoteload in 0.047 seconds<br>
python.path: /Users/username/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/python<br>
python.cachedir: /Users/username/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/python/cache<br>
python.cachedir.skip: false<br>
Quote Load>INFO:16:39:41-main(Quote Load,Init) Started Build 3058<br>
Quote Load>INFO:16:39:41-main(Quote Load,Init) Locale en_US</p>
<p>############################################################################################################################# toolbox: toolbox_init.py initializer script running - performing some quick checks, logging diagnostics, then will exit....<br>
#############################################################################################################################</p>
<p>initialized extension toolbox in 0.485 seconds<br>
Font initialisation attempted from non-UI thread. Hopping over to dispatch thread...<br>
Initializing fonts:<br>
default: [[SF Pro Display, SF Display, Helvetica Neue, Helvetica, Lucida Grande, Dialog]] printing: [[Helvetica, SF Pro Display, SF Display, Helvetica Neue, Helvetica, Lucida Grande, Dialog]] monospaced: [[Gill Sans, Menlo, Monaco, Monospaced]] coding: [[Hack, Monospaced]] fonts resolved:<br>
default: SF Pro Display:12.0:style0 mono: Gill Sans:12.0:style0 coding: Hack:12.0:style0 print: Helvetica:12.0:style0 header: SF Pro Display:14.0:style0 register: SF Pro Display:11.0:style0 reportTitle: SF Pro Display:32.0:style0 calendarTitle: SF Pro Display:11.0:style0 reportHeader: SF Pro Display:10.0:style0 detailTitle: SF Pro Display:14.0:style0 detected system appearance: org.violetlib.vappearances.VAppearanceImpl@44c13103<br>
Theme NoSuchField: reminderHomeBG<br>
Theme NoSuchField: reportAlternateRowBG<br>
Theme NoSuchField: reportRowBG<br>
Setting look and feel class to com.apple.laf.AquaLookAndFeel<br>
Font initialisation attempted from non-UI thread. Hopping over to dispatch thread...<br>
opening last file: myfilename<br>
loading dataset: /Users/username/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/myfilename.moneydance<br>
loading with 128 bit encryption key<br>
loading with 128 bit encryption key<br>
reading trunk data tiksync/trunk<br>
trunk data loaded (2.101 seconds), checking for incremental updates<br>
loading un-synced txn files...<br>
loading synced txn files...<br>
replacing root: null () with new root: myfilename (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)<br>
ICloudContainer.isContainerAvailable(): nativeGetICloudPath: null</p>
<hr>
<h2><a name="toolbox-quick-information-" class="anchor" href="#toolbox-quick-information-"></a>Toolbox - quick information:</h2>
<p>MD CONSOLE FILE LOCATION: '/Users/username/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt'</p>
<h2><a name="md-config-preferences-location-39-users-username-library-containers-com-infinitekind-moneydanceosx-data-library-application-support-moneydance-config-dict-39-" class="anchor" href="#md-config-preferences-location-39-users-username-library-containers-com-infinitekind-moneydanceosx-data-library-application-support-moneydance-config-dict-39-"></a>MD CONFIG/PREFERENCES LOCATION: '/Users/username/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/config.dict'</h2>
<p>BACKUPS - Save Daily: True<br>
BACKUPS - Keep no more than: 5 backups<br>
BACKUPS - Separate Backup Foldr: True<br>
BACKUPS - Backup Folder: '/Users/username/Documents/MoneyDance' (backup location exists)<br>
..key - 'backup.location': '/Users/username/Documents/MoneyDance' ..key - 'backup.last_browsed': '' ..key - 'backup.last_saved': '/Users/username/Downloads'</p>
<h2><a name="-key-39-_default_backup_dir-39-39-not-set-39-" class="anchor" href="#-key-39-_default_backup_dir-39-39-not-set-39-"></a>..key - '_default_backup_dir': ''</h2>
<p>System Default Locale Cty/Lang: 'US' / 'en'<br>
MD Preference Locale Ctry/Lang: 'US' / 'en'<br>
MD Locale Cty/Lang: 'US' / 'en'</p>
<h2><a name="moneydance-decimal-point-39-39-" class="anchor" href="#moneydance-decimal-point-39-39-"></a>Moneydance decimal point: '.'</h2>
<p>MD EXECUTION MODE: 2 (Normal)<br>
JVM - Available processor cores: 10<br>
JVM - Maximum memory possible: 28.8 GB</p>
<h2><a name="jvm-total-memory-allocated-1-7-gb-used-0-8-gb-free-1-0-gb-" class="anchor" href="#jvm-total-memory-allocated-1-7-gb-used-0-8-gb-free-1-0-gb-"></a>JVM - Total memory allocated: 1.7 GB (used 0.8 GB / free 1.0 GB)</h2>
<p>Quote Load>INFO:16:39:57-main(Quote Load,HandleEventFileOpened) Debug level set to INFO<br>
Quote Load>INFO:16:39:57-main(Quote Load,sendAuto) Check Auto without delay<br>
Quote Load>INFO:16:39:57-AWT-EventQueue-0(Quote Load,sendAuto) now 16:39:57.035383 next 2023-01-31T17:00<br>
Update info received with successful signature verification<br>
calculated portfolio cost basis in 0.0 seconds</p>
<h2><a name="mousepressed-but-the-parent-is-an-ancestor-" class="anchor" href="#mousepressed-but-the-parent-is-an-ancestor-"></a>mousePressed, but the parent is an ancestor</h2>
<p>JVM - Maximum memory possible: 28.8 GB</p>
<h2><a name="jvm-total-memory-allocated-1-7-gb-used-0-7-gb-free-1-0-gb-" class="anchor" href="#jvm-total-memory-allocated-1-7-gb-used-0-7-gb-free-1-0-gb-"></a>JVM - Total memory allocated: 1.7 GB (used 0.7 GB / free 1.0 GB)</h2></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T21:57:21Z2023-01-31T21:57:21ZRepeated freezing on a specific investment.<div><p>So this log was after the freeze and after the force quit and before you relaunched MD?</p>
<p>If so, yes no errors.</p>
<p>Out of interest, shut md. Rename config.dict. Launch md and try again. Does it still freeze? Either way, exit again, delete config.dict then rename the original back.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-01-31T22:24:21Z2023-02-05T10:54:59ZRepeated freezing on a specific investment.<div><p>So I’m out of ideas as there are no errors.</p>
<p>If you want me to look further/deeper, perhaps email me.<br>
...</p>
<p>(Not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-01T17:40:14Z2023-02-01T17:40:17ZRepeated freezing on a specific investment.<div><p>Deleting the config file did not help. However, one clarification to a response on an earlier thread. When I said there were no splits involved, I meant transaction splits.<br>
I am now noticing that the security in question has multiple stock splits.</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-01T17:55:55Z2023-02-01T17:55:55ZRepeated freezing on a specific investment.<div><p>Right. Two things...</p>
<ol>
<li>
<p>Run the script (the latest one called test_cost_basis3.py) on post 14 here:<br>
<a href="https://infinitekind.tenderapp.com/discussions/problems/84228-ui-blocks-forever-in-getcostbasis-when-opening-investment-account#comment_56138102">https://infinitekind.tenderapp.com/discussions/problems/84228-ui-bl...</a></p>
</li>
<li>
<p>As a test, edit the stock splits on this security. Take a screenshot first and then delete all the splits.. Does the error go away?</p>
</li>
</ol></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-02T23:16:04Z2023-02-02T23:16:05ZRepeated freezing on a specific investment.<div><p>I think we're definitely in the area. The security hanging is a company stock option (purchase plan) I don't remember why it was set up this way, but the initial purchase was a Sell on the date of the signup. Then over X period of time, paycheck contributions were pushed into the account, and when the option executed, there was a Buy for the actual stock at the original option price and a Buy with the same values to cover the short sell. And over the period there were a few stock splits.</p>
<p>Anyways, test_cost_basis3.py seems to be outputting without errors. Its picking up three transactions (correct) for the troublesome security, the original Sell (at the split adjusted qty) and the two Buy transacations to close out the position. Because of the split there was a fractional share involved. In the end share balance shows as 0. I've eliminated fee,costbasis,totalcost, price since this is an open forum but they all looked ok.</p>
<p>19970514 sell:633.75 totshrs: -633.75<br>
19990630 buy:633 totshrs: -0.75<br>
19990630 buy:0.75 totshrs: 0</p>
<p>I'll try removing the splits next...I've half tempted just to forget about it since the transaction is so long ago and the account is closed. But my curiosity has the better of me...</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-03T00:33:00Z2023-02-03T00:33:01ZRepeated freezing on a specific investment.<div><p>And just like that, deleting the two splits makes the problem go away. However, adding the splits back in mucked up my holdings.</p>
<p>Restored Backup. Try 2.<br>
Changed the dates of the splits (still within the appropriate period). Did not help, still freezes.</p>
<p>Try 3. Changed the most recent split to a date outside the range (+10 yrs). Same hang.<br>
Restored Backup. Try 4.<br>
Changed the date of the other split to outside the range (+10 yrs). Hang FIXED.</p>
<p>Now the fun part. Went back into the security and now I have three splits. The one original unchanged (remember I went to backup), and TWO other splits for the same +10 year date.</p>
<p>Deleted one of the splits. Returned the date back to the original date. HANG RETURNS.... What the ??</p>
<p>Restore Backup. Try 6?<br>
Changed the date of the bad split forward 10 again. Once again, it created two split entries 10 years ahead. Removed one of them. Balances look ok.. somehow. Not sure how considering the split is nine years after the last sell, but ok. Leaving it like this for now.</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-03T05:54:55Z2023-02-03T05:54:55ZRepeated freezing on a specific investment.<div><p>There is a bug whereby the combination of a negative stock balance prior to a stock split followed by any buy/sell after that date will cause an infinite loop.</p>
<p>When it freezes, have you tried leaving it for 10 minds to see if it unfreezes? It should do. As it will abort. At this point grab help/console and upload. Then I can see if it’s the same error.</p>
<p>Anyway, it sounds like you start with a negative sell and then have split(s) and then have buys. From memory this will cause the bug.</p>
<p>My suggested fix. Delete all splits. Pretend the splits had already occurred and enter the original sell using pretend future state. But no good for you if you have other txn using the same security.</p>
<p>@dwg. What’s the best way to handle stock purchase plans? Starting negative doesn’t sound right?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-03T07:13:56Z2023-02-03T07:13:56ZRepeated freezing on a specific investment.<div><p>Stuart,</p>
<p>Going straight to the hard questions eh. Option handling is not something that has come up a lot so I would be hard pressed the state the best way.</p>
<p>Some years back I decided to investigate options a little deeper. I wrote up a set of notes which I have attached. Now I cannot say I did exhaustive testing, but it seemed to work at the time and one of my goals was not to have the options contribute to net wealth, given the option only has a notional or potential value at the time.</p>
<p>There is likely to be other ways but one of the problems is the net worth one. Moneydance is not really geared to handle employee options, vesting etc.</p>
<p>Use the notes as you would like</p>
<p>Des</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-03T18:24:05Z2023-02-03T18:24:07ZRepeated freezing on a specific investment.<div><p>Thanks guys. As I recall (and it was many moons ago), the reason was to ensure it did not contribute to net wealth, while still being able to track the stock's potential value.</p>
<p>Steps:<br>
Execute a Buy for X shares at Y price,<br>
Execute a simultaneous Sell of X shares of the option at the same Y price.<br>
This zeroed out any wealth increase, but still put the stock into the register to track potential value.</p>
<p>Once payroll contributions accumulated in the cash balance and it hit the exercise date, there was a Buy of the option at Y price to cover using the cash funds that had accumulated.<br>
This single transaction zeroed the cash balance that accumulated and simultaneously increased wealth by whatever premium the market price was over exercise (remember wealth was accumulating because of the cash contributions which eventually totaled X shares time Y price).</p>
<p>The reason for the 'option' I believe was just to use as a placeholder, rather than Option in the normal context. I needed a security to track against the actual security. If I created the sell of the original security instead of the option, well, I'd have no shares.</p>
<p>The security hanging is the specific option, so it will never be used again; therefore I will follow Stuart's recommendation of manually entering the adjusted shares and eliminating the splits.</p>
<p>Thanks again for the help!!!!</p></div>netr@certag:infinitekind.tenderapp.com,2009-01-14:Comment/577418822023-02-03T18:30:32Z2023-02-03T18:30:32ZRepeated freezing on a specific investment.<div><p>👍</p></div>Stuart Beesley (Mr Toolbox)