Solved

Hi , In enrichment activity i creating expression as ‘A_’+Rowid() , now when i am running workflow it is giving below error OBD-24000 ODBC error : SQL compilation error: Window function type[ROW_NUMBER] requires ORDER BY in window specification.  How to resolve this issue

Hello Community Members, Good Day!I have a use case, I have a HTL file (present in the Dev, Stage and Prod instances) in which I have a particular HTL Snippet I want to get executed in AEM Stage and Dev instances only (Including Author and Publisher) and strictly not on the Production instance. Is there a way to code this logic in HTL so that the HTL Snippet will only gets executed on the Dev and Stage instance. Thank You.  

Hi everyone, I'm facing an issue in Customer Journey Analytics (CJA) where the same anonymous user (ECID) is being associated with multiple ECIDs across sessions (multiple Person IDs) — even when using the same browser and device. Here's my configuration:"Identity Map" data element type defined by Adobe Experience Platform Web SDK extension. Storage Duration: "None".ECID stored in another field for debugging purposes ("identities.ecid.id"). This field is populated by a data element with Storage Duration: "Visitor". The data element is a custom code (return _satellite.getVisitorId().getMarketingCloudVisitorID().)IdentityMap<ECID> as Person ID in all web datasets in CJA. Here’s what I’ve observed:The ECID is generated and stored correctly in the AMCV_###@AdobeOrg cookie.ECID stored in "identities.ecid.id" is unique, but in some cases (less than 1%) multiple ECIDs as Person IDs are linked to this field. Thus, a new ECID is gener

I am interested in applying for the AD0-E134 Adobe Experience Manager Sites Developer Expert certification exam. Before attempting the exam, I want to take a practice test through the Adobe Certification Exam Prep Portal. However, I noticed that there isn't a practice test available for the AD0-E134 exam. Could you please provide practice test questions for the AD0-E134 Adobe Experience Manager Sites Developer Expert exam, along with some reference study materials to help me prepare? Thanks And Regard John DavidEmail: johndavids213213@gmail.com

