Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Darren_Bowers
Community profile Darren_Bowers MVP
Marketing Automation Integration Manager
Australia
18 BADGES
MVP

MVP

Learn more
Joined the community 25-02-2020 7:38:42 PM
Online
Top badges earned by Darren_Bowers
Customize the badges you want to showcase on your profile
Re: WKF-560038 error when performing action 'prepare' on...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi Mubeen - I think the key error here is 'DLV-490007 There is no valid address to execute the proof' - it sounds like a proofing error, but I have seen this happen when 0 targets try to go into a delivery that has seed addresses set up. I have also seen it happen sometimes when you have non-existent seed folders referenced. Check your incoming target counts and how your seed addresses are set up. Cheers Darren

Views

9

Likes

0

Replies

0
Re: WKF-560038 error when performing action 'prepare' on...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi Mubeen. There should be a delivery that it has tried to prepare. You should find it in the execution folder (the same delivery folder the successful deliveries go into). It would likely have failed because of some logic condition in your email that only happens occasionally. In that delivery you will find an audit log which might tell you why it failed

Views

68

Likes

0

Replies

0
Re: WKF-560038 error when performing action 'prepare' on...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi Mubeen - are there any specific errors in the workflow journal that might help us figure out what the issue is?

Views

123

Likes

0

Replies

0
Re: WKF-560038 error when performing action 'prepare' on...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi@MK0610 - what errors are showing in the delivery Audit logs?https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/monitoring-deliveries/delivery-dashboard.html?lang=en#delivery-audit-ThanksDarren

Views

168

Likes

0

Replies

7
Re: Audit Logs for Experience Cloud Admin Activity
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Experience Cloud
@Ryan_Monger- thanks for this update - this is great news.CheersDarren

Views

182

Likes

0

Replies

0
Re: More than simple input for responding a question / thread into the Adobe forum
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Community Help and Feedback
Hi @CedricRey - I raised this with the forum team as well and while the Comment field is very basic (i.e. no markup at all) what was suggested by the team is you can post the basic Comment with no formatting, then re-edit it again using "Edit Answer" after the Comment is posted.I know its not ideal, but its the only way to correctly format your Comment reply to a thread post right now.CheersDarren

Views

34

Likes

0

Replies

0
Re: enumeration type = system
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @ParthaSarathy - thats a really good question that I dont have a direct answer for. If I was to guess, I would say it allows you to turn an Open Enumeration field to a System type enumeration without losing the additional settings for Open. That way you can turn it back to Open when you want to accept additions again. Its kind of like a Read Only setting for Open enumerations. Someone else here might have a better explanation 🙂 Cheers Darren

Views

100

Likes

0

Replies

0
Re: enumeration type = system
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @ParthaSarathy - System type enumerations are fixed and can't be changed directly in the form field that references them. The Open type of enumeration can be added to by entering the new values into the form field directly if the field supports it.https://experienceleague.adobe.com/docs/campaign-classic/using/getting-started/administration-basics/managing-enumerations.htmlCheersDarren

Views

120

Likes

0

Replies

3
Re: How to handle file import if the content of a column...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
@WastonAdobe- this is a common problem, but doesn't have any really nice fixes if you are using the built-in functionality to import the incoming files.Most of the fixes would require upstream fixes: e.g.Change your string delimiter to not include use the problem character (using uncommon characters like pipe "|" can help)Parse your source data to change the delimiter character before or during export (i.e. single quote to double quote or visa-versa)Pre-parse the file before import using sed/awk...

Views

97

Like

1

Replies

1
Re: Apache Kafka connector
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
@CedricRey- interesting that you post this as we are looking at using Kafka to manage some enterprise-wide configuration changes.Campaign Classic already uses Kafka for its Triggers / Pipelined implementation so you would expect it shouldn't be too difficult to expose those APIs internally for general Kafka use.CheersDarren

Views

90

Likes

0

Replies

