getting below error while creating sales invoice File “apps/erp/erp/dairy_erp/doctype/bulk_upload_queue/bulk_upload_queue.py”, line 164, in generic_creation
doc.save()
File “apps/frappe/frappe/model/document.py”, line 301, in save
return self._save(*args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 323, in _save
if self.get(“__islocal”) or not self.get(“name”):
File “apps/frappe/frappe/model/document.py”, line 270, in insert
d.db_insert()
File “apps/frappe/frappe/model/base_document.py”, line 498, in db_insert
frappe.db.sql(
File “apps/frappe/frappe/database/database.py”, line 209, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 147, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 309, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1062, “Duplicate entry ‘powder’ for key ‘PRIMARY’”)
basically you are adding powder which is key of database basically primary key , check if any record exist for entry powder, maybe you are using powder as item-code ?
powder is item and item code. just creating SI for this item
use something unieque as item code anything different than powder i prefer some kind of naming series