Discussions

Eloqua Bulk Export Breaking since Release 22D

Priyang Rathod
Priyang Rathod Posts: 3 Blue Ribbon

We run Eloqua bulk exports on several of our customers' Eloqua instances. For the past 2 days, all the export jobs for the contact object are failing with the error:

{"failures":[{"field":"filter","value":"(((('{{Contact.Field(C_DateCreated)}}' >= '2022-11-05T00:11:49') AND ('{{Contact.Field(C_DateCreated)}}' < '2022-11-06T00:10:41'))))","constraint":"Must contain an expression with reference to a valid service instance"}]}

The reason we think this is related to the latest release:

  1. It started around the time the 22D was released to Pod 1 and Pod 2
  2. The error is only happening for instances on Pod 1 and Pod 2.
  3. This is not an isolated instance, ALL the exports on instances (more than 15 different Eloqua instances) on Pod1 and Pod 2 are failing.

Any idea what could be happening? We have asked our customers to open support tickets with Eloqua, but am hoping for more visibility as this is not an isolated error.

Thanks!

Best Answer

Answers

  • Lou Patrick
    Lou Patrick Principal Product Manager, Eloqua APIs & App Developer Framework Portland, ORPosts: 200 Bronze Trophy

    can you please provide a full request URL and payload that results in this error?

  • Priyang Rathod
    Priyang Rathod Posts: 3 Blue Ribbon
    edited Jan 24, 2023 8:11PM

    Hi Lou,

    Thanks for looking into this. Here are the details:


    URL: https://secure.p01.eloqua.com/API/Bulk/2.0/contacts/exports
    
    Payload: {
      "name": "xyz_contacts",
      "fields": {
        "C_Last_Exited_Promo_Program_Date1": "{{Contact.Field(C_Last_Exited_Promo_Program_Date1)}}",
        "C_Vertical1": "{{Contact.Field(C_Vertical1)}}",
        "C_Validation_Results1": "{{Contact.Field(C_Validation_Results1)}}",
        "C_Deliverability_Vendor_Status1": "{{Contact.Field(C_Deliverability_Vendor_Status1)}}",
        "C_ZZ___SFDC_Contact_Last_Activity_Date1": "{{Contact.Field(C_ZZ___SFDC_Contact_Last_Activity_Date1)}}",
        "C_ZZ___SFDC_Lead_Last_Modified_Date1": "{{Contact.Field(C_ZZ___SFDC_Lead_Last_Modified_Date1)}}",
        "C_DateCreated": "{{Contact.Field(C_DateCreated)}}",
        "C_Lead_Record_Type_ID1": "{{Contact.Field(C_Lead_Record_Type_ID1)}}",
        "C_Twitter_Account1": "{{Contact.Field(C_Twitter_Account1)}}",
        "C_Last_Submitted_Long_Form_Date1": "{{Contact.Field(C_Last_Submitted_Long_Form_Date1)}}",
        "C_Contact_Owner1": "{{Contact.Field(C_Contact_Owner1)}}",
        "C_ZZ___SFDC_Contact_Created_Date1": "{{Contact.Field(C_ZZ___SFDC_Contact_Created_Date1)}}",
        "C_Web_Profile__Zip_Code1": "{{Contact.Field(C_Web_Profile__Zip_Code1)}}",
        "C_Lead_Last_Archived_Date1": "{{Contact.Field(C_Lead_Last_Archived_Date1)}}",
        "C_Last_Exited_MLSM1": "{{Contact.Field(C_Last_Exited_MLSM1)}}",
        "C_Invalid_Email_Address_Domain_Extension1": "{{Contact.Field(C_Invalid_Email_Address_Domain_Extension1)}}",
        "C_Last_Exited_Engage_Program_Date1": "{{Contact.Field(C_Last_Exited_Engage_Program_Date1)}}",
        "C_Web_Profile__State_Province__from_IP_1": "{{Contact.Field(C_Web_Profile__State_Province__from_IP_1)}}",
        "C_Owner_ID1": "{{Contact.Field(C_Owner_ID1)}}",
        "C_Email_Address_Domain_Suffix1": "{{Contact.Field(C_Email_Address_Domain_Suffix1)}}",
        "C_Last_Entered_ILM_Program1": "{{Contact.Field(C_Last_Entered_ILM_Program1)}}",
        "C_SFDCAccountID": "{{Contact.Field(C_SFDCAccountID)}}",
        "C_Last_Entered_Promo_Program_Date1": "{{Contact.Field(C_Last_Entered_Promo_Program_Date1)}}",
        "C_Deliverability_Vendor_Source1": "{{Contact.Field(C_Deliverability_Vendor_Source1)}}",
        "C_Zip_Postal": "{{Contact.Field(C_Zip_Postal)}}",
        "C_Timestamp__Last_Exited_Lead_Funnel_Date1": "{{Contact.Field(C_Timestamp__Last_Exited_Lead_Funnel_Date1)}}",
        "C_Last_Exited_Data_Washing_Machine1": "{{Contact.Field(C_Last_Exited_Data_Washing_Machine1)}}",
        "C_Last_Updated_Date___Number_of_SFDC_EmailAdd": "{{Contact.Field(C_Last_Updated_Date___Number_of_SFDC_EmailAdd)}}",
        "C_Last_Entered_Nurture_Program_Date1": "{{Contact.Field(C_Last_Entered_Nurture_Program_Date1)}}",
        "C_ZZ___SFDC_Contacts_Owner_Email_Address1": "{{Contact.Field(C_ZZ___SFDC_Contacts_Owner_Email_Address1)}}",
        "C_From_DNS__Country1": "{{Contact.Field(C_From_DNS__Country1)}}",
        "C_Lead_Stage1": "{{Contact.Field(C_Lead_Stage1)}}",
        "C_ZZ___SFDC_Lead_Created_Date1": "{{Contact.Field(C_ZZ___SFDC_Lead_Created_Date1)}}",
        "C_ZZ___SFDC_Lead_Created_By_ID1": "{{Contact.Field(C_ZZ___SFDC_Lead_Created_By_ID1)}}",
        "C_Last_Entered_Contact_Level_Security_Check_p": "{{Contact.Field(C_Last_Entered_Contact_Level_Security_Check_p)}}",
        "C_ZZ___SFDC_Contact_Last_Modified_Date1": "{{Contact.Field(C_ZZ___SFDC_Contact_Last_Modified_Date1)}}",
        "C_Timestamp__Last_Entered_Account_Segment_Pro": "{{Contact.Field(C_Timestamp__Last_Entered_Account_Segment_Pro)}}",
        "C_SFDCLastCampaignStatus": "{{Contact.Field(C_SFDCLastCampaignStatus)}}",
        "C_Last_Refreshed_NetProspex_Profile_Date1": "{{Contact.Field(C_Last_Refreshed_NetProspex_Profile_Date1)}}",
        "C_ZZ___SFDC_Contact_Last_Modified_By_ID1": "{{Contact.Field(C_ZZ___SFDC_Contact_Last_Modified_By_ID1)}}",
        "C_Verification_ID___Original1": "{{Contact.Field(C_Verification_ID___Original1)}}",
        "C_ZZ___SFDC_Last_Modified_By_ID1": "{{Contact.Field(C_ZZ___SFDC_Last_Modified_By_ID1)}}",
        "C_Website": "{{Contact.Field(C_Website)}}",
        "C_Lead_Owner1": "{{Contact.Field(C_Lead_Owner1)}}",
        "C_Marketing_Eligibility1": "{{Contact.Field(C_Marketing_Eligibility1)}}",
        "C_Timestamp__Last_Updated_Date_Marketing_Elig": "{{Contact.Field(C_Timestamp__Last_Updated_Date_Marketing_Elig)}}",
        "C_ZZ___SFDC_Contact_Owner_ID1": "{{Contact.Field(C_ZZ___SFDC_Contact_Owner_ID1)}}",
        "C_Not_Mapped_to_Contact1": "{{Contact.Field(C_Not_Mapped_to_Contact1)}}",
        "C_Last_CV_Level_Timestamp1": "{{Contact.Field(C_Last_CV_Level_Timestamp1)}}",
        "C_ZZ___SFDC_Lead_Record_Type_Name1": "{{Contact.Field(C_ZZ___SFDC_Lead_Record_Type_Name1)}}",
        "C_SFDCLastCampaignID": "{{Contact.Field(C_SFDCLastCampaignID)}}",
        "IsBounced": "{{Contact.Email.IsBounced}}",
        "C_ZZ___SFDC_Lead_Created_By_Name1": "{{Contact.Field(C_ZZ___SFDC_Lead_Created_By_Name1)}}",
        "C_ZZ___SFDC_Contact_Created_By_Name1": "{{Contact.Field(C_ZZ___SFDC_Contact_Created_By_Name1)}}",
        "C_Last_Refreshed_EmailHippo_Date1": "{{Contact.Field(C_Last_Refreshed_EmailHippo_Date1)}}",
        "C_Lead_ID_Last1": "{{Contact.Field(C_Lead_ID_Last1)}}",
        "C_Last_Refreshed_DemandBase_Profile_Date1": "{{Contact.Field(C_Last_Refreshed_DemandBase_Profile_Date1)}}",
        "C_Timestamp__Last_Form_Submit_Feedered_Date1": "{{Contact.Field(C_Timestamp__Last_Form_Submit_Feedered_Date1)}}",
        "C_Web_Profile__Company_DNS_Name1": "{{Contact.Field(C_Web_Profile__Company_DNS_Name1)}}",
        "C_ZZ___SFDC_Contact_Created_By_ID1": "{{Contact.Field(C_ZZ___SFDC_Contact_Created_By_ID1)}}",
        "C_Verification_ID___Most_Recent1": "{{Contact.Field(C_Verification_ID___Most_Recent1)}}",
        "EmailFormat": "{{Contact.Email.Format}}",
        "C_Last_Modified_By1": "{{Contact.Field(C_Last_Modified_By1)}}",
        "C_Last_Entered_Daily_Feeder_Program1": "{{Contact.Field(C_Last_Entered_Daily_Feeder_Program1)}}",
        "C_Last_Entered_Multiple_Lead_Score_Model_Prog": "{{Contact.Field(C_Last_Entered_Multiple_Lead_Score_Model_Prog)}}",
        "C_Deliverability_Vendor_Date1": "{{Contact.Field(C_Deliverability_Vendor_Date1)}}",
        "C_ZZ___SFDC_Lead_Last_Activity_Date1": "{{Contact.Field(C_ZZ___SFDC_Lead_Last_Activity_Date1)}}",
        "ContactIDExt": "{{Contact.Field(ContactIDExt)}}",
        "C_Timestamp__Last_Entered_Lead_Funnel_Date1": "{{Contact.Field(C_Timestamp__Last_Entered_Lead_Funnel_Date1)}}",
        "C_ZZ___D_B_Site_Level_DUNS1": "{{Contact.Field(C_ZZ___D_B_Site_Level_DUNS1)}}",
        "SourceCampaignId": "{{Contact.SourceCampaign.Id}}",
        "C_ZZ___SFDC_Lead_Owner_Email1": "{{Contact.Field(C_ZZ___SFDC_Lead_Owner_Email1)}}",
        "C_ZZ___SFDC_Contact_Last_Modified_By_Name1": "{{Contact.Field(C_ZZ___SFDC_Contact_Last_Modified_By_Name1)}}",
        "C_Last_Entered_Data_Washing_Machine1": "{{Contact.Field(C_Last_Entered_Data_Washing_Machine1)}}",
        "C_SFDCLeadID": "{{Contact.Field(C_SFDCLeadID)}}",
        "IsSubscribed": "{{Contact.Email.IsSubscribed}}",
        "C_DateModified": "{{Contact.Field(C_DateModified)}}",
        "C_DUNS_Number": "{{Contact.Field(C_DUNS_Number)}}",
        "C_Last_Exited_Nurture_Program_Date1": "{{Contact.Field(C_Last_Exited_Nurture_Program_Date1)}}",
        "C_From_IP__Country1": "{{Contact.Field(C_From_IP__Country1)}}",
        "C_Timestamp__Last_Update_from_CSV_Import1": "{{Contact.Field(C_Timestamp__Last_Update_from_CSV_Import1)}}",
        "C_Last_Exited_ILM_Program1": "{{Contact.Field(C_Last_Exited_ILM_Program1)}}",
        "C_SFDCContactID": "{{Contact.Field(C_SFDCContactID)}}",
        "C_Last_Entered_Engage_Program_Date_1": "{{Contact.Field(C_Last_Entered_Engage_Program_Date_1)}}",
        "C_Profile_Recovery_Flag1": "{{Contact.Field(C_Profile_Recovery_Flag1)}}"
      },
      "filter": "(((('{{Contact.Field(C_DateCreated)}}' >= '2022-11-05T00:18:06') AND ('{{Contact.Field(C_DateCreated)}}' < '2022-11-06T00:15:24'))))",
      "dataRetentionDuration": "P1D",
      "autoDeleteDuration": "PT6H",
      "areSystemTimestampsInUTC": true
    }
    
    
    Response: {
      "failures": [
        {
          "field": "filter",
          "value": "(((('{{Contact.Field(C_DateCreated)}}' >= '2022-11-05T00:18:06') AND ('{{Contact.Field(C_DateCreated)}}' < '2022-11-06T00:15:24'))))",
          "constraint": "Must contain an expression with reference to a valid service instance"
        }
      ]
    }
    

    We are running into the same issue across more than 20 different Eloqua instances. This is just one example.

    Appreciate your help!

    Priyang

    Post edited by Priyang Rathod on
  • User_NVFDK
    User_NVFDK Posts: 52 Red Ribbon

    @Lou Patrick when you say "We are currently working on a hotfix" do you mean Oracle?