Product Communities

The source dataflow is failing with the above error. Some one kindly give some information about this. I am seeing this error for the first time.

I am trying to create a calculated field in a custom form that will show me the average turn around time form Project Initiation To Approved Go Live date on all completed projects.  I cannot figure out how to get two expressions in the calculated field.  I know one would be DATEDIFF({DE:Approved Implementation Date},{DE:Project Initiation Date})but I don't know how to add the expression to get the average.  Any suggestions?

We are importing bulk Issues into Workfront for an upcoming onboarding of Projects. Usually, each one generates 3 different associated notifications. We don't want users to be burdened with mass notifications.I know there is a Project status that can be used "Planning" so modifications can be made to the Project that won't send out notifications. Is there a similar status that can be used for Issues?

Hi Team, i need help on this below question 1) When I check the dashboard report in Adobe Campaign Classic, it appears empty—even though the delivery is correctly linked. We’re using a custom target mapping, so I’m trying to determine whether this issue is related to access permissions or a problem with the campaign configuration. Can someone help me identify the root cause? attached screenshot . 2) I send daily emails to around 10,000 customers. I want to implement a rule to exclude any profile that has already received more than 3 emails within the same week from receiving additional emails.   Note : without control from typology because i dont have admin access  

We have opportunities created via SOAP `syncMObjects` API that are not accessible through the REST API. We need to understand the relationship between SOAP M Objects and REST objects, and how to properly migrate or access this data.I see similar question without the answer https://nation.marketo.com/t5/product-discussions/issue-s-with-switching-from-soap-api-to-rest-api-for/m-p/201612#M146895.  **SOAP Opportunity Creation (Working):** { "opportunity": { "type": "Opportunity", "id": 18577, "externalKey": { "attrName": "opportunities.id", "attrValue": "8bb9da36-ab39-11f0-80e8-cefbdec3b66f" }, "attribList": { "attrib": [ {"name": "Name", "value": "NAme"}, {"name": "Amount", "value": "99"}, {"name": "Stage", "value": "In Progress"} ] } }, "action": "UPSERT" } - `getMObjects` with ID 18577 successfully returns opportunity data but all&n

Hello community, I need to obtain a list of workflows that have been successfully executed in a month. Do you know if there is a way to do this? I am using the workflowlog table, extracting the records that contain the text ‘workflow is being run’ to obtain those that have been executed, but I cannot find a way to exclude those that ended in error since I cannot find an execution ID, and if a workflow has been executed several times during the day, I cannot differentiate which execution the error belongs to in the workflowlog table.. Thanks

can we keep common farm file code in a seperate file and reference it in siteA_farm.any and siteB_farm.any ? Below document says we can have a 'includes' folder in conf.d folder .Do we have similar for conf.dispatcher.d ?https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/implementing/content-delivery/validation-debug#flexible-mode-file-structure 

Hi friends,So, I have something which is driving me kinda crazy. I'm trying to write a validation logic rule where if a particular multiselect field is selected along with any other field that the validation error kicks in.Here's the formula:IF(ARRAYLENGTH({DE:fieldName})>1&&CONTAINS({DE:fieldName},"option"),"Option must be the only contract selected. Adjust this and resubmit.")Now, this is a valid expression. However, it isn't validating. I've been trying to cheat with Copilot and Grok and neither are giving me something which works.This is killing me because there's gotta be something simple that I'm clearly not seeing. Help? -j

