Home → Online Banking →

Unable to setup Scottrade Brokerage

• Edit

jrduke1

27 Jan, 2016 09:07 PM

Hello MD support,
I contacted Scottrade tech support and they can see that I connected ok, but stops there. They suggested I call Quicken and wanted to know what version of Quicken I'm using. Of course I don't know that, so I'm contacting you. Is there anything you can check? Inclosed is the error code which is meaningless to me.
Jerry

• Error_picture.tiff 72.3 KB

1. Support Staff 1 Posted by Jenny on 28 Jan, 2016 11:05 AM

   

   Hi Jerry,

   Can you confirm for me the steps you have taken to setup this connection with your bank?

   Many financial institutions will require you to enable your accounts for application-based online banking. You can accomplish this by asking your bank to set up your account for direct connections from Quicken. Moneydance uses exactly the same OFX server connection protocol as Quicken but your bank representative may not know this and mistakenly believe that you can not connect in Moneydance. Calling up your bank and stating precisely the following should get you started. "Please enable direct connect on my account such that I can connect to your servers directly with Quicken. Also give me the login credentials I need to connect Quicken to this service."

   Application-based online banking often requires a different login/PIN than the ones that are used for ATM or web-based banking. When you enable your account for access from Moneydance or Quicken, your financial institution should let you know what customer ID/login and PIN to use.

   Can you also send me the output of your Console Log? To do this run Moneydance and select Help --> Console Window. Then, copy and paste the output of the console window to this discussion.

   Jenny
   Infinite Kind Support

   • Edit

