Note: Due to abuse of the open system we've had to limit anonymous access. To post a bug report or feature request, please sign up for an account using the Register link below.

Ticket #1572 (reopened defect)

Opened 6 months ago

Last modified 5 months ago

NCSECU OFX, HTTP ERROR:500 after bank update; manual setup overridden

Reported by: bootsmon Assigned to: sreilly
Priority: critical Milestone: Moneydance 2008
Component: onlinebanking Version: 2008.beta
Keywords: Cc:

Description

i receive an error message whenever i try to download transaction the State Employees Credit Union. the message is java.10.IOException:HTTP ERROR:500 INTERNAL SERVER ERROR

Change History

03/20/08 14:19:19 changed by bootsmon

i am also receiving ACCOUNT IS UPDATE for other accounts when they have new transactions available. nothing in this featkure seems to work.

(follow-up: ↓ 3 ) 03/20/08 16:19:19 changed by setiraz

  • priority changed from minor to major.
  • component changed from general to onlinebanking.

this sounds like an external error! Did you configure online settings correctly?
please add more information, see TracTicket_Basics

(in reply to: ↑ 2 ) 03/21/08 10:16:58 changed by gmaddry

Replying to setiraz:

this sounds like an external error! Did you configure online settings correctly?
please add more information, see TracTicket_Basics

I am also getting this error. It last worked on Mar 18. I called SECU and was told that Quicken and Money updated server information this week. There may have been other changes as the web site had a message that online banking would not be available after midnight on the 18. The error is happening with 2007 (587) and 2008 (603) I last connected using 2008 (602).

(follow-up: ↓ 5 ) 03/21/08 11:20:59 changed by setiraz

  • priority changed from major to minor.
  • type changed from defect to task.

this is indeed an external error/problem - please try to get those changed settings and set up onlinebanking manual...
would be nice if you could post that new setup here, would be easier for Sean to modify MD's list of settings for onlinebanking

(in reply to: ↑ 4 ) 03/21/08 11:41:59 changed by gmaddry

Replying to setiraz:

this is indeed an external error/problem - please try to get those changed settings and set up onlinebanking manual...
would be nice if you could post that new setup here, would be easier for Sean to modify MD's list of settings for onlinebanking

What changed settings? id gmaddry Gray Maddry

03/21/08 14:54:49 changed by gmaddry

From errlog.txt

X-Powered-By: [ASP.NET] null: [HTTP/1.1 500 Internal Server Error] Date: [Fri, 21 Mar 2008 19:17:09 GMT] PICS-Label: [(PICS-1.1 "http://www.rsac.org/ratingsv01.html" l by "administrator@ncsecu.org" on "2008.03.21T13:53-0400" exp "2012.03.21T12:00-0400" r (n 0 s 0 v 0 l 0 oa 0 ob 0 oc 0 od 0 oe 0 of 0 og 0 oh 0 c 0))(PICS-1.0 "http://www.rsac.org/ratingsv01.html" l by "administrator@ncsecu.org" on "2008.03.21T13:53-0400" exp "2012.03.21T12:00-0400" r (v 0 s 0 n 0 l 0))(PICS-1.1 "http://www.rsac.org/ratingsv01.html" l by "administrator@ncsecu.org" on "2008.03.21T13:53-0400" exp "2012.03.21T12:00-0400" r (l 0 s 0 v 0 o 0)), (PICS-1.1 "http://www.rsac.org/ratingsv01.html" l by "administrator@ncsecu.org" on "2008.03.21T13:53-0400" exp "2012.03.21T12:00-0400" r (n 0 s 0 v 0 l 0 oa 0 ob 0 oc 0 od 0 oe 0 of 0 og 0 oh 0 c 0))(PICS-1.0 "http://www.rsac.org/ratingsv01.html" l by "administrator@ncsecu.org" on "2008.03.21T13:53-0400" exp "2012.03.21T12:00-0400" r (v 0 s 0 n 0 l 0)), (PICS-1.1 "http://www.rsac.org/ratingsv01.html" l by "administrator@ncsecu.org" on "2008.03.21T13:53-0400" exp "2012.03.21T12:00-0400" r (n 0 s 0 v 0 l 0 oa 0 ob 0 oc 0 od 0 oe 0 of 0 og 0 oh 0 c 0))] Content-Type: [text/html] Server: [Microsoft-IIS/6.0]

