Failed to write data into SQL

Hello,

I have an observation today that the Ignition was unable to write the data into the database table I have attached below a wrapper log for this issue could anyone tell why this happened.

E [c.i.i.g.a.DatasourceAuditProfile] [05:30:29]: Error auditing [DefaultAuditRecord[action=“tag write”, actionTarget=“CarMapTemplate”, actionValue=“Dataset [413R ? 11C]”, actor=“admin”, actorHost=“SCADAServer”, context=“4”, system=“project=Direxa_United”, status=“AuditStatus[0x00000000, Severity=Good, Subcode=NotSpecified]”, timestamp=“Mon Mar 08 23:30:29 CST 2021”]], due to underlying exception.
INFO | jvm 2 | 2021/03/08 23:30:29 | com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the CHECK constraint “CHECK_ACTION”. The conflict occurred in database “SupervisionDB”, table “dbo.AUDIT_EVENTS”, column ‘ACTION’.
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
INFO | jvm 2 | 2021/03/08 23:30:29 | at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:955)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate(SRConnectionWrapper.java:180)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.inductiveautomation.ignition.gateway.audit.DatasourceAuditProfile.audit(DatasourceAuditProfile.java:188)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.SQLTags.audit(SQLTags.java:759)
INFO | jvm 2 | 2021/03/08 23:30:29 | at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.SQLTags$ClientWriteOperation.run(SQLTags.java:694)
INFO | jvm 2 | 2021/03/08 23:30:29 | at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
INFO | jvm 2 | 2021/03/08 23:30:29 | at java.util.concurrent.FutureTask.run(Unknown Source)
INFO | jvm 2 | 2021/03/08 23:30:29 | at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
INFO | jvm 2 | 2021/03/08 23:30:29 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
INFO | jvm 2 | 2021/03/08 23:30:29 | at java.lang.Thread.run(Unknown Source)

Thanks,
Kartik I

SQL Server told Ignition (via the JDBC driver) that the insert wasn’t allowed. You need to figure out why, in SQL Server.

Thanks I will look on it.