ORA-00001: UNIQUE CONSTRAINT (CMS.XAK1ZOUT_REGISTER_CURRENC

Retailpro V9 series
Ora-00001: Unique Constraint (CMS.XAK1Zout_Register_Currency) violated.
Issue happens when the installation ID# has been changed while there are open drawers.
Normally Rpro will not allow a change to installation ID if there is an open drawer, however if it does allow a change and “Require workstation level Zout” is enabled in prefs– you will get the above Ora error.
How to fix:
Open TTK and go to SQL shell. run the following script.
update zout_register_urrency set controller = (ID#)
commit

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s almost 30 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s 25 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!