-
1. Re: [MDM] SIP-10205: Last Update Date is in the future.
Bala Gopalan Nov 22, 2020 1:46 PM (in response to Joao Cruz)Hello,
Is the same request succeeds sometime and fails? Did it work if date in the request changed to older than current date?
-
2. Re: [MDM] SIP-10205: Last Update Date is in the future.
Joao Cruz Nov 23, 2020 6:23 AM (in response to Bala Gopalan)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.