Adobe Campaign

Hello, i have an enrichment which joins 3 recipients. I have 2 computed attributes called NUMPER and NUMPOT.I use them to update data but I get this error.ORA-210000 Oracle error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys foundWDB-200001 SQL statement 'CREATE UNIQUE INDEX NPK_wkf145741_401_1 ON wkf145741_401_1 (biPKey_1)' could not be executed.Does anyone know how to fix this error, why does it create an index?@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

Hi there, please can someone address this on excluding the users based upon feature purchased Within the feature schema, users can acquire up to three features, leading to the following scenarios:If a user purchases only one feature, they will receive an email containing that specific feature. This dynamic content personalization involves checking the feature name within an if condition to render the email accordingly.If a user purchases two features, they will receive an email with both features included, again based on the if condition check.If a user acquires all three features, they will receive an email reflecting all three features.The goal is to address the following scenario: If a user buys one feature initially and then acquires another feature later, they should not receive the first feature again in subsequent emails, but only the new feature.To achieve this, I am focusing on broadlogs that do not contain the feature IDs. My workflow involves the following steps:&n

I'm connecting to a postgres database on AWS via FDA but getting errors on the primary key.The table is called transactions and has an attribute called betId as a unique primary key field.When I access the data in the table (via schema data view) I either get an error that primary key needs to be defined or when I define betId as primary key a sql error for cursor:ERROR: column a0.betid does not exist.'SELECT A0.betId FROM adobe.transactions A0 LIMIT 200' could not be executed. Schema definition:<key internal="true" name="pid" noDbIndex="true">  <keyfield xpath="@id"/></key><attribute advanced="false" label="betId" name="id" length="16" sqlname="betId" type="string"/>

when trying an API call for one of our ACS instance it returns following error. nPGS-220000 PostgreSQL error: connection to server at \"abc-mkt-stage4.chqkifxvjhq8.us-west-2.rds.amazonaws.com\" (xx.xx.xxx.xxx), port 5432 failed: FATAL:  remaining connection slots are reserved for non-replication superuser connections\ can someone let me know what this error means and how to fix this? Thanks in advance.

HelloI am trying to set up a complicated rule for published offer after they reached a certain count of opening.How should I write the application condition? 

How to get yesterdays and today CSV files from SFTP path 

can I use read list activity and list update activity both pointing to same list. basically, I first read a list as suppression list then lastly, insert any new data into the same list it seems to have error if i do like that. but if I read list activity and list update activity using different list that can be no errors in Adobe campaign classic

Hello, I'm importing a file with data loading activity and I'm getting this error: Can someone help me understand what it means?

How can I send a Proof with the increased quantity of a delivery?

Hi there,    I have several JavaScript activities that retrieve the total record count based on split conditions. Now, I've added another JavaScript activity to extract the segment code from the split activity. Additionally, I'm attempting to access the instance.vars variable within this new JavaScript activity, which was previously defined in the split condition JavaScript activity. However, an error occurs stating that the "Unable to parse the expression" 1st Js Activity: instance.vars.countOfSegment_RecipientEmail =  vars.recCount 2nd JS Activity : <node expr={"+instance.vars.RecipientEmail+"}  alias="@Segment"/> - The 2nd JS activity is throwing an error   I have implemented two split activities where I've defined instance.vars. in both. Now, I aim to retrieve and display these instances.vars declarations in a table format of an alert activity as shown below:   Please suggest if there's a more effective method to accomplish this task, or h

Do aliases in enrichment activities need to start with "@" for example... "@segmentcode"or can I just alias it "segmentcode"?  Updating Media  Thanks!

Hello,I am configuring a simple if else statement to display content based on data being passed in targetdata in the workflow.  Here is my statement.  I have tested the "if" part alone and it works fine but once I add in the Else, I get the following error.<% if ( targetData.segment == "A" ) { %>HELLO<% } %> <% else { %>GOODBYE<% } %>  

Hi,I am exporting failed deliveries so we can clean our database. When I export the field 'failureMsg' (from targeting dimension) this containes carriage return line feeds that create unwanted new lines in my file. Is there a way to replace them for spaces?

Hi There,  Can we retrieve data from a Google Sheet and incorporate it into the team table within a workflow for exclusion purposes? Additionally, considering this is a dynamic list where new records are added daily, what would be the best approach to accomplish this? Thank you in advance.

