Sales transactions not showing up on report

Hello Team

I am on a production site deployed, and transactions has been ongoing for couple of weeks now. We tried viewing report but nothing seems to show up

These are error logs from the site

Error Report

Python 2.7.6: /home/ubuntu/frappe-bench/env/bin/python (prefix: /home/ubuntu/frappe-bench/env)

Timestamp:
2017-10-02 18:11:49.677869
Relapsed
5
Exception

args (2, ‘No such file or directory’)
errno 2
filename ‘/home/ubuntu/frappe-bench/apps/erpnext/erpnext/stock/doctype/itemme’
message ‘’
strerror ‘No such file or directory’
Locals

path u’/home/ubuntu/frappe-bench/apps/erpnext/erpnext/stock/doctype/itemme’
self
templates {}
Traceback

/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py: 57

55
56 if frappe.local.form_dict.cmd:
57 response = frappe.handler.handle()
58
59 elif frappe.request.path.startswith(“/api/”):
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py: 22

20
21 if cmd!=‘login’:
22 data = execute_cmd(cmd)
23
24 if data:
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py: 53

51 is_whitelisted(method)
52
53 return frappe.call(method, **frappe.form_dict)
54
55
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py: 923

921 del newargs[“flags”]
922
923 return fn(*args, **newargs)
924
925 def make_property_setter(args, ignore_validate=False, validate_fields_for_doctype=True):
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/load.py: 71

69
70 if not docs:
71 docs = get_meta_bundle(doctype)
72
73 frappe.response[‘user_settings’] = get_user_settings(parent_dt or doctype)
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/load.py: 81

79
80 def get_meta_bundle(doctype):
81 bundle = [frappe.desk.form.meta.get_meta(doctype)]
82 for df in bundle[0].fields:
83 if df.fieldtype==“Table”:
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/meta.py: 22

20 def get_meta(doctype, cached=True):
21 if cached and not frappe.conf.developer_mode:
22 meta = frappe.cache().hget(“form_meta”, doctype, lambda: FormMeta(doctype))
23 else:
24 meta = FormMeta(doctype)
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py: 173

171 frappe.local.cache[_name][key] = value
172 elif generator:
173 value = generator()
174 try:
175 self.hset(name, key, value)
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/meta.py: 22

20 def get_meta(doctype, cached=True):
21 if cached and not frappe.conf.developer_mode:
22 meta = frappe.cache().hget(“form_meta”, doctype, lambda: FormMeta(doctype))
23 else:
24 meta = FormMeta(doctype)
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/meta.py: 34

32 def init(self, doctype):
33 super(FormMeta, self).init(doctype)
34 self.load_assets()
35
36 def load_assets(self):
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/meta.py: 41

39
40 if not self.istable:
41 self.add_code()
42 self.load_print_formats()
43 self.load_workflows()
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/meta.py: 87

85 self.add_code_via_hook(“doctype_calendar_js”, “__calendar_js”)
86 self.add_custom_script()
87 self.add_html_templates(path)
88
89 def _add_code(self, path, fieldname):
Locals
/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/form/meta.py: 99

97 return
98 templates = dict()
99 for fname in os.listdir(path):
100 if fname.endswith(“.html”):
101 with open(os.path.join(path, fname), ‘r’) as f:

Error
Traceback (most recent call last):
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/sales_invoice/pos.py”, line 481, in submit_invoice
si_doc.insert()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 233, in insert
raise e
DuplicateEntryError: (u’Sales Invoice’, u’SINV-00093’, IntegrityError(1062, “Duplicate entry ‘SINV-00093’ for key ‘PRIMARY’”))

@omolabake

What report were you trying to view?

You have a duplicate invoice number (it’s weird)…just remove one of them and it should be fine

Thank you this has been resoled