Ignition Server Delay

Ignition
1

Hi guys,
Got here something and I don’t know how to approach it.
Sort story long….

The basic usage of the gateway:
pull data from PLC >> process data >> send it (database or API calls)

I have a problem that appears randomly, and I can’t find the root cause.
Sometimes I’m getting a delay in reading / writing values to devices (Siemens PLCs).
Most of our scripts are set up in tags > value change event

Example of situation:
We are testing a new project and the plc programmer is sending new values at a specific address.
The value change event is triggered, data is processed and inserted into db.
After few minutes of testing… I keep receiving new values from the PLC, in the designer interface the values are updated, but the data is not reaching database, after 5 minutes all the data appeared at once.

Any idea how to approach this?
Do you think is more of a Ignition problem or something related to our network?

Overview:

1
11524×812 83.2 KB

Performance:
2
21455×636 54.4 KB

Database:
3
31063×315 5.62 KB

2

How are you inserting the data into the database? I assume a system.db.runPrepUpdate query in your tag change event somewhere. If that is failing, you should see logs in your gateway telling you that the query failed, and whatever database you’re using should send you an error message as to why.

3

It’s possible that one or more of your tag event scripts are blocking doing IO or otherwise taking longer than you expect.

When you notice that things are backed up or delayed again try to get a thread dump from the gateway status > threads page.

1 Like
4

I’m using system.db.runUpdateQuery(), but we didn’t receive any errors, the data arrived in the DB, but with huge delay, approx. 5 mins