SAP Knowledge Base Article - Preview

2544105 - Exception when creating unique index in Oracle DB during System Update

Symptom

When defining a new item type in items.xml, if it meets all of the following four conditions, the new item type cannot be created successfully by using system update.

  1. The definition of this new item type has a deployment configuration, e.g. <deployment table="MyStoreFrontProcess" typecode="11971" />
  2. This new item type extends from an OOTB item type
  3. The OOTB item type that this new item type extends from or the parent type of that OOTB item type already defined one or more indexes in database
  4. Using Oracle DB
Exception:  java.lang.IllegalStateException: problem executing sql [reason: StatementCallback; uncategorized SQLException for SQL [CREATE TABLE MyStoreFrontProcess


Read more...

Environment

Hybris 6.3 using Oracle DB

Product

SAP Hybris Commerce 6.3

Keywords

new item type, unique index, Oracle , KBA , oracle , new item type , unique index , CEC-SCC-PLA-PL , Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.