Hi @Klaster ,This is nice idea as direct-path insert can perform significantly better than conventional insert.However, there are some constraints here:Data is written directly into datafiles, bypassing the buffer cache;Free space in the table is not reused;Rreferential integrity constraints are ignored. Regards,Milan

Re: Multiple Approvers Required- Adobe Campaign Classic Milan_Vucetic - Adobe Campaign Classic

Hi Jordan, I have not tested but check documentation below.In the event of single approval, the transition corresponding to the choice of operator is activated and the task is finished: the other operators cannot reply.In the event of multiple approvals, transitions corresponding to the choice of each operator are enabled. The task is finished when all operators of the group have replied, or when the task has expired.This activity does not block processing, and the workflow can perform other tas...

Re: Is it possible to change an image after an email got... Milan_Vucetic - Adobe Campaign Classic

Hi @thibaultb473199 I do not think that mentioned aproach is worth at all. Image is in most cases already downloaded in customer inboxes.This would make sense with new Interactive Email Content with AMP (link).However, let's hear the opinion of others. Regards,Milan

Re: Tests for Adobe Campaign Classic Upgrade Milan_Vucetic - Adobe Campaign Classic

Hi @EllyLfind a Build Upgrade Checklist for Campaign Classic file on this link.However, you should extend this with a lot of others/smaller checks (public resources upload, login via IMS...)Regards,Milan

Get monitor report on email Milan_Vucetic - Adobe Campaign Classic

Hi all,Adobe Campaign offers a nice health report on https://your-domain/nl/jsp/monitor.jsp address.In case you want this report to be sent on your email address, this is one of the ways how to do it.In JavaScript node paste the following lines (adjust bold text): function getToken(url, username, password) {var cnx = new HttpSoapConnection(url);var session = new SoapService(cnx, 'urn:xtk:session');session.addMethod("Logon", "xtk:session#Logon",["sessiontoken", "string", "Login", "string", "Passw...

Re: Date query Milan_Vucetic - Adobe Campaign Classic

Hi @Ramaswamiexclude id like this:Regards,Milan

Re: Date query Milan_Vucetic - Adobe Campaign Classic

Hi @Ramaswami,set up like this:Count(@unique_id)Max(DateOnly(@created_date))@respondent_idRegards,Milan

Re: Get records count Milan_Vucetic - Adobe Campaign Classic

Hi @mak_007, you must provide more information or screenshoot of what you maked. Provided aggregation will work for described problem but we cannot see what or how you created everything. Regards, Milan

Re: Get records count Milan_Vucetic - Adobe Campaign Classic

Hi @mak_007,add one more Enrichment node and set these:Regards,Milan

Re: Custom modifications in delivery Input form Milan_Vucetic - Adobe Campaign Classic

Hi @ramprakasht3196, please test it.If not, try with AddDays(getDate(), 30)Regards,Milan

Re: Registering Tracking Servers Milan_Vucetic - Adobe Campaign Classic

Hi @sergio_NYC looks like a small bug.Just empty two fields in Externalize (External account and Instance name) and then de-check Externalize option and make Save.If you ensure that these two fields are emtpy, it will work for you otherwise will show this option enabled.Regards,Milan

Re: Custom modifications in delivery Input form Milan_Vucetic - Adobe Campaign Classic

Hi @ramprakasht3196you should edit nms:delivery and nms:newDelivery forms.lower or equal to - @your_date_field <= GetDate()equalt to or grater - @your_date_field >GetDate()Regards,Milan

Re: Help -- Temporary Work Table Limit by Percent of Total Milan_Vucetic - Adobe Campaign Classic

Hi @wpomeroyif understood correctly, you may add one Enrichment node after node (you provided screenshoot) and calculate percent with following formula:(count of CONTACT_ID * 100) / total_base_count - to get percentage per Zip codeFinaly, add one Split node and query percent column (percent which are above 85).Regards,Milan

Re: IOS Channel Tracking Configuration Milan_Vucetic - Adobe Campaign Classic

Hi @moseenCCthis actualy depends from your arhitecture.Assume that you have separate app and tracking servers for transactional messaging. If yes, then option 3 is correct.Regards,Milan

Re: Address substitution in proofs Milan_Vucetic - Adobe Campaign Classic

Hi @stpias you mentioned it works perfectly with Recipient target mapping.However, with "Subscriptions" target mapping you probably getting something like a Cartesian product. Check what are reconciliations keys for mentioned mapping and you will probably identify what cause the issue.Regards,Milan

Re: Automating Package Movement in Adobe Campaign Milan_Vucetic - Adobe Campaign Classic

Hi @d12kp,here you go:var specfileXml = ' ';var fileName = "location_of_export" + "your_package_name " + formatDate(getCurrentDate(), "%4Y-%2M-%2D %2H:%2N:%2S") + ".xml";var specFile = xtk.specFile.create(specfileXml);var package = specFile.GenerateDoc();saveXmlFile(package, fileName);RegardsMilan

