Background:

By default, the database schema shipped with the gateway prevents duplicates because the time stamp is part of the primary key, however as a DBA you can override this in the database schema directly by changing the primary key. If you do then some situations can result in duplicate time stamps for the same data item in the database:

1) You are using a sampler where the update rate is not restricted, most common among these is the API sampler.

2) The time stamps are being generated by the gateway, and as such it is possible because of delays in processing netprobe updates that two updates get written to the database in the same second.

Possible solutions:

You can stop point 2 by using the Advanced tab at the top of the Database Logging section of the gateway setup setting in the gateway and ticking the

Log netprobe sample time for data items

which will use the time stamps at the point of sample from the netprobe rather than the gateway.

Related articles:

• Database Logging documentation

If you need further help:

• Please contact our support team via the chat service box on any of our websites or raise a support request.
  
• Make sure you provide us with:
  • Background of the issue or request.
  • Use cases, requirements, business impact, etc.
  • Encountered error messages.
  • Log files or diagnostic files.
  • Screenshots.
  • And other important information relevant to your inquiry.