ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Crash ERPNext v11 when acces option "Data export"

erpnext-version-11

#1

When I enter “Data export”, I get to enter the first screen, then when I try to search for Doctypes, the field does not show any doctype, then immediately the ERPNext site can no longer be accessed from the browser.

Data:
ERPNext v11
ERPNext language: Spanish
User in session: administrator
Security permissions: The administrator user has permission to export

HELP PLEASE


#2

Works fine on my test build.

Any error message in the browser’s console?


#3

Please test in language spanish, there the error appears.


#4

I test in this version and crash:

ERPNext: v11.0.3-beta.15 () (staging)
Frappe Framework: v11.0.3-beta.15 () (staging)


#5

I update the version, I can not export yet, when trying to find a datetype it does not show any and then the system hangs up and does not allow to enter

ERPNext: v11.0.3-beta.19 () (staging)
Frappe Framework: v11.0.3-beta.22 () (staging)


#6

Crash:


#7

Even crashes when trying to find a doctype in the export module, I created a new instance by selecting the following commands, the installation I made was in English and selecting the country Indian, adding all types of companies.

Sending error in browser console for detail

Install instance:

sudo bash -c 'for i in update {,dist-}upgrade auto{remove,clean}; do apt-get $i -y; done'

sudo apt-get install python-minimal -y

wget https://raw.githubusercontent.com/frappe/bench/master/playbooks/install.py

sudo python install.py --production --user frappe --bench-branch master --frappe-branch staging --erpnext-branch staging --mysql-root-password F6471b749ad84c234Haced9b82 --admin-password F6471b749ad84c234Haced9b82

Instance:
Ubuntu: 16.04 64bits
Test in ERPNext: v11.0.3-beta.19 () (staging)
Frappe Framework: v11.0.3-beta.22 () (staging)
Language: English
Country: Indian

Console Error:

