Micros Res3700 4.9 1

[dwwillia]

Hello

We wanted to modify some tracking groups so we did the following:

opened dbisql and ran

update micros.trk_grp_def
set ob_grp_in_use = 'f'

I then went into POS configurator - Reporting Tab - Tracking Groups

I copied the last tracking group I used, changed the name and added a couple of different things (Donations) to track

I then went into Historycal totals - Classes tab and attempted to change the tracking group to my new one. However it just freezes and will not allow me to change it.


I have tried restarting database and server but no change. To note, this is on a EM server and these changes will eventually be pushed down to all our locations.

Any ideas on why it would freeze and not allow me to make the change?

 

[Jackba]

question you have set the tracking group to false did you return it to true?

 

[dwwillia]

Set to T or F it does the same freezing

 

[Jackba]

Any errors and at what point doe it freez? when saving or?

 

[CathalMF]

You need to make sure you put a "commit" at the end of that sql query. If you dont then you leave the record locked and it freezes things.

update micros.trk_grp_def
set ob_grp_in_use = 'f'
commit

However since you are creating a new tracking group there was no need to run that SQL query at all.
You only need to run that SQL if you want to modify and existing tracking group. If you're creating a new tracking group then just do it. No SQL needed.

EDIT: Also if you're updaying that table then you really should only change the tracking groups that you're dealing with. Your current SQL is updating every record in that table.

update micros.trk_grp_def
set ob_grp_in_use = 'f'
where trk_grp_seq = 1234
commit

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[dwwillia]

In Historical totals as soon as I change the tracking group from its original value to the new tracking group I created and either hit Save or change the field it immediatly goes to a not responding condition and stays like that.

 

[dwwillia]

CathalMF that did the trick (Forgot to add commit to the end)

The reason we where unlocking it is originally it would not let us change the tracking group to the new one I created. I tried unlocking it to see if it would let me - and with adding commit it now works. Thanks!