Is the same request succeeds sometime and fails? Did it work if date in the request changed to older than current date?
Hi Bala, thanks for your advice.
The DBA team identified that one of the database nodes was 3 seconds ahead of the application server timestamp.
There are 4 db nodes in our architecture, that's why the requests succeeded sometimes.
We've synchronized all nodes and the issue was solved.
Also, we're going to update the C_REPOS_DB_RELEASE table. Currently the INTER_SYSTEM_TIME_DELTA_SEC column has value equals to 0.
Here is what I found in the Informatica documentation:
INTER_SYSTEM_TIME_DELTA_SEC: means the number of seconds required to make up the difference between the database server system time and the system time of another machine.