Oracle task warnings when resumed with timestamp

[lPrasanna]

We have an oracle task which is throwing below warnings continuously when we advance resumed with timestamp.

'The transaction timestamp already exists in an earlier partition'

Is this because source truncated and load the data again? or reading the same duplicated data as we advance resumed?

[lyka]

Hello,

What is the complete warning message? This warning is maybe related to latency

The behavior as I understand it is, that the events which missed their original partition, will be added to the currently opened partition, so there will not be any data loss, and this should be handled as a warning with little affect.

You can try monitoring the specific event arrived to the target by the data and simply comparing data between source / target

The warning here is If you have a down stream data processing, which uses partitions for calculation, you might have incorrect results.

Thanks,

Lyka

[lPrasanna]

Hi Lyka,

Thank you, below is the complete error.

[lyka]

Hello,

Thank you for providing that information - i just wanted to confirm that that is the warning that you are referring to.

anyways, the explanation for that warning is posted on my earlier comment. 

hope it helps!

Thanks,

Lyka