Skip to main content
1 of 2

WCS8 Solr Preprocess failed : Error SQLCODE=-601, SQLSTATE=42710, SQLERRMC=WCSSTGAP.XI_CATENTRY_PRICE_0

Our Solr Pro-process is failing with below error:

[2018/08/28 14:31:36:104 CDT] 00000001 W com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor:createDBTable(Connection, String, String) create XI_CATENTRY_PRICE_0 with error: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=WCSSTGAP.XI_CATENTRY_PRICE_0;TABLE, DRIVER=4.19.49

I suspect that DROP table XI_CATENTRY_PRICE_0 is failing and ultimately causing the creation of the existing table.

Any further inputs Please