ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Date and Time on Clarity servers do not match
Article ID: 222299
Clarity PPM SaaSClarity PPM On Premise
We notice a mismatch in App and DB server times when the following is done.
We fetch DB date time using a query through Gel Script
We compare with the time at which the process gets executed.
A sample screenshot of how the comparison is made is provided below.
To check if there is a mismatch in DB and App server timings, you can navigate to Administration -> Security and Diagnostics -> Health Report -> "Data Warehouse" tab, and look at the "Application and Database Timezone Match" row. Any mismatch would be reported here
If comparison is being made through Gel Script, ensure that the proper time function is used. Conversions into character data type can sometimes turn incorrect, and can show an apparent mismatch.
A sample Gel Script (to be used against a Postgres DB) would be as follows. For other DBs, use the appropriate time functions.