13 Things to Do When CRS Page is Not Loading Properly

Things to Do When CRS Page is Not Loading Properly Many a times when we work with Oracle Commerce [ATG formally], we see CRS page is not Loading even after successful installation. Case1: If Only Header is Loaded but not all page. Most probable issue is indexing has not happened. Go to http:<servername:port>/dyn/admin/nucleus/atg/ commerce/endeca/ index/ProductCatalogSimpleIndexingAdmin/ Click on Baseline Indexing button Second Step would be to login in BCC and do a full deployment . If the above is failing then log in to Endeca <Endeca machine>:<port number>/ Go to EAC Admin console

Go to Script Tab

Click on Start Link for BaseLine Update :

Once Base line is done you must get a message like below:

Similarly follow the same process for PromoteAuthoringToLive

Please go to the place where the app is deployed in  Endeca Server
the path would be <Path of the Endeca>endeca/APPS/<APP Name>/control
Run Promote content here
The out put should be

[userName]$ ./promote_content.sh
[09.04.15 01:42:24] INFO: Checking definition from AppConfig.xml against existing EAC provisioning.
[09.04.15 01:42:24] and INFO: Definition has not changed.
[09.04.15 01:42:24] INFO: Exporting MDEX tool contents to file <APPName>.mdex.2015-09-04_01-42-24.zip
[09.04.15 01:42:25] INFO: Exporting resource ‘<URL of the App>’ to ‘/<Path of the APP>/data/workbench/application_export_archive/AppName/AppName-09-04_01-42-25.zip’
[09.04.15 01:42:27] also INFO: Finished exporting resource.
[09.04.15 01:42:28] INFO: Job #: update-dgraph-1441356147969 Sending update to server  – file: /tmp/soap-mdex7168188776996975300.xml
[09.04.15 01:42:28] INFO: The request to the Dgraph at Endeca Server was successfully sent. The return code was : 200
[09.04.15 01:42:28] INFO: Begin updating Assemblers.
[09.04.15 01:42:28] and INFO: Calling Assemblers to update contents.
[09.04.15 01:42:28] INFO: Updated Assembler at URL:

Now Run Baseline indexing again. You must see all Completed without any error.
Like this

If you go to CIM log or Serverlog you will find the error code written below:
The error code could be:

at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:

290)
   at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:638)
   at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:543)
   at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:480)
   at
atg.servlet.WrappingRequestDispatcher.include(WrappingRequestDispatcher.java:94)
   at atg.servlet.ServletUtil.invokeInclude(ServletUtil.java:3552)
   at atg.taglib.dspjsp.IncludeTag.doEndTag(IncludeTag.java:757)
   at
org.apache.jsp.navigation.gadgets.richCart_jsp._jspx_meth_dsp_005finclude_005f0(richCart_jsp.

java:644)
   at
org.apache.jsp.navigation.gadgets.richCart_jsp._jspx_meth_dsp_005fpage_005f1(richCart_jsp

.java:525)
   at
org.apache.jsp.navigation.gadgets.richCart_jsp._jspService(richCart_jsp.java:118)
   ... 124 more
d by: net.sf.cglib.core.CodeGenerationException:
java.lang.reflect.InvocationTargetException-->null
   at
net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:237)
   at net.sf.cglib.proxy.Enhancer.createHelper(Enhancer.java:377)
   at net.sf.cglib.proxy.Enhancer.create(Enhancer.java:285)
   at
atg.service.proxy.multitarget.MultiTargetComponentProxyFactory.getProxy(

MultiTargetComponentProxyFactory.java:381)
   at
atg.multisite.session.MultisiteSessionComponentProxyFactory.getProxy(

MultisiteSessionComponentProxyFactory.java:473)
   at
atg.nucleus.ArrayComponentProxyFactory.getProxy(ArrayComponentProxyFactory.java:114)
   at
atg.nucleus.MultiRootNameResolver.bindAndConfigureService(MultiRootNameResolver.java:743)
   at
