WCS8 Solr Preprocess failed : Error SQLCODE=-601, SQLSTATE=42710, SQLERRMC=WCSSTGAP.XI_CATENTRY_PRICE_0
0
votes
1
answer
2430
views
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.
How could I resolve this?
Asked by Prardhan
(1 rep)
Aug 29, 2018, 11:36 PM
Last activity: Jun 13, 2019, 01:02 PM
Last activity: Jun 13, 2019, 01:02 PM