Payment error with Foreign currency
Purpose:
Internal to Support Team
Environment:
iVend 6.6 Unplugged
Problem statement:
Getting an error "Load failed. Criteria NHibernate.Criterion.Query" while doing payment with Foreign Currency
Symptoms:
Upon doing payment with foreign currency at Point of sale, POS user faced below error:
"Load failed. Criteria NHibernate.Criterion.Query"
In the log file below error was captured:
<Event>
<Version>6.6.7425.36652</Version>
<Category>ERROR</Category>
<Time>12:39:36 PM</Time>
<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>
</ExceptionInfo>
</Event>
Resolution/Work Around:
Upon Checking in the database it was found that there were duplicate Exchange rate keys. Hence duplicate record needs to be removed.
Related Articles
Getting an error while doing payment with Foreign Currency
Problem Statement: Not able to complete Payment at POS due to Red Box Error Symptom: Getting an error "Load failed. Criteria NHibernate.Criterion.Query" while doing payment with Foreign Currency and also not able to save the transaction with CASH ...iVend POS Accepting Foreign Currencies On POS
Introduction In many instances, customers with foreign currency come to retail stores; in such cases retailers require functionality to support accepting Foreign Currency as a tender at the Point of Sale (POS). Any other currency that is being ...Integration failure between iVend To SAP with Error : System.Exception: AddOn : Payment to be made
Environment : iVend 6.6 with SAP B1 Problem Statement : Transactions are not integrating with iVend To SAP.bIt is showing an error message. System.Exception: AddOn : Payment to be made by the Add-on ...Records stucked on Integration Failure with Error message System.Exception: DI:Enter valid currency
Product version: iVend 6.5 Update 6, iVend 6.6 with SAPB1 Problem statement : Records stucked on Integration Failure with Error message from iVend to SAP System.Exception: DI:Enter valid currency code [OINV.DocCur] , 'KES' at ...Payment Processor Error
Environment: iVend 6.6.8024 SAP B1 10 Problem Statement: One of the Customer was facing an error with a custom payment processor. Getting below attached error. The Payment processor has been working well on other installations but having issue on ...