Technote (troubleshooting)
Problem(Abstract)
Attempts to run SitemapGenerate without the maxUrl 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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.