ExactTarget query locks up

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
dkeseloff
Posts: 2
Joined: Tue 01 Nov 2016 16:53

ExactTarget query locks up

Post by dkeseloff » 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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ExactTarget query locks up

Post by Pinturiccio » 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.

dkeseloff
Posts: 2
Joined: Tue 01 Nov 2016 16:53

Re: ExactTarget query locks up

Post by dkeseloff » 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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ExactTarget query locks up

Post by Pinturiccio » 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?

Post Reply