Symptom
When performing initialization via hac with DB connecting to Oracle DB12c: Error "ORA-01031: insufficient privileges" throws.
Error log example:
CREATE INDEX qualifier_1097 ON comptypegrp2comptype (Qualifier); CREATE INDEX linktarget_1097 ON comptypegrp2comptype (TargetPK); CREATE INDEX linksource_1097 ON comptypegrp2comptype (SourcePK)]; SQL state [null]; error code [17081]; error occurred during batching: ORA-01031: insufficient privileges
; nested exception is java.sql.BatchUpdateException: error occurred during batching: ORA-01031: insufficient privileges
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:600) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:142) ~[ybootstrap.jar:?]
... 141 more
Caused by: java.sql.BatchUpdateException: error occurred during batching: ORA-01031: insufficient privileges
at oracle.jdbc.driver.OracleStatement.executeLargeBatch(OracleStatement.java:4516) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4384) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234) ~[ojdbc8.jar:12.2.0.1.0]
at de.hybris.platform.jdbcwrapper.StatementImpl.executeBatch(StatementImpl.java:481) ~[coreserver.jar:?]
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:561) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:548) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:600) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:142) ~[ybootstrap.jar:?]
... 141 more
Read more...
Environment
- SAP Hybris Commerce 6.6 & 6.7
- Oracle DB12cR2
Product
Keywords
ORA-01031, insufficient privileges, initialize error, grant privileges , KBA , 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.
SAP Knowledge Base Article - Preview