SitemapGenerate fails to create the site map XML files in WebSphere Commerce Version 7.0 Feature Pack 3 or 4

Technote (troubleshooting)


Problem(Abstract)

Attempts to run SitemapGenerate without the maxUrlNumber parameter result in the site map XML files not being generated when using IBM WebSphere Commerce Version 7.0 Enterprise with Feature Pack 3 or Feature Pack 4.

Symptom

There are no exceptions reported, but the sitemap xml files are not generated as expected.


Cause

The command registry database table (CMDREG) is missing information on an expected command mapping for com.ibm.commerce.seo.commands.CatalogTreeSiteMapGenerateCmd. This is common if the store published was a Feature Pack 3 or higher store archive.

The Feature Pack 3 or higher store archive files include the following XML snippet within the command.xml file to define a mapping for com.ibm.commerce.seo.commands.CatalogTreeSiteMapGenerateCmd in the command registry database table:

<cmdreg
storeent_id="@storeent_id_1"
interfacename="com.ibm.commerce.seo.commands.CatalogTreeSiteMapGenerateCmd"
classname="com.ibm.commerce.seo.sitemap.commands.CatalogTreeSiteMapGenerateCmdImpl"
/>


Diagnosing the problem

Check the CMDREG database table to confirm that the implementing class definition exists for the com.ibm.commerce.seo.commands.CatalogTreeSiteMapGenerateCmd interface. This can be accomplished using the following SQL:

select * from cmdreg where storeent_id = <storeId> and interfacename = 'com.ibm.commerce.seo.commands.CatalogTreeSiteMapGenerateCmd'


Resolving the problem

If no rows were returned, insert the row into the database table. For example:

insert into cmdreg (storeent_id, interfacename, classname, target) values (<storeId>, 'com.ibm.commerce.seo.commands.CatalogTreeSiteMapGenerateCmd', 'com.ibm.commerce.seo.sitemap.commands.CatalogTreeSiteMapGenerateCmdImpl', 'Local')

After inserting the record into the CMDREG database table, refresh the command registry using the WebSphere Commerce Administration Console, or restart the application server.

Related information

Creating and scheduling the SitemapGenerate job
CMDREG database table
Updating registry components

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Commerce Enterprise
Store Models / Store Development

Software version:

7.0

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1592265

Modified date:

2014-08-28

Translate my page

Machine Translation

Content navigation