URL:
http://IP/?txt=&doctype=DocType&ignore_user_permissions=0&filters=%7B%22issingle%22%3A0%2C%22istable%22%3A0%2C%22name%22%3A%5B%22in%22%2C%5B%22Identification+Document+Type%22%2C%22Cash+Flow+Mapper%22%2C%22Activity+Cost%22%2C%22Salary+Structure+Assignment%22%2C%22Supplier+Scorecard+Criteria%22%2C%22Lead+Source%22%2C%22Daily+Work+Summary+Group%22%2C%22Daily+Work+Summary%22%2C%22Asset%22%2C%22Vehicle%22%2C%22Department%22%2C%22Supplier+Scorecard%22%2C%22Territory%22%2C%22Loan%22%2C%22Employee+Benefit+Application%22%2C%22Contract%22%2C%22OAuth+Authorization+Code%22%2C%22Chat+Token%22%2C%22Asset+Movement%22%2C%22Landed+Cost+Voucher%22%2C%22Salary+Component%22%2C%22Timesheet%22%2C%22User+Permission%22%2C%22Item+Web+Detail%22%2C%22Employee+Transfer+Property%22%2C%22Translation%22%2C%22Delivery+Trip%22%2C%22Stock+Entry%22%2C%22Address+Template%22%2C%22Price+List%22%2C%22GSuite+Templates%22%2C%22Account%22%2C%22Employee+Advance%22%2C%22Shift+Assignment%22%2C%22Item+Price%22%2C%22Supplier+Scorecard+Standing%22%2C%22Website+Theme%22%2C%22Training+Result%22%2C%22Razorpay+Settings%22%2C%22Data+Export%22%2C%22Shopify+Log%22%2C%22Tax+Withholding+Category%22%2C%22Loyalty+Point+Entry%22%2C%22Expense+Claim%22%2C%22Customs+Tariff+Number%22%2C%22Custom+DocPerm%22%2C%22Employee+Incentive%22%2C%22Campaign%22%2C%22Opportunity+Type%22%2C%22Finance+Book%22%2C%22Error+Snapshot%22%2C%22Employee+Onboarding+Template%22%2C%22Employee+Onboarding%22%2C%22Calendar+View%22%2C%22Operation%22%2C%22Sales+Order%22%2C%22Journal+Entry%22%2C%22Event%22%2C%22Leave+Allocation%22%2C%22Item+Alternative%22%2C%22Leave+Policy%22%2C%22Attendance%22%2C%22Project+Update%22%2C%22PayPal+Settings%22%2C%22Employee+Benefit+Claim%22%2C%22Compensatory+Leave+Request%22%2C%22GoCardless+Mandate%22%2C%22Shipping+Rule%22%2C%22Data+Migration+Mapping%22%2C%22Supplier%22%2C%22Version%22%2C%22Tag+Category%22%2C%22Routing%22%2C%22Deleted+Document%22%2C%22Webhook%22%2C%22Auto+Email+Report%22%2C%22Work+Order%22%2C%22Asset+Repair%22%2C%22ToDo%22%2C%22UOM%22%2C%22Blanket+Order%22%2C%22Transaction+Log%22%2C%22Asset+Maintenance+Team%22%2C%22Role+Profile%22%2C%22Prepared+Report%22%2C%22Payment+Terms+Template%22%2C%22Activity+Type%22%2C%22Chat+Profile%22%2C%22Payroll+Period%22%2C%22Data+Migration+Connector%22%2C%22Country%22%2C%22Share+Transfer%22%2C%22Supplier+Scorecard+Period%22%2C%22Training+Program%22%2C%22Subscription%22%2C%22Sales+Partner+Type%22%2C%22Loyalty+Program%22%2C%22Quality+Inspection+Template%22%2C%22Email+Rule%22%2C%22Customer+Group%22%2C%22Budget%22%2C%22Project+Type%22%2C%22Contact%22%2C%22POS+Closing+Voucher%22%2C%22Hub+Tracked+Item%22%2C%22Material+Request%22%2C%22Training+Event%22%2C%22Market+Segment%22%2C%22Attendance+Request%22%2C%22Payment+Request%22%2C%22Cash+Flow+Mapping+Template%22%2C%22Item%22%2C%22GCalendar+Account%22%2C%22Employee+Tax+Exemption+Sub+Category%22%2C%22Currency%22%2C%22Brand%22%2C%22Employee+Separation+Template%22%2C%22LDAP+Settings%22%2C%22Loan+Type%22%2C%22Email+Unsubscribe%22%2C%22Accounting+Period%22%2C%22Notification%22%2C%22Bank+Statement+Settings%22%2C%22Cost+Center%22%2C%22Additional+Salary%22%2C%22Chat+Room%22%2C%22Custom+Role%22%2C%22Party+Type%22%2C%22Dropbox+Settings%22%2C%22Asset+Value+Adjustment%22%2C%22Payment+Entry%22%2C%22Retention+Bonus%22%2C%22Leave+Encashment%22%2C%22Pricing+Rule%22%2C%22Email+Group%22%2C%22Terms+and+Conditions%22%2C%22Email+Group+Member%22%2C%22Travel+Request%22%2C%22Driver%22%2C%22Employee+Tax+Exemption+Category%22%2C%22Employee+Promotion%22%2C%22User%22%2C%22Stock+Ledger+Entry%22%2C%22Leave+Period%22%2C%22Domain%22%2C%22Job+Applicant+Source%22%2C%22GL+Entry%22%2C%22Quotation%22%2C%22Employee+Transfer%22%2C%22Cash+Flow+Mapping+Template+Details%22%2C%22Social+Login+Key%22%2C%22OAuth+Client%22%2C%22Shift+Type%22%2C%22Cheque+Print+Template%22%2C%22Email+Template%22%2C%22Issue+Type%22%2C%22Employee%22%2C%22POS+Profile+User%22%2C%22Purpose+of+Travel%22%2C%22Gender%22%2C%22Help+Article%22%2C%22GoCardless+Settings%22%2C%22Item+Group%22%2C%22Subscription+Plan%22%2C%22OAuth+Bearer+Token%22%2C%22Exchange+Rate+Revaluation%22%2C%22Asset+Maintenance%22%2C%22Shift+Request%22%2C%22Slack+Webhook+URL%22%2C%22Employment+Type%22%2C%22Serial+No%22%2C%22Feedback+Trigger%22%2C%22Bank+Guarantee%22%2C%22Employee+Grade%22%2C%22Salary+Structure%22%2C%22Asset+Category%22%2C%22UOM+Category%22%2C%22Data+Migration+Run%22%2C%22Integration+Request%22%2C%22Manufacturer%22%2C%22Cash+Flow+Mapping%22%2C%22Vehicle+Log%22%2C%22Location%22%2C%22Employee+Tax+Exemption+Declaration%22%2C%22Interest%22%2C%22Supplier+Group%22%2C%22Payment+Term%22%2C%22Job+Offer%22%2C%22Payment+Order%22%2C%22Staffing+Plan%22%2C%22Chat+Message%22%2C%22Warehouse%22%2C%22Employee+Tax+Exemption+Proof+Submission%22%2C%22Feedback+Request%22%2C%22Success+Action%22%2C%22Share+Type%22%2C%22Desktop+Icon%22%2C%22Employee+Separation%22%2C%22Website+Sidebar%22%2C%22Supplier+Scorecard+Variable%22%2C%22Shareholder%22%2C%22Address%22%2C%22Print+Style%22%2C%22Lead%22%2C%22Tax+Rule%22%2C%22Opportunity%22%2C%22Bank%22%2C%22Customer%22%2C%22Employee+Health+Insurance%22%2C%22List+Filter%22%2C%22Payment+Gateway+Account%22%2C%22Sales+Stage%22%2C%22Training+Feedback%22%2C%22Bank+Account%22%2C%22Batch%22%2C%22Job+Card%22%2C%22Auto+Repeat%22%2C%22Contract+Template%22%2C%22Kanban+Board%22%2C%22Leave+Application%22%2C%22Project%22%2C%22Email+Flag+Queue%22%2C%22UOM+Conversion+Factor%22%2C%22Blogger%22%2C%22Loan+Application%22%2C%22Data+Migration+Plan%22%2C%22DocShare%22%2C%22View+log%22%2C%22Cashier+Closing%22%2C%22Bank+Statement+Transaction+Entry%22%2C%22File%22%2C%22Salutation%22%2C%22Help+Category%22%2C%22Newsletter%22%2C%22Asset+Maintenance+Log%22%5D%5D%7D&cmd=frappe.desk.search.search_link&_=1541769241024

