Urgent ... Weird behaviour when incrementing system variable

[plume]

2nd waitress clocked in an hour ago, no doubles right now … but not a lot of customers this lunch time … let’s wait.

[QMcKay]

I currently have the Script/Report method running, and no doubles.

[QMcKay]

Switched to Update +1 method without Report Tag, no doubles…

[QMcKay]

Switched to Increase Value 1, no doubles…

[QMcKay]

@plume,

Please post the Report you are using to track the SerialNumber Tag.

[plume]

(Btw I don’t really need that reports to see doubles, the printed tickets are enough)

[SerialNumber:1, 3, 5]

{REPORT SQL DETAILS:

SELECT Id,Value,Name

FROM ProgramSettingValues

WHERE Id = '23'

:F.Id,F.Value,F.Name}



[Table Custom:2,2, 3, 2]

>Terminal|T Numb|SerialNumber|Amount

{REPORT TICKET DETAILS:T.Terminal,T.TicketNumber,TT.SunatNumber.desc,T.TotalAmount:}

[plume]

I was told to use:
{GLOBAL SETTING:SerialNumber}
instead of
{SETTING:SerialNumber}

[plume]

@QMcKay

currently have the Script/Report method running, and no doubles.

I am almost sure that will give NO double, I am just making a last try this lunch time replacing:

{GLOBAL SETTING:SerialNumber}
by
[=TN('{REPORT SQL DETAILS:SELECT [Value] FROM [ProgramSettingValues] WHERE [Name]='SerialNumber':F.Value}')]

Then I’ll use you script.

[QMcKay]

##Report

[Ticket Serials:1,2,2,1,2,2,2]
>>DB|{REPORT SQL DETAILS:SELECT [Value] FROM [ProgramSettingValues] WHERE [Name]='SerialNumber':F.Value}

>>Payment
>tNum|tDate|pDate|Ser|tUser|pUser|Terminal
{REPORT PAYMENT DETAILS:T.TicketNumber,T.Time,P.Time,TT.SerNum.desc,T.User,P.User,T.Terminal}

>>Ticket
>tNum|tDate|pDate|Ser|tUser|pUser|Terminal
{REPORT TICKET DETAILS:T.TicketNumber,T.Time,T.LastPaymentDate,TT.SerNum.desc,T.User,-,T.Terminal}

[plume]

The only diff I see is:

In Yellow, my “TagValue” variable’s name was : “SerialNumber” I don’t know if it has impact

[plume]

Could you try with that?

@plume

{GLOBAL SETTING:SerialNumber}

[plume]

@QMcKay

[Ticket Serials:1,2,2,1,2,2,2]
>>DB|{REPORT SQL DETAILS:SELECT [Value] FROM [ProgramSettingValues] WHERE [Name]=‘SerialNumber’:F.Value}

>>Payment
>tNum|tDate|pDate|Ser|tUser|pUser|Terminal
{REPORT PAYMENT DETAILS:T.TicketNumber,T.Time,P.Time,TT.SerNum.desc,T.User,P.User,T.Terminal}

>>Ticket
>tNum|tDate|pDate|Ser|tUser|pUser|Terminal
{REPORT TICKET DETAILS:T.TicketNumber,T.Time,T.LastPaymentDate,TT.SerNum.desc,T.User,-,T.Terminal}

[QMcKay]

UPDATE:

@QMcKay

Switched to Increase Value 1, no doubles…

Got doubles.

@QMcKay

Switched to Update +1 method without Report Tag, no doubles…

Still no doubles.

[QMcKay]

@plume

In Yellow, my “TagValue” variable’s name was : “SerialNumber” I don’t know if it has impact

Should not matter.

The variable name in the Action is not related to the Program Setting Name… erm, at least it shouldn’t be!

---

@plume

Could you try with that?

{GLOBAL SETTING:SerialNumber}

Shouldn’t make any difference, but I will try it.

Currently still using Update+1 method, without Report (using {SETTING:SerialNumber}).

Do you mean to say use {GLOBAL SETTING:SerialNumber} in the Update and the Tag?

[sukasem]

@QMcKay

UPDATE:

QMcKay:
Switched to Increase Value 1, no doubles…

Got doubles.

QMcKay:

Is that mean Update Program Setting use value store in memory when Update Type set to Increase?

[QMcKay]

@sukasem

Is that mean Update Program Setting use value store in memory when Update Type set to Increase?

Seems that way, don’t know, just reporting it is “broken”, imo.

[plume]

@QMcKay

Do you mean to say use {GLOBAL SETTING:SerialNumber} in the Update and the Tag?

yes in both actions …

[sukasem]

@QMcKay

Seems that way, don’t know, just reporting it is “broken”, imo.

It seems if it find the value in memory it won’t read from database. After logout from POS and log back in, it update correct value.

[QMcKay]

@QMcKay

Switched to Update +1 method without Report Tag, no doubles…

Changed to {GLOBAL SETTING:SerialNumber}

Got DOUBLES!

But hold on… I think I might have found a way to reproduce it…

EDIT: Nope. Switched back to {SETTING:SerialNumber} and NO doubles.

[QMcKay]

Ok, so 2 things are “BROKEN” IMO … causing DOUBLES …

Update Type: Increase fails to read the updated value.

{GLOBAL SETTING:X} is not always reading the value from the DB. It must be caching it somehow.

---

Using the following, I still get NO doubles…

Update Type: Update using +1 method for increase.

{SETTING:X}