0
Re: Encrypting PDF while sending Email to customer in Ado...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @mayank_singh - as I mentioned in my other post this isn't a simple piece of work that I can give you a solution for. It depends on a lot of factors. My advice would be to get the help of an Adobe partner or Adobe consulting to help you plan out what your requirements are and how best to achieve this.If I was going to do this, I would pre-create all of the PDFs in a location before you prepare the delivery and then pass in the location of the PDF to the Campaign workflow so you can either att...

Views

116

Likes

0

Replies

0
Re: Encrypting PDF while sending Email to customer in Ado...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @mayank_singh - there are lots of vendors now for creating PDFs, but to do it in real time you would need a PDF service available to your Campaign server that you can call via command line, API or even watched folders like Adobe Acrobat Distiller.So for one example, you could create a watched folder in Acrobat Distiller (can be a network folder) that when you drop a Word document into, it will convert that file to PDF and apply whatever security settings you want, based on the watched folder ...

Views

111

Likes

2

Replies

0
Re: Automating Cache Clearing in Adobe Campaign
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi Gaurav,This was touched on in this thread not long ago: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/server-clear-cache/qaq-p/404342But unless you are experiencing specific issues with your "cache" there isn't much you need to do from an Adobe Campaign perspective.CheersDarren

Views

131

Likes

2

Replies

0
Re: Redirection link failed for few URL
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi Ram - can you give us any more information like the changes you made to the click formula and an example of the types of links that do work vs the ones that don't work? Is the issue random or are there specific links that always don't work?CheersDarren

Views

92

Likes

0

Replies

0
Re: Enable company to https://console.adobe.io
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @1982luca - To access Adobe.io for your company you have to be a System Admin for your Org or be assigned a Developer role in the admin console: https://www.adobe.io/apis/experienceplatform/console/docs.html#!AdobeDocs/adobeio-console/master/faq.md#why-cant-i-create-a-project-for-my-organizationCheersDarren

Views

85

Like

1

Replies

0
Re: SQL in ACC
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - that would be dependant on your database implementation. I would look for documentation on PostgreSQL or SQL Server. That isnt really Campaign specific, unless you are after a data dictionary for Adobe Campaign then you just look at the schema definitions in Data schemas. Cheers Darren

Views

103

Likes

0

Replies

0
Re: SQL in ACC
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - Florian has some great blog posts / snippets on lots of different topics including queryDef & custom SQL functions:https://blog.floriancourgey.com/2018/08/use-querydef-the-database-toolkit-in-adobe-campaignhttps://blog.floriancourgey.com/2020/01/adobe-campaign-snippetshttps://blog.floriancourgey.com/2018/12/replace-in-expression-of-adobe-campaignThere's also the Adobe docs as a referenceCheersDarren

Views

168

Like

1

Replies

3
Re: Need Help with Looping in JS for a usecase
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
@akashaj7696 - you mention you only want to populat the bestZip (12345) for ID1. If the use case is this simple then just use an Enrichment activity that looks for CCT_ID = "ID1" then set the bestZip value to 12345. If its more complex than this, like you have more than one CCT_ID that you need to look for then you probabaly need to use JS to locate and populate the bestZip for the right CCT_ID. Cheers

Views

125

Likes

0

Replies

0
Re: Need Help with Looping in JS for a usecase
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - I have tried to do this and I found that its easier to write back to another schema than the one you are querying in the queryDef. You can then query the temporary table later in the workflow.I could never get the xtk.session.Write() function to actually work correctly so I used sqlExec() instead. Be careful if you are using user-input values as its not database-safe doing direct DB writes, so you should sanitize the inputs.Also, the write operation seems to affect the cursor i...

Views

164

Likes

0

Replies

3
Re: Scheduled workflow getting executed before the assign...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @Greeshma_Sampath1 - There are a couple of strange time entries in there. The first one is when the workflow ran at 02:31:51 PM - that's almost a 2 minute schedule delay. It could indicate your system is under large performance load.The 20 minute delay at 03:50:12 PM is pretty extreme though.The late starts could also be related to other factors like @craigthonis mentioned or if a workflow killed the Campaign Jobs (operationMgt) workflow and required a restart.CheersDarren