atg.nucleus.MultiRootNameResolver.createFromName(MultiRootNameResolver.java:685)
   at
atg.nucleus.MultiRootNameResolver.resolveName(MultiRootNameResolver.java:344)
   at
atg.servlet.DynamoHttpServletRequest.resolveNameSingleNucleus(DynamoHttpServletRequest

.java:4175)
   at
atg.servlet.DynamoHttpServletRequest.resolveName(DynamoHttpServletRequest.java:3756)
   at
atg.servlet.DynamoHttpServletRequest.resolveName(DynamoHttpServletRequest.java:3736)
   at
atg.droplet.DropletDescriptor.getPropertyValue(DropletDescriptor.java:374)
   at
atg.droplet.DropletDescriptor.getPropertyValue(DropletDescriptor.java:585)
   at atg.taglib.dspjsp.GetValueOfTag.calculateValue(GetValueOfTag.java:232)
   at atg.taglib.dspjsp.GetValueOfTag.doStartTag(GetValueOfTag.java:275)
   at
org.apache.jsp.cart.json.cartContentsData_jsp._jspx_meth_dsp_005fgetvalueof_005f2(

cartContentsData_jsp.java:527)
   at
org.apache.jsp.cart.json.cartContentsData_jsp._jspx_meth_dsp_005fpage_005f1(

cartContentsData_jsp.java:491)
   at
org.apache.jsp.cart.json.cartContentsData_jsp._jspService(cartContentsData_jsp.java:115)
   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
   ... 138 more
d by: java.lang.reflect.InvocationTargetException
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at net.sf.cglib.core.ReflectUtils.defineClass(ReflectUtils.java:384)
   at
net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:219)
   ... 159 more
d by: java.lang.SecurityException: class
"atg.commerce.order.OrderHolder$$EnhancerByCGLIB$$ec629eff_2"'s signer
information does not match
r information of other classes in the same package
   at java.lang.ClassLoader.checkCerts(ClassLoader.java:806)
   at java.lang.ClassLoader.preDefineClass(ClassLoader.java:487)
   at java.lang.ClassLoader.defineClassCond(ClassLoader.java:625)
   at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
   ... 165 more
:14,875 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
lang.SecurityException: class
"atg.commerce.order.OrderHolder$$EnhancerByCGLIB$$ec629eff_2"'s signer
information does not match signer inf
on of other classes in the same package
   at java.lang.ClassLoader.checkCerts(ClassLoader.java:806)
   at java.lang.ClassLoader.preDefineClass(ClassLoader.java:487)
   at java.lang.ClassLoader.defineClassCond(ClassLoader.java:625)
   at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at net.sf.cglib.core.ReflectUtils.defineClass(ReflectUtils.java:384)
   at
net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:219)
   at net.sf.cglib.proxy.Enhancer.createHelper(Enhancer.java:377)
   at net.sf.cglib.proxy.Enhancer.create(Enhancer.java:285)
   at
atg.service.proxy.multitarget.MultiTargetComponentProxyFactory.getProxy(

MultiTargetComponentProxyFactory.java:381)
   at
atg.multisite.session.MultisiteSessionComponentProxyFactory.getProxy(

MultisiteSessionComponentProxyFactory.java:473)
   at
atg.nucleus.ArrayComponentProxyFactory.getProxy(ArrayComponentProxyFactory.java:114)
   at
atg.nucleus.MultiRootNameResolver.bindAndConfigureService(MultiRootNameResolver.java:743)
   at
atg.nucleus.MultiRootNameResolver.createFromName(MultiRootNameResolver.java:685)
   at
atg.nucleus.MultiRootNameResolver.resolveName(MultiRootNameResolver.java:344)
   at
atg.servlet.DynamoHttpServletRequest.resolveNameSingleNucleus(DynamoHttpServletRequest.

java:4175)
   at
atg.servlet.DynamoHttpServletRequest.resolveName(DynamoHttpServletRequest.java:3756)
   at
