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.