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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

David__Garcia
David__Garcia
Online

Badges

Badges
51

Accepted Solutions

Accepted Solutions
90

Likes

Likes
212

Posts

Posts
359

Discussions

Discussions
75

Questions

Questions
287

Ideas

Ideas
13

Blog Posts

Blog Posts
10
Top badges earned by David__Garcia
Customize the badges you want to showcase on your profile
Re: Query for delivery logs and account activation date
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
I can only suggest that you try running the query and see what you get, only by trying, trial and error, you will learn these different queries. perhaps try on a staging environment, learn the schema attributes available in the delivery schema and look at the list of available functions (https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/filtering-data/list-of-functions.html?lang=en)

Views

14

Like

1

Replies

0
Re: Query for delivery logs and account activation date
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
1- Will fetch deliveries whose delivery code is xyz (not delivery label), so if multiple deliveries happen to be configured with the same delivery code, it will pull records for them also.2- There is no such thing as recipient activation date ootb, unless you add it as a custom field and setup a custom process to update the flag based on a particular action such as email confirmation, double optin, etc etc.

Views

76

Likes

3

Replies

3
Re: Calculated fields using XML memo data
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Thanks!

Views

27

Likes

0

Replies

0
Re: Calculated fields using XML memo data
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
@Darren_Bowers @LaurentLam @Marcel_Szimonisz @Adhiyan @Jonathon_wodnicki @CedricRey @Milan_Vucetic @Manoj_Kumar_ @Florian_Courgey @Jean-Serge_Biro

Views

54

Likes

0

Replies

0
Re: Several Web service modules are getting created in a day in adobe application other than the daily auto restart at 6:00 AM
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
What version of Adobe Campaign you are running? I noticed this issue on older builds, and it was fixed by updating to the latest version, as a means of automated service recovery, I developed a powershell script to monitor unresponsive neolane services and to hard kill these services and restart them as the server was on premise, this was a possible short mitigation.

Views

148

Like

1

Replies

2
Calculated fields using XML memo data
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Given that I have the following recipient mData/data structure I tried using the following expression in a calculated field and in queryDef as well as [changes/@changeDate] in the where clause to no avail, I have a timestamp stored in the mData field and I need to calculate which records are over 72 hours old. "Iif(Abs([changes/@changeDate] - GetDate()) / 36e5) >= 72, 'Expired','Pending'" The following error is generated 24/12/2021 04:51:43 js6 QUE-370015 The node of path '/changes/@changeD...

Views

68

Likes

0

Replies

3
Re: Despite receipt failure recipients are retained in the delivery!
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
These documents may help at understanding delivery failures soft/hard bounces and the retry mechanisms. https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/monitoring-deliveries/understanding-delivery-failures.html?lang=enhttps://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/monitoring-deliveries/understanding-quarantine-management.html?lang=enhttps://experienceleague.adobe.com/docs/campaign-standard/using/testing-and-sending/monitoring-messa...

Views

33

Likes

2

Replies