Gray Maddry

03/26/08 16:52:24 changed by setiraz

new settings = parameters your financial institution now uses for online banking / direct banking / ofx
those things that even Money and Quicken need - if possible you can try to get the changed connection details from the setup/ini files of those apps

03/26/08 16:54:24 changed by setiraz

see also #1588 (also some more informations and links)

03/26/08 17:00:19 changed by setiraz

  • summary changed from my transactions quit downloading due to HTTP ERROR:500 to NCSECU OFX, HTTP ERROR:500 after bank update.

please try asking your financial institution about connection settings again

03/26/08 17:57:41 changed by wfaulk

To inline some data from my duplicate ticket #1588:

MSMoney claims that the new URL is https://onlineaccess.ncsecu.org/secuofx/secu.ofx, which is different than what Moneydance has, but this generates a 500 error in Moneydance, too.

I got info about the URL update here, which claims that the new URL is https://onlineaccess.ncsecu.org/secuofx/secu.ofx (and the Org and FID remain the same at "SECU" and 1001).

There's a thread on the forum about this that contains some (not very helpful) information from the bank.

A diff with an old version of the file (from here) shows only: 

40c40
< <ProviderURL>https://onlineaccess.ncsecu.org/scripts/SECUOFXWedge.dll</ProviderURL>
---
> <ProviderURL>https://onlineaccess.ncsecu.org/secuofx/secu.ofx</ProviderURL>
51c51
< <BrandingDate>1/30/2003</BrandingDate>
---
> <BrandingDate>11/27/2007</BrandingDate>
79a80
> <PayeeDelete>0</PayeeDelete>
93c94
< <Charge>0</Charge>
---
> <Charge>0.0000</Charge>

I have asked the bank for confirmation of this information and am waiting for a response.

03/26/08 18:22:21 changed by wfaulk

I should have linked to the forum thread.

03/26/08 23:03:03 changed by wfaulk

I have found the problem.

When I try to set up a manual connection in Moneydance, it decides that it knows better than I do and asks moneydance.com what it thinks the org "SECU" and fid "1001" should be by requesting (among other things) http://moneydance.com/synch/moneydance/fi2004dir/SECU-1001.dct, which has the old OFX URL. It then apparently overrides the URL I entered with the one it got from moneydance.com, which breaks the setup.

I can't give it bogus org and fid information, because that will break the actual OFX connection. But I can cause moneydance.com to resolve to an incorrect address by editing my hosts file, and when it doesn't get the information it wants, it ever so graciously tries to access the URL I provided. And it works.

So now this is a bug in Moneydance where manual connections aren't manual at all. I don't understand why it should override what I enter.

I'm going to post to the forum to give people the workaround and some more detailed instructions on how to do it.

03/26/08 23:32:30 changed by setiraz

  • priority changed from minor to critical.
  • type changed from task to defect.
  • summary changed from NCSECU OFX, HTTP ERROR:500 after bank update to NCSECU OFX, HTTP ERROR:500 after bank update; manual setup overridden.

03/27/08 09:13:20 changed by sreilly

  • status changed from new to closed.
  • resolution set to fixed.

Sorry about that. This should now be fixed.

03/27/08 09:40:28 changed by wfaulk

  • status changed from closed to reopened.
  • resolution deleted.

I see that that the contents of SECU-1001.dct have been updated, but has Moneydance been fixed so that manual connections aren't overridden? While this probably solves my immediate problem, the next time someone's bank changes its OFX URL, this problem will occur again unless the manual connection problem is resolved. Maybe it should be a new ticket?