Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Retail POS error
Microsoft Dynamics AX (Archived)

Retail POS error

(0) ShareShare
ReportReport
Posted on by E. R. 739

Dears,

Please note that i am not able to open POS taking into consideration that the channel database synchronization is done properly and the download sessions are applied also database include data.

the following is the event viewer error:

LSRetailPosis.Settings.ApplicationSettings: System.OverflowException: Conversion overflows.
at System.Data.SqlClient.SqlBuffer.get_Decimal()
at System.Data.SqlClient.SqlBuffer.get_Value()
at System.Data.SqlClient.SqlDataReader.GetValueFromSqlBufferInternal(SqlBuffer data, _SqlMetaData metaData)
at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at LSRetailPosis.DataAccess.DataUtil.DBUtil.GetTable(SqlSelect SqlUtilSelect)
at LSRetailPosis.DataAccess.SettingsData.GetStoreInformation(String storeId)
at LSRetailPosis.Settings.ApplicationSettings.LoadSettingsForTerminal(Terminal terminal)
at LSRetailPosis.Settings.ApplicationSettings.InitializeSettings(String[] args).

Anyone faced the above before?

Your suggestion are highly appreciated.

Regards,

Elie

*This post is locked for comments

  • E. R. Profile Picture
    E. R. 739 on at
    RE: Retail POS error

    Dear all,

    Kind reminder.

    Regards,

    Elias

  • E. R. Profile Picture
    E. R. 739 on at
    RE: Retail POS error

    HI experts,

    anyone can help regarding the above??

    thank you in advance

  • E. R. Profile Picture
    E. R. 739 on at
    RE: Retail POS error

    Hi Andrea, 

    Please note that i used the SQL Profiler again and find the followings:

     exec sp_executesql N'SELECT DIRPARTYTABLE.NAME AS NAME, T4.LOCATOR AS PHONE, * FROM RETAILSTORETABLE INNER JOIN RETAILCHANNELTABLE ON RETAILSTORETABLE.RECID = RETAILCHANNELTABLE.RECID
                                        LEFT JOIN (SELECT * FROM DIRPARTYPOSTALADDRESSVIEW WHERE ISPRIMARY = 1) AS T1 ON T1.PARTY = RETAILCHANNELTABLE.OMOPERATINGUNITID
                                        INNER JOIN DIRPARTYTABLE ON DIRPARTYTABLE.RECID = RETAILCHANNELTABLE.OMOPERATINGUNITID
                                        LEFT JOIN (SELECT T2.PARTY, T3.LOCATOR FROM DBO.DIRPARTYLOCATION AS T2
                                        INNER JOIN LOGISTICSELECTRONICADDRESS AS T3 ON T2.LOCATION = T3.LOCATION WHERE T3.TYPE = 1 AND T3.ISPRIMARY = 1)
                                        AS T4 ON T4.PARTY = RETAILCHANNELTABLE.OMOPERATINGUNITID WHERE STORENUMBER=@STORENUMBER AND INVENTLOCATIONDATAAREAID=@INVENTLOCATIONDATAAREAID  ORDER BY VALIDFROM DESC',N'@STORENUMBER nvarchar(6),@INVENTLOCATIONDATAAREAID nvarchar(3)',@STORENUMBER=N'000009',@INVENTLOCATIONDATAAREAID=N'ABC'

    Output:

    NAME PHONE STORENUMBER NAME PHONE OPENFROM OPENTO DIMENSION DIMENSION2_ DIMENSION3_ STATEMENTMETHOD ONESTATEMENTPERDAY CLOSINGMETHOD ROUNDINGACCOUNT MAXIMUMPOSTINGDIFFERENCE MAXROUNDINGAMOUNT MAXSHIFTDIFFERENCEAMOUNT MAXTRANSACTIONDIFFERENCEAMOUNT FUNCTIONALITYPROFILE CREATELABELSFORZEROPRICE ITEMNUMSEQ INVENTORYLOOKUP REMOVEADDTENDER TENDERDECLARATIONCALCULATION MAXIMUMTEXTLENGTHONRECEIPT NUMBEROFTOPORBOTTOMLINES ITEMIDONRECEIPT SERVICECHARGEPCT SERVICECHARGEPROMPT TAXGROUP TAXGROUPDATAAREAID REPLICATIONCOUNTER ROUNDINGTAXACCOUNT MAXROUNDINGTAXAMOUNT CULTURENAME MODIFIEDDATE MODIFIEDTIME RECID SQLSERVERNAME DATABASENAME USERNAME PASSWORD USEDEFAULTCUSTACCOUNT WINDOWSAUTHENTICATION HIDETRAININGMODE TAXOVERRIDEGROUP USEDESTINATIONBASEDTAX USECUSTOMERBASEDTAX TAXIDENTIFICATIONNUMBER OFFLINEPROFILE INVENTLOCATIONIDFORCUSTOMERORDER STMTPOSTASBUSINESSDAY STMTCALCBATCHENDTIME GENERATESITEMLABELS GENERATESSHELFLABELS EFTSTORENUMBER PRICEINCLUDESSALESTAX INSTANCERELATIONTYPE OMOPERATINGUNITID CHANNELTYPE RELATIONTYPE RECID INVENTLOCATION INVENTLOCATIONDATAAREAID CURRENCY DEFAULTCUSTACCOUNT DEFAULTCUSTDATAAREAID TRANSACTIONSERVICEPROFILE PARTY PARTYLOCATION ISPRIMARY ISPRIVATE ISLOCATIONOWNER RECID LOCATIONNAME ADDRESS STREETNUMBER STREET CITY ZIPCODE STATE COUNTY COUNTRYREGIONID DISTRICT POSTBOX BUILDINGCOMPLIMENT TIMEZONE LONGITUDE LATITUDE LOCATION VALIDFROM VALIDTO COUNTRYCURRENCYCODE DISTRICTNAME POSTALADDRESS ISOCODE NAME LANGUAGEID NAMEALIAS MEMO PARTYNUMBER INSTANCERELATIONTYPE KNOWNAS MODIFIEDDATETIME CREATEDDATETIME RECID PARTY LOCATOR
    RetailABC NULL 9     0 0       3 0 0   1E+13 0 0 0 FN01 0   0 4 0 39 0 0 0   VAT-STG ABC 0   0 en-us 00:00.0 0 5637144576         0 0 0 0 0 0   5637145326   0 0 0 0   1 101893 5637148403 0 101893 5637144576 JS ABC LBP ABC-000001 ABC   NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL RetailABC en-us Jisr el Bacha NULL 9 2377   02:32.0 26:40.0 5637148403 NULL NULL

    the above stored procedure is the only one that is showed on sql profiler when trying to open pos.

    Please advise

  • E. R. Profile Picture
    E. R. 739 on at
    RE: Retail POS error

    Hi Andreas, you are right but i tried to use sql profiler but i didn't understand anything. is there any other way to check from where i can find this wrong data?

  • E. R. Profile Picture
    E. R. 739 on at
    RE: Retail POS error

    Dear Amith, iam using AX2012 R3 + CU9

    i tried to download/install hotfix kb3032970 but the error is still the same.

    i need to check the wrong data where to find it. do you have sql scripts that help in this process?

  • Suggested answer
    A.Prasanna Profile Picture
    A.Prasanna 8,219 on at
    RE: Retail POS error

    Hi elie,

    Which Version of AX and CU , are you using ?

    any way refer this link ondynamicsax.blogspot.com/.../retail-process-upload-jobs-encountered.html

    at least it will give you clue to resolve your issue.

    Hope this will help.

    Amith Prasanna

  • Andreas Hofmann Profile Picture
    Andreas Hofmann on at
    RE: Retail POS error

    Seems like a SQL query is returning data that the application cannot cast correctly (decimal value too large?). I suggest you run SQL Query Analyzer at the same time you reproduce this issue. That will tell you what SQL query is causing this. From that you may be able to infer what data is wrong or if this is a bug.

  • E. R. Profile Picture
    E. R. 739 on at
    RE: Retail POS error

    there are no customizations on POS (related tables).

    I did initiliza parameters (result: info log: already exist).

    Did full data sync. applied on download sessions.

    POS doesnt open. same same. I guess it is related to wrong data (Conversion overflows/ Decimals!!).

  • Suggested answer
    A.Prasanna Profile Picture
    A.Prasanna 8,219 on at
    RE: Retail POS error

    Did you do any customizations in POS (related) tables ?, Try to do Full Data sync (to do full data sync go to Channel Database Form under Setup ).

    If that is not working , try to initialize retail parameters and then do full data sync and check.

    Hope this will help

    Amith Prasanna

  • E. R. Profile Picture
    E. R. 739 on at
    RE: Retail POS error

    Hi Amith,

    Thank you for your prompt reply.

    yeah it is a Fresh Environment and the POS was working properly suddenly the error came yp!

    Awaitig your feedback.

    Regards,

    Elie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans