Eloqua BULK API Calls Remains in Pending Status (Doc ID 2040030.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Eloqua Marketing Cloud Service - Version 9 to 10 [Release 9 to 10]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Eloqua's BULK API remains in "pending" status

EXPECTED BEHAVIOR
-----------------------
Eloqua's BULK API should return success status after finished

STEPS
-----------------------
The issue can be reproduced via the following steps:


1. Run Bulk API

POST https://.eloqua.com/api/bulk/2.0/activities/exports
{
  "name":"Example Activity Export",
  "fields":{
  "ActivityId":"{{Activity.Id}}",
  "AssetName":"{{Activity.Asset.Name}}",
  "ActivityType":"{{Activity.Type}}",
  "ActivityDate":"{{Activity.CreatedAt}}",
  "EmailAddress":"{{Activity.Field(EmailAddress)}}",
  "ContactId":"{{Activity.Contact.Id}}",
  "VisitorId":"{{Activity.Visitor.Id}}",
  "AssetType":"{{Activity.Asset.Type}}",
  "AssetId":"{{Activity.Asset.Id}}",
  "RawData":"{{Activity.Field(RawData)}}"
  },
  "filter":"'{{Activity.Type}}'='FormSubmit'"
}


2. Receive the below response:

{
  "name":"ATD - Example Activity Export",
  "fields":{
  "ActivityId":"{{Activity.Id}}",
  "AssetName":"{{Activity.Asset.Name}}",
  "ActivityType":"{{Activity.Type}}",
  "ActivityDate":"{{Activity.CreatedAt}}",
  "EmailAddress":"{{Activity.Field(EmailAddress)}}",
  "ContactId":"{{Activity.Contact.Id}}",
  "VisitorId":"{{Activity.Visitor.Id}}",
  "AssetType":"{{Activity.Asset.Type}}",
  "AssetId":"{{Activity.Asset.Id}}",
  },
  "filter":"'{{Activity.Type}}'='FormSubmit'",
  "uri":"/activities/exports/1",
  "createdBy":"Docs.Example",
  "createdAt":"2014-01-28T21:18:06.5184689Z",
  "updatedBy":"Docs.Example",
  "updatedAt":"2014-01-28T21:18:06.5184689Z"
}


3. Synchronize the Data for Export

POST https://.eloqua.com/api/bulk/2.0/syncs
{
  "syncedInstanceUri" : "/activities/exports/1"
}


4. Get the below response: it always shows "pending"

{
  "syncedInstanceUri":"/activities/exports/1",
  "status":"pending",
  "createdAt":"2014-01-28T21:18:07.5792689Z",
  "createdBy":"Docs.Example",
  "uri":"/syncs/123"
}


BUSINESS IMPACT
-----------------------
The issue has the following business impact:


Due to this issue, users cannot determine if their BULK API calls are working correctly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms