GP Rolling Column being used by two mappings at the same time.
Brandon asked 3 years ago
Hello,
I am wondering if anyone has had experience with this. Is it possible for two users to run two different sc mappings both using the same GP rolling column. For example, two people running separate SOP invoice integrations. Both of which are grabbing the next invoice number using the GP rolling column. I am concerned that they may fight over who get’s the next number. I’m not sure how smartconnect would handle this, or GP for that matter.
Thank you for your time.
I am wondering if anyone has had experience with this. Is it possible for two users to run two different sc mappings both using the same GP rolling column. For example, two people running separate SOP invoice integrations. Both of which are grabbing the next invoice number using the GP rolling column. I am concerned that they may fight over who get’s the next number. I’m not sure how smartconnect would handle this, or GP for that matter.
Thank you for your time.
Answers
Mark Anderson Staff answered 3 years ago
Yes, you can have 2 maps running at the same time to get the same next GP Rolling column value with no issues of a duplicate. This process is run within SQL Server and handles locking the table to get the next record. So User 1 gets ORD00001, if User 2 is running at the exact same time it would wait until User 1 saved that next number, and then User 2 would get ORD00002.