Solved

I am trying to execute insert operation throught javascript method.  var temp="INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES ('9383677898998939','GOWTHAMANTEST','GOWTHAMTEST1')";logInfo("My query :"+temp);var strSql = sqlExec(temp);  but its throwing unique constraint exception. How do i refer to my sequence and get the next value to insert? 02/11/2020 12:50:57 PM WDB-200001 SQL statement 'INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES ('9383677898998939','GOWTHAMANTEST','GOWTHAMTEST1')' could not be executed.02/11/2020 12:50:57 PM PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint "gowsampledb_id" DETAIL: Key (isampledbid)=(0) already exists.

I am trying to scan AEM multi module project using sonar and got the following error. I have uber jar 6.3 version in pom files.[ERROR] COMPILATION ERROR : [INFO] -------------------------------------------------------------[ERROR] /var/lib/jenkins/jobs/Experiments/jobs/SONAR-TEST-Modules-Scan/workspace/ui.apps/src/main/content/jcr_root/apps/sling/servlet/errorhandler/ResponseStatus.java:[3,28] cannot find symbol  symbol: class WCMUse  location: package com.adobe.cq.sightly[ERROR] /var/lib/jenkins/jobs/Experiments/jobs/SONAR-TEST-Modules-Scan/workspace/ui.apps/src/main/content/jcr_root/apps/sling/servlet/errorhandler/ResponseStatus.java:[5,37] cannot find symbol  symbol: class WCMUse[ERROR] /var/lib/jenkins/jobs/Experiments/jobs/SONAR-TEST-Modules-Scan/workspace/ui.apps/src/main/content/jcr_root/apps/sling/servlet/errorhandler/ResponseStatus.java:[9,5] method does not override or implement a method from a supertype[ERROR] /var/lib/jenkins/jobs/Experiments/jobs/SONAR-TEST-Modules-Scan/wo

1. can a user have a visitor ID?2. can a visitor have a User ID?3. we have an app that has pre and post logins - is pre- login "Visitor", and post-login "User"?

I have to create segments in Adobe Analytics.These segments use many different URLs, thus they are many conditions.I heard that there is a way to import my URLs via a spreadsheet upload into Segment builder.I'm seeking documentation on how to use the Segment builder spreadsheet upload.Can this be done through classifications?

Hello all, we have custom templates and polices in our project deployed to "/conf/customProject/settings/wcm/templates" and "/conf/customProject/settings/wcm/policies". The problem is, that on the publisher the policies don't work, because of the deny jcr:all for everyone on the conf-folder. So we need to add 2 ACLs:This works perfectly for us, but we don't know if there are any side effects or if there is not a better user (maybe a system user) for this issue. Does anyone have the same issue and a better practice to handle it? Best, Maik

I packaged a site from our Dev environment and added it to my local AEM instance. I would like to be able to edit that site using Eclipse but I don't know how to go from "already in AEM" to Eclipse project. I only know how to go from making a new project and add it to AEM.

How do we use different links for any particular CTA button in an email?For example, for one of the CTA s we need user to go to a particular clan(kind of casino game) and collect coins; however we cannot let them collect coins if they click the CTA second time. In that case, they should not be redirected to the place where they collected the coin but go somewhere else on the clan app.Any idea on how to do this?Do I need to manually change the link everyday going to the CTA in marketo? Or we have a way to do that?

I'd like to filter my internal traffic on a Rollup suite and leave my site's actual reporting suite without exclusions. Has anyone tried this and/or what observations do you have?  How long does it take for these filters to take effect or are they immediate?   Such as if I need to add or remove IPs I want to exclude.On this same topic, is the visitor's IP address available to s_code so that I can capture it and store it as an evar, traffic var?  I noticed that Processing Rules can take actions on traffic from recognized IPs. Thanks for any info/ideas!MitchellT

We use the "Visits Web Page" trigger to enter people into a nurture stream.  It looks like this: Visits Web Page - Webpage contains (any of 5 values/URLs) - Date of Activity in past 7 days - Min Number of Times: 4 Does this setup mean someone will only qualify if they have visited at least ONE of the URLs at least 4 times?  Or does it mean they would qualify if they visited a combo of those URLs for a total of 4 visits?  (For example, they visited each URL one time in 7 days, for a total of 4 webpage visits.  Or if they visited the first URL two times, then the third URL once, and the fifth URL once - for a total of 4 visits.)  

Hello Experts,  I have received an email from Scene7 support that TLS 1.1 security protocol will not be supported from 29th Feb 2020. I have analyzed that there is no impact as such in our system but still I would like to hear from experts if there could be any potential issue for Scene 7 users. Our Current Setup: We are uploading assets into DAM, these assets get sync to S7 using DAM update asset workflow. After the successful upload of assets into S7, we use these assets for authoring.Assets access URL format is //company.scene7.com/is/image/image_name_without_extension (asset access url is not having request scheme while accessing the asset in pages for authoring). Cheers! 

Hi, I need to use Akamai Replication Agent V3  Could any one provide inputs on  sample code that could be used with  AEM6.3 Thanks

I have added new fields in fields management. I can see the new added field in the Lead info page but the same is not visible on Company info page.How can i add the same button on Company Info page or this is a limitation.Best regards,Deepak Kumar

