# Urgent: Critical Issue - Unable to Insert Data into MSSQL Database During Script Execution

**URL:** <https://forum.inductiveautomation.com/t/urgent-critical-issue-unable-to-insert-data-into-mssql-database-during-script-execution/91615>\
**Category:** Ignition\
**Tags:** python, database, scripting, ignition81\
**Created:** [June 10, 2024, 12:17pm UTC](https://forum.inductiveautomation.com/t/urgent-critical-issue-unable-to-insert-data-into-mssql-database-during-script-execution/91615 "2024-06-10T12:17:12Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 11, 2024, 1:24pm UTC](https://forum.inductiveautomation.com/t/urgent-critical-issue-unable-to-insert-data-into-mssql-database-during-script-execution/91615/2 "2024-06-11T13:24:04Z")

</div>

Be warned that the forums are not support. If it is truly urgent you can contact them here:  
[https://support.inductiveautomation.com/](https://support.inductiveautomation.com/)

> [@Ramya\_R](#):
>
> Additionally, we have observed that both CPU and database (DB) usage on our system are consistently at 100%

That said, you have not given any information on your Ignition / DB setup, how often you're trying to write to the DB, etc.  
If it's related to this post:

> [@Ignition - High CPU Usage in MS SQL DB](https://forum.inductiveautomation.com/t/ignition-high-cpu-usage-in-ms-sql-db/79630):
>
> We are using Ignition 8.1.23 version. I have a serious problem with my ignition instance and that their SQL server was hanging on 100%. The Ignition gateway and the database server are in different AWS instances. CPU Suddenly, the CPU usage increments and everything in my server falls down, Data logging stopped in DB like that. Then I have restarted the Gateway/ AWS instances and the CPU usage decrements again and I still cannot find why. This has happened multiple times in the last 2 weeks. …

You didn't give any information there, either.

If you expand the error in the log, there should be a 'Caused by' section. Post the entire error here

My gut tells me your AWS instances are underprovisioned for what you are trying to do.

---

_[View the full topic](https://forum.inductiveautomation.com/t/urgent-critical-issue-unable-to-insert-data-into-mssql-database-during-script-execution/91615)._