Can't "Export" customers and addresses

URL: /desk#query-report/Customer Addresses and Contacts
Message: uncaught TypeError: Cannot read property ‘ref_doctype’ of undefined
report.min.js:103

I can’t export and initially it doesn’t load until hitting “Refresh”.
Please advise!

With Gratitude/Adam

Did you edit the report query?

No- we haven’t changed any queries.

I would suggest try bench update once.

I ran the update- which upgrade to v7 - and the error still persists. Please advise.

Can you share the full error trace?

Uncaught TypeError: Cannot read property ‘ref_doctype’ of undefined
(anonymous function) @ report.min.js:66
callback @ desk.min.js:538
callback @ desk.min.js:130
200 @ desk.min.js:132
(anonymous function) @ desk.min.js:137
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
z @ jquery.min.js:4(
anonymous function) @ jquery.min.js:4

This is not very helpful. Can you share the console log of the browser as well?

Kanchan- that is all that is in the browser console. There is no Python stack trace- it gets that far and stalls and the overlay prevents interaction. Any other ideas?

libs.min.js:3684 XHR finished loading: GET “http://erp.minerallogic.com/socket.io/?EIO=3&transport=polling&t=1474044169773-0”.Request.create @ libs.min.js:3684Request @ libs.min.js:3607XHR.request @ libs.min.js:3538XHR.doPoll @ libs.min.js:3568Polling.poll @ libs.min.js:3957Polling.doOpen @ libs.min.js:3901Transport.open @ libs.min.js:3078Socket.open @ libs.min.js:2508Socket @ libs.min.js:2390Socket @ libs.min.js:2325Manager.open.Manager.connect @ libs.min.js:1064Manager @ libs.min.js:922Manager @ libs.min.js:892lookup @ libs.min.js:825init @ desk.min.js:161startup @ desk.min.js:994load_startup @ desk.min.js:994init @ desk.min.js:994Class @ desk.min.js:7frappe.start_app @ desk.min.js:993(anonymous function) @ desk.min.js:994i @ jquery.min.js:2fireWith @ jquery.min.js:2ready @ jquery.min.js:2J @ jquery.min.js:2
jquery.min.js:4 XHR finished loading: GET “http://erp.minerallogic.com/?doctype=Report&name=Customer+Addresses+and+Contacts&cmd=frappe.desk.form.load.getdoc&_=1474044169198”.send @ jquery.min.js:4ajax @ jquery.min.js:4frappe.request.call @ desk.min.js:135frappe.call @ desk.min.js:131with_doc @ desk.min.js:538load @ report.min.js:66(anonymous function) @ report.min.js:51dispatch @ jquery.min.js:3$event.dispatch @ report.min.js:206r.handle @ jquery.min.js:3trigger @ jquery.min.js:4(anonymous function) @ jquery.min.js:4each @ jquery.min.js:2each @ jquery.min.js:2trigger @ jquery.min.js:4change_to @ desk.min.js:859(anonymous function) @ desk.min.js:871with_page @ desk.min.js:867(anonymous function) @ desk.min.js:869with_doctype @ desk.min.js:531show @ desk.min.js:869frappe.route @ desk.min.js:180startup @ desk.min.js:995load_startup @ desk.min.js:994init @ desk.min.js:994Class @ desk.min.js:7frappe.start_app @ desk.min.js:993(anonymous function) @ desk.min.js:994i @ jquery.min.js:2fireWith @ jquery.min.js:2ready @ jquery.min.js:2J @ jquery.min.js:2
report.min.js:66 Uncaught TypeError: Cannot read property ‘ref_doctype’ of undefined(anonymous function) @ report.min.js:66callback @ desk.min.js:538callback @ desk.min.js:130200 @ desk.min.js:132(anonymous function) @ desk.min.js:137i @ jquery.min.js:2fireWith @ jquery.min.js:2z @ jquery.min.js:4(anonymous function) @ jquery.min.js:4
libs.min.js:3684 XHR finished loading: GET “http://erp.minerallogic.com/socket.io/?EIO=3&transport=polling&t=1474044169929-1&sid=7qt_QpjcoiNOUjpHAAAQ”.Request.create @ libs.min.js:3684Request @ libs.min.js:3607XHR.request @ libs.min.js:3538XHR.doPoll @ libs.min.js:3568Polling.poll @ libs.min.js:3957Polling.onData @ libs.min.js:3996(anonymous function) @ libs.min.js:3571Emitter.emit @ libs.min.js:2100Request.onData @ libs.min.js:3719Request.onLoad @ libs.min.js:3790xhr.onreadystatechange @ libs.min.js:3672
libs.min.js:3684 XHR finished loading: GET “http://erp.minerallogic.com/socket.io/?EIO=3&transport=polling&t=1474044170121-2&sid=7qt_QpjcoiNOUjpHAAAQ”.Request.create @ libs.min.js:3684Request @ libs.min.js:3607XHR.request @ libs.min.js:3538XHR.doPoll @ libs.min.js:3568Polling.poll @ libs.min.js:3957Polling.onData @ libs.min.js:3996(anonymous function) @ libs.min.js:3571Emitter.emit @ libs.min.js:2100Request.onData @ libs.min.js:3719Request.onLoad @ libs.min.js:3790xhr.onreadystatechange @ libs.min.js:3672

maybe you can run once again:
frappe-bench$ bench switch-to-master
frappe-bench$ bench update --upgrade
frappe-bench$ bench update --patch
frappe-bench$ bench migrate

Ran it- it ran successfully; however, Same error: Uncaught TypeError: Cannot read property ‘ref_doctype’ of undefined. No additional console output.

can you try use another browser maybe use iexplore or mozilla or chrome…

I discovered this report works coming from SELLING module, but not from CRM module. May be a bug, but I have a solution.

Hello adcoment

I’m trying to export a report of all our Customer details and I don’t have the option to select addresses & contacts as a column in the report.

Any ideas why I can’t do this?

I am using v4.12

1 Like