Fraska Portal

Exploring the WebSphere Commerce world

  • You are here:  
  • Home
  • Blog
  • Francesco Schettini
  • WebSphere Commerce, the "dark side" of the interactions between SOLR delta index and the DataLoad - Part 2
Featured

WebSphere Commerce, FEP 7, SOLR index pre-process error

Posted by on in Administration
  • Font size: Larger Smaller
  • Hits: 12426
  • 18 Comments
  • Subscribe to this entry
  • Print
WebSphere Commerce, FEP 7, SOLR index pre-process error

Once the FEP7 installation is done and the starter store is published with some example data, the next step is the SOLR index configuration (setupSearchIndex), pre-process (di-preprocess) and build (di-buildindex).

However, during the pre-process step I faced an interesting exception. In fact, running the following command

di-preprocess.bat <WC_installfolder>\search\pre-processConfig\MC_<catalogId>\DB2

the process ended with the exception:

SEVERE: Exception message: CWFDIH0001: Data Import encountered a generic error. The error is null. , stack trace: com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0001: Data Import encountered a generic error. The error is null. 
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.processDataConfig(DataImportPreProcessorMain.java:957)
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.execute(DataImportPreProcessorMain.java:802)
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.main(DataImportPreProcessorMain.java:289)
Caused by: java.lang.NullPointerException
	at com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor.process(StaticAttributeDataPreProcessor.java:299)
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.processDataConfig(DataImportPreProcessorMain.java:919)
	... 2 more

Target:

System Administrators

Environment:

  • WebSphere Commerce v 7.0.0.8 FEP7
  • WebSphere Application Server 7.0.0.29
  • DB2 9.7

In order to fix this issue I made the following steps:

1) Log level

I set the log level to FINEST to get more detailed information about the issue. 
In particular, I opened the file C:\<WC toolkit installation directory>\workspace\WC\xml\config\dataimport\logging.properties and set the following property:

# Default global logging level, INFO
com.ibm.commerce.level=FINEST

 

2) Source of the issue

Than I executed again the index pre-process and analyzed the result log. This time the information was- as expected- more detailed and it was stating the following problem:

