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.
Log Details:
<Message>query did not return a unique result: 2</Message>
<ExceptionInfo>
<Type>NHibernate.NonUniqueResultException</Type>
<Message>query did not return a unique result: 2</Message>
<Source>NHibernate</Source>
<TargetSite>System.Object UniqueElement(System.Collections.IList)</TargetSite>
<StackTrace> at NHibernate.Impl.AbstractQueryImpl.UniqueElement(IList list)
at NHibernate.Impl.CriteriaImpl.UniqueResult[T]()
at NHibernate.Criterion.QueryOver`1.SingleOrDefault()
at NHibernate.Criterion.QueryOver`1.NHibernate.IQueryOver<TRoot>.SingleOrDefault()
at .[](IQueryOver`1 )</StackTrace>
Proposed Solution/Workaround:
Follow the below steps
exec sp_executesql N'SELECT this_.LaborSessionKey as LaborSes1_182_0_, this_.StoreKey as StoreKey182_0_, this_.UserKey as UserKey182_0_,
this_.JobCodeKey as JobCodeKey182_0_, this_.BusinessDate as Business5_182_0_, this_.StartDate as StartDate182_0_,
this_.EndDate as EndDate182_0_, this_.BreakCount as BreakCount182_0_, this_.TotalBreakTime as TotalBre9_182_0_,
this_.TotalTime as TotalTime182_0_, this_.Status as Status182_0_, this_.LastBreakTime as LastBre12_182_0_, this_.CreatedBy as CreatedBy182_0_, this_.Created as Created182_0_,
this_.ModifiedBy as ModifiedBy182_0_, this_.Modified as Modified182_0_ FROM LbrLaborSession this_ WHERE ((this_.StoreKey = @p0 and this_.UserKey = @p1) and not (this_.Status = @p2))',
N'@p0 bigint,@p1 bigint,@p2 int',@p0=10000000000002,@p1=20000000000004,@p2=3
select * from LbrLaborSession where storekey=10000000000002 and UserKey=20000000000004 and status <> 3
select * into LbrLaborSessionTemp from LbrLaborSession where storekey=10000000000002 and UserKey=20000000000004 and status <> 3
begin tran
Delete from LbrLaborSession where storekey=10000000000002 and UserKey=20000000000004 and status <> 3 and LaborSessionKey=20000000000718
rollback tran
Constraints / Scenarios:
Before executing delete query, take backup of records into temp table.
Related Articles
Unable to perform End Of Day at Store Management Console
Problem statement Unable to perform End Of day. Environment iVend Retail 6.5 Update 6 Patch 2021_23 Symptoms While performing the End Of Day at store management console system gives the below error. "Cannot save store. Store count exceeds number of ...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 ...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 ...Disable automatic End Of Day report generation when doing End of Day process at Day End
Requirement Customer wants to disable automatic End Of Day report at Day End means when the user doing the "End of day" process at the store" then no report should generate at the store Version 6.5 Update 6. Answer There is no such feature available ...End of day Error : User doesn't have rights on object Store
Unable to Perform End Of Day from Point Of Sale. Article metadata. Authored by Mohd. Aamir This article was updated• 2y ago2 years ago This article has 38 views.• 38 Views This article has average rating: 0 out of 5 stars• ( )( ) ( ) ( ) ( ) ...