2. 2 Posted by jrduke1 on 28 Jan, 2016 10:46 PM

   

   > On Jan 28, 2016, at 3:05 AM, Jenny <[email blocked]> wrote:
   >
   > Hello Jenny,
   I go to online, set up online banking, and follow the instructions using new connection and selecting Scottrade Brokerage.
   I have a Scottrade Bank account also, and it works ok.
   I use the same user name and password that I use to log on to the web site, and Scottrade
   support tells me that is correct. As I said before, they do see that it is trying to connect, but fails.
   Here’s the log.

   Jerry
   >
   >
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   there are txn files to sync
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   syncing with dropbox: com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e
     checking for txn logs...
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Transaction files in com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e:
     81E2A21A-1F60-445A-AC71-A5287225E9B5.txn
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Could not apply tracnsaction javax.crypto.BadPaddingException: Given final block not properly padded
     done
     saving state file to dropbox...
   Saving state file to dropbox
   syncing txns after date: 20150128
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
     done (15 ms)
     removing processed txn logs...
     done
   syncing finished
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   there are txn files to sync
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   syncing with dropbox: com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e
     checking for txn logs...
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Transaction files in com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e:
     81E2A21A-1F60-445A-AC71-A5287225E9B5.txn
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Could not apply tracnsaction javax.crypto.BadPaddingException: Given final block not properly padded
     done
     saving state file to dropbox...
   Saving state file to dropbox
   syncing txns after date: 20150128
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
     done (17 ms)
     removing processed txn logs...
     done
   syncing finished
   setStatus(Downloading Transactions..., -1.0)
   Sending message to https://ofx.scottrade.com
   >>>>>>>>

   OFXHEADER:100
   DATA:OFXSGML
   VERSION:102
   SECURITY:NONE
   ENCODING:USASCII
   CHARSET:1252
   COMPRESSION:NONE
   OLDFILEUID:NONE
   NEWFILEUID:NONE

   <OFX>
   <SIGNONMSGSRQV1>
   <SONRQ>
   <DTCLIENT>20160128143747.929
   <USERID>25642547
   <USERPASS/>
   <GENUSERKEY>N
   <LANGUAGE>ENG
   <FI>
   <ORG>Scottrade
   <FID>777
   </FI>
   <APPID>QWIN
   <APPVER>2400
   </SONRQ>
   </SIGNONMSGSRQV1>
   <INVSTMTMSGSRQV1>
   <INVSTMTTRNRQ>
   <TRNUID>1454020667929-27
   <INVSTMTRQ>
   <INVACCTFROM>
   <BROKERID>www.scottrade.com
   <ACCTID>25642547
   </INVACCTFROM>
   <INCTRAN>
   <INCLUDE>Y
   </INCTRAN>
   <INCOO>N
   <INCPOS>
   <INCLUDE>Y
   </INCPOS>
   <INCBAL>Y
   </INVSTMTRQ>
   </INVSTMTTRNRQ>
   </INVSTMTMSGSRQV1>
   </OFX>

   <<<<77<<<<
   HTTP response headers:
   null: [HTTP/1.1 400 Bad Request]
   Date: [Thu, 28 Jan 2016 22:37:49 GMT]
   Content-Length: [54]
   Content-Type: [application/x-ofx]
   Connection: [close]
   Accept-Ranges: [None]
   Server: [IFS-HTTP/3.5.4]
   Reading message from https://ofx.scottrade.com
   >>>>>>>>

   java.io.IOException: HTTP Error:400 Bad Request
   at com.moneydance.apps.md.controller.olb.ofx.OFXConnection.sendMessage(OFXConnection.java:2602)
   at com.moneydance.apps.md.controller.olb.ofx.OFXConnection.sendMessage(OFXConnection.java:2510)
   at com.moneydance.apps.md.controller.olb.ofx.OFXConnection.getTransactions(OFXConnection.java:953)
   at com.moneydance.apps.md.view.gui.OnlineManager.downloadTransactions(OnlineManager.java:632)
   at com.moneydance.apps.md.view.gui.OnlineManager.downloadTransactions(OnlineManager.java:552)
   at com.moneydance.apps.md.view.gui.InvestAccountDetailPanel$DLTxnsRunnable.run(InvestAccountDetailPanel.java:528)
   at com.moneydance.apps.md.controller.BackgroundOpsThread.run(BackgroundOpsThread.java:109)
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   there are txn files to sync
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   syncing with dropbox: com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e
     checking for txn logs...
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Transaction files in com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e:
     81E2A21A-1F60-445A-AC71-A5287225E9B5.txn
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Could not apply tracnsaction javax.crypto.BadPaddingException: Given final block not properly padded
     done
     saving state file to dropbox...
   Saving state file to dropbox
   syncing txns after date: 20150128
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   setStatus(Finished syncing with , 0.0)
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
     done (12 ms)
     removing processed txn logs...
     done
   syncing finished
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   there are txn files to sync
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   syncing with dropbox: com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e
     checking for txn logs...
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Transaction files in com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e:
     81E2A21A-1F60-445A-AC71-A5287225E9B5.txn
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Could not apply tracnsaction javax.crypto.BadPaddingException: Given final block not properly padded
     done
     saving state file to dropbox...
   Saving state file to dropbox
   syncing txns after date: 20150128
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
     done (15 ms)
     removing processed txn logs...
     done
   syncing finished
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   there are txn files to sync
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   syncing with dropbox: com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e
     checking for txn logs...
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Transaction files in com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e:
     81E2A21A-1F60-445A-AC71-A5287225E9B5.txn
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Could not apply tracnsaction javax.crypto.BadPaddingException: Given final block not properly padded
     done
     saving state file to dropbox...
   Saving state file to dropbox
   syncing txns after date: 20150128
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
     done (16 ms)
     removing processed txn logs...
     done
   syncing finished
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   there are txn files to sync
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   syncing with dropbox: com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e
     checking for txn logs...
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Transaction files in com.moneydance.modules.features.netsync.DropboxFSInterface@7de6385e:
     81E2A21A-1F60-445A-AC71-A5287225E9B5.txn
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   Could not apply tracnsaction javax.crypto.BadPaddingException: Given final block not properly padded
     done
     saving state file to dropbox...
   Saving state file to dropbox
   syncing txns after date: 20150128
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
   is /Users/jstandarduser/Dropbox connected?
     folder exists
     can write
     done (14 ms)
     removing processed txn logs...
     done
   syncing finished

   • Edit

3. 3 Posted by Ian L on 29 Jan, 2016 02:21 PM

   

   Hi Jerry,

   What version of Moneydance are you using? Also, has this connection ever worked, or is the first time you are trying to connect to this account?

   Ian
   Infinite Kind Support

   • Edit

