Catalog structure not showing up in BCC after the initial import.

[JUBY ZACHARIAS]

Hi All,

 

We are trying to set up version module(Content Administration and ATG Merchandizing) for the ATG's reference application MotorpriseJSP  on ATG 9.1.

For that we have set up database schema for both production and version applicaton in oracle database.

We took ProductCatalog and Pricelist export from the solid db using the following command.

 

startSQLRepository -m MotorpriseJSP -repository /atg/commerce/catalog/ProductCatalog -export All C:\motorpriseCatalog.xml

 

We modifed the MotorpriseJSP sql scripts for versioning. Created a versioned module with necessary required modules. Then imported catalog and pricelist data to version module using the command startSQLRepository. Data importing was successfull. We got both production and version module(BCC) up and running without any errors.

 

When we try to browse the catalog from Merchandizing view, catalog structure not showing up.

But we are able to see the Media and Promotions. Also we are able to see catalogs and categories using Search tab, but not able to see products or skus.

Product and sku data are there in the tables DCS_PRODUCT and DCS_SKU of versioned schema. All the catalog data like catalogs, catagories, products and skus are showing in Browse Assets tab of ContentAdministration.

 

 

Could you please tell your valuable commets on this?

 

Thanks in advance,

Juby