Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-20970

May 2022 Discounts & Giveaways report will not generate for #02209

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Closed/Resolved by Caller
    • Affects Version/s: CFA 2022R2
    • Fix Version/s: CFA 2022R4
    • Component/s: Reports
    • Labels:
      None
    • VTask #:
      VTASK0491851
    • Root cause - Reason:
      Code defect
    • Root Cause:
      food cost values got bigger so converting the field value to decimal type in sql when summing up.

      Description

      Description

      The Samples Summary Report not Generating for May 31 to May 31,  and  Discounts & Giveaways report also not generating when selecting month of 'May'.

      Environment : PROD
      Store : 02209

       Steps
      1. Open http://m.inform.cfahome.com/#/Reporting/ReportPortal

      2. Select Report Group : Discounts & Giveaways

      3. Select Report: Samples Summary

      4. Select Date Range May 31 to May 31

      Expected : The report generate successfully 

       Notes: Same issue reported with the Discounts & Giveaways Report for 'May'

      I have found the following error in Event Viewer:

      Timestamp: 6/2/2022 11:29:26 PM
      Activity Token: 800136c5-0c02-a300-b63f-84710c7967bb
      Message: HandlingInstanceID: 82591cb3-2555-4685-8c8e-5e2ce52e4a44
      An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
      ----------------------------------------------------------------------------------
      06/02/2022 19:29:26
      Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
      Message : Arithmetic overflow error converting expression to data type money.
      The statement has been terminated.
      Source : .Net SqlClient Data Provider
      Help link :
      Errors : System.Data.SqlClient.SqlErrorCollection
      Class : 16
      LineNumber : 26
      Number : 8115
      Procedure : qryMMSReportData_SampleSummary
      Server : ATL2CFASQLV001
      State : 2
      ErrorCode : -2146232060
      Data : System.Collections.ListDictionaryInternal
      TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
      Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
      at System.Data.SqlClient.SqlDataReader.get_MetaData()
      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
      at Mx.Data.Inventory.Reporting.ReportingData.qryMMSReportData_SampleSummary_Reader(Int64 entityID, DateTime startDate, DateTime endDate, Boolean aggregateTotals, SqlTransaction transaction)

      Additional Info:

      MachineName : ATL2CFAWEBV001
      TimeStamp : 6/2/2022 11:29:26 PM
      FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
      AppDomainName : /LM/W3SVC/1/ROOT-1-132986268039511744
      ThreadIdentity :
      WindowsIdentity : CFA\CFAWebUser

      Category: General
      Priority: 30
      EventId: 100
      Severity: Error
      Title:Enterprise Library Exception Handling
      Machine: ATL2CFAWEBV001
      Application Domain: /LM/W3SVC/1/ROOT-1-132986268039511744
      Process Id: 6600
      Process Name: C:\Windows\SysWOW64\inetsrv\w3wp.exe
      Win32 Thread Id: 3472
      Thread Name:
      Extended Properties: HelpLink.ProdName - Microsoft SQL Server
      HelpLink.ProdVer - 13.00.4466
      HelpLink.EvtSrc - MSSQLServer
      HelpLink.EvtID - 8115
      HelpLink.BaseHelpUrl - http://go.microsoft.com/fwlink
      HelpLink.LinkId - 20476

       

        Attachments

          Issue Links

          blocks

          Feature Request - CFAMX-11540 Production Defects

          • Blocker - Blocks development and/or testing work, production could not run.
          • Open

            Activity

              People

              • Assignee:
                caner.saritac Caner Saritac
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.