OFX Direct Connect problem

Sat Feb 13 00:42:38 EST 2016

One other thing that might be worth trying is adding a Client UID to the user settings in Edit User in Aqbanking setup. The header version of 103 might effectively be telling the server that it should be expecting a Client UID. 

A possible test of the need for this effort would be to create a new data file in Quicken and try to connect to Advia. Quicken generates a ClientUID internally (and hides it from the user completely) and saves the generated value in the Quicken data file. If the ClientUID is really going to serve as a second authentication factor, the bank must have some way to validate the new value Quicken generates for your new file. I would expect that you’d get a message in Quicken telling you how to go about the validation. An additional possibility is that the bank only allows one ClientUID per customer — in which case you’d have to get them to reset your account to accept a new value.

A ClientUID is just a standard UUID without any hyphens. The error code in your original log file is an example of a standard UUID. I find it really curious that your error code is a unique number. Very weird. Maybe that’s the way they run the validation attempt.

Any unix system will generate a UUID with the command “uuidgen”. I don’t know if there is any easily accessible utilities for Windows. There are several UUID generators on the web, if it doesn’t freak you out to get such an item from a public place...
--
Dave Reiser
dbreiser at icloud.com

> On Feb 12, 2016, at 4:22 PM, Connie Reynolds <connie.aquarianessence at gmail.com> wrote:
> 
> Thanks. I tried that already. Notice it hasn't passed validation since Dec.
> 1, 2011. They have a new name and server now too, Advia and netteller. I'll
> call to see if they'll help, but the address I used is the one in the
> Quicken ofx log.
> 
> 
> http://www.aquarianessence.com/ <http://aquarianessence.com/>
> 
> On Fri, Feb 12, 2016 at 12:27 PM, jmk <jmk at cmail.nu> wrote:
> 
>> I don't know the answer but I suspect maybe you have the wrong URL for OFX
>> queries. See here:
>> 
>> http://www.ofxhome.com/index.php/institution/view/515
>> 
>> Usually the URL has 'ofx' in it somewhere. If those settings don't work
>> you'll probably have to contact the bank tech support and see if they can
>> help.
>> 
>> 
>> 
>> On 02/10/2016 01:36 PM, Connie Reynolds wrote:
>> 
>> I am attempting to replace Quicken 2013 while it is still not outdated. My
>> first round of attempts failed so I tried again by setting the program to
>> run in XP mode, thinking maybe it was a Vista problem. I am working with
>> Windows Vista, Gnucash 2.6.11, attempting to connect with Advia Credit
>> union, formerly First Community FCU. I used Quicken settings for the 2016
>> version, as suggested in another thread (app version 2500, Header version
>> 103). I wasn't able to retrieve accounts, receiving the message, "14:13:50
>> Saving communication log to /tmp/ofx.log
>> 14:13:50 Sending request...
>> 14:13:59 Using old SSL preparation code.
>> 14:13:59 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
>> 14:14:01 Waiting for response...
>> 14:14:02 Parsing response...
>> 14:14:02 Parsing response
>> 14:14:02 Error parsing response
>> 14:14:02 Operation finished, you can now close this window" so I entered
>> one manually, a checking account. My User settings are:
>> User name: my name as it appears on bank account
>> User ID: The acct# used to log in to one of my accounts
>> Bank Settings:
>> Bank name: First Community Federal Credit Union (MI) (Now Advia Credit
>> Union) (taken from the quicken ofx.log
>> FID: 7120
>> ORG: Advia Credit Union (as shown on quicken log)
>> Server URL:https://cm.netteller.com/login2008/Authentication/Views/Login.aspx?fi=1stcomm&bn=fbecbddd369f3ea2&burlid=2c80ca5f14ba73cc
>> (as shown on quicken log
>> 
>> I set up account with same acct#/ID as user, settings are:
>> Account number: same as above
>> Account name: same as above
>> Owner name: my name as appears on account
>> Currency: set to usd but keeps changing to Euro
>> Account type: Checking
>> Country: United States of America (US)
>> Bank code: 272483633 (this is routing number)
>> Bank name: First Community FCU now Advia Credit Union (as shown on quicken
>> log)
>> Selected user: (the user created above)
>> 
>> When I attempt to download transactions the message is,
>> AqBanking v5.5.1.0stable
>> Sending jobs to the bank(s)
>> Locking user FC********
>> Saving communication log to /tmp/ofx.log
>> Sending request...
>> Connecting to server...
>> Resolving hostname "cm.netteller.com" ...
>> IP address is "216.116.81.86"
>> Connecting to "cm.netteller.com"
>> Connected to "cm.netteller.com"
>> Using old SSL preparation code.
>> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
>> Connected.
>> Sending message...
>> Message sent.
>> Waiting for response...
>> Receiving response...
>> HTTP-Status: 200 (OK)
>> Response received.
>> Disconnecting from server...
>> Disconnected.
>> Parsing response...
>> Parsing response
>> Error parsing response
>> Unlocking user FC********
>> Postprocessing jobs
>> Job Get Transactions: finished
>> Resetting provider queues
>> 
>> The ofx log reads like an html document, title "error" and says "We're
>> sorry. While processing your request, we encountered a system-related
>> error. Your request was not processed. If this error persists, please
>> contact support.  Error Code: d82aa81d-7c37-4551-9521-268d898fe1c1
>> 
>> If I change the url to https://cm.netteller.com I get the same message and
>> log says:
>> Sending:
>> -------------------------------------
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:103
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20160210142734.000
>> <OFX><SIGNONMSGSRQV1><SONRQ><DTCLIENT>20160210142734.000<USERID>FC******
>> 
>> <USERPASS>*********
>> 
>> <LANGUAGE>ENG<FI><ORG>Advia Credit
>> Union<FID>7120</FI><APPID>QWIN<APPVER>2500</SONRQ></SIGNONMSGSRQV1><BANKMSGSRQV1><STMTTRNRQ><TRNUID>20160210142734.000<CLTCOOKIE>1<STMTRQ><BANKACCTFROM><BANKID>272483633<ACCTID>FC********<ACCTTYPE>CHECKING</BANKACCTFROM><INCTRAN><DTSTART>20150101000000.000<DTEND>20160210142726.000<INCLUDE>Y</INCTRAN></STMTRQ></STMTTRNRQ></BANKMSGSRQV1></OFX>
>> 
>> Received:
>> ------------------------------
>> -------
>> Thank you in advance for any suggestions that might work.
>> 
>> Connie
>> _______________________________________________
>> gnucash-user mailing listgnucash-user at gnucash.orghttps://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
>> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.