Database Errors
Database errors occur when storing or retrieving data in the local database. WCPOS uses a local database to store products, customers, and other data for fast access and offline functionality. These errors are prefixed with DB.
Categories
| Category | Code Range | Description |
|---|---|---|
| Connection | DB01xxx | Database connection and transaction issues |
| Data | DB02xxx | Record and constraint issues |
| Query | DB03xxx | Query syntax and data type issues |
Connection Errors
Issues connecting to or operating on the local database.
| Code | Name | Description |
|---|---|---|
| DB01001 | Connection Failed | Could not connect to the local database |
| DB01002 | Query Timeout | Database query took too long |
| DB01003 | Transaction Failed | Database transaction could not complete |
Data Errors
Issues with records, duplicates, and constraints.
| Code | Name | Description |
|---|---|---|
| DB02001 | Duplicate Record | A record with this ID already exists |
| DB02002 | Record Not Found | The requested record does not exist |
| DB02003 | Constraint Violation | Data violates database constraints |
Query Errors
Issues with query syntax and data types.
| Code | Name | Description |
|---|---|---|
| DB03001 | Query Syntax Error | The database query has syntax errors |
| DB03002 | Invalid Data Type | Data type does not match expected type |
| DB03003 | Missing Required Field | A required field is empty |