Bug 442665 - Mapping new account to existing bank errors
Summary: Mapping new account to existing bank errors
Status: REOPENED
Alias: None
Product: kmymoney
Classification: Applications
Component: onlinebanking (show other bugs)
Version: 5.1.2
Platform: Appimage Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-18 16:44 UTC by Eleazar
Modified: 2023-08-06 19:15 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eleazar 2021-09-18 16:44:02 UTC
SUMMARY
When mapping new account for an existing bank I get an error while updating the already mapped account is successful.

STEPS TO REPRODUCE
1. Select Account -> Map account -> OFXImporter
2. Select same bank as other mapped account (in my case Fidelity Investments)
3. In credentials page, enter your credentials
4. Select next

OBSERVED RESULT
When credentials page loads Notification loads stating "Certificate verification of OFX host failed. Last successful verification was on ..."
When I hit next I get the popup saying "No suitable accounts were found at this bank" and I can see an error in the console.

Starting eventloop
Finishing eventloop
Ending eventloop
Starting eventloop
OfxHttpRequest::slotOfxConnected "/home/eagleboy/.local/share/kmymoney/response.ofx"
Finishing eventloop
Ending eventloop
LibOFX ERROR: find_dtd():Unable to find the DTD named opensp.dcl
LibOFX ERROR: find_dtd():Unable to find the DTD named ofx160.dtd
LibOFX ERROR: ofx_proc_file(): FATAL: Missing DTD, aborting

But the OFX seems to have valid data.

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

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20210918123619.541[-4:EDT]<LANGUAGE>ENG<FI><ORG>fidelity.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS><TRNUID>20210918103618.000<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><ACCTINFORS><DTACCTUP>20210918033009.000[-4:EDT]<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>XXXXXXXXX</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>YYYYYYYYY</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>111111111</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>222222222</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO></ACCTINFORS></ACCTINFOTRNRS></SIGNUPMSGSRSV1></OFX>

EXPECTED RESULT
Accounts to load in selection screen

SOFTWARE/OS VERSIONS
Linux: Kubuntu 20.04
KDE Plasma Version: 5.18.5
KDE Frameworks Version: 5.68.0
Qt Version: 5.12.8

ADDITIONAL INFORMATION
App image build 972
Comment 1 Jack 2021-09-18 16:55:05 UTC
What distro are you using, or is this compiled from source?  More important, what version of libofx do you have?  The critical error is the missing DTD, and on my system, both of those missing files are part of the libofx package.
Comment 2 Eleazar 2021-09-18 17:08:18 UTC
(In reply to Jack from comment #1)
> What distro are you using, or is this compiled from source?  More important,
> what version of libofx do you have?  The critical error is the missing DTD,
> and on my system, both of those missing files are part of the libofx package.

Nightly Build (App Image Build 972) and OFX 1:0.9.15-3build1

OP provided info:
SOFTWARE/OS VERSIONS
Linux: Kubuntu 20.04
KDE Plasma Version: 5.18.5
KDE Frameworks Version: 5.68.0
Qt Version: 5.12.8

ADDITIONAL INFORMATION
App image build 972
Comment 3 Thomas Baumgart 2021-09-28 14:41:06 UTC
Looks like the AppImage version is looking in the wrong spot to find the files and picks them up from the installed version:

openat(AT_FDCWD, "/home/appimage//appimage-workspace//deps/usr/share/libofx/dtd/opensp.dcl", O_RDONLY) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, "/usr/local/share/libofx/dtd/opensp.dcl", O_RDONLY) = 16
openat(AT_FDCWD, "/home/appimage//appimage-workspace//deps/usr/share/libofx/dtd/ofx160.dtd", O_RDONLY) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, "/usr/local/share/libofx/dtd/ofx160.dtd", O_RDONLY) = 16

We have to find out what needs to be tweaked so that libofx looks in the right directory inside the AppImage.
Comment 4 Jack 2023-07-05 23:13:26 UTC
I'm guessing this has actually been fixed.  Would be great to get confirmation, otherwise, the bot will close in 30 (?) days.
Comment 5 Bug Janitor Service 2023-07-20 03:45:08 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 6 Bug Janitor Service 2023-08-04 03:44:59 UTC
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!
Comment 7 Eleazar 2023-08-06 18:49:52 UTC
Still not working for me.
Kubuntu 22.04
KDE Plasma: 5.24.7
KDE Frameworks: 5.92.0
QT Version: 5.15.3
Kernel: 6.2.0.26-generic
Graphics Platform: X11
KMyMoney: App image Build 5.1.3-fb2f0d78f



Output
Starting eventloop
Finishing eventloop
Ending eventloop
LibOFX ERROR: find_dtd():Unable to find the DTD named opensp.dcl
LibOFX ERROR: find_dtd():Unable to find the DTD named ofx160.dtd
LibOFX ERROR: ofx_proc_file(): FATAL: Missing DTD, aborting




temp file (/tmp/libofxtmpjXQtqS)
<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20220630230432.874[-4:EDT]<LANGUAGE>ENG<FI><ORG>fidelity.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS><TRNUID>20220630210431.000<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><ACCTINFORS><DTACCTUP>20220630033004.000[-4:EDT]<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>X83729002</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>Z19707573</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>218870983</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>226262907</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO></ACCTINFORS></ACCTINFOTRNRS></SIGNUPMSGSRSV1></OFX>
~
Comment 8 Eleazar 2023-08-06 19:15:08 UTC
Tried with the nightly build
Kubuntu 22.04
KDE Plasma: 5.24.7
KDE Frameworks: 5.92.0
QT Version: 5.15.3
Kernel: 6.2.0.26-generic
Graphics Platform: X11
KMyMoney: App image Build (5.1.80-a29dfd559) kmymoney-master-572-linux-gcc-x86_64.appimage

Output 
Starting eventloop
Finishing eventloop
Ending eventloop
LibOFX ERROR: find_dtd():Unable to find the DTD named opensp.dcl
LibOFX ERROR: find_dtd():Unable to find the DTD named ofx160.dtd
LibOFX ERROR: ofx_proc_file(): FATAL: Missing DTD, aborting

Valid Reponse (/tmp/libofxtmpj1jiab)
<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20220630230432.874[-4:EDT]<LANGUAGE>ENG<FI><ORG>fidelity.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS><TRNUID>20220630210431.000<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><ACCTINFORS><DTACCTUP>20220630033004.000[-4:EDT]<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>X83729002</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>Z19707573</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>218870983</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>226262907</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO></ACCTINFORS></ACCTINFOTRNRS></SIGNUPMSGSRSV1></OFX>