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