Re: Primary Foreign relation in ACM Milan_Vucetic - Adobe Campaign Classic

Hi @abhiseks1679239,cardinality 1-N is created by default always. In order to create 1-1 relation add the following: revCardinality="single"If you want to create ref. integrity consider this: integrity (optional): referential integrity of the occurrence of the source table to the occurrence of the target table. Possible values are as follows:define : it is possible to delete the source occurrence if it is no longer referenced by a target occurrence,normal : deleting the source occurrence initial...

Re: Leave element not working as expected | Adobe Campaig... Milan_Vucetic - Adobe Campaign Classic

Hi @rahuladwani you should check:if you updated database structure with your new schema extensionwhy you have one tag more then it is needed in provided code (just after )if form can access provided paths (@campaignType,@campProduct, etc...)try with separate tag for each fieldRegards,Milan

Re: Performance Issues in Recomputing logic Milan_Vucetic - Adobe Campaign Classic

Hi @rohanpat,this query is realy "hard" and make recompute for each delivery ever sent. Not sure why you use this, as AC will do it (not in realtime of course).Tracking tables have link to the delivery table and this is a way to fetch impacted Delivery ID.One way can be to use Incremental query to fetch all tracking logs since last execution of the workflow. Based on previously mentioned link, use distinct delivery IDs from result and pass it to your JS script (adapt script to read temp query ta...

Re: Using Dynamic Javascript page with API URL call for l... Milan_Vucetic - Adobe Campaign Classic

Hi @hetfiddcheck if your external account is changed or deleted.Data Source : enter the following syntax nms:extAccount:ID of your external database account in the execution instance .As the error says, rtServerInfo.extAccount[0] does not exist. Regards,Milan

Re: Display sms content Milan_Vucetic - Adobe Campaign Classic

Hi @tejashriw155148, now is clear what is your requirement. From my perspective, this could be done by editing form and hard coding mentioned text if specific connector is used. However, this is not good solution at all but can be done. For this kind of requests delivery templates are used. Regards, Milan

Re: Inconditional stop on workflow - Error message Milan_Vucetic - Adobe Campaign Classic

Hi @noemielebautIf you are sure there is only one server it could be that you had a DNS change (new certificate maybe) or even server name change. It is strange that server or services restart did not helped. You did not mention if there is a load balancer in the architecture.You may try:put directly this endpoint (ibcrmr18.srv-ib.dev) to console and try again. It could be that you currently point DNS entry on IBCRMR18 and something stuckSee on what node workflow stopped. If it is database relat...

Re: Adobe Campaign Classic Vocabulary/Definitions Milan_Vucetic - Adobe Campaign Classic

Hi @DMartz unfortunately, you must use ACC general documentation for such thing: Link Here you can find tables descriptions: AC Database parameters Regards,Milan

Re: Exception Handling in Javascript Milan_Vucetic - Adobe Campaign Classic

Hi @nitesha38268385assume that you have whitelisted URLwhich you are hitting bellow.Make some debuging by yourself. Call part of this function from the workflow within JS node with logInfo(http.execute()) where you will get more info about exception.Hopefully, the new error you may find in this list: Error codes AC Regards,Milan

Re: Negative values in autopk field Milan_Vucetic - Adobe Campaign Classic

Hi @ukender, my sugestion is to open an Adobe Support ticket for this. Of course, update on latest stable build should resolve your problem. There is not too much documentation, but you can swith to some dedicated sequence Id. Check this link: https://helpx.adobe.com/campaign/kb/sequence_auto_generation.html#Switchtoadedicatedsequence Regards, Milan

Re: Display sms content Milan_Vucetic - Adobe Campaign Classic

Hi @tejashriw155148 just create an SMS delivery template with prefered connector and put prefered text in the Text content. Whenever you use this template, text will be show automaticaly.Check this link Regards,Milan

Re: Negative values in autopk field Milan_Vucetic - Adobe Campaign Classic

Hi @ukenderyou have probably reached maximum for xtkNewId. Instead of reseting (counting from 0 again) you have enabled negative sequence generation.Check this: Link Regards,Milan

Re: Converting month to its number Milan_Vucetic - Adobe Campaign Classic

Hi @Raaghuik1996create new column with this expresion:Iif(@column='January','1' , Iif(@column='February','2' ,Iif(@column='March','3' ,Iif(@column='April','4' ,Iif(@column='May','5' ,'Other')))))Adjust source column name and other months.In case you have dates in some column you can use built in function for month number Month ()Regards,Milan

Re: Real Time Pricing in Email Milan_Vucetic - Adobe Campaign Classic

Hi @raghavc small update on this topic as Adobe introduced AMP feature to accomplish these things.https://docs.adobe.com/content/help/en/campaign-classic/using/sending-messages/sending-emails/defining-interactive-content.html#targeting-amp-emailRegards,Milan