Eloqua Bulk Export Breaking since Release 22D

Priyang Rathod

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!

Lou Patrick

https://community.oracle.com/topliners/discussion/comment/16772338#Comment_16772338

"SourceCampaignId" is the cause of this validation error, as it can only be included in app contact exports.

Now that we are aware of this scenario of including all fields returned with the fields endpoint in the export, and that it is apparently a common practice, we have decided to remove the source campaign field from the fields endpoint. We are currently working on a hotfix.

Apologizes for this issue, and thanks for raising this and providing examples.

Lou Patrick

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

Priyang Rathod

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

User_NVFDK

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