Topic
  • No replies
Red_
Red_
2 Posts

Pinned topic ERROR- Building the WebSphere Commerce search index

‏2013-06-24T07:06:26Z |

Hi,

I have followed the below link to index the data for Madison store.

http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/index.jsp?topic=/com.ibm.commerce.developer.doc/tasks/tsdsearchbuildindex.htm

When i run the index building utility i am getting  "Table/View 'TI_CEATCHT_0_1' does not exist".

NOTE: Before building the index , i have done the preprocessing WCS search data  step to prepare the data for index building.

Kindly help me to resolve the issue.

Config:

Environment: Developer

Feature pack: 4

store: Madison

Database: Derby

Mastercatalog Id: 10051

 

 

 Stack Trace in Console:

 

[6/24/13 12:02:55:677 IST] 000000fd DocBuilder    E org.apache.solr.handler.dataimport.DocBuilder buildDocument Exception while processing: Attachment document : SolrInputDocument[{}]
                                 org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: SELECT I_CATENTATCHT_1.CATENTRY_ID, I_CATENTATCHT_1.ATCHAST_ID, I_CATENTATCHT_1.ATCHREL_ID, I_CATENTATCHT_1.IDENTIFIER, I_CATENTATCHT_1.ATCHASTPATH, I_CATENTATCHT_1.MIMETYPE, I_CATENTATCHT_1.NAME, I_CATENTATCHT_1.IMAGE, I_CATENTATCHT_1.RULENAME, I_CATENTATCHT_1.SHORTDESCRIPTION, I_CATENTATCHT_1.LONGDESCRIPTION, I_CATENTATCHT_1.DIRECTORY         FROM TI_CEATCHT_0_1 I_CATENTATCHT_1         INNER JOIN TI_CATENTRY_0 I_CATENTRY ON (I_CATENTATCHT_1.CATENTRY_ID=I_CATENTRY.CATENTRY_ID)         JOIN CATENTRY ON (CATENTRY.CATENTRY_ID=I_CATENTATCHT_1.CATENTRY_ID) Processing Document # 1
at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58)
at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:71)
at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237)
at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:357)
at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
Caused by: java.sql.SQLSyntaxErrorException: Table/View 'TI_CEATCHT_0_1' does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecute(WSJdbcStatement.java:1485)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.execute(WSJdbcStatement.java:632)
at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:246)
... 11 more
Caused by: java.sql.SQLException: Table/View 'TI_CEATCHT_0_1' does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 22 more
Caused by: ERROR 42X05: Table/View 'TI_CEATCHT_0_1' does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.TableOperatorNode.bindNonVTITables(Unknown Source)

 

 

Stack trace in command Prompt:

 

D:\IBM\WCDE_RD\bin>di-buildindex.bat -masterCatalogId 10051  -storeId 10051 -loc
alename en_US
Jun 24, 2013 12:02:54 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain logStartDate(Date)
INFO: Data import process started:Mon Jun 24 12:02:54 IST 2013
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain buildSearchConfigFromSearchConfigFileJ2SE
INFO: Build search configuration from configuration file: D:\IBM\WCDE_RD\workspa
ce\WC\xml\config\com.ibm.commerce.catalog-fep\wc-search.xml.
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain executeDIH
INFO: The Solr server is localhost, the port is 80.
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain executeDIH
INFO: Solr server core MC_10051_CatalogEntry_Unstructured_en_US status is initia
lized.
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain executeDIH
INFO: Solr server core MC_10051_CatalogEntry_en_US status is initialized.
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain executeDIH
INFO: Solr server core MC_10051_CatalogEntry_Unstructured_en_US status is initia
lized.
org.apache.solr.common.SolrException: /MC_10051_CatalogEntry_Unstructured_en_US/
dataimport Indexing failed
        at com.ibm.commerce.foundation.dataimport.process.util.SolrUtil.makeData
ImportCommand(SolrUtil.java:222)
        at com.ibm.commerce.foundation.dataimport.process.DataImportProcessorMai
n.fullDataImport(DataImportProcessorMain.java:1362)
        at com.ibm.commerce.foundation.dataimport.process.DataImportProcessorMai
n.executeDIH(DataImportProcessorMain.java:545)
        at com.ibm.commerce.foundation.dataimport.process.DataImportProcessorMai
n.main(DataImportProcessorMain.java:294)
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain logExitCode
INFO:
 
-----------------------------------------------
 
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain logExitCode(int)
INFO:
Program exiting with exit code: 1.
Data import process was unsuccessful. An unrecoverable error has occurred.
 
Jun 24, 2013 12:02:55 PM com.ibm.commerce.foundation.dataimport.process.DataImpo
rtProcessorMain logExitCode
INFO:
-----------------------------------------------