Alert storage profile threw an exception on receive

Hi Guys,

I am getting the bellow coming up in the console log every time an alert is triggered? It doesn’t seem to be effecting anything, just curious as to why? I haven’t modified the alert database from what Ignition auto created and I am using standard digital triggered alerts. The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 4 (""): The supplied value is not a valid instance of data type datetime. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. at at at at$PrepStmtExecCmd.doExecute( at at at at at at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate( at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate( at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate( at at at at com.inductiveautomation.ignition.gateway.alert.AlertBusImpl$ at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ at java.util.concurrent.Executors$ Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$ Source) at Source)

Thanks for any advice.


The error comes from deleting old alerts from the database. You probably have your retention period set to a really high number. What is the value right now? You can find it by editing your alert storage profile.

Ok cheers,

I had set the number of days to 999999.