Quote Loader not receiving any prices

jeffcarp's Avatar

jeffcarp

27 Apr, 2021 01:52 AM

I am having a problem with Quote Loader suddenly not receiving any security prices but it is reporting "Prices Loaded." Screenshot attached.

  1. 1 Posted by derekkent23 on 27 Apr, 2021 08:20 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi jeffcarp

    Perhaps start by updated to Quote Loader to build 3034, you are running 3027, update under EXTENSION – MANAGE EXTENSIONS. Don’t forget to restart Moneydance after you install.
    As you can see from my screen shot your securities work for me.

    If you still problems post your computer operating system.
    In Quote Loader under HELP – set DEBUG ON/OFF to DETAILED.
    Restart Moneydance, run Quote Loader on completion close Moneydance and post the Moneydance file errlog.txt
    If you're using Mac OS, it should be located at one of these locations within your Home folder:
    ~/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt or:

    ~/Library/Application Support/Moneydance/errlog.txt

    If you have any trouble finding your Home Library folder you can open Finder and hold down the option key while selecting the Go menu and the Library folder option should occur or you can open Finder and select Go -> Go to Folder and copy and paste in the following:
    ~/Library This should pull up your local Library folder.

    If you're using Windows, it should be located under your login directory at:
    C:\Users(yourusername).moneydance\errlog.txt

    or

    C:\Documents and Settings(yourusername).moneydance\errlog.txt
    Depending on your version of Windows

    If you're using Linux it should be located in your home folder at:
    ~/.moneydance/errlog.txt

    Hope this helps.

  2. 2 Posted by jeffcarp on 27 Apr, 2021 12:01 PM

    jeffcarp's Avatar

    I cannot update to the latest version through EXTENSION - MANAGE EXTENSION because of an error message. I suspect this message is why Quote Loader isn't working. It is also the same error message that I receive whenever I try to connect to any online bank. None of those work either.

    I am on Moneydance 2021.1 (3066) for Windows.

  3. 3 Posted by derekkent23 on 27 Apr, 2021 12:18 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi effcarp

    Are your banks set to download when you start Moneydance under preferences network (Automatically Download in Background), if so turn this feature off and see what happens.
    If there are still issues post a copy of your Moneydance errlog.txt file it may help.

    I am also running 2021.1(3066) for Windows 10.

    Hope this helps.

  4. 4 Posted by jeffcarp on 27 Apr, 2021 12:22 PM

    jeffcarp's Avatar

    No, I do not have my banks set to download automatically in the background. I only do it manually. Here are the contents of my errlog.txt file:

    Starting Moneydance 2021.1 (3066) at Tue Apr 27 07:10:56 CDT 2021
    Settings Folder: C:\Users\Jeffrey.A.Carpenter\.moneydance
    OS: Windows 10 10.0 amd64
    Java: 15.0.1 (AdoptOpenJDK)
    Is in sandbox: false; restricted file access: false
    Library path: c:\program files\moneydance\jre\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Users\Jeffrey.A.Carpenter\AppData\Local\Microsoft\WindowsApps;
    Initializing fonts:
      default: [[Dialog]]
      printing: [[Adobe Arabic, Dialog]]
      monospaced: [[Calibri, Monospaced]]
      coding: [[Hack, Monospaced]]
    fonts resolved:
     default: Dialog:12.0:style0
     mono: Calibri:12.0:style0
     coding: Hack:12.0:style0
     print: Adobe Arabic:12.0:style0
     header: Dialog:14.0:style0
     register: Dialog:11.0:style0
     reportTitle: Dialog:32.0:style0
     calendarTitle: Dialog:11.0:style0
     reportHeader: Dialog:10.0:style0
     detailTitle: Dialog:14.0:style0
    Setting look and feel class to com.sun.java.swing.plaf.windows.WindowsLookAndFeel
    initialized extension debtinsights in 0.587 seconds
    creatingURLStreamHandler for protocol 'moneydanceextloader'
    findandreplace (0): 04-27 07:10:57.514|Initialized build 1215 ok
    initialized extension findandreplace in 0.013 seconds
    initialized extension invextension in 0.0 seconds
    creatingURLStreamHandler for protocol 'http'
    initialized extension moneyforesight in 0.468 seconds
    initialized extension priceui in 0.0 seconds
    ratios (0): 04-27 07:10:58.069|Initialized build Build 1034 ok
    initialized extension ratios in 0.0 seconds
    initialized extension securityquoteload in 0.015 seconds
    multires images not supported: java.lang.ClassNotFoundException: sun/awt/image/MultiResolutionImage.class
    initialized extension updater in 0.0 seconds
    Quote Load>INFO:07:10:58-main(Quote Load,Init) Started Build 3027
    Quote Load>INFO:07:10:58-main(Quote Load,Init) Locale en_US
    opening last file: JKCarpenter 2021-1
    loading dataset: C:\Users\Jeffrey.A.Carpenter\.moneydance\Documents\JKCarpenter 2021-1.moneydance
    set antialiasing to HRGB
    loading with 128 bit encryption key
    reading trunk data tiksync/trunk
    trunk data loaded (1.638 seconds), checking for incremental updates
    loading un-synced txn files...
    loading synced txn files...
    creatingURLStreamHandler for protocol 'https'
    Error checking for updates: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    at java.base/sun.security.ssl.Alert.createSSLException(Unknown Source)
    at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
    at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
    at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
    at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(Unknown Source)
    at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(Unknown Source)
    at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(Unknown Source)
    at java.base/sun.security.ssl.SSLHandshake.consume(Unknown Source)
    at java.base/sun.security.ssl.HandshakeContext.dispatch(Unknown Source)
    at java.base/sun.security.ssl.HandshakeContext.dispatch(Unknown Source)
    at java.base/sun.security.ssl.TransportContext.dispatch(Unknown Source)
    at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
    at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
    at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at java.base/sun.security.ssl.SSLSocketImpl.ensureNegotiated(Unknown Source)
    at java.base/sun.security.ssl.SSLSocketImpl$AppOutputStream.write(Unknown Source)
    at java.base/java.io.OutputStream.write(Unknown Source)
    at com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.writeRequest(HTTPURLConnectionHelper.java:966)
    at com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.beginResponse(HTTPURLConnectionHelper.java:681)
    at com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.getInputStream(HTTPURLConnectionHelper.java:214)
    at com.moneydance.apps.md.controller.olb.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:147)
    at java.base/java.net.URL.openStream(Unknown Source)
    at com.moneydance.modules.features.updater.Main$VersionInfoDownloader.run(Main.java:177)
    at java.base/java.lang.Thread.run(Unknown Source)
    Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    at java.base/sun.security.validator.PKIXValidator.doBuild(Unknown Source)
    at java.base/sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
    at java.base/sun.security.validator.Validator.validate(Unknown Source)
    at java.base/sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source)
    at java.base/sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
    ... 21 more
    Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(Unknown Source)
    at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
    at java.base/java.security.cert.CertPathBuilder.build(Unknown Source)
    ... 26 more
    replacing root: null () with new root: Personal Finances (29221989-c772-4c68-8f18-2eb241d19e2e
    getting account info from dropbox failed: com.dropbox.core.NetworkIOException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    Error creating or resetting syncing process:java.lang.Exception: Not linked to Dropbox
    java.lang.Exception: Not linked to Dropbox
    at com.moneydance.apps.md.view.gui.sync.DropboxSyncConfigurer.getSyncFolder(DropboxSyncConfigurer.java:77)
    at com.moneydance.apps.md.controller.sync.SyncManager.loadSyncFolderForData(SyncManager.java:75)
    at com.moneydance.apps.md.controller.sync.SyncManager.dataFileWasLoaded(SyncManager.java:62)
    at com.moneydance.apps.md.view.gui.MoneydanceGUI.dataFileOpened(MoneydanceGUI.java:1650)
    at com.moneydance.apps.md.view.gui.MoneydanceGUI$DataFileOpener.run(MoneydanceGUI.java:1614)
    at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
    at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
    at java.base/java.security.AccessController.doPrivileged(Unknown Source)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
    at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
    Quote Load>INFO:07:11:06-main(Quote Load,HandleEventFileOpened) Debug level set to INFO
    Quote Load>INFO:07:11:06-AWT-EventQueue-0(Main,sendAuto) now 07:11:06.685032800 next 2021-04-27T09:00
    Beginning shutdown process
    Compacting old transaction logs
    waiting for background tasks to complete...
    backing up file...
    saving automatic backup file: C:\Users\Jeffrey.A.Carpenter\.moneydance\archive\backups\JKCarpenter 2021-1.2021-04-27.moneydancearchive
    finished backing up file; now to remove expired backups...
    completed removal of expired backups
    Tasks complete. Goodbye!

  5. 5 Posted by derekkent23 on 27 Apr, 2021 01:34 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi jeffcarp

    Another thought.

    All your issue, Bank downloads, running Extension Manager and Quote Loader all involve connecting to the internet.
    Have you any software that could block access to the internet, VPN or internet security software?
    The error log suggest Moneydance cant even connect to Dropbox.

    Hope this helps.

  6. 6 Posted by jeffcarp on 27 Apr, 2021 01:40 PM

    jeffcarp's Avatar

    I don't have any issues with connecting to anything else on the Internet. I actually have Dropbox on the same computer and it's working fine, as is connecting to all of these banks through a web browser on the same computer.

  7. 7 Posted by derekkent23 on 27 Apr, 2021 03:38 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi jeffcarp

    I was not thinking in terms of something blocking your computers access to the internet just features within Moneydance needing internet access.

    If you have no software that could be doing this then perhaps part of the Moneydance program itself is corrupted. Re-download and install 3066.

    If that does not help with Moneydance closed try renaming the config.dict file to say config.dict_old and opening Moneydance. Note you will loose all your preference setting and your licence key. Make sure you have a copy of the key before you try this. If this does not help with Moneydance closed you can always revert back to the original config.dict file. The file is located in the same folder as errlog.txt.

    Hope this helps.

  8. Support Staff 8 Posted by Sean Reilly on 27 Apr, 2021 03:47 PM

    Sean Reilly's Avatar

    I think it's very unlikely that the moneydance application or installation is corrupted. The error messages seem to be that when moneydance is trying to connect to any secure service that it cannot determine whether it is actually speaking to the intended party on the other side of the connection.

    I would looks into network settings, including whether there is an http/https proxy configured on your computer. I would be very suspicious of any other software that was recently installed or updated, especially if it was network related.

    Would you also be able to send a copy of your preferences file which should be called config.dict in your C:\Users\Jeffrey.A.Carpenter\.moneydance folder.

    Thanks,
    Sean

    --
    Sean Reilly
    Developer, The Infinite Kind
    https://infinitekind.com

  9. Support Staff 9 Posted by Sean Reilly on 27 Apr, 2021 03:48 PM

    Sean Reilly's Avatar

    Or maybe during the most recently installation Moneydance has been tagged by the system as unable to make network connections?

    I'm not familiar enough with windows to know whether that might be a possibility or where to look to fix it.

    --
    Sean Reilly
    Developer, The Infinite Kind
    https://infinitekind.com

  10. 10 Posted by jeffcarp on 27 Apr, 2021 04:02 PM

    jeffcarp's Avatar

    I do think there is something going on with Moneydance connections to secure services. I attached the config.dict file as requested. I've found an issue with NordVPN that also can't connect to secure services. That screenshot is attached. I have reached out to their support as well to see if they can provide any insight. I can still connect to secure websites and other services like Google Drive, Dropbox, etc securely.

  11. Support Staff 11 Posted by Sean Reilly on 27 Apr, 2021 04:07 PM

    Sean Reilly's Avatar

    I also use NordVPN and I would be worried if they weren't able to connect. I just tried and they were able to connect for me. I would be very wary of something nefarious happening on your network or possibly only on your computer. The config.dict file preferences look fine, so I wouldn't think it was anything inside of Moneydance, rather that Moneydance's TLS verification is doing what it's supposed to do.

    Thanks,
    Sean

  12. 12 Posted by jeffcarp on 27 Apr, 2021 04:13 PM

    jeffcarp's Avatar

    I use Moneydance on a corporate laptop. If I look at that NordVPN error message, it looks like this is related to Websense Endpoint, which is software that is part of our corporate security deployment. I am wondering if my company has upgraded something and Websense Endpoint has inserted itself in the middle of unknown or unapproved secure connections - kind of like a "man in the middle" situation? That might explain why widely used services like Dropbox and secure browsing still work but something more obscure like Moneydance doesn't work?

  13. 13 Posted by Stuart Beesley ... on 27 Apr, 2021 04:29 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I agree with Sean...It lookalike any connection that MD makes is being blocked by your computer; and/or you have an issue with access to your local security certificates. I would check that the "app"is not being blocked by Windows, Defender, Anti-Malware, your virus checker, your firewall etc....

  14. 14 Posted by jeffcarp on 27 Apr, 2021 05:07 PM

    jeffcarp's Avatar

    I have a feeling that this is an update to our corporate security policies and I won't be able to use my company laptop for Moneydance anymore. Some of the security settings, such as enabling a new app through the firewall, are locked out from user changes. I think my energy needs to shift to figuring out Moneydance on my personal Chromebook. Knowing nothing about Linux - this might be rough!

  15. 15 Posted by derekkent23 on 27 Apr, 2021 05:20 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi jeffcarp

    I was not far wrong with my thoughts on Moneydance’s access to the internet being block by other software.

    The following article has been archived so I don’t know if it is still valid.
    https://infinitekind.tenderapp.com/kb/archive-program-basics/instal...

    Hope this helps.

  16. 16 Posted by jeffcarp on 27 Apr, 2021 05:35 PM

    jeffcarp's Avatar

    Installing on Chromebook has been remarkably easy. However, the high resolution of the Pixel Slate makes the text so small that it's unusable. I'm trying to read about the "sommelier" command to change the app scale but I don't know how to format the command to use it.

  17. 17 Posted by derekkent23 on 27 Apr, 2021 05:44 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi jeffcarp

    It may not help but in Moneydance PREFERENCES - APPEARANCE you can change the Font size

    Have Fun, Stay Safe.

  18. 18 Posted by Stuart Beesley ... on 27 Apr, 2021 05:47 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I don't know much about ChomeBook... Are you able to find the file called

    Moneydance.vmoptions

    if so, we can try adding these to the end of it:

    -Dsun.java2d.uiScale=2
    -Dsun.java2d.uiScale.enabled=true
    

    But, otherwise....the command seems to be:

    sommelier -X --scale=0.8 --dpi=160 /usr/share/code/code "--unity-launch %F" &
    

    Where I suspect %F needs to be replaced with the path for the Moneydance app.

    https://www.reddit.com/r/Crostini/wiki/howto/adjust-display-scaling...

  19. 19 Posted by jeffcarp on 27 Apr, 2021 07:34 PM

    jeffcarp's Avatar

    The Dsum changes to that text file fixed the scaling issue. The last issue seems to be that there is no header text showing at the very top of any window in Linux on the Chromebook like it shows on Windows. For example, when entering the file password, the text "Please enter your password" shows up at the top of the screen on Windows but doesn't on Linux. On the Home screen, the file name is shown in text at the top of the screen on Windows but not on Linux. Finally, when going into any accounts register, the account name is listed in the header at the top left on Windows but not on Linux.

  20. 20 Posted by Stuart Beesley ... on 27 Apr, 2021 07:53 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Can you send screenshot showing the issue?

  21. 21 Posted by jeffcarp on 27 Apr, 2021 10:12 PM

    jeffcarp's Avatar

    Here are screenshots.

  22. 22 Posted by Stuart Beesley ... on 28 Apr, 2021 05:23 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    from what I've read, this is a 'feature' of Chromium. It's but design to make apps look like the rest on the ChromeBook. Many people have complained about this when Linux is enabled. It's also been flagged as a bug (feature removal). I suggest checking you are on the latest Os Version and keep checking updates..

    https://support.google.com/pixelbook/thread/879869?hl=en

    (Others may know different)....

    (not support, just a fellow user)

  23. System closed this discussion on 28 Jul, 2021 05:30 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac