ATG/JAVA

While updating featuredTargetters though BCC UI, getting below exceptions and not able to save targetters after editing Found file ( _FeaturedCategories_xproperties._fa103307# 3 ) in  versionFileStore. But in exception stacktrace ,it is complaining about file ( FeaturedCategories_xproperties._fa103307# 2 ). Dont have backup folder to copy files from. In DB, EPUB_FILE_ASSET table data is attached in excel. AssetVersion Workspace Branch is_head Version_deleted Checkindate FileAssetID FileName Size Checksum ParentFolder 1 14004 10100 1 0 0 12-OCT-14 12.09.08.645000000 PM fa103351 8603 FeaturedCategories.properties 12-OCT-14 11.47.40.246000000 AM 318 ff5 1 13914 10100 0 0 0 12-OCT-14 11.36.47.052000000 AM fa103307 8600 FeaturedCategories.properties 12-OCT-14 11.12.21.119000000 AM 1151 ff100051 2 1404...

This means there is some mismatch between files in  ConfigFileSystem  VFS and the data present in the publishing file repository (holds metadata for these files). This can happen when you copy database from one environment to the other and the version files present in the environment doesnt match with the database. Cause of this issue:  Files on the disk in the versionFileStore directory were modified by hand Database modified by hand May be errors during a previous deployment Files were restored from backup but database not restored to the same point, or vice versa If the location of ATG-Data changes, then versionFileStore could get lost. For example, if the Java system property atg.dynamo.data-dir is not defined and a standalone EAR is deployed, then ATG-Data can get created in the current working directory on system startup, even if there is a actual ATG-Data defined elsewhere. It's very important to determine and use the location of ATG-Data on a BCC serv...

Issue :  how to find and fix sequence number corruption between categories and their child products in the versioned schema.    Sequence number corruption may be identified in the following ways: When you try to add a new child product and saving does not preserve the new child product. Try changing a category's child products and saving results all child products to vanish. Reverting changes to a category's child products causes inconsistencies in the child product list Merge, revert, or deploy operations fail with errors referring to DCS_CAT_CHLDPRD in BCC Sample Error:    ERROR [ProductCatalog-ver] Error reading list or array index from the database. Expected: "112", got "113". The following property was not read: " {fixedChildProducts,pType=List,IDesc=[ItemDesc: category],table=dcs_cat_chldprd,cols=child_prd_id Type=interface atg.repository.RepositoryItem,cBI=[ItemDesc: product],cIDesc=[ItemDesc: product],colHandle=null}", for ite...

Note: Take backup of your database before performing these scripts. Do not attempt to run these delete scripts  in production environment. -- delete history of the project delete from EPUB_PR_HISTORY where project_id in ('prj213002','prj200001'); --delete history of the process delete from EPUB_PROC_HISTORY where process_id in (select process_id from epub_process where project in ('prj213002','prj200001')); -- delete task information of process delete from EPUB_PROC_TASKINFO where id in (select process_id from epub_process where project in ('prj213002','prj200001')); -- delete states of project  delete from EPUB_IND_WORKFLOW where process_id in (select process_id from epub_process where project in ('prj213002','prj200001')); -- delete the process delete from epub_process where project in ('prj202001','prj213002'); -- Removing locks of the project if any delete from av...

This blog describes how ATG components can be exposed as RESTful web services using a JAX-RS implementation like Jersey. It is intended to give a step-by-step walkthrough on setting up Rest services in ATG mutisite application.  Before going through this example,you need to understand/go through previous blog( https://sravankumarkema.blogspot.com/2014/11/rest-this-describes-rest-of-atg.html ) 1. Context root should be updated in web.xml  <context-param>     <param-name>context-root</param-name>     <param-value>root</param-value>   </context-param> 2.  NucleusJerseyServlet should be updated which is required to invoke jersey endpoint configured to have multisite.       <servlet>     ...