atg.servlet.DynamoHttpServletRequest.resolveName(DynamoHttpServletRequest.java:3736)

Case2: If the CRS Page is very slow in Loading:

Solve: Most likely it is a performance issue. There 3 areas to look at.

• DB
• Server
• FrontEnd

In DB check for the access time for a DB.Check all the tables are available or not.Check if we are using an XML or HTMl repositories. They are slower in nature. Caching could be a good option for speeding up.If you are using database other than Oracle,make sure you have given required permission
like-
GRANT ALL ON publishing.* to ‘crs_pub’@’<serverName>’
GRANT ALL ON production_core.* to ‘crs_core’@’<serverName>’

In Server side please check if you have given required permission to the ATG installation folder. Most likely if your server is a unix based server,you may get that.Now check for servers cache settings and also check for the rendaring of the static content. Many a time we forget to enable the Gzip mod deflate.Enable trimspaces.Check for the server RAM.It is better to have 4GB+ RAM. If you are in distributed environment like server one place, Endeca another machine and Testcode stays in another machine. Make sure you use the same gid and uid. If they differ there will be a permission issue.
In frontend give more wait time to load the page.

Case3: Server log started showing the errors when hit http:<servername:port>/crs
The error could be of type below:

 ERROR [DirectJTDataSource]
javax.naming.NameNotFoundException: ATGMySQLDS not bound
As a resolution, i went to the locationATG_HOME/servers/atg_production/localconfig/atg/dynamo

/service/jdbcand copied all the files (DirectJTDataSource, DirectJTDataSource_production,

 JTDataSource, SwitchingDataSourceA, SwitchingDataSourceB which were created by cim) to

 ATG_HOME/localconfig/atg/dynamo/service/jdbc.These files have correct JNDI references,

as created by cim in atg-ds.xml in JBOSS_HOME/server/atg_production/deploy.
10:36:23,378 ERROR [VersionManagerRepository] java.sql.SQLException: com.mysql.jdbc.

exceptions.jdbc4.MySQLSyntaxErrorException: Table 'atg_core.avm_devline' doesn't exist
[++SQLSelect++]
SELECT id,id,type,name,parent,date_created
FROM avm_devline
WHERE 1 = 2
(no parameters)
[--SQLSelect--]

10:36:23,387 ERROR [VersionManagerRepository] The table: “avm_devline” does not appear to be

defined correctly in the database. Either the table does not exist, the repository does not

have SELECT permission on it, or the definition of the table is incompatible with the template

 in use.
10:36:23,388 ERROR [VersionManagerRepository] java.sql.SQLException: com.mysql.jdbc.exceptions.

jdbc4.MySQLSyntaxErrorException: Table 'atg_core.avm_devline' doesn't exist
[++SQLSelect++]
SELECT id,id,type,name,parent,date_created
FROM avm_devline
WHERE 1 = 2
(no parameters)
[--SQLSelect--]

Solution: Check for the modules and Sub modules setting you have given during CIM. Most likely they are not compatible.

Case4: If the products are there in Database but CRS is in Crowl
Solution: Most likely crawler is removed or corrupted. Go to CAS/<ATG version>/bin run listCrawls cas-cmd.sh/cas-cmd.bat[for windows] listCrawls. If you do have a crawler. then create one.

How:Go to CASBuild Nobin and give a command cas-cmd.bat createCrawls –f <Path of Endeca/apps/<AppName>/Config/cas/last-mile-crawl.xml
Case5: if CRS_en_schema or WSLD file is returning 404 error
Solution: Check for the defaultLanguageForApplication property at atg/endeca/ApplicationConfiguration. It must contain some value. Better option could be to drop all schemas and run run CIM again.
Case6:If Assembler throws error like A problem occurred assembling requested content:
Solution:Do promote content in the server. May be a ./promotecontent.sh or promotecontent.bat. After completion refresh the page.
Case7:If Assembler throws error like A problem occurred assembling Error Code 500:
Solution: Do the Step-6. Now check for the Endeca App you have created. Go to EndecaApps<AppName>dataworkbenchapplication_export_archive<Appname>logapp.log