During Indexing can we have some property by which results from the certain paths are given high preference rather others. Example - I want my query to fetch the results from both the paths (/content/A  , /content/B ) but results from path /content/A should be on top rather then results from /content/B.

I'm receiving an error when attempting to edit a previously created metric (created by me). The error says "You do not have permission to create components for this report suite" and I cannot save the metric after making changes (it's greyed out). I have tried clearing cache/cookies and signing out an back in. Has anyone else experienced this? Thank you,Whitney

EnglishCould you tell about after the market form is created. 【phenomenon】After sending the text contents filled in after creating the form, when the same form is used again, if the text box (arbitrary input item) is sent in a blank state, the previous contents will be reflected in the text box of the alert mail content I have. [Solution]I hope know the solution if this is a Marketo specification or a bug. Thank you 日本語マルケトフォーム作成後について、教えて頂きたいことがあります。 【現象】フォーム作成後記入したテキスト内容を送信後、再度同じフォームを使用した際、テキストボックス（任意入力項目）をブランクの状態で送信するとアラートメールの内容に前回の内容がテキストボックスに反映されてしまっている。 【解決】こちらがマルケトの仕様なのかバグなのか知りたい よろしくお願い致します。 

I want to set default values for fields inside coral ui multifield. I tried to use cq:template but not sure of how to set values for fields inside aem multifieds. Can anyone help me out with this?

I have a requirement to add RTE text dynamically by the selection of the Listbox.  if anyone is having any idea on how to do that. Please share the details. Thanks In Advance.    

I have a requirement to add a table to the AEM TouchUI dialogue and I want to add content to that table dynamically by the selection of dropdown. Please guide me on how to do that. Thanks In Advance   

Hi Everyone!  I'm setting up a newsletter sign up page, where we're hoping to use multiple single check boxes to indicate a subscription to the corresponding newsletter.  These boxes map to custom fields in salesforce that are also check boxes.  The problem we keep running into is making the check boxes "required".  We don't want to allow people to submit the form without having at least one of these boxes checked, but if we select "required" in forms 2.0, you have to check off the boxes.  I'm guessing that this might be solved with some kind of script in an html box on the landing page?   I've suggested going with a select box to make things easy, but the web team is pretty firm on making these check boxes. How would you guys approach this problem?

Hi, Has anyone come across this issue where you are unable to create a translation project for one particular page using reference panel method.It just creates an empty folder entry in projects but with no translation project content inside the folder. Please find error log below:10.02.2020 06:53:47.131 *ERROR* [JobHandler: /var/workflow/instances/server0/2020-01-31/update_language_copy_11:/content/project-name/language-masters/da-dk/plans] com.day.cq.workflow.compatibility.CQWorkflowProcessRunner Process execution resulted in an error: Error while updating the content of /content/launches/2020/02/10/translation_reviewdanishdenmark18/content/project-name/language-masters/da-dk/plans.com.day.cq.workflow.WorkflowException: Error while updating the content of /content/launches/2020/02/10/translation_reviewdanishdenmark18/content/project-name/language-masters/da-dk/plans.at com.adobe.cq.wcm.translation.impl.process.InjectMasterLanguageIntoLaunchProcess.execute(InjectMasterLanguageInto

I am trying to debug some java code, but i am getting a connection timed out exception-Failed to connect to remote VM. Connection timed out.I have added if not defined CQ_JVM_OPTS set CQ_JVM_OPTS=-Xmx1024m -XX:MaxPermSize=256M -Djava.awt.headless=true -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=30303in start.bat file

When I try to target a component for a specific region the wrench icon to open the dialog is not showing up. There are no error in the logs and the component is allowing to be edited for different regions, is there anything I could try to troubleshoot this? Thanks,J

I've read posts about the /content/entities folder that the CF models reference, but I don't have one in my project.If I go through the Cloud Services configuration in the assets folder properties, I am able to create CFs using the models from the selected conf/ directory. My issue is that a global project holds several CF models and this project will have a few extra models. If I enable the new models using this method, I can't use the old "global" models from another project. Does anyone know what the best practice is for allowing CF models from multiple projects on a asset folder?

Hi My colleagues and I are having issues downloading reports in Analytics - we select the relevant options (download > excel), it comes up with the "Your report is being generated in the following format: Excel" and then shortly turns into the following error message:  Failed to create XLS report. An administrator has been notified. It's been like this for weeks. Workspace reports download perfectly fine and the scheduled projects come out on time but the main analytics reports are all affected by the above. ThanksKirsten

Hi!I'm having an issue with some fairly large discrepancies regarding DTM Rules and Adobe Analytics displaying the results.We have a Page Load Rule set to fire event 99 on /AddVehicles page called Start Quote, however those numbers do not match the number of visits to that page. Its only showing that the rule fired 52k times when there were 83k visits.Here are the DTM Conditions:Additionally, we have a Direct Call Rule set up to fire on the same page that should trigger some non-sequential third party tags (AdWords, Kenshoo, Twitter, Floodlight, etc) in addition to firing event 1 in Adobe Analytics which we have named Add Vehicles Page Load. As you can see in the first image, that custom event is firing even less than the Start Quote Page Load rule. (42k)Shouldnt all of these numbers be the same? or at least closer than they are? I inherited this suite setup, so I didnt implement them, but Im thoroughly confused as to why the events arent much closer to the number of visits if they are