Issue after upgrading to 6.6

Problem:

After upgrading to 6.6 it was reported that below error was coming while assigning Till to POS.

Syntax error: The operand after the 'UseDrawer' operator is missing"

Root Cause:

"UseDrawer" SP missing from Store database.

Resolution:

Store database must have the same schema as the Enterprise database. For this specific instance, once the missing store procedure named "UseDrawer" is available in the store database, issue got fixed.

Important :

If the store was not properly upgraded ( to 6.6 ) then it may result in the difference of Database objects ( SP /views) at store , as compared to Enterprise and this may result in different kind of exceptions at different screens. So in such cases it is suggested that, as a first check you can check and compare the number of SP and views at store vs Enterprise.

Recommendation:

It is highly recommended to follow the pre- upgrade checklist to avoid such issues.

Key Check Point:

If you have any custom views/ Stored procedure in your Enterprise database and you are re-initializing the store after that, make sure below are followed

-- Confirm the Enterprise has been upgraded successfully to 6.6

-- Before taking backup for store re-initialization, take backup of the custom stored procedures and views

-- Once done, drop them from the production database

-- Once done, take backup of store with desired setting (for store re-initialization)

-- Once backup is completed, use this to re-initialize the store

-- After store initialization, verify the schema (view/procedures) against Enterprise database

-- Once all set, then reload/recreate the existing custom views and stored procedures at HO* and store databases

* You can restore the custom views/Stored procedure at HO just after completing the back up as well ( if required)

One another exception caused because of similar reason has been discussed at below article as well.

https://citixsys96.zohodesk.com/portal/en/kb/articles/on-searching-transaction-error-message-an-error-has-been-encountered-during-the-search-function

• Related Articles

• Cannot process credit cards after upgrading to iVend 6.6

  Problem Statement: Transaction could not b completed using credit card Symptom: Getting an error "Error payment processor: The remote server returned an error: (404) Not found.. Please swipe the card again or try another card" while making payment ...

• Issue with replication

  Product version: 6.6 Problem Statement: The replication service is not working, the service is updated and starts without problems but the logs do not move. Proposed Solution:- Steps to perform to resolve the issue 1) Stop the Replication Service 2) ...

• Do we require to uninstall iVend 6.5 update 6 before upgrading to 6.6

  Query: Do we require to uninstall iVend 6.5 update 6 before upgrading to 6.6 Answer: In case of an upgrade, iVend 6.6 can be run on the existing iVend 6.5 upgrade 6 setup.

• Multiple Receipt Printing issue

  Environment: iVend 6.6 7989 SAP B1 10 Problem Statement: iVend is sending lots of receipts for single transaction until printing has to be stopped. Symptoms: It was observed that for Receipt ID ‘Transaction receipt’, Transaction receipt was selected ...

• Is it mandatory to reinstall the iVend SAP Addon when upgrading iVend to version 6.6

  Query: - A folder named "Addon" comes with the every iVend 6.6 Patch release. Please confirm, for those customers who are integrated with SAP B1 is it mandatory to reinstall the iVend SAP Addon when upgrading iVend to version 6.6? Also is this new ...