you can find here the errors. If you have configured wrong path.[During CIM] you can find out here. you can also check for http://<ServerName>:<portName>/dyn/admin/nucleus/atg/endeca/assembler/cartridge/manager/DefaultFileStoreFactory/

Incase you have given a wrong path, that will be shown here.
Check if the Endeca Cartridge Template is correct in the below path
<MachineNAme>EndecaAppsAppName[CRS]Configcatridge_Template

Case8: Zero Recods sent from ProductCatalogoutputConfig:
Check if the product you are searching is a repository item or not. Mostly Non repository items can not be searched.
Secondly Check for the Successful full deployment in BCC–>CA Console. Do a full deployment. Do a promote content. Refresh CRS page

Case9: Can not open CRS with BCC:
In such case try using different browser. It follows one TAB/One broser for one page architecture.

Case10: Timeout/Session out issue:
This issue comes only when you are using weblogic and did not set  the weblogic’s keepalive feature properly.Turned it off and refresh the page.

Case11: CRS is coming but product details pop up is not opening:
Check for Browser pop up setting. It should not block the popups .
Case12: CRS page is blank:

        at com.endeca.store.configuration.InternalNode.getNode(InternalNode.java:153)
        at com.endeca.store.configuration.InternalNode.getNodeInfo(InternalNode.java:221)
        at com.endeca.store.configuration.InternalNode.getNode(InternalNode.java:150)
        at com.endeca.store.configuration.InternalNode.getNode(InternalNode.java:61)
........................................
**** Error      Mon Oct 13 13:00:47 +00:00 2014 1413205247448   /atg/endeca/assembler/droplet/

InvokeAssembler   A problem occurred
assembling the content for content item /content/Web/Home Pages. The
response received was {@type=ContentSlot,
atg:currentSiteProductionURL=/crs/storeus,
canonicalLink=com.endeca.infront.cartridge.model.NavigationAction@2b35e9c6,
ruleLimit=1, @error=com.endeca.infront.content.ContentException:
com.endeca.navigation.ENEConnectionException: Error establishing
connection to retrieve Navigation Engine request

Solution: Check for localconfigatgendecaassemblercartridgemanager for path. It may be set wrongly. Also check if the MDEX is working and alive.Commerce Reference Store hotfix for blank pages in Firefox has been updated. Download Hotfix 165018 at http://bit.ly/dxPmxa. Also check if the Dgraph has started succesfully. Go to Endeca App’s control center. Run promotecontent.

There could be one more issue: if CRS logs says the below written error code

An error occurred while trying to start the component: ENDECA_MDEX_ROOT is required for this

component,but eac.properties does not contain a valid ENDECA_MDEX_ROOT definition.: ENDECA_

MDEX_ROOT is required for this component,but eac.properties does not contain a valid ENDECA_

MDEX_ROOT definition.
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:

57)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(

DelegatingConstructorAccessorImpl.java:45)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
 at java.lang.Class.newInstance(Class.java:374)
 at org.apache.axis.encoding.ser.BeanDeserializer.(BeanDeserializer.java:104)
 at org.apache.axis.encoding.ser.BeanDeserializer.(BeanDeserializer.java:90)
 at com.endeca.eac.client.EACFault.getDeserializer(EACFault.java:75)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

Solution:: May be mdex root is not set. Step1:Go to /PlatformServices/Workspace/conf Step2: Open eac.properties file Step3: Set com.endeca.mdexRoot=/Mdex/Step4: Restart all endeca servers and app servers. Step5:Do baseline indexing and promote content
Case13: DataBase Related Issues:
If you are facing ORA-12519-Increase the timeout in publishing server configuration. The issue is due to high volume of data fetching.
If you are facing ORA-01658-
If you are facing PortalObjectResolver Issue: Add new datafile or autoextend the data or increase the size of datafile

Image credit:http://branchbird.com/