since ‎05-05-2017
‎10-12-2019
vigneshn9321496
Employee
Re: How to get count after split activity for each subset
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Classic
Hi,Thanks for your reply.What I need is this: I have a split activity to split based on conditions into subset1, subset2, subset3. Now I need count of records in subset1, subset2 and subset3.Should I add js script in each subset activity of the split?Thanks,Vignesh

Views

1.0K

Likes

0

Replies

0
How to get count after split activity for each subset
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Classic
Hi,I have a query, and then a split activity to split based on the trigger segment locale. Now I need to count of records in each of these split subsets stored in a separate targetData variable. How can I achieve that?Tried adding an enrichment activity in each of the split subsets to try and get the count of primary key (or countAll). But throws an error not a single-group group function.Tried checking the "GroupBy" and also Group data by targeting dimension element in advanced properties. Then...

Views

2.9K

Like

1

Replies

3
Re: Enrich List values to TriggerLog query data
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,Thanks Ankur. We did use row id to form a link and update in the enrichment.Thanks,Vignesh

Views

489

Likes

0

Replies

0
Enrich List values to TriggerLog query data
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,I have a requirement where I have got a list of promo codes. I would need to pick up random (non-repeating) promo codes from the list and add them to the query data (one promo code to one email id) and send out a delivery.Tried adding a readlist activity and enrich the query data with a value from the list. But problem is, I do not have a link to get a specific promo code and add it to a particular email id entry.Any suggestions on how I can achieve this?Thanks,Vignesh

Views

659

Likes

0

Replies

2
Get details of workflows from which no mails have been sent
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,I need a query to get the details of the workflows (within this workflow there is a delivery) which did not trigger any deliveries. Basically where there were no records in the query action and hence no one was targetted in the delivery action and so no mails sent.Tried to do the below:query on workflows schema will give me the workflows that ran successfully. Exclude the data from the triggerlogs or triggerlogUC so that we get data of workflows which ran successfully but did not insert any d...

Views

385

Likes

0

Replies

0
Re: Use query data in the delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi Adam,Seems like there is an issue in the ";" character used in your script. Try developing a simple script first with only one column of values to be displayed. I was able to use the above script without any issues.Thanks,Vignesh

Views

1.1K

Likes

0

Replies

0
Re: ORA-210000 Oracle error: ORA-01878: specified field not found in datetime or interval
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi Florent,Issue was because of a few records which were present in the database which were in the Daylight saving time difference. Deleted those records and now the workflow runs fine without any issue.Thanks,Vignesh

Views

1.6K

Like

1

Replies

0
ORA-210000 Oracle error: ORA-01878: specified field not found in datetime or interval
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,I have a query in my workflow and I am using an expressionDateOnly(@START_DATE) greater than or equal to DateOnly(DaysAgo(14)).When the query runs, for a few records which fall on Daylight saving time shift, is throwing an error.Tried to use ToDate(@START_DATE) as well, and still the same issue.Can someone assist on how to get rid of this.Thanks,Vignesh

Views

2.1K

Like

1

Replies

2
Recipient specified by a script in continuous delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,Could anyone let me know how to use the "Specified by a script" feature in a continuous delivery (how can the static list of recipients be specified) in campaign v6.Thanks,Vignesh

Views

555

Like

1

Replies

1
Re: Use query data in the delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi all,Thanks for the help. Used Amit's suggestion on changing the schema, and now able to get the values in the instance variable. But while using the variable in the alert statement, I get an error that I do not have rights needed on the folder to complete the operation. Planning to try with a continuous delivery instead.Thanks,Vignesh

Views

967

Likes

0

Replies

0
Re: Use query data in the delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi Dan,Unfortunately I do not have access to change the rights of operators in the instance.Also I tried to use query def like below:var query = xtk.queryDef.create( ); var resultSet = query.ExecuteQuery(); for each (var row in resultSet) { logInfo("From temp schema : " + row.@newFirstName); instance.vars.AKTEST = row.@newFirstName; logInfo("From instance variable : " + instance.vars.AKTEST); } But Got the below error : "02/26/2018 5:28:17 AM js3 SCR-160012 JavaScript: error while evaluating...

Views

977

Likes

0

Replies

0
Re: Use query data in the delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi Dan,Thanks a lot for your reply. When I tried to run that workflow, I get an error "The user cannot use the 'execCommand' function without having the required 'sql' right.".Is there any way to avoid this?Thanks,Vignesh

Views

973

Likes

0

Replies

0
Use query data in the delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,I have a query action which queries the "Workflows" and identifies all the workflows which are in paused state due to an error. I want to create a workflow which queries this, and sends out the output of the query (all the paused workflow names) in a delivery. Is this possible?Thanks,Vignesh

Views

5.3K

Likes

3

Replies

9
Export personalization block?
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,Is there a way to export the P-Blocks for reference to the local machine? Or is the only way to copy the html from the pblock into a notepad and save them in the machine separately?Any guidance in this is highly appreciated.Thanks,Vignesh

Views

858

Likes

0

Replies

1
Re: Include duplicate email ids in a delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,Thanks for the reply.After unchecking the "Exclude Duplicate Addresses during Delivery", I also had to check the "Keep duplicate records (same identifier)" and now all the email ids are getting targeted and I can substitute them while sending proofs.Thanks,Vignesh

Views

1.1K

Likes

0

Replies

0
Include duplicate email ids in a delivery
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,I have a requirement where I need to include duplicate email ids in the delivery, since they are different in having a unique segment id which is also included in the delivery. I am basically having a split activity and adding separate segment ids to each split (and overlapping the split data). And while sending the delivery, the duplicate email ids are getting excluded with a reason "Double" in the 'Target' section of the delivery.Any way I can overcome this behavior?Thanks,Vignesh

Views

1.9K

Like

1

Replies

2
Re: Bounce summary report population
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi Amit,Thanks for your input. I did try to create a new delivery and included 2 email addresses in the target section. One a proper email and another a bounce email id (tested that it was a bounce email by sending a mail from my personal email id). When I started the delivery, the delivery has executed saying 100% successful " All messages have been processed" and in the sending logs, I see that the message has been sent successfully to the bounce email as well.Any insight on this behavior is r...

Views

865

Likes

0

Replies

1
Re: Bounce summary report population
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi Amit,I am trying in ACS env, not v6. And I see that even after 5 days, the delivery which I had created still is in "Sending" state and in the log, I see "DEL-430020 Scheduling next retry to xxxxxx".Any idea when this might actually go to the bounce report?Thanks,Vignesh

Views

865

Likes

0

Replies

3
Bounce summary report population
Avatar

vigneshn9321496

Employee

vigneshn9321496
- Adobe Campaign Standard
Hi,I created a delivery and sent it to an email which I am sure doesn't exist. The delivery is still in "Sending" state and trying repeatedly to send that email since 4 days now as seen in the delivery log. When will the delivery sending stop and get updated in the bounce report saying that this delivery could not be sent and have the value "1" in the Bounce summary report for the column "Bounces"?Any help in this is highly appreciated. I am pretty new to this tool.Thanks,Vignesh

Views

1.1K

Likes

0

Replies

5
Likes given to