Hi All We have 3 schemas (recipient, lead, Dealer) and three target Mapping for the each of the schemas. We afe planning to make  an 'Unsubscribe Webapp' for  the 3 schemas.. In the webapp there is a dropdown to capture the reason and press submit  button after which the user gets Unsubscribed. The Webapp will update a Boolean filed in 'Email Opt Out' schema as 'Yes' and the reason of opt-out. This 'Email opt out schema ' will be used to to exclude users from further email communication send out from any of the three target mapping namely recipient, lead and dealer.  (the three schemas do not have a common id and we are planning to use exclusion in workflow to exclude opt-out users ). We want to use this webapp for all the three schemas for unsubscribing. Please suggest a approach / solution to achieve this RegardsBhaskar  

Is there a way to desactivate/unpublished an offer automatically?

Hello, I received several mails from mcd-mkt-prod32@adobe-campaign.com , each containing text like this in both subject and mail: 06/16/2020 07:18:28_DE Favorite Items Import(mcdDeFavoriteItemsImport) Import Successfulor 06/16/2020 07:19:14_DE Engagement Sources Import(mcdDeEngagementSourcesImport) Import Successfuletc I wanted to ask if these mails genuinely belong to Adobe Campaign and what could be the reason I received them, because I am not using any Adobe Campaign product. Regards  

Have faced a "Folder hierarchies of environments ' ' and ' ' do not match error" in offerMgt workflow.Preceded by a "Folder path ' ' is not a subfolder of folder path ' ' " warning.Have tried to delete that Design folder and create again but doesn't work.Any idea what to do to fix this?Thanks for your help!

Hi all, I need help with the following case, hope someone knows how to implement it: We assume that in the workflow we start from a table with the following structure: personagegenderMario18HombreDiego31HombreSergio22HombreMaria50MujerIgnacio45HombreAlberto29HombreBlanca25Mujer And after that table we add a Split with two paths. Where the segment code there would have the value of Male or Female depending on the path:  But then I would like to add a Cells where in the segment code part I could enter the age variable: The desired end result would be this:personagegendersegmentCodeMario18HombreHombre_18Diego31HombreHombre_31Sergio22HombreHombre_22Maria50MujerMujer_50Ignacio45HombreHombre_45Alberto29HombreHombre_29Blanca25MujerMujer_25  Is it possible?  Thank your very much as always Kind regards,Blanca   

Hi there,  Is there a method to compare two columns (feature_purchased_date and email_sent_date) belonging to different tables? I want to retrieve records where feature_purchased_date from the "feature" table is greater than email_sent_date from the "recipient delivery logs" table.  Thank you in advance

Hi there,I tried using the script below in the JS activity, but I encountered the error: 'it is not contained in either aggregate function or GROUP BY clause.' I am now attempting to use a subquery and will update you on the progress. Please can you let me know if it can be achievable without using subquery.var fquery = xtk.queryDef.create ( <queryDef schema = {vars.targetSchema} operation = "select" > <select> <node expr="Substring(@segmentCode,'_',1)" alias="SegmentCode"/> <node expr="Sum(Case(When(@segmentCode LIKE '%_IS_DELETED', 1), Else(0)))" alias="@IS_DELETED"/> </select> <groupBy> <node expr="Substring(@segmentCode,'_',1)"/> </groupBy> </queryDef> ); var itemsXMLF = fquery.ExecuteQuery(); // DOMElement var itemsXMLFStr2 = itemsXMLF.toString(); vars.itemsXMLFString2 = itemsXMLF.toXMLString(); //logInfo("itemsXMLF = " + itemsXMLF.toString()

Hi all! Is there a way to add seed addresses in the Campaign Web UI?

Hi all team, I would like to ask if its possible to group the values ​​of a query by a variable. We have seen how to do it with the variable that is Key of the table but not with other variables. For example, in this case it groups the emails sent for each request (the key is request) and checking the boxes that I indicate. But how can I group by another variable, for example DNI?  Maybe it is not possible, but need to be ensure! Thank you very much for your help. Kind regards,Blanca

hi all.please help me with high level steps on how can we send proof for direct mail delivery in adobe campaign classic@parthas @akshayanand @3176980 

Hi, We have the option called upload from local machine, for data loading activity. Is it possible we can find where the file is stored while uploading it to server. Can we access the server where the file gets stored, as it shows its being stored in the temporary schema. I checked in many schemas in adobe unable to find the same.Any idea how we can see where it's getting stored?