ATG/JAVA

Step 1:  Create custom StatesActiviy  /config/com/my/activity/statesActivities.xml < generic-activities >   < activity >     < id > states </ id >     < resource-bundle > com.my.bcc.WebAppResources </ resource-bundle >     < display-name-resource > states.displayName </ display-name-resource >     < description-resource > states.description </ description-resource >     < destination-page >       < url > /ControlCenter/index.html </ url >       < clear-context > true </ clear-context >       < acl > Profile$accessRight$ statesfull :read;Profile$accessRight$ statesread :read </ acl >     </ destination-page >   </ activity > </ generic-activities > Step 2. Create custom activitySource config/...

ContentBrowseHierarchy.xml Add Below tag to show custom item as child node in home node.   < browse-item is-root = "false" id = "home" create-allowed = "false" show-count = "false" label-resource = "node.home.label" icon-resource = "node.home.iconSmall" multisite = "any" bin = "false" >   <browse-item is-root="false" create-allowed="false" show-count="false" multisite="any" bin="false" reference-id="Quiz"/> </ browse-item > Add below tags to display custom items in browse panel and should be able to browse. 'Quiz' is item descriptor. Those will be displayed in browse panel. <!-- Quiz -->     <browse-item is-root="true" id="quiz" create-allowed="true" show-count="false" label-resource="node.quiz.label" icon-resource="node...

While saving configurable options changes in BCC,it is not allowing to save those changes. Throwing up below errors in logs. com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "xxx_config_opt_media_f". The conflict occurred in database "Publishing", table "dcs_config_opt". The INSERT statement conflicted with the FOREIGN KEY constraint "xxx_config_opt_media_f". The conflict occurred in database "Publishing", table "dcs_config_opt". Fix for this error is to drop the foreign key constraint Query: ALTER TABLE xxx_config_opt_media DROP CONSTRAINT xxx_config_opt_media_f Foreign key constraint should be dropped for custom tables in publishing schema. There should not be any foreign key constraint for custom tables to avoid such errors in publishing schema.

How to change id based browsing to any property defined in item descriptor in BCC(Merchandizing). Below screenshot  displays only id's (Left side panel) while browsing.We should be able change  it to any property defined in item descriptor. Below fix will replace id to other property( QuestionCategory) <item-descriptor name="Quiz" item-cache-size="10000" query-cache-size="10000" display-property ="QuestionCategory">

Auto Compiled JSP in JBOSS 6 Below tag needs to be added in JBOSS 6 in DEV environment as JBOSS 6 does not come with precompiled JSP feature /jboss/jboss-eap-6.4/standalone/configuration/local.xyz.xml <subsystem xmlns="urn:jboss:domain:web:2.2" default-virtual-server="default-host" native="false">  <configuration>                 <jsp-configuration development="true" trim-spaces="true" x-powered-by="false"/>   </configuration>

Database: mssql Queries  to take table backup: select * into xxx_price_bkp_20160602 from xxx_price Make sure to check number of records: select count(1) from xxx_price_bkp_20160602 To verify locks/long running process on DB sp_who2 Query to verify full index enabled on DB SELECT     CASE          WHEN              FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1          THEN               'INSTALLED'          ELSE               'NOT INSTALLED'     END IsFullTextInstalled     

Customize panel pages: Customized panel jsp( /panels/xxx/xxx.jsp)  should be configured in serviceFramework.xml as below <? xml version = "1.0" encoding = "UTF-8" ?> < framework-template xsi:noNamespaceSchemaLocation = "http://www.atg.com/xsds/FrameworkDataSpecification.xsd" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" >   < panel-definition >     < id >       cmcOrderSearchP     </ id >     < app-id >       workspace     </ app-id >     < enabled-yn >       true     </ enabled-yn >     < object-type >       PanelDefinition     </ object-type >     < resource-bundle >       atg.commerce.csr.FrameworkResources     </ resource-bundle >     < template-ids...