End Of Day and showing error message Till Session not available

End Of Day and showing error message Till Session not available

/*****INTERNAL TO CXS SUPPORT TEAM*****/

Problem Statement

 End Of Day and showing error message Till Session not available

Environment

iVend 6.5 With SAPB1(dated version)

Resolution/Work Around

We have to make  the required changes using sql queries on Problematic Store db

take backup before excuting update query

Further we used SQL Script to update Till status correct so you were allowed to do EOD on Store MC Screen.

select * from CfgVersion


select * from CfgSiteInformation


select * from rtlstore where siteid='put in site id'

select * from TilTill where storekey='Put in store key'
and status not in ('3','4') and Tillkey in ('put in till id')

begin tran

update TilTill
set status=3
where storekey='Put in store key'
and status not in ('3','4') and Tillkey in ('put in till id')

commit tran

This KB article concludes here.


    • Related Articles

    • Not able to do End Of Day and showing error message 'Till Session not available'

      Environment : iVend 6.5 Update 5 with SAPB1 Problem Statement : Customer has informed that unable to do EOD while selecting the assigned till showing error message ‘Till Session is not available’. Symptoms : Some tills were in assigned status and not ...

    • Till Mgmt and End of Day Processes in iVend Retail

      Master Till The first step is to create the Master Tills. Each till requires a unique master record to be defined and then from this the user can set up the reusable tills. Each master till is used to generate the tills for use at the POS each ...

    • Email showing error message through schedule "Failure sending mail"

      Environment: iVend Version 6.6 with SAPB1 10 Problem Statement: Email showing error message through schedule "Failure sending mail" Symptoms: Email showing error message through schedule "Failure sending mail". The error is displayed in schedule log ...

    • Error during end of day

      Environment: 6.5 update 6 Problem Statement: An error pops up when trying to perform the end of day activity. "Load failed. Criteria - NHibernate.Criterion.QueryOver'2[CXS.SubSystem.labor.LaborSession, CXS.SubSystem.Labor.laborSession]" Log Details: ...

    • Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"

      Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...