0
Re: how to stop spam email from IP 130.248.176.196 ?
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
This is indeed an adobe campaign instance, you can add emailcenter@crm.magalu.com on your email provider blacklist. Also, there must be an opt-out flag in the bottom of your email? search for it, which updates adobe campaign and you will be automatically excluded from further marketing campaigns. You must have interacted with this website (https://www.magazineluiza.com.br) for them to acquire your email/details information, do you have an accont with them? send out an email to their support team...

Views

43

Like

1

Replies

0
Re: Storing data in mData / Memo XML
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
I was able to get it done by extending the recipient schema and adding more attributes to the new changes element In this way, I can use the following script to access the mData field and store data in an xml format. var recipient = NLWS.nmsRecipient.create( This is a test ) recipient.save();Available fieldsxpath to xml fields [changes/@firstName] However, I cannot get it to work with my JSON variant?var recipient = NLWS.nmsRecipient.create( {recipient:{ email : 'dummy@dummy.com', la...

Views

71

Like

1

Replies

0
Storing data in mData / Memo XML
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Currently, am using the sqlExec function to access the mData field of the recipient schema to store tmp data such as below, while this works, I do not want to rely on this method. /** store tmp changes in xml field **/ xmlData = '' +'' +'This is a test' +'' +'' sqlExec("UPDATE NmsRecipient SET mData = '"+xmlData+"' WHERE iRecipientId='"+parseInt(ctx.recipient.@id)+"' "); The first test was the JSON method (recipient.comment actually stores the string in the mData field) var recipient = NLWS.nmsR...

Views

78

Likes

0

Replies

2
Re: Why takes time to update RCH and RCHH multiple times in a loop process in a single execution.
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
What is RCH?

Views

33

Like

1

Replies

0
Re: tracking workflow failing without details
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
There is another client with the same version and deployment model facing the same issue, I will try to find out if this is a known issue.

Views

67

Like

1

Replies

0
Re: tracking workflow failing without details
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Whats your acc server version and deployment model? hybrid?

Views

81

Likes

0

Replies

2
Re: Authorized addresses in urlPermission
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
look for it using the search function, can't remember exactly which folder. "serverConf"

Views

64

Likes

0

Replies

0
Re: Authorized addresses in urlPermission
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
The location path of the serverconf varies depending on version and Operating System, but look for it somewhere inconfig.xml or serverConf.xml C:\Program Files (x86)\Adobe Campaign\Adobe Campaign v7\conf (windows)/usr/local/neolane/nl6/conf/ng/ (linux)you need to whitelist the domain/ip you are connecting to in the section mentioned Here are some support referenceshttps://experienceleague.adobe.com/docs/campaign-classic/using/installing-campaign-classic/additional-configurations/url-permissions....

Views

74

Likes

2

Replies

2
Re: tracking workflow failing without details
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
How often is your tracking workflow executing? every 1h?

Views

102

Likes

0

Replies

4
Re: Tracking Workflow taking very long times to execute after GS 11 upgrade
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Did you find the root cause?

Views

40

Likes

0

Replies

1
Re: Filtering Email Bot Activity in Adobe campaign Classic
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Given there are virtually unlimited number of domains and email addresses attached to them, bots are engineered to crawl email links in an attempt to find malicious links, there are virtually limitless number of bots with different kind of configuration on all email platforms which makes any attempt at detecting bots worthless. You could perform a small scale research by doing the following. Create set of addresses on major email providers (outlook, yahoo, gmail) they will be unmonitored (noone ...

Views

64

Like

1

Replies

0
Re: How to read mData data memo field xpath, javascript sqlGetMemo fromXMLString DOMDocument
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
After a lot of testing trial and error, the following worked; it was the xpath was wrong. var recipientId = 13241267; var x = sqlGetMemo('SELECT mData FROM nmsRecipient WHERE iRecipientId ='+recipientId); var y = DOMDocument.fromXMLString(x); var z = y.root.getValue('/changes/@firstName'); //now works var za = y.getElementsByTagName('recipient')[0].getValue('/changes/@firstName'); //now works

Views

69

Likes

3

Replies

0
How to read mData data memo field xpath, javascript sqlGetMemo fromXMLString DOMDocument
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
I am using the data/mData field in the recipient schema to store some data which has the following structure. Here is my script to write the data above to the recipient schema /** store tmp changes in xml field **/ xmlData = '' +'' +'' +'' +'' sqlExec("UPDATE NmsRecipient SET mData = '"+xmlData+"' WHERE iRecipientId='"+parseInt(ctx.recipient.@id)+"' "); Now I want to read the data stored by converting the mData to DOMdocument so that I can use xpath to traverse through the nodes and get the...

Views

80

Likes

0

Replies

1
Re: Dashboard report
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Try recomputing delivery statistics, the how to is listed under this blog https://blog.floriancourgey.com/2019/03/recompute-delivery-stats-adobe-campaign Javascript codevar nmsDeliveryDirtyFlags_tracking = 1; // tracking logs (1) var nmsDeliveryDirtyFlags_messageCounters = 8; // broad logs (1) var flags = nmsDeliveryDirtyFlags_tracking | nmsDeliveryDirtyFlags_messageCounters; // bit operation (2) NLWS.nmsDelivery.RecomputeStats(vars.deliveryId, flags); nmsDeliveryDirtyFlags_tracking and nmsDeliv...

Views

48

Like

1

Replies

0
Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Thanks Manoj,It was all down to the bloody template which had the wrong target mapping set. both scripts actually work.

Views

97

Likes

0

Replies

0
Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Update 3 Both scripts actually work, after double checking the configuration of my template, the target mapping had been set to nms:subscription rather than nms:recipient which is what the error code was pointing to, I can now sleep in peace.

Views

99

Likes

0

Replies

0
Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Hey Manoj, I've already tried and I get the same error, please see update 2, I am wondering why the audit log states attribute id unknown and to check the definition of the nms:subscription schema, could you please test both scripts on your side and let me know if you get the same error?

Views

102

Likes

0

Replies

2
Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
@Darren_Bowers @LaurentLam @Marcel_Szimonisz @Adhiyan @Jonathon_wodnicki @CedricRey @Milan_Vucetic @Manoj_Kumar_ @Florian_Courgey @Jean-Serge_Biro

Views

119

Likes

0

Replies

0
How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Hi All,I am working on a preference centre with the aim of notifying users on profile changes so that these can then be approved or cancelled, normally, I would trigger a command from the webapp to start a workflow and submit a few variables to personalize a delivery and execute it, however, I want to test out an alternative way of triggering the notification but I am short in time to go deep into testing and finding out how it works. How do you personalize, and execute a delivery on the fly usi...

Views

136

Likes

0

Replies

6
Re: Error code Momen_Code50_MailBlock
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
Find out the domain refusing emailsApply for whitelist (if you control your instance's mtas)Get details from refusing domain administrators as to why emails generating from your instance is being refused and request whitelisting.if hybrid solution, then involve deliverability team to act on your behalf and they will find out why email is being refused by the 1% of your population and possibly request whitelisting.Raise a ticket to Adobe Support and get deliverability involved.

Views

62

Like

1

Replies

0
Re: How to calculate average number of deliveries
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
One way would be: query broadlogrcp count by @ID group by DateOnly(@eventDate), refine query by @eventDate on or after DaysAgo(7), add enrichment then use avg() expression on the @count ( such as avg(@count)

Views

48

Like

1

Replies

0
Re: Passing a Distinct Workflow Variable to Alert
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
You can count the records (count(@id) and group by project field on your querydef The plan is to count the records and display the project those belong to RecordsProject25SDPROJ 456712SDPROJ 4567154SDPROJ 485653SDPROJ 6598 Here are some supporting docshttps://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/distinct-opens-and-clicks/m-p/265641https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/xtk-querydef-create-question/td-p/317948https://blog.f...

Views

78

Likes

0

Replies

1
Re: Adobe Campaign Classic V8 Non Admin user not able to run query on nms recipient
Avatar
Expansion
Employee
David__Garcia
Employee

Likes

212 likes

Total Posts

359 posts

Correct reply

90 solutions
Top badges earned
Expansion
Builder
Originator
Bedrock
Coach
View profile
David__Garcia
- Adobe Campaign Classic
The next issue could be folder rights as the SQL error is doing a join on xtkrights with your two operators (xr.iOperatorId IN (258970, 258974)) ) Can you check the web@default logs and look for an error code QUE-370030 perhaps there are some missing rights on some folders, something like the following QUE-370030 You do not have the rights needed on folder of identifier xxx (documents of type 'Workflow (workflow)') to complete the operation. (iRc=-53) So search for all instances of "QUE-370030 Y...

Views

134

Likes

0

Replies

2