Hi SAP Experts,
While calling nextvals parallelly (Multi-threads) the Sequence.NEXTVAL does not get incremented automatically
Please help me to resolve this issue
Updated May 18, 2018
Hi SAP Experts,
While calling nextvals parallelly (Multi-threads) the Sequence.NEXTVAL does not get incremented automatically
Please help me to resolve this issue
Comments
The issue you are facing is because while calling nextvals parallelly the sequence is not cached, therefore the sequence expects that first thread cached the sequence as cache size from master and other threads are using cached one. But now there are several threads which are trying to cache the sequence from master.
Please do the following: