Solved

Here is sample of my schema which I will export data to <element autopk="true" autouuid="true" dataSource="nms:extAccount:bqExport" desc="bqtest" hybrid="false" img="xtk:bigquery.png" label="bqtest" labelSingular="bqtest" name="bqtest" sqltable="bqtest"> <attribute label="col1" name="col1" type="string"/> <attribute label="col2" name="col2" type="string"/> <attribute label="col3" name="col3" type="datetime"/> </element> In my workflow I am querying these 3 columns from campaign and then I have the update activity with operation type set to "Insert" as I only want to export deltas rather than syncing changes the gcp remote table, for this reason I had set the autopk="true" and autouuid="true" However, I am getting the following error 10/01/2025 03:05:27 writer2 WDB-200001 SQL statement 'UPDATE wkf5712550_85_1 SET uAutoPKey_1= WHERE iRecProcState >= 0 AND COALESCE(uPKey_1,NULL) IS NULL' could not be executed. 10/01/2025 03:05:

Hi Team, Our site has implemented with youtube-nocookie.com videos but this format videos are not tracking with youtube embedded tracking method,Can some one help me how we can track this kind of video? @jennifer-6

Hi Gurus!! Trying to get a report to group tasks initially by under either "COPY" or "DESIGN", and then by project namebased on if the task name has the word "Copy" in it, or the word "design". This way copy/design teams could see everything relating to them, even if it was an ad hoc task not in templates.Been muddling around with text mode for groupings and after reading i think its around valuefield but not getting exact results i want to see. (maybe its Valueexpression?)group.0.valuefield=IF(CONTAINS("copy",{name}),"")also wondering how i would say to the program to put things under 1 of these 2 headings,so If name Contains "copy" put under "Copy" group. If name Contains "design" put under "Design" group.Hoping this makes sense to all and thanks for any help/solutions/guidance! 

Has anyone developed a way to generate a proof review report that shows you proofs you were assigned to as a reviewer only?

We have upgraded from 6.5.13 to 6.5.16 and after that page activation/publish and rollout page is not working. Does anyone had this issue and fixed it already? Please help.Error in the log:POST /libs/wcm/core/content/reference.json HTTP/1.1] org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Uncaught Throwable javax.servlet.ServletException: org.apache.jackrabbit.oak.query.RuntimeNodeTraversalException: The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.Edit: I added the below properties as suggested but still not works. 

Hi all, we wanted to setup a webhook to calculate the sum of 2 fields (Behavior Score and Demographic Score) and update to another field called "Person Score".We created the webhook and the php code (attached both), and we're getting Response Code: 200, but the actual "Person score" is not updated. Can you check what might be the issue?  Many thanks Itay

Hi all, To anyone experienced with the subject, how easy or difficult it is and does it work faithfully and at scale? Can someone please point me to any good set of documentation on this subject with steps to follow and approach etc? Thanks..

Marketing server and DB (Oracle) - In house in client premises.Data is getting loaded for multiple Business units.For better performance of database, client is looking for partitioning of database.What are the best practices that can be suggested to clients for partitioning.Would there be any change at Adobe Campaign application level (any changes to existing workflows or queries) if the database is partitioned? Please help with pointers.

Hi, I am System administrator for my Org. I am trying to grant developer access to console, but developer is not able to login to console successfully. Everytime he sees User login only  Can you please point correct Products to assign from adminconsole to grant developer access.  

Hello, I would need to find out the last PLP viewed before a purchase, how could i do that?

 We would like to track the visitors with the help of tracking code on sub domains of a website.example - when a user redirecting to registration page ( where tracking code is not implemented)  from previous page xyz, we don't want to lose the value of the tracking code from page XYZ  to registration page. (same session --> keep track of users, necessity to keep track of campaign, different domain will not carry the tracking code.)* what will be the ideal solution to the query above? 

Hi, I have a task report with a column that is calculating the turnaround time of the task: displayname=Turnaround Timetextmode=truevalueexpression=IF(ISBLANK({actualCompletionDate}), "", CONCAT(WEEKDAYDIFF({handoffDate},{actualCompletionDate})))valueformat=HTMLThe report is grouped by month and the team would like to see the Turnaround Time AVERAGE summarized per month without having to export the report into excel and use a formula to find the address there. Is this possible? 

Hi, I read all threads about the subject and I haven't found clear answer. Let's say we have Adobe Analytics implementation with vsitorID (server side by Tealium EventStream) We would like to migrate to Adobe Cloud ID (ECID) identifiers. My understanding was that we can enable ECID in parallel to visitorID, have some months of traffic with both identifiers and then turn off visitorID to smoothly migrate visitors which came to the website in between. But the way how it works in our test is following: Scenario (values are created by me)1. Visit with visitorID=123 only2. Visit with visitorID=123 and ECID=abc => the same Visitor3. Visit with ECID=abc (without visitorID) => NEW (2nd) VISITOR  Why visitor with the same value as ECID is not stitched before and after turning off visitorID?Is there a way to migrate from visitorID to Adobe Cloud ID without completely loosing existing Visitors?

 Hey all, I am trying to pass data from Adobe Analytics into another application using 2oath authroization within an Analytics Project API To do so the destination requires data related to the Token Endpoints which I am not able to find. For context, I am Analytics owner, not a developer, and  in my previous uses of the APIs (ex. Supermetrics) I have only needed the ClientID and Client Secret and OrgID to successfull connect. This application is asking for Authorization Token Endpoint and Token Endpoint URL : i have gone through the API documentation and any reference to the Endpoints defines them, but doesnt help on where to find, or who can create / identify ( https://experienceleague.adobe.com/en/docs/experience-platform/destinations/destination-sdk/functionality/destination-configuration/oauth2-authorization) Fields Required to connect AA to ApplicationsClient IDHAVEClient SecretHAVEAuthorization Endpoint URLCANT FINDToken Endpoint URLCANT FINDGlobal C

I am using AEM to manage experience fragments that are shared with Target. I make updates to the content of experience fragments regularly and would like to be able to keep a change history in case I need to revert to a previous version. I have not found anything in Adobe's documentation regarding a detailed change log or version control. Does AEM have version control for experience fragments? If not how are others managing logging updates and reverting, if necessary? Thanks,Keith

Hi All, I have a requirement to customize AEM ACS Commons Query Report Builder.I have created dropdown Tier wise (Tier1, Tier2, Tier3) each tyre has Multiple paths.Like Tier1 has 4 paths, Tier2 has 10 pathson basis of selection i need to Execute queryI am using but in XML i can't write multiple queries <queryconfigjcr:primaryType="nt:unstructured"sling:resourceType="acs-commons/components/utilities/report-builder/configs/queryconfig"pageSize="50"query="type=cq:Page
path={{parentPath}}
1_property=jcr:content/cq:template
1_property.value={{pageTypes}}
2_property=jcr:content/cq:lastReplicated
2_property.operation={{isPublished}}
3_property=jcr:content/jcr:primaryType
3_property.value=cq:PageContent"queryLanguage="queryBuilder"reportExecutor="com.adobe.acs.commons.reports.models.QueryReportExecutor"/> Any Suggestions how to implement this. Thanks in Advance.

Hi all, I am building an API which will serve up some HTML for other websites to consume. The general idea is that there will be an experience fragment within AEM, and my API will grab the HTML output of this experience fragment and append that to the API response. Is there a way within Java that I can programmatically calculate the rendered HTML output of an experience fragment? The fragment will be made up of multiple sightly based components. Imagine an API response similar to this: { "cssLink": "mysite.com/path/to/some.css", "jsLink": "mysite.com/path/to/some.js", "html": "<div class='my-fragment'>...</div>" }

I have few AEM Users with different type of permissions like let's say User A is a content author and has access till pages only, while User B is a developer and has access till most of the nodes except few like he/she may not have access to configuration nodes etc.. While User C has access to everything and belongs to Admin group. All these users are in on-prem instance of AEM and I want to migrate to AEM Cloud Instance. How can I achieve this.? Similarly I want to migrate the groups as well...

hi , does anyone know how to salt a sha256 hash in CDP? i see that if i use the sha256 function sha256(string) in the flow mapping it works, but when i add a salt to the function sha256(string,string) it returns as blank.

Hi So..... i have a column in the data schema called eventDate, it is string, date-time format in the standard format (ie 2025-01-13T16:15:00Z) - In an AJO email I'd like to display this as both the date in the format 13-01-2025 and the time as 16:15 for the life of me I cant figure out the converting and formatting. any ideas?

I have a Marketo form for an event where I want to enable the submit button only after the user has entered the correct value in the event code field? How do I do this? I have the Global Validation Rule enabled already to check for email ID entered. This particular check is for a different field.

Hi all,How is a 'new visitor' defined?  A new visitor is a visitor who hasn't been to you your site in xx days? 30, perhaps?  Cannot find a definition.Thanks,Marty

Hi all,Need some help trying to set up a report for my team. Currently we have a calculated field (SD EH Date | Vendor Partnerships) returning a date stamp of the most recent change from another custom field in the form.I'm trying to compare that date stamp to the current day the report is run ($$TODAY) and determine if the difference in time is within the last 2 weeks, within the last week, or within the last 48hr. Essentially trying to flag changes that happen within a gradient system as we get closer to present day.I've tried searching these forums and other Experience League resources, was currently attempting the following in the column with no success:valueexpression=IF(DATEDIFF($$TODAY;{DE:SD EH Date | Vendor Partnerships};days))<=2,"Urgent Change",IF(DATEDIFF($$TODAY;{DE:SD EH Date | Vendor Partnerships};days))<=7,"New Change",IF(DATEDIFF($$TODAY;{DE:SD EH Date | Vendor Partnerships};days)) <=14,"Recent change","No changes")))Any insight would be appreciated! I'm still

We have been using a round robin with random sampling like this: https://nation.marketo.com/t5/knowledgebase/distribute-your-leads-round-robin-or-randomly/ta-p/248624 but there are discussions about the fairness of the random sample and it has been requested that we try a round robin queue.For example tasks go to Salesperson 1 the 2 then 3 and then the fourth task would go back to Salesperson 1 so the queue works in a linear order rather than randomly.I cant find a good way to do this in single flow.  Idea I've had but can't create - this would create a cycle but unsure how I can phrase that in a Marketo flow(if last task was allocated to this Salesperson 1, allocate to Salesperson 2...ect...default option go to Salesperson 1) Any help or ideas would be much appreciated

Hello,I created a adaptive form that submits data to a php script with a Submit to URL link.And in the post submit event of this button i click another invisible button liek this:xfa.resolveNode("Countries.#pageSet.Page2.Invisible.Subform2.Button1").execEvent("click"); that also holds a script to upload the file on a server and save same details in a mysql table:this.event__click.submit.target = "https://serveraddress/2025/submitRDI.php?id_poz=" + xfa.resolveNode("Countries.#pageSet.Page2.Invisible.Subform2.id_pvc").rawValue + "&rng=" + Countries.hiddenFields.RNG.rawValue;Is there a way to do these 2 actions with 1 button so that after the 1st action is completed the second one will start?