Production Order not opening

ERPNext
1

Hi all,

I have created a production order from BoM of final item. If I try to display or delete the production order, i get following error. can anyone help me in this regard.

   Did not loadServer Error: Please check your server logs or contact tech support.

Traceback (innermost last):
File “/home/erpnext/frappe-bench/apps/frappe/frappe/desk/form/load.py”, line 31, in getdoc
doc = frappe.get_doc(doctype, name)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 470, in get_doc
return frappe.model.document.get_doc(arg1, arg2)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 45, in get_doc
return controller(arg1, arg2)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 76, in init
self.load_from_db()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 104, in load_from_db
d = frappe.db.get_value(self.doctype, self.name, “*”, as_dict=1)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 390, in get_value
ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 425, in get_values
return self._get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 516, in _get_values_from_table
conditions, order_by), values, as_dict=as_dict, debug=debug, update=update)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 129, in sql
self._cursor.execute(query, values)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
ValueError: month must be in 1…12

Traceback (innermost last):
File “/home/erpnext/frappe-bench/apps/frappe/frappe/app.py”, line 51, in application
response = frappe.handler.handle()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py”, line 62, in handle
execute_cmd(cmd)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py”, line 85, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 718, in call
return fn(args, **newargs)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/desk/form/load.py”, line 31, in getdoc
doc = frappe.get_doc(doctype, name)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line 470, in get_doc
return frappe.model.document.get_doc(arg1, arg2)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 45, in get_doc
return controller(arg1, arg2)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 76, in init
self.load_from_db()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 104, in load_from_db
d = frappe.db.get_value(self.doctype, self.name, "", as_dict=1)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 390, in get_value
ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 425, in get_values
return self._get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 516, in _get_values_from_table
conditions, order_by), values, as_dict=as_dict, debug=debug, update=update)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 129, in sql
self._cursor.execute(query, values)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
ValueError: month must be in 1…12

Regards
Santosh

2

Can you replicate it on demo.erpnext.com ?

3

It is working on demo.erpnext.com.
I have created:
Items: rhpl tr, rhpl tr-10, rhpl tr-20, rhpl rm
Production orders: PRO-00173, PRO-00174, PRO-00175
BOM: BOM/rhpl tr-10/002, BOM/rhpl tr-20/001, BOM/rhpl tr/001

where rhpl rm is raw material, rhpl tr-10 and rhpl tr-20 are sub-assemblies, rhpl tr is final product.

4

Hi,

Thanks for your reply.
same error I am getting every time I create Production order.
Also in operation cost it is not multiplicating for number of items to be produced, instead it is taking the value of operation cost of 1 item mentioned in BOM.

Regards
Santosh

5

Santosh,

I am getting the same error when I try to open/delete my production order. How did u fix it?

6

Mubeen,

I think the problem was with workstation and operation timings. I have created shift timings and got resolved. But unable to access already submitted production order with errors.

7

Please let us know how we can replicate this.

8

Thanks.
I have deleted production order, BOM, workstation and recreated them. For workstation I have assigned shift timings and tried it again. It works for me without errors.

I think this problem is fixed in new version of virtual image.