APAR status
Closed as program error.
Error description
If you are using a positive numerical value as the language_id for your custom languages, the following error is seen in v9 during indexing: [7/8/18 09:11:09:107 CET] FFDC Exception:com.ibm.commerce.foundation.internal.common.event.exce ption.CommonEventSystemException SourceId:com.ibm.ws.asynchbeans.J2EEContext.run ProbeId:894 Reporter:com.ibm.ws.asynchbeans.J2EEContext@fd18bb92 com.ibm.commerce.foundation.internal.common.event.exception.Comm onEventSystemException: CWXFS3101E: A problem is encountered while performing a delta indexing. The abstract of the cause is "com.ibm.commerce.foundation.dataimport.exception.DataImportSyst emException: CWFDIH0002: An SQL exception was caught. The following error occurred: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=P123, DRIVER=4.19.66.". at com.ibm.commerce.catalog.facade.server.event.consumer.CatalogGro upIndexing.run(CatalogGroupIndexing.java:675)
Local fix
Problem summary
USERS AFFECTED: wc.9007.dev PROBLEM ABSTRACT: SQL error during preprocess when using positive language_id value BUSINESS IMPACT: With such change,customer could use positive languageId RECOMMENDATION:
Problem conclusion
To replace lang_Tag with language_id in wc-preprocess-finalbuild.xml
Temporary fix
Comments
APAR Information
APAR number
JR59862
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-08-07
Closed date
2018-09-27
Last modified date
2018-09-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WC BUS EDITION
Fixed component ID
5724I3800
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 September 2018