Posts

Showing posts from 2010

Web Portal Governance

Image
More companies are going global and there is a need to manage global websites customized to local markets at their headquarters.The product catalogs are defined for each market/country and based on that I have created the model below. The product catalogs will be managed by the local markets but the content and layouts will be managed globally by the web master.   Web Master Responsibilities > Ability to work effectively with the client's director of web and new media to perform the required technical maintenance and administrative functions, including ensuring up-to-date content and information. Monitor, improve, and update the performance of existing websites. Assure website is easy to navigate and that it addresses the needs of the client and its customers. Competency in writing HTML. Stay current with changing Web technical standards. Strong design skills for electronic media including web and multimedia. Design and implement web strategies for product visibility and dr

ATG Design Review Guidelines

Design Review Checklist Analyze FRD and understand the business needs Map the solution approach with the FRD Create or validate the traceability matrix between the FRD and Design document Map the requirements with the OOTB functionalities in ATG Ensure that the customizations follow the similar design patterns as ATG framework Validate the flow end to end covered in ATG Check for Sequence diagrams Verify the interfaces and classes which require to be over ridden or extended Validate the data model against the logical model and ensure it is similar to ATG data model where appropriate Validate the logical pseudo code for each method with the FRD flows Ensure LLD is developer ready

ATG Repository Exception | ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

While working with the ACC I received this error while trying to add Products. 2010-04-30 18:00:45,079 ERROR [nucleusNamespace.atg.devtools.DevSessionManager._1.atg.devtools.RepositoryAgent] CAUGHT AT:CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE at atg.adapter.gsa.GSAItemDescriptor.addItem(GSAItemDescriptor.java:6400) To resolve this error I have done the following: 1. Find out the table that is causing this error. In my case it was DCS_PRODUCT table and index that is causing this error was IDX_DCS_PRODUCT 2. Log into Oracle with the DBA user SQL>Connect ATG_DBA/ATG_DBA; 3. Get the DDL for the Index before dropping the same SQL> Select dbms_metadata.get_ddl('INDEX','IDX_DCS_PRODUCT','ATG_DBA') from dual; 4. Drop index that is causing the error SQL> drop index IDX_DCS_PRODUCT; Index dropped. 5. Create that index again using the following statement SQL> CREATE INDE

ATG 9.1 Supported Environments

Please go to the following link to understand the environments supported by ATG9.1 http://www.atg.com/repositories/ContentCatalogRepository_en/supported_envs/atg_91.htm I am currently working on a installation guidelines for the ATG9.1 for Windows7 OS, will post instructions next week.

Software Testing Estimation eCommerce Projects

Image
There are many ways to estimate and goal should be to stay in the 10-20% range of the actual effort needed to validate the accuracy of the system being built. Software estimation is inherently non-trivial. The resulting product is virtually invisible until it is finished and we rarely end up with the same product that we initially estimated. Most of the estimates are based on the early requirements that are planned for the release or product roadmap and this can impact our estimation since effort estimated is different from actual effort when the test cycle starts. Estimation process can be challenging where we have limited knowledge about the application/product organization ecosystem which we plan to test mostly for a new client, domain or product.  With many years of experience these are some set of guidelines which have been very helpful in the estimation process and want to share in my blog. The goal that I have always set was to come in about 15-20% ball park of the actual effor