I use the Workfront extension for InDesign and every time I generate a proof it gives people weird roles. For instance, some people are given "Reviewer & Approver" while others are given "Reviewer." I'm sure it has something to do with their role in the system, but I'd like for everyone I add to be a "Reviewer & Approver" and for me to be a "Reviewer" (I don't need to submit a decision on proofs I create). Is there some way to change that? At the moment, I have to open the proof in workfront and manually change the roles in the proof workflow every time I create a proof from the extension and it gets annoying. I've tried making templates, but each proof I create has different approvers so I can't always forsee what groups of people to include in a template and I don't necessarily want a million templates. To my knowledge, setting proof recipient roles within the extension is not currently possible, but it would be a great feature. If no workaround for this exists, can

Hi, Can we add more than 5 dynamic items of a dimension in column?  Don't seem to be possible yet, but I want to double check in case I didn't do it right. Thanks! 

Issue starts after AEM 6.5.23 service pack installation.The file upload field stopped popping up on the "Upload Zip" option of design importer.The error is due to sanitization of html which contained a non standard html attribute "coral-fileupload-select". Is this something adobe should fix as issue is with coral fields which are used in AEM but are non standard?  

Hi,I have a timesheet report that is shared with management.   We noticed that depending who runs the report, they don't see the same people.   For example, when I run the report for 'this quarter', I see timesheets for 14 people.   When one manager runs it, they get the same thing but then a different manager only sees 12 people.  I have checked to make sure they don't have any different filter or view on.   I didn't think there was permissions/sharing for timesheet profiles but maybe there are somewhere?  Also, the 2 people that don't show are the system administrators.  Any ideas why the difference in the report or any permission that I am missing somewhere? Thanks Heather 

Hi all, I'm sure I'm missing something super simple but I'm trying to use a calculated field, formatted as a number, to pull in the difference between our planned start date and actual completion date on our task reporting form for tasks named review. The formula I'm using is:  IF(CONTAINS({name},"review"),WEEKDAYDIFF({plannedStartDate},{actualCompletionDate}),"") but it isn't working as expected. Does anyone have any suggestions on how to further troubleshoot? 

Do we have Send Time Optimization (STO) in AJO under Campaigns ? if yes, is there a criteria only after which its enabled in the UI ?

Hi I wanted to ask if there's a way to create an exclusion list of users in the CDP who are not activated to any available destinations. I know that I could create an exclusion list audience and apply a "not in this audience" rule for all audiences I create. But I just wanted to know if there's a better way to do that. I've seen that I can apply usage policies to audiences to prevent them from being exported. However, if the users from the labeled audience belong to another segment, nothing is going to prevent them from being exported to any destination. For this case, it would be more about excluding a group of users from being exported to any destination. ThanksRenato

Hi @2693620 I am performing audience export. Email address field in audience export, where some the values are null in exported csv file. When SFMC automation takes this file, it gives error where emailaddress = 'null'.Could you suggest how can i make this field as blank ?Already tried below.1. Added calculated field and used both formulas iif(replacestr(email_address, ",", "") == 'null', '', replacestr(email_address, ",", ""))coalesce(replacestr(email_address, ",", ""), "") both are still giving null text in export. Thanks in advance.Best Regards,Santosh 

What happens when you use duration in a wait step without specifying the time?For example: Wait 4 hours, wait must end Mon-Friday. Send email.If someone enters the wait step on Saturday at 9 a.m., when will they receive the email? Right at 12:00 am Monday? Or would it be Monday 4 hours after they entered the wait, at 1 p.m. Monday?

Hi,We have Adobe Analytics and a Redshift instance where we put our web metrics, Qualtrics surveys, content inventories, etc. But we get constant requests for insights on what's going on inside of AEM.  List of pages with a specific value in a tag list. Can we get a list of pages that have “Payroll” in the product list tag?List of pages that have specific terms in the text. Can we get a list of all pages that contain the phrase “packaged solution” or “marketplace packaged solution”?List of pages with specific components. Can we get a list of pages that contain dynamic components?List of pages created by or modified by a person or list of persons.The following authors have left the company, and their content must be re-assigned to new authors. Provide a list of pages that have been authored by or last-modified the following people: Name1, Name2, …List of pages that contain a specific type of asset. Can we get a list of all pages that have attached Exce

I'm creating a Workfront to Jira scenario using the Jira Cloud Create a record Module.  It keeps erroring on the "reporter" field of t he module.  I have tried mapping it to both the Sponsor name and the email address of the sponsor but when I run the scenario I get an error:[400] Specify a valid value for reporterDoes anyone know what could be wrong?  In Jira the reporter is a character name. Thanks in advance  Frank

Hello Community,I am working with a dataset in AEP and need to trace all the batch IDs that were generated during a particular ingestion. I can see the source Dataflow Run ID has ingested some records in the dataset and took 1.3 hours run but I see during this time multiple batch have been created in dataset. I tried with APIs with the following ways: Flow services run id the payload do not provide the dataset detailsCatalogue services batches with bath id, here as well the Data flow run details are not available My requirement is:Given a source Dataflow Run ID, I want to list all the batch IDs created in AEP.What is the correct way (via API or Query Service) to fetch all batch IDs of a dataset based on a given Source Dataflow Run ID? 

Hi Community,I am trying to integrate Adobe Commerce with Adobe Experience Platform (AEP) using the Data Connection extension.I have created an event schema and a profile schema.I noticed that I cannot choose ECID (it seems to be default and not selectable).Now I want to know what type of Identity Namespace I should set as the Primary Identity for both schemas.Should I use Email, ECID, or some other namespace?What is the best practice for Adobe Commerce → AEP integration?

Hi there,We are trying to create an audience with evaluation method as Segmentation but when we try to save it, it says: Ineligible evaluation method.We don't quite understand why what are the methods that needs to compatible with the audience definition and the documentation is not very clear.Can anyone assist us?

Hi Team, We have uploaded a list of email IDs using custom upload under a new audience yesterday.In audience still total profile counts is not reflecting.  We are using it in an audience and no profile is qualifying under it during dry run. Does the respective dataset needs to be enabled for lookup?

Hi everyone, I’m facing a challenge I haven’t been able to solve yet. I have an Experience Event dataset that contains multiple rows per ID, and I need to transform it into a Profile dataset by aggregating all rows for a given ID into a single row, using arrays to store the values. Here’s an example of the schema:Experience Event Dataset_entity.fg.ID _entity.fg.name _entity.fg.score _entity.fg.normalizedScore _entity.fg.version Timestamp Target Profile Dataset_entity.ID _entity.fg[].name _entity.fg[].score _entity.fg[].normalizedScore _entity.fg[].version extSourceSystemAudit.lastUpdatedDate I’m trying to write a SQL query that would group all rows by ID and transform the values into arrays, but I haven’t found a working solution yet. Has anyone faced a similar use case or could share an example of how to achieve this transformation using SQL in AEP? Thanks in advance,Regards,Samy

We have an web event dataset which is profile enabled and ECID is an identity field. Now for record class datasets (Person, Account), we do not have ECID present . Now question is in Customer Profile store, will records for those ECID coming from Web Event Data will appear or not?