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

PMIX export files missing in S3 end point while status = 1 in INFORM tables

    Details

    • Type: Customer Defect
    • Status: Ready for Developer (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2023R3
    • Fix Version/s: None
    • Component/s: Exports
    • Labels:
      None
    • VTask #:
      VTASK0519764

      Description

      CFA reported missing PMIX data for date rang 06/30 to 07/02, After we checked the status in our tables, these export records were marked as '1', CFA is asking if we can add more validation or notification to show the correct status for the AWS S3 destination.

      Select * from tbExportQueueMessage with ( nolock ) where BusinessDay = '2023-06-29' and XSLTExportTaskID = 136 and Status = 1  order by BusinessDay

Select * from tbExportQueueMessageDestination with (Nolock ) where  XSLTQueueExportID in (Select XSLTQueueExportID from tbExportQueueMessage with ( nolock ) where BusinessDay = '2023-06-29' and XSLTExportTaskID = 136  ) 
and  XsltExportDestinationId = 15 and ExportedSuccessfully = 1

      Data sent successfully when we resend the export.

       

        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:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

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