Solved

How to get the get/procure a developer license for CQ5.x & AEM 6.x.Please email me at sandeepdas@triconinfotech.com if you have details around this.

Hi guys,I wanted to know if it's possible to use variables(instance or otherwise) in the Update step. I'm getting errors when MSSQL tries to generate the prepared statement. I'm fairly certain this should be possible, so I'm not sure why I'm getting errors. 07/05/2017 10:32:41 AM ODBC error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'. SQLState: 3700007/05/2017 10:32:41 AM ODBC error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. SQLState: 3700007/05/2017 10:32:41 AM SQL statement 'INSERT INTO wkf188035_86_1 (iRecTrnState, iPKey1, sPKey1_1, sPKey1_2, iPKey1_3, sPKey_1, sPKey_2, iPKey_3, sFld1065550762, sFld1066795947, iFld1067254700, iSrc1) SELECT   0, case when W0.iIClientId <> 0 then W0.iIClientId else NULL end, C107/05/2017 10:32:41 AM .sName, C1.sCampaignName, C1.iClientId, NULL, NULL, NULL, substring(cast(NULL as varchar(255)), 1, 255), substring(cast(NULL as varchar(255)), 1, 255), W0.

Model:  package com.adobe.aem.guides.sabb.core.models;import java.util.List;import javax.inject.Inject;import org.apache.sling.api.resource.Resource;import org.apache.sling.models.annotations.DefaultInjectionStrategy;import org.apache.sling.models.annotations.Model;@Model(adaptables = Resource.class, defaultInjectionStrategy = DefaultInjectionStrategy.OPTIONAL)public interface Article {    @Inject    List<Articles> getArticles();    @Model(adaptables = Resource.class, defaultInjectionStrategy = DefaultInjectionStrategy.OPTIONAL)    interface Articles {        @Inject        String getArticleTitle();        @Inject        String getArticleDate();        @Inject        String getArticleDescription();    }}  dialog xml:  <?xml version="1.0" encoding="UTF-8"?><jcr:root xmlns:sli

Hi Team,  Can anyone tell me how to calculate the anniversary date in an organization Req: Should send mail automatically when an employee completed one year in an organization. I need the Query conditions to calculate that  

Is this possible?Couldn't find any methods in the API to do so. Thanks!

Hello, When looking at top paid search keywords, I'm seeing a lot of unspecified keywords. Does anyone know why they are coming in as unspecified?   Thanks!

Hi All,Sitemap isnt generating page urls only giving the last modified date on uat environment but on test its showing page urls with last modified date, can anyone help me.mapping is like thisuat;template-slingmapping-brands.json;https;www-uat.isravision.com;;/content/isravision;test;template-slingmapping-brands.json;https;www-test.isravision.com;;/content/isravision;

I have seen a couple posts here related to a similar issue, where JCR-SQL2 query returns 3 results in CRXDE Query Tool but 0 results in OSGI.  Here's my code:String query = "SELECT DISTINCT page.[jcr:path] FROM [cq:Page] AS page...";Session session = resourceResolver.adaptTo(Session.class);QueryManager queryManager = session.getWorkspace().getQueryManager();Query query = queryManager.createQuery(query, Query.JCR_SQL2);QueryResult queryResult = query.execute();String mycontent = new String();if (queryResult.getNodes() != null) { NodeIterator nodeIterator = queryResult.getNodes(); while (nodeIterator.hasNext()) { Node node = nodeIterator.nextNode(); String path = node.getPath(); mycontent += path; }}The variable mycontent returns empty. Am I missing something? I tried to look into the queryResult but there's no return values inside. When I use breakpoint, it shows nodeIterator.hasNext() return false.. 

