In an environment where you use Microsoft SQL Server, obtaining a value table will get the value incremented twice if you use NEXT VALUE from a sequence .

 
In an environment where you use Microsoft SQL Server, if you use the TenantDatabase (script development model) API or the SQL definition of IM-LogicDesigner, obtaining a value from a sequence table will get the value incremented twice.
This is true even if you use JDBC methods directly.

For more information on this phenomenon and a way to avoid it, please refer to the following blog.

https://dev.intra-mart.jp/blog-205165/

--Target -------------------------------------------------------------------------
iAP/Accel Platform/All Updates
--------------------------------------------------------------------------------

FAQID:1157
Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk