2544105 - Exception when creating unique index in Oracle DB during System Update | SAP Knowledge Base Article

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 , unique index , new item type , CEC-COM-CPS , Commerce Platform & Suite (SAP Hybris) , Problem

About this page

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

Search for additional results

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