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

Sales after Finalize Day AutoNotification is failing

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2022R3
    • Fix Version/s: CFA 2022R4
    • Component/s: None
    • Labels:
      None
    • Root cause - Reason:
      Code defect
    • Root Cause:
      It seems like culture id was hard coded to 4. instead passed entity culture id.

      Description

      Scenario - Testing Environment 

      Store 70021 in testing is currently set to a tbEntity.NotificationCultureID = NULL. By default this should trigger the American English version of the Sales After Finalize Day.  Also, notice store 00096 is has a tbEntityID.NotificationCultureID = NULL in testing.  70021 Fails to send the Autonotification while 00096 works fine.

       

      Scenario - Walk thru the work flow and Finalize the day for store 70021 in testing 

      Wait until the Cash Day Summary export is triggered. 

      Open and ring in sales on the lab and settle the shift. 

      When the shift record comes into the system the Sales After Finalize Day alert is displayed in by using this query:

      select TaskName, * from tbExportQueueMessage (nolock) eqm
      join tbTaskName tn
      on eqm.XSLTExportTaskID = tn.TaskNameId
      where --BusinessDay = '2022-05-25'
      TimeToExport > '2022-05-01 15:00:00.000'
      --and status = 1 --and RetryCount = 0
      --and TaskName like '%safety%'
      --and status = -1
      --and status = 2
      and TaskName like '%cashier s%'
      --or '%product%'
      --and XSLTExportTaskID in (124,136)
      and StoreNumber in ( '00096','70021')
      order by businessday desc;

      Defect :  Store 70021 in testing is failing with this message: 

      CFA Cashier Settlement export for destination Send Via Email of type Email failed for store : 70021 retry count : 1 with exception: System.NotSupportedException: Culture 'es' is a neutral culture. It cannot be used in formatting and parsing and therefore cannot be set as the thread's current culture. at System.Globalization.CultureInfo.CheckNeutral(CultureInfo culture) at System.Globalization.CultureInfo.get_DateTimeFormat() at Mx.XsltExports.Services.XsltExportDestinationService.SendReportToEmailDestination(XsltExportDestination destination, CachedReport report, String reportLocation) at Mx.XsltExports.Services.XsltExportDestinationService.SendReportToDestination(XsltExportDestination destination, CachedReport report, Nullable`1 queueExportId, String reportLocation, Boolean archiveFileAfterSending) at Mx.Services.XSLTExportServiceClass.SendXsltDestinationSenders(IList`1 destinationSenders, CachedReport report)

       

       

      Expected: it should pass for store 70021 and an email should be generated as we have done for store 00096.

       

       

       

       

       

       

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                charles.wheeler Charles Wheeler
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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