HI,I am trying to write Junit for a java class which has context aware configuration code something like below:Main class logic:ConfigurationBuilder configBuilder =resource.adaptTo(ConfigurationBuilder.class); SimpleConfig simpleConfig = configBuilder.name("feature").as(SimpleConfig.class); but smipleConfig value is showing as "null" when I debug it in Junit.Junit class logic, what I am trying to do:package org.apache.sling.testing.mock.caconfig; import static org.apache.sling.testing.mock.caconfig.ContextPlugins.CACONFIG; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertTrue; import org.apache.sling.api.resource.Resource; import org.apache.sling.api.resource.ValueMap; import org.apache.sling.caconfig.ConfigurationBuilder; import org.apache.sling.testing.mock.caconfig.example.SimpleConfig; import org.apache.sling.testing.mock.sling.junit.SlingContext; import org.apache.sling.testing.mock.sling.junit.SlingContextBuilder; import org.junit.Before;

We're using NameID as the SAML assertion attribute for the userIDAttributein the SAML OSGi config. Now, this needs to be changed to use Mail instead. We also have enabled auto-creation of user.Upon making the configuration change to use Mail instead of NameID, duplicate users are getting created. This is expected because the value of the two properties differs. Is there a way to consolidate the two? Asking because before going ahead to write a script for this, wanted to understand if there is a utility already available for this? or if I am missing to update any other relevant configurations to achieve this change?

I have added cugCheckUser as CUG on folder given in screenshot Then I have added publishUser in CUG exempted principal configuration as below.  When I am logging with publishUser credentials. I should able to see the content as publishUser is added in CUG Exempted principal configuration.If I login with cugCheckUser credentials I can see content. Why CUG Exempted principal not behaving properly.

We are attempting to export data from specific fields in a smart list to an external database via Marketo API. I am having trouble finding documentation or other questions that cover this, can it be done?

Does anyone know if there is a way to create a report that includes the timestamp of when a person filled out the form?

Is there anyway to add/edit our email headers? I am not talking about the top of the HTML document, but the actual header information of the email (reply-to, etc.) I know that the Email Editor gives Me Accress to From & Reply-to, but I have been advised that adding a List-Unsubscribe Header would possibly increase our deliverability with GMail, Outlook.com, and others. Does Anyone know if this can be added? 

I am trying to submit a form from AEM but when i submit a form receiving 400 error. Below details <section id="marketoForm">       <script src="//abc.xyz.com/js/forms2/js/forms2.min.js"></script>     <form id="mktoForm_1002"></form>     <script>MktoForms2.loadForm("//abc.xyz.com", "account_Id", 1002);</script> </section>     POST abc.xyz.com/index.php/leadCapture/save2 400   send @ forms2.min.js:7   ajax @ forms2.min.js:7   (anonymous) @ XDFrame:42   dispatch @ forms2.min.js:6   q.handle @ forms2.min.js:6   postMessage (async)       h @ forms2.min.js:4   i @ forms2.min.js:4   n.send @ forms2.min.js:4   U @ forms2.min.js:4   c @ forms2.min.js:4   (anonymous) @ forms2.min.js:4   Promise.then (async)   &