Request Header:

GET /?txt=&doctype=DocType&ignore_user_permissions=0&filters=%7B%22issingle%22%3A0%2C%22istable%22%3A0%2C%22name%22%3A%5B%22in%22%2C%5B%22Identification+Document+Type%22%2C%22Cash+Flow+Mapper%22%2C%22Activity+Cost%22%2C%22Salary+Structure+Assignment%22%2C%22Supplier+Scorecard+Criteria%22%2C%22Lead+Source%22%2C%22Daily+Work+Summary+Group%22%2C%22Daily+Work+Summary%22%2C%22Asset%22%2C%22Vehicle%22%2C%22Department%22%2C%22Supplier+Scorecard%22%2C%22Territory%22%2C%22Loan%22%2C%22Employee+Benefit+Application%22%2C%22Contract%22%2C%22OAuth+Authorization+Code%22%2C%22Chat+Token%22%2C%22Asset+Movement%22%2C%22Landed+Cost+Voucher%22%2C%22Salary+Component%22%2C%22Timesheet%22%2C%22User+Permission%22%2C%22Item+Web+Detail%22%2C%22Employee+Transfer+Property%22%2C%22Translation%22%2C%22Delivery+Trip%22%2C%22Stock+Entry%22%2C%22Address+Template%22%2C%22Price+List%22%2C%22GSuite+Templates%22%2C%22Account%22%2C%22Employee+Advance%22%2C%22Shift+Assignment%22%2C%22Item+Price%22%2C%22Supplier+Scorecard+Standing%22%2C%22Website+Theme%22%2C%22Training+Result%22%2C%22Razorpay+Settings%22%2C%22Data+Export%22%2C%22Shopify+Log%22%2C%22Tax+Withholding+Category%22%2C%22Loyalty+Point+Entry%22%2C%22Expense+Claim%22%2C%22Customs+Tariff+Number%22%2C%22Custom+DocPerm%22%2C%22Employee+Incentive%22%2C%22Campaign%22%2C%22Opportunity+Type%22%2C%22Finance+Book%22%2C%22Error+Snapshot%22%2C%22Employee+Onboarding+Template%22%2C%22Employee+Onboarding%22%2C%22Calendar+View%22%2C%22Operation%22%2C%22Sales+Order%22%2C%22Journal+Entry%22%2C%22Event%22%2C%22Leave+Allocation%22%2C%22Item+Alternative%22%2C%22Leave+Policy%22%2C%22Attendance%22%2C%22Project+Update%22%2C%22PayPal+Settings%22%2C%22Employee+Benefit+Claim%22%2C%22Compensatory+Leave+Request%22%2C%22GoCardless+Mandate%22%2C%22Shipping+Rule%22%2C%22Data+Migration+Mapping%22%2C%22Supplier%22%2C%22Version%22%2C%22Tag+Category%22%2C%22Routing%22%2C%22Deleted+Document%22%2C%22Webhook%22%2C%22Auto+Email+Report%22%2C%22Work+Order%22%2C%22Asset+Repair%22%2C%22ToDo%22%2C%22UOM%22%2C%22Blanket+Order%22%2C%22Transaction+Log%22%2C%22Asset+Maintenance+Team%22%2C%22Role+Profile%22%2C%22Prepared+Report%22%2C%22Payment+Terms+Template%22%2C%22Activity+Type%22%2C%22Chat+Profile%22%2C%22Payroll+Period%22%2C%22Data+Migration+Connector%22%2C%22Country%22%2C%22Share+Transfer%22%2C%22Supplier+Scorecard+Period%22%2C%22Training+Program%22%2C%22Subscription%22%2C%22Sales+Partner+Type%22%2C%22Loyalty+Program%22%2C%22Quality+Inspection+Template%22%2C%22Email+Rule%22%2C%22Customer+Group%22%2C%22Budget%22%2C%22Project+Type%22%2C%22Contact%22%2C%22POS+Closing+Voucher%22%2C%22Hub+Tracked+Item%22%2C%22Material+Request%22%2C%22Training+Event%22%2C%22Market+Segment%22%2C%22Attendance+Request%22%2C%22Payment+Request%22%2C%22Cash+Flow+Mapping+Template%22%2C%22Item%22%2C%22GCalendar+Account%22%2C%22Employee+Tax+Exemption+Sub+Category%22%2C%22Currency%22%2C%22Brand%22%2C%22Employee+Separation+Template%22%2C%22LDAP+Settings%22%2C%22Loan+Type%22%2C%22Email+Unsubscribe%22%2C%22Accounting+Period%22%2C%22Notification%22%2C%22Bank+Statement+Settings%22%2C%22Cost+Center%22%2C%22Additional+Salary%22%2C%22Chat+Room%22%2C%22Custom+Role%22%2C%22Party+Type%22%2C%22Dropbox+Settings%22%2C%22Asset+Value+Adjustment%22%2C%22Payment+Entry%22%2C%22Retention+Bonus%22%2C%22Leave+Encashment%22%2C%22Pricing+Rule%22%2C%22Email+Group%22%2C%22Terms+and+Conditions%22%2C%22Email+Group+Member%22%2C%22Travel+Request%22%2C%22Driver%22%2C%22Employee+Tax+Exemption+Category%22%2C%22Employee+Promotion%22%2C%22User%22%2C%22Stock+Ledger+Entry%22%2C%22Leave+Period%22%2C%22Domain%22%2C%22Job+Applicant+Source%22%2C%22GL+Entry%22%2C%22Quotation%22%2C%22Employee+Transfer%22%2C%22Cash+Flow+Mapping+Template+Details%22%2C%22Social+Login+Key%22%2C%22OAuth+Client%22%2C%22Shift+Type%22%2C%22Cheque+Print+Template%22%2C%22Email+Template%22%2C%22Issue+Type%22%2C%22Employee%22%2C%22POS+Profile+User%22%2C%22Purpose+of+Travel%22%2C%22Gender%22%2C%22Help+Article%22%2C%22GoCardless+Settings%22%2C%22Item+Group%22%2C%22Subscription+Plan%22%2C%22OAuth+Bearer+Token%22%2C%22Exchange+Rate+Revaluation%22%2C%22Asset+Maintenance%22%2C%22Shift+Request%22%2C%22Slack+Webhook+URL%22%2C%22Employment+Type%22%2C%22Serial+No%22%2C%22Feedback+Trigger%22%2C%22Bank+Guarantee%22%2C%22Employee+Grade%22%2C%22Salary+Structure%22%2C%22Asset+Category%22%2C%22UOM+Category%22%2C%22Data+Migration+Run%22%2C%22Integration+Request%22%2C%22Manufacturer%22%2C%22Cash+Flow+Mapping%22%2C%22Vehicle+Log%22%2C%22Location%22%2C%22Employee+Tax+Exemption+Declaration%22%2C%22Interest%22%2C%22Supplier+Group%22%2C%22Payment+Term%22%2C%22Job+Offer%22%2C%22Payment+Order%22%2C%22Staffing+Plan%22%2C%22Chat+Message%22%2C%22Warehouse%22%2C%22Employee+Tax+Exemption+Proof+Submission%22%2C%22Feedback+Request%22%2C%22Success+Action%22%2C%22Share+Type%22%2C%22Desktop+Icon%22%2C%22Employee+Separation%22%2C%22Website+Sidebar%22%2C%22Supplier+Scorecard+Variable%22%2C%22Shareholder%22%2C%22Address%22%2C%22Print+Style%22%2C%22Lead%22%2C%22Tax+Rule%22%2C%22Opportunity%22%2C%22Bank%22%2C%22Customer%22%2C%22Employee+Health+Insurance%22%2C%22List+Filter%22%2C%22Payment+Gateway+Account%22%2C%22Sales+Stage%22%2C%22Training+Feedback%22%2C%22Bank+Account%22%2C%22Batch%22%2C%22Job+Card%22%2C%22Auto+Repeat%22%2C%22Contract+Template%22%2C%22Kanban+Board%22%2C%22Leave+Application%22%2C%22Project%22%2C%22Email+Flag+Queue%22%2C%22UOM+Conversion+Factor%22%2C%22Blogger%22%2C%22Loan+Application%22%2C%22Data+Migration+Plan%22%2C%22DocShare%22%2C%22View+log%22%2C%22Cashier+Closing%22%2C%22Bank+Statement+Transaction+Entry%22%2C%22File%22%2C%22Salutation%22%2C%22Help+Category%22%2C%22Newsletter%22%2C%22Asset+Maintenance+Log%22%5D%5D%7D&cmd=frappe.desk.search.search_link&_=1541769241024 HTTP/1.1
Host: IP
Connection: keep-alive
Accept: application/json
X-Frappe-CSRF-Token: 4560151ff11f3bcca972ff536204e5b73b2682b749f31f8acd1e422d
X-Requested-With: XMLHttpRequest
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36
Referer: http://IP/desk
Accept-Encoding: gzip, deflate
Accept-Language: es-US,es;q=0.9,es-419;q=0.8,en;q=0.7
Cookie: selling_price_list=Venta%20est%C3%A1ndar; user_image=; system_user=yes; user_id=Administrator; full_name=Administrator; sid=265e7c60eae3acbc4685758eb645aeb705ff434718de37431c1da7f3; io=ZXZtplcXOe07mKYhAAAb

Response Header:

HTTP/1.1 400 Bad Request
Server: nginx
Date: Fri, 09 Nov 2018 13:14:51 GMT
Content-Type: text/html
Content-Length: 163
Connection: keep-alive

Response:

<html>
  <head>
    <title>Bad Request</title>
  </head>
  <body>
    <h1><p>Bad Request</p></h1>
    Request Line is too large (5739 &gt; 4094)
  </body>
</html>

#8

SOLVED: I have been configuring the supervisor “–limit-request-line 0”, I detail solution:

Added option --limit-request-line 0 into wsgi server startup line.

Config file [/home/erpnext/frappe-bench/config/supervisor.conf]:
line 2> command=/home/erpnext/frappe-bench/env/bin/gunicorn -b 127.0.0.1:8000 -w 2 -t 120 --limit-request-line 0 frappe.app:application

In order to apply changes restart wsgi server:

sudo supervisorctl reload

see the link where you get the solution (@David_Stegnitz)