> For the complete documentation index, see [llms.txt](https://docs.avoautomation.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avoautomation.com/avo-assure/error-logs/errors/action/database-actions.md). # Database Actions The following are the errors that can occur while using Database actions: | Error | Description | Solution | | ----------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 77 Error with database operation (database) | This error occurs when you have used **Run Query**(DB) and you have not provided the valid connection details. | Provide the correct connection details, **\;\;\;\;\;\;\;\(Optional);\(Optional)** | | Error occurred due to unexpected alert # | This error occurs when an unexpected alert or pop-up appears during execution, preventing Avo Assure from interacting with the application. | Handle or dismiss the unexpected alert before continuing execution or add appropriate alert-handling steps in the test case. | | Element not found # | This error occurs when the captured element cannot be found on the application screen during execution, or when the element's properties have changed, causing Avo Assure to be unable to locate or interact with it. | Verify that the target element is present on the application screen during execution. If the element has changed or cannot be identified, update its object properties in the **Element Repository** and recapture the element if necessary before retrying the execution. | | Unable to establish connection to DB (Database) | This error occurs when Avo Assure is unable to establish a connection to the configured database. This may occur because the database server is unavailable, the connection details are incorrect, or the user does not have sufficient privileges to access the database. | Verify that the database connection details are correct, ensure the database server is running and accessible, and confirm that the user has the necessary permissions to establish the connection before retrying the operation. | | Values does not match # | This error occurs when Avo Assure compares the expected value with the actual value obtained during execution and finds that they do not match. As a result, the verification fails and returns a False status. | Verify both the expected and actual values, and ensure that the application contains the correct data before executing the verification. | | Error with database query (database) | This error occurs when the SQL query executed by Avo Assure contains syntax errors, references invalid database objects, or includes unsupported SQL statements. As a result, the query execution fails. | Verify the SQL query syntax, ensure that the referenced database objects exist, and confirm that the query is compatible with the target database before executing the action. | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.avoautomation.com/avo-assure/error-logs/errors/action/database-actions.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.