Views

121

Likes

0

Replies

0
Re: Unique Identifier of Email
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @gnals12. If you just delete the data in the BroadLog then the primary key will continue where it left off. Its a database sequence and will continue to increase unless you reset it (usually not recommended). Unsure why you want to "clean" the BroadLog. It should be regularly purged as part of the normall instance configuration. You can set the BroadLog history in the configuration. Cheers Darren

Views

121

Likes

0

Replies

0
Re: Administration Node is not showing up
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @gnals12 - The screenshot you showed has the administration folder/node on it.Do you mean the folder is there but you cant access it? If that's the case then talk to your sysadmin - they haven't enabled the admin rights correctly.CheersDarren

Views

113

Likes

0

Replies

0
Re: Add 3 days to script for "Test"
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @drewettj - an easy way to do this is to subtract the last run time from the current time and see if its less than 3 days. e.g. (getCurrentDate().getTime() - getOption("lastRunDate_TECHNICALWORKFLOW").getTime())<=259200000 Date.getTime() returns milliseconds for for 3 days = (3 * 1000 * 60 * 60 * 24) = 259200000 millisecondsCheersdarren

Views

144

Likes

0

Replies

0
Re: Unique Identifier of Email
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @gnals12 - The broadLog primary key (@id) is the unique identifier for a message created in ACC. Every message created (including control, seeds and proofs) will have a unique broadLog identifier. You can find it in the nms:broadLogRcp table.CheersDarren

Views

153

Like

1

Replies

2
Re: How to change a subject line script into an actual subject line in the broadlog
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - a subject that is unique to a recipient can't be stored under the definition for a delivery, because the delivery object doesnt contain all the data per recipient.If you need to see the subject before you send the delivery you can enrich the subject using a formula onto the temporary schema in the workflow. If you need to see the subject after you send the delivery then you can add it to the broadLog as @wodnicki has described below. Cheers Darren

Views

147

Likes

0

Replies

0
Re: How to change a subject line script into an actual su...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
@akashaj7696 - I'm not sure its stored anywhere. I would expect it is calculated on the fly by the SMTP send email function using the data + subject formula and fired off as part of the email

Views

180

Likes

0

Replies

0
Re: ACC not recognizing bracket notation javascript, alwa...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @JoshuelPattersonRM - I tested your code and it works fine in a delivery template.You should probably change the for loop limit to 3 as you only have 2 array items, but otherwise it works fine.CheersDarren

Views

126

Like

1

Replies

0
Re: track mailto: in adobe campaign classic
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @Ketangp - its not actually possible to track a mailto: link since it doesn't open a web browser to the Campaign tracking server. mailto: and tel: links are handled by the mail client natively on the user's local machine or within the browser client.There are some workarounds you can do where you link to a page that opens a mailto: link using Javascript, but the CX on something like that is questionable, but at least it is tracked.CheersDarren

Views

130

Like

1

Replies

0
Re: How to change a subject line script into an actual su...
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - I'm not sure what you mean by "try something inside the delivery"? @wodnicki has given you a response above on how to store the computed subject in the BroadLog. Unfortunately this is the only way to retrieve it after the delivery have been sent. Does this help you get what you need? Cheers

Views

231

Likes

0

Replies

0
Re: Get recipients from a API to delivery and send an email
Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

264 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
- Adobe Campaign Classic
Hi @ags - Yes you can do this but it would be up to you how you want to treat the incoming targets. You can choose to add them as Recipients in the Javascript, then load them from the Recipient table further in the workflow. You can also save the new targets into a temporary table and again retrieve them as your targets before the send. There are a few options you have available.Typically what you also want to do (whichever way you choose) is have some way to identify them again, either by putti...

Views

165

Likes

0

Replies

0