Hi,I've seen many posts and read through all the Adobe docs. on the Mobile SDK but for me, there is a gap in knowledge once it gets down to Tags/Launch and how to create data elements that need custom code to access data from the mobile app (not just built-in Lifecycle info). And how the rules should be structured as well as how to use Assurance to test the code? I've seen pieces but nothing that takes a developer from end-to-end completely. It's crazy, Adobe doesn't even have a class covering the Mobile SDK. Does anyone know of any resources that lay everything out or any third-party organizations that teach the Mobile SDK? As I mentioned, the docs. touch on most of this but not enough to be able to do an implementation. My particular areas of interest are: 1) how to create data elements/rules that return specific data from the mobile app.2) How to test with Assurance (I've seen the docs. but still leaves a bunch of questions). Thanks!  Thanks!

Hello,I am using the AEM Assets events from Adobe I/O on assets in the AEM cloud dev instance as shown here. However, it seems like the Assets Deleted and Asset Metadata Updated events do not register when I perform those actions on an asset in the mapped AEM cloud instance as shown here. These events also do not show up in the trace logs as shown below.  However, when I trigger the sample events directly from Adobe I/O as shown below, I do see both the events getting triggered with some sample requests. But it does not work for events on actual assets in the cloud dev instance. If anyone is facing this issue, please let me know any resolutions for this.  

I've created an action in adobe io that exports profiles in an adobe ajo journey, but even though it's not returning errors in my adobe io, ajo is taking a very large fraction of profiles from my action with the http error.This adobe io code receives the data and sends it to S3 (it's arriving correctly)example: out of 2000 profiles 1.3k are giving http errors (not timeouts) and the rest work correctly.  My app doesn't require authentication and is true for web, this is the payload I'm sending from adobe ajo to my export action:{"journeyId": {"toBeMapped": true,"dataType": "string","label": "nome jornada"},"fileName": {"toBeMapped": true,"dataType": "string","label": "Nome do arquivo"},"CHAVE": {"toBeMapped": true,"dataType": "string","label": "Chave"},"MARCA": {"toBeMapped": true,"dataType": "string","label": "Marca"}}

Hello Everyone,  I am checking  the possibility of extracting the definition of segment into a JSON format. The scope of segment definition  is the filters that compromise the build of the segments , like the dimensions used, other segments etc.,

Once data is ingested into dataLake, it create a profile in profile store. when we query the profile using ECID or other namespace, we do see unique profile-id associated with the record. now does this profile-id changes under any circumstance for that particular profile ? if yes, what are those scenario ? is this profile-id present in any dataset, if we need to query it using queryService ?

Hi, I’m trying to build a master table of campaigns and journeys (including campaign ID/name and journey ID/name) using the ajo_entity_dataset. However, I’ve run into an issue: there’s a journey whose name we recently updated (the current journey has the "v2" name, while the other two entries show the old names). Unfortunately, I can’t find a reliable way to filter for only the current journey name. The only timestamp field I found is lastModifiedAt, but it shows the same timestamp for all three records, so it doesn’t help me isolate the latest version.Is there another field available that would let me keep only the current journey with its updated name?Thanks for your help!

Many of our custom forms use the same fields. When you attempt to delete a custom form, you get warning message that says, "Deleting this form causes all custom data on the objects associated with the form to also be deleted. The deleted data cannot be recovered." I'm unsure of the scope of "all custom data." Does this mean that any other custom form that happens to use the same fields as the deleted form will have all their historical data in those fields deleted as well? Or does it only affect the historical data of the field associated with that particular form? Hope that makes sense.

how to get customer generated dataSet, as the below API only returns system generated dataSets ?https://developer.adobe.com/experience-platform-apis/references/catalog/#operation/listDatasets

I have a Workfront report to track reports that haven't been viewed in the last 3 months, and one of the columns is "Dashboards" so that I can see if a particular report is included on a dashboard.  However, reports that are included on Canvas dashboards don't show any value in the "Dashboards" column.  (Reports included on standard, non-Canvas dashboards do show the correct info in the "dashboards" column.)   Has anyone else run into this problem and/or is there another field I should include to display the Canvas dashboard info?  Thanks! For example:Report Name           DashboardsReport A                   Dashboard X   (standard dashboard)Report B                  **blank**           (even though it is on Canvas Dashboard Y) 

Hi - I am working on cleaning up an inherited instance. We have quite a few dead projects with tasks that are not completed. This shows in my overdue task report.. does anyone have any tips to clean this up? The tasks will remain open because the projects are dead and will not be picked back up.

Hi,I am working on a multilingual AEM Sites implementation and using Experience Fragments (XF) extensively for reuse across pages. I want to create localized variations of an XF but without duplicating the entire fragment manually for each language.Is there a recommended way to manage locale-specific variations of XFs in a scalable and maintainable manner?

Hi ,I created a data flow for SFTP source and executed it once at a certain time. Now, that everything was verified and works correctly, I want to modify the flow and schedule it to run daily at a certain time. I checked this link in the documentation Update a Source Connection Dataflow in the UI | Adobe Experience Platform but I don't see an "Update Dataflow" option in my shortcut menu. This is what I see in my AEP:If I try the "Edit Schedule" option - all is greyed out, like below, so I cannot modify anything: So, to my question - is there a way to modify the schedule for an existing Data Flow or I have to create a new one? Is what I see a matter of permissions, and, if so, what permissions must be set for me to be able to change the schedule? Any help would be highly appreciated. Thanks

We’re in the process of importing MLS data into Marketo for contacts already in our database—things like listing addresses, statuses (just sold/just listed), pricing, etc. One of the data points we could include is a direct image link (hosted externally) for each property.Has anyone used image URLs as a custom field in Marketo before?If so:Can we reference that image URL in an email and have it display properly?Are there any best practices for dealing with variable image sizes or load times?Any gotchas we should be aware of when using this approach in dynamic content?Would love to hear if this is a viable path and how others have handled it.Thanks!

I want to know what's the return visit rate of users who watched a livestream. Would it be best to set up a segment? How should I set up my tables to get this data.

Hello, Can I have a proof report which tells me what project the proof was uploaded on? Thanks,Nisha

Hi Team,In Adobe IO, I have Event Registered named "Asset Status". and for that I have configured Event Providers as AEM Assets, and which has various Subscribed Event as Assets Published, Asset Unpublished, Asset Download....and from AEM if I upload, publish, download... an asset the event is getting triggered and able to track it under debug Tracker and with the help of Journalling API when I hit below pathhttps://events-va6.adobe.io/events/organizations/39270/integrations/790353/628d3c56-844b-4f8d-a700-59e871963149I am able to retrieve event-details in JSON Format but only able to see for Asset Processing Completed.But I want to retrieve for all the other events as well like Asset Downloaded, Asset Published, Asset Unpublished.... can you please help me how to achieve this using Journaling APIThanks & Regards,Vishal Jain@sarav_prakash @amitvishwakarma @rojoangel @EstebanBustamante @arunpatidar @Harwinder-singh @sravs @abhishekana

Hi All, I created a very simple template and a component. 1. When I am creating a page selecting this template, screen becomes blank. Kindly examine the attached package once and suggest.  2. Also, I set allowedPaths of template to /content(/.*)?.This template is available only at http://localhost:4502/sites.html/content.How to make it available in this path and also all sites underneath it like "We Retail" and "WKND" ? Highly appreciate all your replies. Thanks,Rama.

Hi,  I am building out a Fusion Senario using webhooks. I was wondering what other strategies exist to limit access to the webhook besides an IP restriction? We would be hosting a server in AWS and can't use a IP restriction to restrict inputs from it.  Are there access token restrictions you can setup? OAuth / JWT restrictions? How do you secure your wehooks? 

profilesnapshot dataset has a field identityMap which has value in map structure. This is one of the sample value of identityMap field from the snapshot. [ecid -> "{(NULL,49790455655365226853605257450011089444,NULL)}",gid -> "{(NULL,3bcaebe5-6723-4822-abd4-2cfb22c4b908,NULL)}",vid -> "{(NULL,bacb8bd9d4aadef2d22482a829f1c149,NULL)}"] [ups -> "[795d22e5-ba6f-43e9-b8d8-e96f2be2e24c -> "(NULL,realized,2025-07-05 16:54:55.0)",73ffb7e5-7988-4108-9dd3-4403b2773915 -> "(NULL,realized,2025-07-05 16:54:55.0)"]"] i want to query snapshot dataset for a specific ecid. i have tried different syntax (cast, unnest, json_extract etc) but none of them worked. this is one of the query i tried. whats the correct syntax to access map values in snapshot dataset ? SELECT * FROM profile_snapshot_export_44b7518a_0a16_44bd_888c_891a9999ef0a whereJSON_EXTRACT(identityMap, '$.ecid[1]') = '49790455655365226853605257450011089444'

In documentation its said that development sandboxes are: slower, have its own limits Both types of sandboxes might be resetWhat are the advantages of Development sandboxes in that case from your experience?

Hi Experts,Could you kindly suggest if deployment independent for more number of pages ( more than 25 pages) same kind of lighthouse report can be generated? It will not be dependent upon AEMaaCS pipeline or deployment.If yes, kindly share in little details.Thanks in advance !!