[kmymoney] [Bug 401137] New: Failed to retrieve an exchange rate - Update Stock & Currency Prices

[Michael Carpino]

https://bugs.kde.org/show_bug.cgi?id=401137

Bug ID: 401137
Summary: Failed to retrieve an exchange rate - Update Stock &
Currency Prices
Product: kmymoney
Version: git (master)
Platform: Manjaro
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: bugtracker
Assignee: kmymoney-***@kde.org
Reporter: ***@gmail.com
Target Milestone: ---

SUMMARY

When I update my Stock prices within KMM I receive a Price Update Failed
message. The message I receive is "Failed to retrieve an exchange rate for USD

E000015 from KMyMoney Currency. It will be skipped this time." This occurs 6

different times with my pricing updates. Within the status box this message
appears,
"Fetching URL https://fx-rate.net/USD/E000003...
Identifier found: 'USD/"'
Date found: 'Sat Nov 17 2018'
Unable to update price for USD > E000003 (no price or no date)"

The difference for each error is the "E0000..". I would like to stop receiving
these error messages but can't figure out a way to eliminate them.

STEPS TO REPRODUCE
1. Update stock prices
2.
3.

OBSERVED RESULT


EXPECTED RESULT

No error message as I have a valid stock price already updating.


SOFTWARE/OS VERSIONS

Linux/KDE Plasma: 4.19.1-1-MANJARO
(available in About System)
KDE Plasma Version: 5.14.3
KDE Frameworks Version: 5.52.0
Qt Version: 5.11.2

ADDITIONAL INFORMATION

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=401137

Thomas Baumgart <***@kde.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|REPORTED |NEEDSINFO
Resolution|--- |WAITINGFORINFO

--- Comment #1 from Thomas Baumgart <***@kde.org> ---
It looks like your data file has been corrupted for some reason which is
causing this. Here's howto check:

1. Open the investment view and select the securities tab
2. Check for any E###### in the symbol column
3. For those that contain such a value, you need to change the symbol

Here's how to do that:

1. Switch to the Equities tab in the investment view

Repeat the following steps for each one of the items in the above list

2. Select the relevant investment account (once for each account)
3. For each equity listed with a symbol of said format, right click on it and
select 'Edit investment...'.
4. Click 'Next'
5. Change the value of the trading symbol field to the needed symbol for price
update
6. Click 'Next', click 'Finish'

Depending on the version you use, you might not be able to do all this (a
recent git master or 5.0.2 is not affected). Please report back if you have
problems or the problem persists, the instructions are unclear or whatever.
Please close the bug as 'FIXED' 'WORKSFORME' in case you resolve the problem.

[Michael Carpino]

https://bugs.kde.org/show_bug.cgi?id=401137

--- Comment #2 from Michael Carpino <***@gmail.com> ---
I tried your recommendation, however, I can't edit the securities based on your
solution. The corruption is related to somehow the securities have been
labeled as a currency that don't exist.

I have attached 3 screenshots to help with possibly identifying the problem.
Screenshot 1 shows some of my securities. Please note Berkshire. Now go to
screenshot 2, Update Stock and Currency Prices, Berkshire's internal ID is
E000003. Screenshot 3, Update Stock and Currency prices, there is an ID Label
of USD > E000003 source KMyMoney Currency. I don't have a security nor a
currency labeled this in my database. The problem here is when I update prices
it keeps trying to update the 6 currencies in screen 3 labeled "USD > ....".

[Michael Carpino]

https://bugs.kde.org/show_bug.cgi?id=401137

--- Comment #3 from Michael Carpino <***@gmail.com> ---
Created attachment 116382
--> https://bugs.kde.org/attachment.cgi?id=116382&action=edit
Screenshot 1

[Michael Carpino]

https://bugs.kde.org/show_bug.cgi?id=401137

--- Comment #4 from Michael Carpino <***@gmail.com> ---
Created attachment 116383
--> https://bugs.kde.org/attachment.cgi?id=116383&action=edit
Screenshot 2

[Michael Carpino]

https://bugs.kde.org/show_bug.cgi?id=401137

--- Comment #5 from Michael Carpino <***@gmail.com> ---
Created attachment 116384
--> https://bugs.kde.org/attachment.cgi?id=116384&action=edit
Screenshot 3

[Michael Carpino]

https://bugs.kde.org/show_bug.cgi?id=401137

--- Comment #6 from Michael Carpino <***@gmail.com> ---
Created attachment 116385
--> https://bugs.kde.org/attachment.cgi?id=116385&action=edit
Screenshot 4

This screenshot shows the errors of the update

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=401137

--- Comment #7 from Thomas Baumgart <***@kde.org> ---
Thank you for the detailed screenshots. They explain a lot. Nevertheless, this
looks a bit strange.

Can you follow directions on
https://docs.kde.org/stable4/en/extragear-office/kmymoney/details.formats.anonymous.html
and send the anonymized file to my private mail address. Depending on the
version of KMyMoney you have, it could be, that you cannot create the
anonymized file (this used to be a bug fixed in 5.0.3). Consider using the
AppImage version to create it
(https://binary-factory.kde.org/job/KMyMoney_Nightly_Appimage_Build/)

[Michael Carpino]

https://bugs.kde.org/show_bug.cgi?id=401137

Michael Carpino <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDSINFO |RESOLVED
Resolution|WAITINGFORINFO |FIXED

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=401137

Thomas Baumgart <***@kde.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Resolution|FIXED |NOT A BUG

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=401137

--- Comment #8 from Thomas Baumgart <***@kde.org> ---
Created attachment 116642
--> https://bugs.kde.org/attachment.cgi?id=116642&action=edit
Script to remove invalid price pairs confusing the application

The problem was some corrupted data contained in the users file. The anonymous
file he provided helped a lot to analyze the problem and solve it (removing the
invalid data). I sent him the attached perl script wich took care of it.