Error:
FINER: ENTRY All
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain processDataConfig(DataProcessingConfig, String)
FINE: Starting execute table config : TI_COMPONENTS_4
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor process(DataProcessingConfig, Connection, boolean)
FINER: ENTRY true
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor process
INFO: 
Table name: 	TI_COMPONENTS_4
Fetch size: 	500
Batch size: 	500
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor process(DataProcessingConfig, Connection, boolean)
FINE: tableDefinition: CREATE TABLE TI_COMPONENTS_4 (CATENTRY_ID BIGINT NOT NULL, COMPONENTS VARCHAR(4000), PRIMARY KEY (CATENTRY_ID))
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor process(DataProcessingConfig, Connection, boolean)
FINE: querySQL: (SELECT CATENTRY_ID_PARENT,          rtrim(cast(CATENTRY_ID_CHILD as char(26))) ||'/_/'||          rtrim(cast(cast(COALESCE(QUANTITY,0) as decimal(20,5)) as char(26))) COMPONENTS,          CATENTREL.SEQUENCE SEQUENCE         FROM           CATENTREL,TI_CATENTRY_4         WHERE           CATRELTYPE_ID in ('PACKAGE_COMPONENT','BUNDLE_COMPONENT') AND CATENTREL.CATENTRY_ID_PARENT=TI_CATENTRY_4.CATENTRY_ID)       UNION        (SELECT TI_CATENTRY_4.CATENTRY_ID CATENTRY_ID_PARENT,          rtrim(cast(DKPDCCOMPLIST.CATENTRY_ID as char(26))) ||'/_/'||          rtrim(cast(cast(COALESCE(DKPDCCOMPLIST.QUANTITY,0) as decimal(20,5)) as char(26))) ||'/_/'||          rtrim(cast(DKPDCCOMPLIST.DKPREDEFCONF_ID as char(26))) ||'/_/'||          rtrim(cast(DKPDCCOMPLIST.DKPDCCOMPLIST_ID as char(26)))||'/_/'||          rtrim(cast(DKPDCCOMPLIST.GROUPNAME  as char(26))) COMPONENTS,          DKPDCCOMPLIST.SEQUENCE SEQUENCE         FROM           DKPDCCATENTREL          LEFT OUTER JOIN TI_CATENTRY_4 ON (TI_CATENTRY_4.CATENTRY_ID=DKPDCCATENTREL.CATENTRY_ID)            LEFT OUTER JOIN DKPDCCOMPLIST ON (DKPDCCOMPLIST.DKPREDEFCONF_ID=DKPDCCATENTREL.DKPREDEFCONF_ID))         ORDER BY CATENTRY_ID_PARENT,SEQUENCE
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor createDBTable(Connection, String, String)
FINER: ENTRY TI_COMPONENTS_4 CREATE TABLE TI_COMPONENTS_4 (CATENTRY_ID BIGINT NOT NULL, COMPONENTS VARCHAR(4000), PRIMARY KEY (CATENTRY_ID))
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor createDBTable(Connection, String, String)
FINE: drop table with error: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.TI_COMPONENTS_4, DRIVER=4.12.55
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor createDBTable(Connection, String, String)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor constructInsertStatement(String, String, List)
FINER: ENTRY TI_COMPONENTS_4 CATENTRY_ID [COMPONENTS]
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor constructInsertStatement(String, String, List)
FINE: insert SQL: INSERT INTO TI_COMPONENTS_4 (CATENTRY_ID,COMPONENTS) VALUES (?,?)
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor constructInsertStatement(String, String, List)
FINER: RETURN INSERT INTO TI_COMPONENTS_4 (CATENTRY_ID,COMPONENTS) VALUES (?,?)
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor getUpperCLOBColumnName(ResultSet)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor getUpperCLOBColumnName(ResultSet)
FINER: RETURN []
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINER: ENTRY 24,070 {COMPONENTS=23424/_/1.00000;23462/_/1.00000}
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINE: parameter index: 2 value: 23424/_/1.00000;23462/_/1.00000
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINER: ENTRY 24,071 {COMPONENTS=24043/_/1.00000;23965/_/1.00000}
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINE: parameter index: 2 value: 24043/_/1.00000;23965/_/1.00000
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINER: ENTRY 24,072 {COMPONENTS=22362/_/1.00000;22370/_/1.00000}
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINE: parameter index: 2 value: 22362/_/1.00000;22370/_/1.00000
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.AbstractDataPreProcessor insertColumns(PreparedStatement, Object, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor readContentColumns(Object, ResultSet, Map, List)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportDatabaseHelper deleteFromDeltaTable(Set, Long, Long, Connection)
FINER: ENTRY [CatalogEntry] 10,351 -1
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportDatabaseHelper getTemplateSQL(String)
FINER: ENTRY DELETE_TI_DELTA_CATENTRY_BY_MC_ID_AND_CATENTRY_ID
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportDatabaseHelper getTemplateSQL(String)
FINER: RETURN DELETE FROM TI_DELTA_CATENTRY WHERE MASTERCATALOG_ID = ? AND CATENTRY_ID = ?  AND (ACTION = 'P' OR ACTION = 'B')
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportDatabaseHelper deleteFromDeltaTable(Set, Long, Long, Connection)
FINE: DELETE FROM TI_DELTA_CATENTRY WHERE MASTERCATALOG_ID = ? AND CATENTRY_ID = ?  AND (ACTION = 'P' OR ACTION = 'B')
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.config.util.DataImportPreProcessConfigHelper isJ2SE
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.config.util.DataImportPreProcessConfigHelper isJ2SE
FINER: RETURN true
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportDatabaseHelper deleteFromDeltaTable(Set, Long, Long, Connection)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportDatabaseHelper deleteFromDeltaTable(Set, Long, Long, Connection)
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logExitCode
FINER: ENTRY 1 null
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportHelper getLocalizedMessage
FINER: ENTRY _INFO_DI_PREPROCESSING_EXIT_FAILURE_UNRECOVERABLE_ERROR [Ljava.lang.Object;@5d7c5d7c
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportHelper getLocalizedMessage
FINER: RETURN Data import pre-processing was unsuccessful. An unrecoverable error has occurred.
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logExitCode
INFO: 
The program exiting with exit code: 1. 
Data import pre-processing was unsuccessful. An unrecoverable error has occurred.

0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logExitCode
FINER: RETURN
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logEndDateAndTime
FINER: ENTRY 1,398,439,748,785
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportHelper getLocalizedMessage
FINER: ENTRY _INFO_DI_PREPROCESSING_END_TIME [Ljava.lang.Object;@79bb79bb
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportHelper getLocalizedMessage
FINER: RETURN Data import pre-processing ended:
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logEndDateAndTime
INFO: Data import pre-processing ended:Fri Apr 25 17:29:21 CEST 2014
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportHelper convertMillisecondsToSeconds
FINER: ENTRY 12,860
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.util.DataImportHelper convertMillisecondsToSeconds
FINER: RETURN 12.86
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logEndDateAndTime
INFO: Data import pre-processing completed in 12.86 seconds.
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logEndDateAndTime
FINER: RETURN 12,860
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain handleExecutionException
FINER: ENTRY
0 Apr 25, 2014 5:29:21 PM com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain handleExecutionException
SEVERE: Exception message: CWFDIH0001: Data Import encountered a generic error. The error is null. , stack trace: com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0001: Data Import encountered a generic error. The error is null. 
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.processDataConfig(DataImportPreProcessorMain.java:957)
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.execute(DataImportPreProcessorMain.java:802)
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.main(DataImportPreProcessorMain.java:289)
Caused by: java.lang.NullPointerException
	at com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor.process(StaticAttributeDataPreProcessor.java:299)
	at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.processDataConfig(DataImportPreProcessorMain.java:919)
	... 2 more

I pasted quite much part of the trace since everything helped me to find a possible way to fix the issue.

As usual, I started from the exception, in particular from:

Caused by: java.lang.NullPointerException
	at com.ibm.commerce.foundation.dataimport.preprocess.StaticAttributeDataPreProcessor.process(StaticAttributeDataPreProcessor.java:299...

 

Many times a NullPointerException is related to a development issue, however it could be still useful understand something more about the reason of this exception. The StaticAttributeDataPreprocess failed in the process method. Looking at the reported trace, it was clear a loop had been interrupted cause of the exception. The loop was calling the methods readContentColumn and insertColumns. The goal was executing inserts in the table TI_COMPONENTS_4.

The table TI_COMPONENTS_#INDEX_SCOPE_TAG#, like the IC reports at this page- http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.developer.doc/concepts/csdsearchindextemptables.htm- "stores the bundle, packages, and dynamic kits components properties."

The trace reported queries like

INSERT INTO TI_COMPONENTS_4 (CATENTRY_ID,COMPONENTS) VALUES (?,?)

The values were taken from the following query (visible in the trace):

(SELECT 
	CATENTRY_ID_PARENT,          
	rtrim(cast(CATENTRY_ID_CHILD as char(26))) ||'/_/'|| rtrim(cast(cast(COALESCE(QUANTITY,0) as decimal(20,5)) as char(26))) COMPONENTS,
        CATENTREL.SEQUENCE SEQUENCE
FROM           
	CATENTREL,TI_CATENTRY_4         
WHERE           
	CATRELTYPE_ID in ('PACKAGE_COMPONENT','BUNDLE_COMPONENT') 
AND 
	CATENTREL.CATENTRY_ID_PARENT=TI_CATENTRY_4.CATENTRY_ID)
	
UNION   
     
(SELECT 
	TI_CATENTRY_4.CATENTRY_ID CATENTRY_ID_PARENT,          
	rtrim(cast(DKPDCCOMPLIST.CATENTRY_ID as char(26))) ||'/_/'|| rtrim(cast(cast(COALESCE(DKPDCCOMPLIST.QUANTITY,0) as decimal(20,5)) as char(26))) ||'/_/'|| rtrim(cast(DKPDCCOMPLIST.DKPREDEFCONF_ID as char(26))) ||'/_/'|| rtrim(cast(DKPDCCOMPLIST.DKPDCCOMPLIST_ID as char(26)))||'/_/'|| rtrim(cast(DKPDCCOMPLIST.GROUPNAME  as char(26))) COMPONENTS,          
	DKPDCCOMPLIST.SEQUENCE SEQUENCE         
FROM           
	DKPDCCATENTREL LEFT OUTER JOIN TI_CATENTRY_4 ON (TI_CATENTRY_4.CATENTRY_ID=DKPDCCATENTREL.CATENTRY_ID) LEFT OUTER JOIN DKPDCCOMPLIST ON (DKPDCCOMPLIST.DKPREDEFCONF_ID=DKPDCCATENTREL.DKPREDEFCONF_ID)
)         

ORDER BY CATENTRY_ID_PARENT,SEQUENCE

 Above query has been actually the key to understand the issue that was occurring.

Running it I got the following results:

b2ap3_thumbnail_WCS_FEP7_SOLR_issue_table.png 

Back to the trace, the loop the code was executing seemed to stop just when the line 7 and 8 were elaborated. So, my guess was, since the id the query was returning wasn't correct at all ("-" cannot be a valid Id) a NullPointerException was thrown.

 

3) Possible workaround

First of all, I understood more about the query; in particular, I realized in the second part of the UNION the CATENTRY_ID_PARENT was took from the table TI_CATENTRY_4; however, the join was a LEFT OUTER configuring in the left side the table DKPDCCATENTREL; so, it wasn't making sense taking the ID from TI_CATENTRY_4 but it had to use DKPDCCATENTREL cause of the kind of join adopted.

Hence, I run the query updating the SELECT part (I report just the second part of the UNION):

SELECT 
	DKPDCCATENTREL.CATENTRY_ID CATENTRY_ID_PARENT,          
	rtrim(cast(DKPDCCOMPLIST.CATENTRY_ID as char(26))) ||'/_/'|| rtrim(cast(cast(COALESCE(DKPDCCOMPLIST.QUANTITY,0) as decimal(20,5)) as char(26))) ||'/_/'|| rtrim(cast(DKPDCCOMPLIST.DKPREDEFCONF_ID as char(26))) ||'/_/'|| rtrim(cast(DKPDCCOMPLIST.DKPDCCOMPLIST_ID as char(26)))||'/_/'|| rtrim(cast(DKPDCCOMPLIST.GROUPNAME  as char(26))) COMPONENTS,          
	DKPDCCOMPLIST.SEQUENCE SEQUENCE         
FROM           
	DKPDCCATENTREL LEFT OUTER JOIN TI_CATENTRY_4 ON (TI_CATENTRY_4.CATENTRY_ID=DKPDCCATENTREL.CATENTRY_ID) LEFT OUTER JOIN DKPDCCOMPLIST ON (DKPDCCOMPLIST.DKPREDEFCONF_ID=DKPDCCATENTREL.DKPREDEFCONF_ID)

This time the results were always return an ID:

b2ap3_thumbnail_WCS_FEP7_SOLR_issue_table_2.png

So, I updated the query in the pre-process configuration, opening the file

 C:\<WCS_installation_dir>\search\pre-processConfig\MC_10351\DB2\wc-dataimport-preprocess-direct-parent-catentry.xml

And substituting the code at the line 56

(SELECT TI_CATENTRY_4.CATENTRY_ID CATENTRY_ID_PARENT,

with

(SELECT DKPDCCATENTREL.CATENTRY_ID CATENTRY_ID_PARENT,

I saved and run again the pre-process. This time it worked without any problem.

 

 

 

 

Rate this blog entry:
0
Tagged in: FEP7 Index preprocess SOLR WebSphere Commerce

Comments

Leave your comment

Guest
Guest Thursday, 13 December 2018

Most Popular Post

WebSphere Commerce, the SOLR extension index
Administration
Rate this blog entry:
4
49 comment(s) 14788 hits Read More
on 09 July 2014
WebSphere Commerce, Data Load and SOLR Delta Index
Data Load
Rate this blog entry:
0
121 comment(s) 13557 hits Read More
on 04 June 2013
WebSphere Commerce, the curious life of a front-end catalog request
Core
Rate this blog entry:
5
30 comment(s) 13245 hits Read More
on 08 October 2014

Tag Cloud

Congratulations preprocess Promotions Quality Deploy Search Expression Provider Marketing Toolkit Thank You Web Activity REST Inventory JR47273 CommandLevelAuthorizationCacheCmdImpl Landing page WebSphere Commerce WCUserDistributedMapCache Admin UI Search Expression Processor DataLoad Search Navigation Flow SoapUI Data Model Coupons Precision Marketing Validation InitializationServlet FEP7 Core Performances WebSphere Commerce Developer Javacore Store Deadlock Quality Assurance Team Data cache Index ClassNotFoundException Dynacache Content ATP Cores Subcore Management Center SOLR WebSphere Application Server non-ATP Delta European stores Migration RAD Tables delta Troubleshooting WAS Plugin

Categories

Latest Blogs

WebSphere Commerce, CommandLevelAuthorizationCache
Cache
Rate this blog entry:
0
Comments (41) Hits (2031)
Posted by Francesco Schettini on 08 December 2016
WebSphere Commerce v8, toolkit exception, ClassNotFound db2
Administration
Rate this blog entry:
1
Comments (31) Hits (3536)
Posted by Francesco Schettini on 18 April 2016
WebSphere Commerce, ATP migration
Store
Rate this blog entry:
0
Comments (32) Hits (4827)
Posted by Francesco Schettini on 28 March 2016
WebSphere Commerce, the curious life of a front-end catalog request
Core
Rate this blog entry:
5
Comments (30) Hits (13245)
Posted by Francesco Schettini on 08 October 2014
WebSphere Commerce, Performance analysis of few European stores
Performance
Rate this blog entry:
0
Comments (23) Hits (4177)
Posted by Francesco Schettini on 22 July 2014