Devart Forums

Posted: **Tue 01 Nov 2016 17:05**

Hi,

I am attempting to query the SentEvent object, with related columns of Subscriber, as shown in the query below. This query locks up consistently and never produces results.

I have successfully connected to ExactTarget using the User Authentication (user is set up as API user in Marketing Cloud). I have been able to run queries against other objects, such as the Send and Subscriber Objects and have been able to access the SentEvent when the related columns to Subscriber are unchecked.

Thanks for your help.

Code: Select all

SELECT t.SendID, 
       t.SubscriberKey, 
       t.EventDate, 
       t.Client_ID, 
       t.EventType, 
       t.BatchID, 
       t.TriggeredSendDefinitionObjectID, 
       t.ListID, 
       t.PartnerKey, 
       t.SubscriberID, 
       SubscriberID.ID AS "SubscriberID.ID", 
       SubscriberID.PartnerKey AS "SubscriberID.PartnerKey", 
       SubscriberID.CreatedDate AS "SubscriberID.CreatedDate", 
       SubscriberID.Client_ID AS "SubscriberID.Client_ID", 
       SubscriberID.Client_PartnerClientKey AS "SubscriberID.Client_PartnerClientKey", 
       SubscriberID.EmailAddress AS "SubscriberID.EmailAddress", 
       SubscriberID.SubscriberKey AS "SubscriberID.SubscriberKey", 
       SubscriberID.UnsubscribedDate AS "SubscriberID.UnsubscribedDate", 
       SubscriberID.Status AS "SubscriberID.Status", 
       SubscriberID.EmailTypePreference AS "SubscriberID.EmailTypePreference"
FROM SentEvent AS t
LEFT OUTER JOIN Subscriber AS SubscriberID ON t.SubscriberID = SubscriberID.ID
WHERE ((t.EventDate > '2016-09-01 09:42:05'))
LIMIT 100

Posted: **Fri 04 Nov 2016 12:08**

Try selecting only the SentEvent object and look through the returned rows. Are there any rows with EventType values later than '2016-09-01 09:42:05'?

If there are no such values, then no records are returned because of the "WHERE ((t.EventDate > '2016-09-01 09:42:05'))" condition.

Posted: **Fri 04 Nov 2016 15:27**

Thanks for your reply.

Yes, the latest record has a time stamp of 10/3/2016 7:32:34 AM.

Also, it is not that I am getting 0 records, it is that the query never completes. It hangs.

Thanks,

Dan

Posted: **Tue 08 Nov 2016 14:17**

We cannot reproduce the issue.

Please try using the Devart’s Skyvia tool and check whether the issue is reproduced with Skyvia. For this:
1. Go to https://skyvia.com/ and register for free.
2. Create a Marketing Cloud (ExactTarget) connection in the Connection tab. For more information, please refer to https://skyvia.com/resources/docs/index ... target.htm
3. Go to the Query page and click New SQL. Skyvia has a limitation of 5 queries per day in the free pricing plan. This should be enough for testing.
4. Select your connection and paste your query.
5. Click the Execute button.
6. Is the query executed successfully?

Devart Forums

ExactTarget query locks up

ExactTarget query locks up

Re: ExactTarget query locks up

Re: ExactTarget query locks up

Re: ExactTarget query locks up