Unable to find exchange rate for USD to CAD for key date 2020-01-07. Please create a Currency Exchange record manually

I got this new error on ERPNext latest version.

I created a manual entry but I dont get why the automatic currency dont work?
Any suggestions?

anyone? it was working fine, only did upgrade and not working anymore

Please post your error traceback, that really helps to troubleshoot!

I was able to find this!

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/setup/utils.py”, line 109, in get_exchange_rate
cache.setex(key, value, 6 * 60 * 60)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 1540, in setex
return self.execute_command(‘SETEX’, name, time, value)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 839, in execute_command
return self.parse_response(conn, command_name, **options)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 853, in parse_response
response = connection.read_response()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 718, in read_response
raise response
ResponseError: value is not an integer or out of range

What version are you on?

Perhaps update since cache.setex(key, value, 6 * 60 * 60)

has changed to this cache.set_value(key, value, expires_in_sec=6 * 60 * 60)


If that still fails try this named parameter:

cache.set_value(key, value=value, time=6 * 60 * 60)

edit: reference setex fails with "value is not an integer or out of range" · Issue #260 · redis/redis-py · GitHub

ERPNext: v12.3.1 (version-12)

Frappe Framework: v12.1.0 (version-12)

I get such an error when an instance does not have any connection to the internet (which is logical because it can’t fetch the rate from fixer.io).

I have some testing instances in Linux Containers on my Laptop and at times they loose external network connectivity while I still can access them through the local (on my machine) 10.19.225.xxx network.