Erpnext Errors Database

What it does

This skill enables AI agents to retrieve and analyze error logs directly from an ERPNext database. It allows for the investigation of system failures, transaction issues, or application crashes by querying stored error records.

When to use it

• Diagnosing why a specific sales order failed to generate during processing.
• Investigating recurring login errors reported by multiple users in the last hour.
• Auditing database entries for critical exceptions that occurred after a recent system update.
• Extracting detailed stack traces to assist developers in fixing custom script bugs.

Key capabilities

• Direct access to ERPNext error tables within the database schema.
• Retrieval of timestamped error records linked to specific transactions or users.
• Querying for specific error codes, messages, and severity levels.
• Filtering results by date ranges, module names, or user IDs.

Example prompts

• "Find all errors related to the 'Stock Entry' module that occurred yesterday."
• "Retrieve the top 10 most frequent database exceptions logged in the last week."
• "Show me the details of any error associated with transaction ID #98234 and the user who triggered it."

Tips & gotchas

Ensure your AI agent has appropriate read-only permissions on the ERPNext database before attempting queries to avoid locking or security violations. Be specific with date ranges and module names to reduce noise in large production environments.