I have been working on an syncing products from shopify to local database I get this massege: ERROR - Error during sync from Shopify to database: (pyodbc.IntegrityError) ('23000', "[23000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'VA_ID', table 'at98dbDemo.dbo.Articoli'; column does not allow nulls. INSERT fails. (515) (SQLExecDirectW); [23000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.
Closed this issue · 0 comments
DantoniShop commented
Please first make sure you have looked at:
- Documentation: https://github.com/mkleehammer/pyodbc/wiki
- Other issues
Environment
To diagnose, we usually need to know the following, including version numbers. On Windows, be
sure to specify 32-bit Python or 64-bit:
- Python:
- pyodbc:
- OS:
- DB:
- driver:
Issue
Often it is easiest to describe your issue as "expected behavior" and "observed behavior".