I was trying to build the custom code in Cloud Service Environment getting below trace and unable to run sonar checks.    Let me know if anyone had similar issue and any solutions helped?   Error Trace- Unable to run check class com.adobe.platform.experience.selfservice.cqrules.checks.java.UnableToSupportSlingSchedulerCheck - AMSCORE-554 on file /build_root/build/****/core/src/main/java/***************.java, To help improve SonarJava, please report this problem to SonarSource : see https://www.sonarqube.org/community/ java.lang.NullPointerException: nullat com.adobe.platform.experience.selfservice.cqrules.checks.java.UnableToSupportSlingSchedulerCheck.getClassFullyQualifierName(UnableToSupportSlingSchedulerCheck.java:82)at com.adobe.platform.experience.selfservice.cqrules.checks.java.UnableToSupportSlingSchedulerCheck.visitNode(UnableToSupportSlingSchedulerCheck.java:67)

Hoping someone has an idea how to do what I'm going to describe or a better alternative. We have a lead gen campaign. When a lead fills out a form Marketo sends a lead alert to one of our brokers, who are external to our company. The broker follows up with the lead. We have no visibility into what happens from there until the lead becomes a customer (if they do). WE WANT SOME LEVEL OF FEEDBACK ON WHAT HAPPENED THOUGH There was a thought to add a CTA to the lead alert that the broker could click >> go to a landing page with a form >> and provide information about their interaction with the lead. The key is to carry the lead information from the Lead Alert (which has Marketo fields incl. Company Name, Email, and more) over to the landing page when the broker clicks the CTA. When the form is submitted by the broker it updates the original lead's record in Marketo. ("I called the lead on May 3rd and sent them a quote." Hope that is enough of a description. Is something like

Hi,I have created a section container in which we can drag and drop multiple component in it using parsys but when i refresh the page the component that i have added in section container getting disappear also if i make any changes in section container then also the component inside it is getting disppear can someone help me with this?

How to convert the type of the file from JAR to Executable Jar file. Thanks&Regards,Anantharamulu.

Adobe's documentation gives very basic details about AEM Packager Manager's new extract only checkbox. Whar does it actually do? Extract Only - Extract the package only so that no snapshot is created and therefore uninstall will not be possibledocumentation Package Manager | Adobe Experience Manager Can someone please shed some more light?

I tried to install Marketo Sales Insight to our SFDC instance, but got error message on the page layout. Does anyone have any solutions? I followed the instruction to download from the SFDC AppExchange. https://experienceleague.adobe.com/docs/marketo/using/product-docs/marketo-sales-insight/msi-for-salesforce/installation/install-marketo-sales-insight-package-in-salesforce-appexchange.html?lang=en Then, I configured the SFDC using this instruction. https://experienceleague.adobe.com/docs/marketo/using/product-docs/marketo-sales-insight/msi-for-salesforce/configuration/configure-marketo-sales-insight-in-salesforce-enterprise-unlimited.html?lang=en   However, I got error message on the lead page layout. Does anyone know what I missed? Thank you!

Hi all, wondering if anyone has seen this before / has insight / knows a fix:   A client of ours identified an issue last week in which, when they open a Marketo email in a new Outlook window, the links no longer work. The links work fine in the standard "preview" window.   We are not able to recreate it, so we suspect it may have something to do with their internal email security settings, or similar. I have never personally seen this before so any feedback would be appreciated!

There is a need to kill a workflow.There are 1000's of dam update workflow in the instances tab and hence cannot locate this custom workflow from workflow instance tab and terminate it.I ran a query as below to locate the workflow /var path. This is actually in production , we need to do this. path=/var/workflow/instancestype=cq:Workflow1_property=status1_property.value=RUNNING2_property=modelId2_property.value=/var/workflow/models/dam/test-staging-assetsp.limit=-1 So, can someone help me how I can terminate this workflow using this /var path?I tried using the workflow remover from ACS commons, but it is not working and still I can see this workflow is active.Do we have any JMX console, where it is possible to give the /var path t terminate a workflow? @arunpatidar 

Hi all, I see that for SPAs, triggerView() fires a 'delivery' network request for a 'notification', much like a metric used under adobe.target.trackEvent(), rather than 'content' as seen with adobe.target.applyOffer(). I understand how to configure builds against triggerView in the VEC, but we have issues with the VEC in our secure account area, in that security issues currently restrict the site being viewed through an iFrame. This makes editing very tricky. My question is therefore: Is it possible to use the Form-based editor in conjunction with triggerView? In the 'Location' field, I see no option to select the 'view' key that is passed in the triggerView() call, and targeting the 'target-global-mbox' with audience refinements for page URL doesn't work either.How does the VEC recognise these view changes if it's not with new mbox names? Can that be replicated in the form-based editor? Many thanks,Chris

I want to change the colour of bullet list inside rte. So I created a new clientlibs with categories (rte.coralui3, cq.authoring.editor) and added my style definition and linked the created clientlibs inside my dialog but the clientlibs is not picked up. Clientlibs changesDialog I am following up this forum https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/add-style-to-rte-6-3-lt-ul-gt-or-lt-li-gt-element/m-p/255466. But it is not working in AEM 6.5. Am I missing anything ?