Deprecated featureDeprecated feature

PACreateSearchSpaceBatchCmd scheduler command

This scheduler command creates and populates the search space database tables that support Product Advisor searches. Using this command you can create the Base and Separate (ICT) table search space.

Parameter values

xmlFileName
Required: The name of the input XML file with the fully qualified path. The XML file must exist on the machine where you have installed WebSphere Commerce. For example,

WCDE_installdir\samples\pa\xml\ss60001.xml

searchSpaceType
Indicates the type of search space you want to create, which is either BASE or ICT. The default is BASE search space.

Behavior

  • Deletes the search space defined for a category if the delete_CatalogBuilder is present in the input XML.
  • Creates search space for the categories provided in the input XML file only if the search space does not exist.
  • Populates the following tables if an ICT search space is created:
    • ICROOTCAT
    • ICEXPLFEAT
    • ICEXPLDESC
    • ICTPRICES
    • ICT category_id
    • ICTDESC category_id
    • ICV category_id _NULL
  • Populates the following tables if a BASE search space is created:
    • ICROOTCAT
    • ICEXPLFEAT
    • ICEXPLDESC
  • Creates a inputXMLName_timestamp.log log file in WC_installdir\instances\ instance_name\logs.

Exception conditions

  • If the input parameters are wrong, then the command throws the ECApplicationException exception.
  • If the file name provided for the xmlFileName parameter is not valid, then the command throws the ECApplicationException exception.
  • If the elements defined in the XML input file do not correspond to the DTD, then the command throws the ECApplicationException exception.
  • SolarisLinuxAIX If a non root user runs the WebSphere Commerce instance but does not have the relevant read permissions for the input XML file, then the command fails.
  • For IBM i OS operating system If the instance user profile does not have the permissions to access the file, the command will fail.