UNABLE TO SEAT WORKSTATION: MAXIMUM NUMBER OF SEAT EXCEEDED

Symptom: When try to login to Retail Pro, system returns message “Unable to seat workstation: maximum number of seat exceeded”.

Cause: Licensing restricts the number of RPRO9.exe connection based on the number of seat allocated to the station. Sometime when Retail Pro is not closed properly (end process RPRO9.exe in task manager is one common example), the system will think workstation(s) is still connected to the database.

Resolution: In Techtoolkit > Managing Schema Objects > SQL Shell, select either workstation table or workstation_v view. Look for records that has the field TIME_IN populated. If there are many entries in the table, execute the following query:

select ws_id, workstation, time_in from workstation where time_in is not null

If the query returns a number of records equal to the number of seat allocated to the station, a new RPRO9.exe connection will not be allowed and the system will return the warning message. You will need to identify and note which workstation and ws_id is not currently running Retail Pro. Issue the following queries to clear the offending record (replace the # with the actual ws_id number from the previous query):

update workstation set time_in=null where ws_id=#
commit

This should allow Retail Pro to be launched successfully.

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Comments
This field is for validation purposes and should be left unchanged.

34445

or

Schedule A Demo

Popup — Contact Us

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

30973

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

72974

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

29265

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Phone
This field is for validation purposes and should be left unchanged.

50984

or

Schedule A Demo

Sandy Malaney

Upon graduating with a degree in business from California State University, Sacramento, Sandy Malaney accepted a sales position from Lanier Business Products. She found her stride in outside sales, becoming Lanier’s top producer in their telecommunications division.

In 1988, Malaney joined Checkpoint Systems, selling security systems to retail companies. Malaney gained valuable information about the retail sector that would eventually lead her to her next career at a startup called Retail Technologies, Inc. (RTI) in 1990.

As vice president of sales and marketing, Malaney focused on sales, brand marketing, and expanding product line. (Today Retail Technologies is known as Retail Pro International (RPI), and is headquartered in Folsom, CA.)

Then in 1993, RTI eliminated its sales division to focus solely on software development. Sandy and her husband Mick seized the opportunity to open a software distributorship that included selling and supporting RTI’s point of sale and inventory management solution—Retail Pro.

The Malaneys didn’t need to look far for a business name. “Big Hairy Dog” described the family dog, Molly, an Old English Sheep Dog. Today, pups Dugan Finnegan and Paisley Rose continue to dutifully represent the family business.

Sandy Malaney’s varied experiences in business and in life prepared her for the rigors of owning a small technology firm. Celebrating 27 years (or—189 dog years) of success, Big Hairy Dog continues to expand in the retail market place, while providing an award-winning help desk to customers worldwide.

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

98473

TECHNICAL SUPPORT

tech@BigHairyDog.com

Support Hours

Monday – Friday: 6AM-6PM PST

PST Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

After-Hours Phone Number:
916.368.1070

Fax: 916.368.1411

3205 Ramos Circle Sacramento, CA 95827

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

24233

BIG HAIRY DOG

3205 Ramos Circle
Sacramento, CA 95827
800-377-7776 FAX: 916-368-1411
Info@BigHairyDog.com

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Support Hours

Monday – Friday: 6AM-6PM PST
Saturday: 9AM-5PM PST
Sunday: 9AM-2PM PST

Mick Malaney President & Co-Founder
CELL: (916) 803-3939

Sandy Malaney CEO & Co-Founder
CELL: (916) 802-3939

Sales Department

800-377-7776 | 916-368-3939
Info@BigHairyDog.com
Karen Page CELL: 503-728-8396

Felicia Casper CELL: 916-956-9727

Technical Support Department

916-368-1070
Tech@BigHairyDog.com

Customer Service/Upgrade Service

800-377-7776 | 916-368-3939
Service@BigHairyDog.com

Administration/Billing

916-368-3939
Admin@BigHairyDog.com