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

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

Problem:

After upgrading to 6.6 it was reported that below error was coming while assigning Till to POS.
QuoteSyntax 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:

Idea
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)