Urgent ... Weird behaviour when incrementing system variable

OK here is the test:

1 Instance, 1 User (No RDP)

Rule (Using Generic Action Type)

Test 1 (For the first time, no value has been read/load)

Manually write data to database

Click Test


I click Test Few More

Test 2 (Change Value in Database)

Manually write data to database (Reset To 0 and 100)

Click Test


See the result:

Increase: 4 (WRONG)

Update: 101 (CORRECT)

1 Like

Before I was using Increase but I was told to use Update instead.

Increase is different:
The function is supposed to read itself the db, while in Update we give that function the value we think we read from DB.
I also had problem (not exactely the same, I had soemtimes 3 times the same number) but that problem was maybe related to TAG and not Update Program Setting with Increase.

Good test. Looks like Update Type:Increase is broken. Looks like it is cached, and not read from DB.

What syntax are you using? {:X}, or {SETTING:X}, or {GLOBAL SETTING:X} ?

Nice test.

However I have it wrong with Update also using {GLOBAL SETTING:UpdateType}

Could you try?

Using {SETTING:X}

can you try with GLOBAL?

{GLOBAL SETTING:XXX} Read from cache :scream:

Unbelievable we got another bug `{GLOBAL SETTING:X}’ = {:X}. So, change it back to {SETTING:X} You should be fine now.

EDIT: GLOBAL read from cache in “Before” but read from database in “After”. It seem it doesn’t know the value was update (I manually change database) so, it use local value but after Update Program Setting Action it read from database. @QMcKay

1 Like

actually I have it setup now with Update and I give the {REPORT SQL} value.

I haven’t had double today, I think I will stick with it until the patch.

Thanks a lot sukasem, QMcKay, JTRTech, kendash, and the ones I forgot!

1 Like

168 posts later and we uncovered 2 bugs. LOL.

Good work Team! :wink:

1 Like

was this fixed as im getting same issue.
Mine is set to {GLOBAL SETTING:ORDERNUMBER}
What shall i change it to?