The trigger is Toggled with period 30 minute.
During the first month, SQL Server and Factory studio worked well.
But the last few days, The Factory save historian into SQL Server was abnormal.
The UTCTimestamp_Ticks have wrong value when data was save.
How can I check cause of problem
Best.
Could you provide us with more details on how the trigger tag is being toggled?
Do messages appear on the trace window when data is saved to SQL Server? Adding the trigger tag to the trace windows would help because any changes to the tag would be displayed in the trace window.
Could you send us a screenshot of the database records with incorrect UTCTimestamp_Ticks values? Feel free to attach any other screenshots you believe may help us.
Is it possible to send us an example project with the same configurations of your project?
Dear Sir/Madam
Thank for your feed back.
In my project, I have many Historian table. All of them has the same trigger tag.
The problem happen in some of them and happen during 17:00 pm to 6:AM tommorrow. Remain time, every thing work Ok.
My trigger tag is toggled in period 30 minute.
When Tigger is togger, data is stored into sql server.
But value of UTCtime_tick was wrong.
I open Watch module and infor module to monitor.