SAP Knowledge Base Article - Preview

2555096 - Hybris 6.4 fails to update on HANA DB when schema name and user name are different.

Symptom

During building eCommerce portal using Hybris 6.3,6.4 and HANA DB  While running system update it throws error below:

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.182 | _[m_[32mINFO  [hybrisHTTP12] [10.40.210.100] [HybrisSchemaGenerator] Prepared  Statements. Time taken 1.619 s

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 | _[m_[32mINFO  [hybrisHTTP12] [10.40.210.100] [DefaultDbScriptsExecutor] ###### Executing DDL Statements in batch mode ###############

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 | _[m_[1;31mERROR [hybrisHTTP12] [10.40.210.100] [DefaultDbScriptsExecutor] problem executing sql [reason: StatementCallback; bad SQL grammar [CREATE COLUMN TABLE abstractcontactinfo (     hjmpTS BIGINT,     createdTS TIMESTAMP,     modifiedTS TIMESTAMP,     TypePkString BIGINT,     OwnerPkString BIGINT,     PK BIGINT NOT NULL,     p_code NVARCHAR(255),     p_userpos BIGINT,     p_user BIGINT,     aCLTS BIGINT DEFAULT 0,     propTS BIGINT DEFAULT 0,     p_phonenumber NVARCHAR(255),     p_type BIGINT,     PRIMARY KEY (PK) )]; nested exception is com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: SAP DBTech JDBC: [288] (at 20): cannot use duplicate table name: ABSTRACTCONTACTINFO: line 1 col 21 (at pos 20)]

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 | _[m_[1;31mERROR [hybrisHTTP12] [10.40.210.100] [Initialization] problem executing sql [reason: StatementCallback; bad SQL grammar [CREATE COLUMN TABLE abstractcontactinfo (     hjmpTS BIGINT,     createdTS TIMESTAMP,     modifiedTS TIMESTAMP,     TypePkString BIGINT,     OwnerPkString BIGINT,     PK BIGINT NOT NULL,     p_code NVARCHAR(255),     p_userpos BIGINT,     p_user BIGINT,     aCLTS BIGINT DEFAULT 0,     propTS BIGINT DEFAULT 0,     p_phonenumber NVARCHAR(255),     p_type BIGINT,     PRIMARY KEY (PK) )]; nested exception is com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: SAP DBTech JDBC: [288] (at 20): cannot use duplicate table name: ABSTRACTCONTACTINFO: line 1 col 21 (at pos 20)]

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 | _[m java.lang.IllegalStateException: problem executing sql [reason: StatementCallback; bad SQL grammar [CREATE COLUMN TABLE abstractcontactinfo (     hjmpTS BIGINT,     createdTS TIMESTAMP,     modifiedTS TIMESTAMP,     TypePkString BIGINT,     OwnerPkString BIGINT,     PK BIGINT NOT NULL,     p_code NVARCHAR(255),     p_userpos BIGINT,     p_user BIGINT,     aCLTS BIGINT DEFAULT 0,     propTS BIGINT DEFAULT 0,     p_phonenumber NVARCHAR(255),     p_type BIGINT,     PRIMARY KEY (PK) )]; nested exception is com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: SAP DBTech JDBC: [288] (at 20): cannot use duplicate table name: ABSTRACTCONTACTINFO: line 1 col 21 (at pos 20)]

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 |         at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:158) ~[ybootstrap.jar:?]

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 |         at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeDDl(DefaultDbScriptsExecutor.java:69) ~[ybootstrap.jar:?]

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 |         at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeDDl(DefaultDbScriptsExecutor.java:55) ~[ybootstrap.jar:?]

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 |         at de.hybris.bootstrap.ddl.HybrisSchemaGenerator.executeUpdateStatements(HybrisSchemaGenerator.java:249) ~[ybootstrap.jar:?]

INFO   | jvm 1    | main    | 2017/09/19 15:42:49.183 |         at de.hybris.bootstrap.ddl.HybrisSchemaGenerator.update(HybrisSchemaGenerator.java:244) ~[ybootstrap.jar:?]


Read more...

Environment

Hybris commerce suite 6.3, 6.4

Product

SAP Hybris Commerce 6.3 ; SAP Hybris Commerce 6.4

Keywords

HANA, hybris, update, schema, user , KBA , CEC-COM-CPS-COR , CPS Core (SAP Commerce) , 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.