4. 4 Posted by jrduke1 on 29 Jan, 2016 08:58 PM

   

   I tried to make this work using both Md 2011 and 2015 v1334. I've tried many times in the past to set this up. It has never worked. As I have said the Scottrade bank does work, and always has.

   Jerry

   • Edit

5. 5 Posted by Ian L on 01 Feb, 2016 04:12 PM

   

   Instead of your website username, can you try using your account number as your login ID? Use the same password as you use on the website.

   Ian
   Infinite Kind Support

   • Edit

6. 6 Posted by jrduke1 on 01 Feb, 2016 06:51 PM

   

   Hi Ian,

   I have always used the account number in the username login procedure.

   Jerry

   • Edit

7. 7 Posted by Ian L on 02 Feb, 2016 02:37 PM

   

   I've tweaked our Scottrade connection a bit to see if that allows you to connect. Can you try re-creating your connection with your financial institution and see if that fixes the issue that you're seeing? You will need to disable your current connection to your bank and then recreate it using the New Connection button on the Online Banking Setup screen. To do so, you can follow these steps:

   1. Select your bank account in Moneydance

      
   2. Select the Online->Setup Online Banking button/menu

      
   3. Click the "Disable" button.  If you don't see a disable button, just close the setup window.

      
   4. Repeat the previous steps for any additional accounts at the same institution.
      
   5. Select the Online->Setup Online Banking button/menu (again)

      
   6. Click the "New Connection" button and select your bank and hit OK
      
   7. Continue with the setup process, entering your username/password


   Make sure you pick new connection, even though your bank is still one of the connection choices after you disable it. Choosing your bank from the list of available banks will force Moneydance to download the updated information, which should then allow you to connect.

   Please let me know if you continue to have connection problems after recreating your connection.

   Ian
   Infinite Kind Support

   • Edit

8. 8 Posted by jrduke1 on 02 Feb, 2016 11:41 PM

   

   Ian,
   Followed your instructions.The set up looked normal. Still got the error.

   Jerry

   • Edit

9. 9 Posted by Ian L on 03 Feb, 2016 12:46 PM

   

   Does your password contain any non-alphanumeric characters like underscores or exclamation points? If so, could you try resetting your password so that it only contains numbers and letters to see if that works?

   If that still doesn't work, could you try connecting in a completely new Moneydance file? You can create a new file using the File->New menu option.

   Ian
   Infinite Kind Support

   • Edit

10. 10 Posted by jrduke1 on 04 Feb, 2016 07:33 PM

    

    Hi Ian,

    It worked when I used a new MD file. Is there a way to fix my original file as it would be easer. I wouldn’t have to enter a bunch of new securities.

    Jerry

    • Edit

11. 11 Posted by Ian L on 05 Feb, 2016 08:46 PM

    

    Can you try completely resetting your connection in your original file to see if that fixes the problem you're seeing? To do this, you'll need to force clear the current connection information for your bank in Moneydance. I'm sending two files called remove_one_service_2015.py (for Moneydance 2015) and remove_one_service.py (for older versions) that will help do that. Before proceeding, please back up your Moneydance data set, just in case something goes wrong. So far, this hasn't caused any problems, but better safe than sorry!

    To use the file, first save it to your computer and then follow these steps:

    1. In Moneydance, click on the Extensions Menu and choose the Manage Extensions option.
       
    2. From the list of available extensions, choose the Python Interface extension, then click Install to download the extension and finish to complete the installation.
       
    3. Close the Manage Extensions window.
       
    4. Again, click the Extensions menu. This time, choose the Python Interface option.
       
    5. In the python window, click the read from file button and load the file from whereever you saved it. You will be asked to select which connection you want to clear. Choose your bank, and click OK. You'll get a confirmation message when the connection has been removed. Close the window when done.
       
    6. Set up the connection to your bank like normal. Since all of your settings have been cleared, you should get the most recent connection information for your bank.

    Hopefully, that will work. If it doesn't, let me know and we'll continue troubleshooting.

    Ian
    Infinite Kind Support

    • remove_one_service_2015.py 672 Bytes
    • remove_one_service.py 511 Bytes
    • Edit

12. jrduke1 closed this discussion on 06 Feb, 2016 07:01 AM.