ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

417 Expectation Failed

bug

#1

When I open the Profit and Loss Statement, I get a pre.load of the page and then this error:

I have checked the account and it seems that it is trying to load an asset account in a Profit and Loss Statement.

I also did a

bench migrate

and got no results.

Help!

jquery.min.js:4 GET http://[SERVER]/?report_name=Profit+and+Loss+Statement&filters=%7B%22company%22%3A%22[COMPANY]%22%2C%22from_fiscal_year%22%3A%222018%22%2C%22to_fiscal_year%22%3A%222018%22%2C%22periodicity%22%3A%22Monthly%22%7D&cmd=frappe.desk.query_report.run&_=1526068993207 417 (EXPECTATION FAILED)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1518210000.0:1548
frappe.call @ desk.min.js?ver=1518210000.0:1441
_refresh @ report.min.js?ver=1518210000.0:1280
(anonymous) @ report.min.js?ver=1518210000.0:1256
setTimeout (async)
refresh @ report.min.js?ver=1518210000.0:1255
(anonymous) @ report.min.js?ver=1518210000.0:1058
(anonymous) @ jquery.min.js:2
i @ jquery.min.js:2
add @ jquery.min.js:2
(anonymous) @ jquery.min.js:2
each @ jquery.min.js:2
(anonymous) @ jquery.min.js:2
Deferred @ jquery.min.js:2
then @ jquery.min.js:2
setup_report @ report.min.js?ver=1518210000.0:1057
(anonymous) @ report.min.js?ver=1518210000.0:1027
(anonymous) @ desk.min.js?ver=1518210000.0:1692
(anonymous) @ desk.min.js?ver=1518210000.0:1760
each @ jquery.min.js:2
(anonymous) @ desk.min.js?ver=1518210000.0:1759
dispatch @ jquery.min.js:3
$event.dispatch @ report.min.js?ver=1518210000.0:3020
r.handle @ jquery.min.js:3
trigger @ jquery.min.js:4
z @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
load (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1518210000.0:1548
frappe.call @ desk.min.js?ver=1518210000.0:1441
fetch @ desk.min.js?ver=1518210000.0:165
execute @ desk.min.js?ver=1518210000.0:130
frappe.require @ desk.min.js?ver=1518210000.0:79
(anonymous) @ VM340:4
_eval @ desk.min.js?ver=1518210000.0:518
callback @ report.min.js?ver=1518210000.0:1020
callback @ desk.min.js?ver=1518210000.0:1437
_ @ desk.min.js?ver=1518210000.0:1461
(anonymous) @ desk.min.js?ver=1518210000.0:1562
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
z @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
load (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1518210000.0:1548
frappe.call @ desk.min.js?ver=1518210000.0:1441
(anonymous) @ report.min.js?ver=1518210000.0:1014
callback @ desk.min.js?ver=1518210000.0:5459
callback @ desk.min.js?ver=1518210000.0:1437
_ @ desk.min.js?ver=1518210000.0:1461
(anonymous) @ desk.min.js?ver=1518210000.0:1562
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
z @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
load (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1518210000.0:1548
frappe.call @ desk.min.js?ver=1518210000.0:1441
with_doctype @ desk.min.js?ver=1518210000.0:5433
(anonymous) @ report.min.js?ver=1518210000.0:1009
callback @ desk.min.js?ver=1518210000.0:5498
callback @ desk.min.js?ver=1518210000.0:1437
_ @ desk.min.js?ver=1518210000.0:1461
(anonymous) @ desk.min.js?ver=1518210000.0:1562
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
z @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
load (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1518210000.0:1548
frappe.call @ desk.min.js?ver=1518210000.0:1441
with_doc @ desk.min.js?ver=1518210000.0:5489
load @ report.min.js?ver=1518210000.0:1005
(anonymous) @ report.min.js?ver=1518210000.0:898
dispatch @ jquery.min.js:3
$event.dispatch @ report.min.js?ver=1518210000.0:3020
r.handle @ jquery.min.js:3
trigger @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
each @ jquery.min.js:2
each @ jquery.min.js:2
trigger @ jquery.min.js:4
change_to @ desk.min.js?ver=1518210000.0:9430
(anonymous) @ desk.min.js?ver=1518210000.0:9633
with_page @ desk.min.js?ver=1518210000.0:9599
(anonymous) @ desk.min.js?ver=1518210000.0:9627
with_doctype @ desk.min.js?ver=1518210000.0:5426
show @ desk.min.js?ver=1518210000.0:9626
frappe.route @ desk.min.js?ver=1518210000.0:2195
startup @ desk.min.js?ver=1518210000.0:12110
load_startup @ desk.min.js?ver=1518210000.0:12079
init @ desk.min.js?ver=1518210000.0:12075
Class @ desk.min.js?ver=1518210000.0:37
frappe.start_app @ desk.min.js?ver=1518210000.0:12059
(anonymous) @ desk.min.js?ver=1518210000.0:12070
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
ready @ jquery.min.js:2
J @ jquery.min.js:2
14:03:15.139 desk.min.js?ver=1518210000.0:1649 Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 62, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 22, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 53, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 939, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 96, in run
res = frappe.get_attr(method_name)(frappe._dict(filters))
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/profit_and_loss_statement/profit_and_loss_statement.py”, line 16, in execute
ignore_closing_entries=True, ignore_accumulated_values_for_fy= True)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py”, line 135, in get_data
calculate_values(accounts_by_name, gl_entries_by_account, period_list, accumulated_values, ignore_accumulated_values_for_fy)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py”, line 153, in calculate_values
raise_exception=1
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 309, in msgprint
_raise_exception()
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 284, in _raise_exception
raise ValidationError(encode(msg))
ValidationError: Could not retrieve information for [ACCOUNT].


#2

Is there any customisation?


#3

On that specific report, there isn’t, but the ERPNext instance does have custom software on it.

I also massive loaded the accounts via the Database. The odd thing is that it used to work, but now it no longer does.