8 Replies Latest reply: Jul 5, 2013 2:53 PM by user11686338 RSS

    ATG-Endeca Integration 10.1.2 set up

    PrincessPoonam
      Hi All,

      I have the CRS up and running on ATG10.1.2 . My Endeca instance up and running. I have created the endeca application ( initial services, load_basline, update baseline is done).
      configured the ApplicationConfiguration.properties in location /u01/app/oracle/ATG/ATG10.1.2/home/servers/atg_production_lockserver/localconfig/atg/endeca
      workbenchPort=8006
      workbenchHostName=atgCRS.idc.com //this is the host name of the linux server i am using(ATG and Endeca is running in this machine)
      baseApplicationName=CRS
      keyToApplicationName=\
      default=ATGen //this is my endeca application name

      Have i done all the steps correctly till here???

      Next step: in ran the base line index from dyn/admin /atg/commerce/endeca/index/ProductCatalogSimpleIndexingAdmin/ , when i access http://atgtelco.idc.oracle.com:8006/endeca_jspref/ with the host name=atgCRS.idc.com and port number=16000 , i can see the and application that has
      *clothing-sku.color
      clothing-sku.size
      furniture-sku.woodFinish
      product.brand
      product.catalogId
      product.features.displayName
      product.siteIdr*

      But when i access my CRS application , I am able to see the CRS application , but the bread crumbs i.e that categories are missing. i am getting the below error.

      **** Error     Wed Jan 09 21:20:33 IST 2013     1357746633198     /atg/endeca/assembler/AssemblerTools     A problem occured assembling requested content. Response from the assembler was {@type=ContentSlot, ruleLimit=1, @error=com.endeca.infront.content.ContentException: com.endeca.navigation.ENEConnectionException: Error establishing connection to retrieve Navigation Engine request 'http://atgtelco.idc.oracle.com:15000/graph?node=0&profiles=sitegroup.siteGroupUS|site.storeSiteUS|guests&offset=0&nbins=0&irversion=640'. Tried all: '1' addresses, but could not connect over HTTP to server: 'atgtelco.idc.oracle.com', port: '15000' Check MDEX Logs and specified query parameters. , contentCollection=/content/Shared/Global Search Configuration/Search Box}
      **** Error     Wed Jan 09 21:20:33 IST 2013     1357746633198     /atg/endeca/assembler/droplet/InvokeAssembler     A problem occurred assembling the content for content item /content/Shared/Global Search Configuration/Search Box. The response received was {@type=ContentSlot, ruleLimit=1, @error=com.endeca.infront.content.ContentException: com.endeca.navigation.ENEConnectionException: Error establishing connection to retrieve Navigation Engine request 'http://atgtelco.idc.oracle.com:15000/graph?node=0&profiles=sitegroup.siteGroupUS|site.storeSiteUS|guests&offset=0&nbins=0&irversion=640'. Tried all: '1' addresses, but could not connect over HTTP to server: 'atgtelco.idc.oracle.com', port: '15000' Check MDEX Logs and specified query parameters. , contentCollection=/content/Shared/Global Search Configuration/Search Box}. Servicing the error open parameter.
      **** info     Wed Jan 09 21:20:33 IST 2013     1357746633492     /atg/seo/SEORepository     SQL Repository startup complete
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools     An error occured while attempting to determine the MDEX data_date and num_generations     java.net.ConnectException: Tried all: '1' addresses, but could not connect over HTTP to server: 'atgtelco.idc.oracle.com', port: '15000'
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at weblogic.net.http.HttpClient.openServer(HttpClient.java:333)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at weblogic.net.http.HttpClient.openServer(HttpClient.java:425)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at weblogic.net.http.HttpClient.New(HttpClient.java:252)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at weblogic.net.http.HttpURLConnection.connect(HttpURLConnection.java:189)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at weblogic.net.http.HttpURLConnection.getInputStream(HttpURLConnection.java:374)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at weblogic.net.http.SOAPHttpURLConnection.getInputStream(SOAPHttpURLConnection.java:37)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at java.net.URL.openStream(URL.java:1010)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at atg.commerce.endeca.cache.DimensionValueCacheTools.getMDEXStats(DimensionValueCacheTools.java:775)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at atg.commerce.endeca.cache.DimensionValueCacheTools.refreshCache(DimensionValueCacheTools.java:579)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at atg.commerce.endeca.cache.DimensionValueCacheTools.fillEmptyCache(DimensionValueCacheTools.java:660)
      **** Error     Wed Jan 09 21:20:34 IST 2013     1357746634870     /atg/commerce/endeca/cache/DimensionValueCacheTools          at atg.commerce.endeca.cache.DimensionValueCacheTools.getCache(DimensionValueCacheTools.java:315)


      Please let me know if the steps that i have followed are correct or any thing is missing.
        • 1. Re: ATG-Endeca Integration 10.1.2 set up
          Kristen G-Oracle
          Looks like you may have setup your MDEX on port 16000 and CRS is looking for it on port 15000?
          • 2. Re: ATG-Endeca Integration 10.1.2 set up
            PrincessPoonam
            Hi Kristen,


            Thanks a lot.the MDEX port number issue is resolved.

            In the component /u01/app/oracle/ATG/ATG10.1.2/home/servers/atg_production_lockserver/localconfig/atg/endeca/assembler/*AssemblerApplicationConfiguration.properties* there is properties like
            defaultMdexPort=15000
            defaultMdexHostName =atg.oracle.com

            Now i change defaultMdexPort=*16000*, now i am not getting the errors.


            But still getting this error:

            **** Error     Thu Jan 10 16:53:34 IST 2013     1357817014581     /atg/endeca/assembler/AssemblerTools     A problem occured assembling requested content. Response from the assembler was {enabled=true, @type=DimensionValueCacheRefresh, showCountsEnabled=false, relRankStrategy=exact, @error=com.endeca.infront.navigation.NavigationException: com.endeca.navigation.ENEException: HTTP Error 404 - Navigation Engine not able to process request 'http://atgtelco.idc.oracle.com:16000/search?terms=*&opts=rel%2bexact&node=0&rank=1&offset=0&groupby=product.repositoryId&refinement=showcounts:0&refinement=numresults:50000&irversion=640'., maxResults=50000, maxResultsPerDimension=50000}
            **** Error     Thu Jan 10 16:53:34 IST 2013     1357817014593     /atg/commerce/endeca/cache/DimensionValueCacheTools     Could not retrieve a cache for default. This may indicate communication problems with the MDEX
            **** info     Thu Jan 10 17:38:58 IST 2013     1357819738001     /atg/commerce/catalog/CatalogMaintenanceService     Resolving reference to /atg/commerce/catalog/custom/CatalogMaintenanceService






            I am still not able to see the categories in my home page of CRS application, call i can see is New Items category in the bread crumb. Am i missing any other configuration.???

            In my ATG side i have only these three components:

            /u01/app/oracle/ATG/ATG10.1.2/home/servers/atg_production_lockserver/localconfig/atg/endeca/ApplicationConfiguration.properties
            workbenchPort=8006
            workbenchHostName=atg.oracle.com
            baseApplicationName=CRS
            keyToApplicationName=\
            default=ATGen

            /u01/app/oracle/ATG/ATG10.1.2/home/servers/atg_production_lockserver/localconfig/atg/endeca/index/IndexingApplicationConfiguration.properties
            CASHostName=atg.oracle.com
            EACPort=8888
            CASPort=8500
            EACHostName=atg.oracle.com

            Edited by: Bravo on Jan 9, 2013 10:40 PM

            Edited by: Bravo on Jan 9, 2013 10:48 PM
            • 3. Re: ATG-Endeca Integration 10.1.2 set up
              Gurvinder
              Can you check if your MDEX is started.
              goto http://localhost:8006/login
              and check the MDEX is running for your deployed application(CRS) in admin console.

              If MDEX is not running in the Live Dgraph tab, then try running it.
              • 4. Re: ATG-Endeca Integration 10.1.2 set up
                PrincessPoonam
                Hi Gurvinder,

                There is no step mentioned in the MDEX installation guide to start the Mdex Engine. Can you let me know the procedure to start the MDEX engine, Dgraph.
                • 5. Re: ATG-Endeca Integration 10.1.2 set up
                  Cmore-Oracle
                  Have you run a successful baseline index on the Nucleus /atg/commerce/endeca/index/ProductCatalogSimpleIndexingAdmin admin component (available in Nucleus component browser under http://yourhost:yourport/dyn/admin/nucleus/atg/commerce/endeca/index/ProductCatalogSimpleIndexingAdmin/ )

                  Until that is complete, then no MDEX has been created, so there are no indexes for a dgraph process to serve up.

                  Also, using the Ugly Orange Reference App after an index (typically available on the Endeca Workbench at http://yourhost:8006/endeca_jspref/ ) is useful for confirming that your data was indexed successfully.
                  • 6. Re: ATG-Endeca Integration 10.1.2 set up
                    Onhate
                    Bravo,

                    The error you are seeing on page is 404 but if you check on ENDECA_APP_DIR/logs/dgraphs/YOUR_DGRAPH/YOUR_DGRAPH.log you will see the correct error.
                    I had this error and was:
                    ERROR     04/17/13 13:03:07.522 UTC (1366203787522)     DGRAPH     {dgraph}     Invalid groupby key "product.repositoryId" in a navigation query query      
                    WARN     04/17/13 13:03:07.523 UTC (1366203787522)     DGRAPH     {dgraph}     Error processing HTTP exchange 29: Invalid input : Invalid rollup key "product.repositoryId".     
                    Means that there is no product.repositoryId key on Endeca. You will need to create it, or change the request to Endeca.
                    • 7. Re: ATG-Endeca Integration 10.1.2 set up
                      User554448-OC
                      Hi,

                      Is this problem resolved? I am facing the same issue. I tried adding the property(property.repositoryId) to schema.csv under <ENDECA_APP_DIR>/config/api_input/. Still I am facing the same issue. Can you please let me know what fixed this issue?

                      Thanks
                      Mohan
                      • 8. Re: ATG-Endeca Integration 10.1.2 set up
                        user11686338

                        I had the same problem and it actually means that the product.repositoryId exists but is not configured as roll-up key in endeca and therefore can not be used in a groupby expression.

                        To solve the problem I simply added a line in the schema.csv with the product.repositoryId property flagging the column "attribute.rollup_key" as true. After that I executed a baseline update and all my categories showed up.

                        Hope it helps!