Retrieve Transactions Error

[Stefan]

Hello,

I am trying to retieve transactions from 2 brokers.
They both worked fine for the last year. However today, only one works OK.
From the second one I receive "Missing ACCTINFORs in reply" error. Every time I try.
Could you please let me know what can I do to get this fixed?

[Mark]

Hi Stefan,

My guess is that it is a temporary problem with your broker's OFX server. I'd suggest trying again, and if you still have problems, take a look at the log file. You can look in the "ofxretr.txt" file, and see the raw response from the OFX server. If you'd like to send us this file, we can look at it for you. You may also want to call your broker, and ask them if they are aware of any problems with their OFX server. For more on finding the log files, see the bottom of this page:

http://www.fundmanagersoftware.com/tintrtv.html

[Stefan]

Looking into the ofxretr.txt file I see this error:

<STATUS><CODE>400<SEVERITY>ERROR<MESSAGE>Date/Time must be JDBC format</STATUS>

Is this something on the Broker's end?

[Mark]

Hi Stefan,

I'm not sure what that means. Does the response start with <OFX> ? Did you show the whole response? All OFX servers should have a <OFX> beginning in their response. I would suggest calling the broker. What broker is this?

[Stefan]

here is the whole response from the server:

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

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20100820122924.000[-4:EDT]<LANGUAGE>ENG<DTPROFUP>20100820192943.525[-4:EDT]<DTACCTUP>20100820192943<FI><ORG>smithbarney.com<FID>5207</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS><TRNUID>19081-FM7-20100820162924-250<STATUS><CODE>400<SEVERITY>ERROR<MESSAGE>Date/Time must be JDBC format</STATUS></ACCTINFOTRNRS></SIGNUPMSGSRSV1></OFX>

[Mark]

Hi Stefan,

That to me sounds like an internal database query error. If you adjust your date range settings for the retrieve, does that have any effect? It really shouldn't matter, but might be interesting to try. I would call the broker, and ask them about it.

[Stefan]

I've seen a message on the site that they are doing some maintenance work which will extend into the week-end. I think this may affect it, but I won't investigate further at this point. I'll try again in a day.

Thank you!

[Stefan]

I spoke this morning with the SmithBarney online download services support. They said they had no reported problem with OFX servers.
But they didn't want to try debugging FM with me because they support only Money or Quicken. And Money support ends at the end of the 2010.
I tried to talk to them about "a Money like" application, but they were very strict that only Money or Quicken are supported. Is there a way for you to test wirth them?
So, I am stuck here. I tried many times, I still get the same error as above.
My other brokerage account works fine.
Any ideas how I could progress here?

[Stefan]

Still working with SB on the issue. I installed Money 2007 and that didn't seem to work as well. So, now, I have managed to get to SB support and they are investigating the issue. It seems thay did make changes on the OFX servers over the week end and this may be the first feedback they got. So, for now, they are investigating the issue.

[Mark]

Hi Stefan,

That is unfortunate they will not look into it further... I tried testing it here, and I get the expected response of "Signon Invalid" (as I don't have a real account to test with). This is normal, and at least indicates that FM is talking to a real OFX server. I'm guessing the problem may be happening on a subsequent request though.

If you use the "File / New Portfolio Wizard" and start to set up a new account with Smith Barney, but leave the account number blank and enter a bogus login username/password, do you also get this same "Signon Invalid" error?

In these cases I used to suggest testing your account with MS Money, but I don't believe you can download a free trial of that anymore, as it is being discontinued. This, and that Smith Barney won't work with anything besides Quicken/Money makes debugging the problem difficult.

Another experiment you may try is to use the New Portfolio Wizard and enter your real details. Does that get past this error condition?

The actual error you're getting to me sounds like some internal configuration/script problem on their OFX server. The date format supplied by Fund Manager is according to the OFX spec. I suspect they are somehow converting it before making a request to their internal database, and that is not going well. Maybe you could send me (or post) the "ofxpost.txt" file that is present when you get this error. I can double check the date is formatted properly. The "ofxpost.txt" file contains the information Fund Manager sends to the OFX server. The "ofxretr.txt" contains the response for that posted request.

[Stefan]

Hello Mark,

Thank you for the reply. As I mentioned, I got MS Money 2007 and installed it and tried to connect to SB. It gave me the error "No active accounts" . So, apprently it logged on correctly but couuldn't find any transaction info. So, I think there is the same issue.
But, it enabled me to engage now SB support which is looking into the issue.
And they mentioned they did make changes to the OFX server over the weekend - so that is probably the issue.
They will call me and I will keep you posted. For now, I don't think there is any issue with FM - my other broker works fine with FM.

[Mark]

Hi Stefan,

Thanks for the update. My last post was made before I read the one you had posted right before it...

[Mario]

I just got off the line talking to the supervisor of the call center that supports Smith Barney. He put me on hold and went to talk to the programmers that are working on solving the retrieval problem that we are having with them. His response -

"they are aware of the problem and are working on a solution, but they would not commit to a fix date or time line".

The agent that first answered the call was a real "nice jerk" to be kind. Once I told him that I was using MSMoney 2007 and was having problems, he basically said 'too bad, so sad", we don't support Money, only Quicken and you are out of luck. Needless to say, I did not take kindly to that response and after a few choice words I told him to put me through to his supervisor, which resulted in the above response.

Any way, I told them that I would give them a week to fix it. After that, I'll call my broker and move my accounts to Fidelity. I never have a problem with them, their site and applications are much better than Smith Barney's and they charge me less.....

[Mark]

Hi Mario,

Thanks for sharing the status you found out on this issue.

[Stefan]

Mark: as far as I understand, both Money & Quicken use OFX.
If this is true then Quicken should not be working as well.
However, my impression is Quicken is they didn't have issues with Quicken, just with Money.
Do you know why this is so?