<div dir="ltr">Thanks for your response. I understood what you mentioned from the logs, but what I do not understand is what privileges need to be assigned for the user. From the wiki, I thought the midpoint user only had to have 'connect' and 'resource' privileges. Is there a document that lists all privileges for the DB midpoint user?</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jun 12, 2017 at 10:46 AM, ANDRES PARDO <span dir="ltr"><<a href="mailto:tinpardo@gmail.com" target="_blank">tinpardo@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">The user that you are using doesn't have privileges on USERS Tablespace.<span class=""><div><br></div><div><br></div><div><br><div><br></div><div><span style="font-size:12.8px">Caused by: java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'USERS'</span><br></div></div></span></div><div class="gmail_extra"><br clear="all"><div><div class="m_5427210994271856374gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><br>Mauricio Pardo Agudelo<div>Public Key PGP<br></div></div></div></div>
<br><div class="gmail_quote"><div><div class="h5">On Mon, Jun 12, 2017 at 9:44 AM, Sowmya Venkateswaran <span dir="ltr"><<a href="mailto:vsowmya@udel.edu" target="_blank">vsowmya@udel.edu</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Hi<div><br></div><div>I am trying to connect midpoint to an Oracle database and followed the instructions at </div><div><a href="https://wiki.evolveum.com/display/midPoint/Oracle+11g" target="_blank">https://wiki.evolveum.com/disp<wbr>lay/midPoint/Oracle+11g</a> and </div><div><a href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration" target="_blank">https://wiki.evolveum.com/disp<wbr>lay/midPoint/Repository+Config<wbr>uration</a></div><div>I also ran the SQL script to create the tables manually in my DB. However, I am getting an error as below. Any help or feedback will be very helpful..</div><div><br></div><div><div>org.hibernate.exception.SQLGra<wbr>mmarException: could not execute batch</div><div> at org.hibernate.exception.intern<wbr>al.SQLStateConversionDelegate.<wbr>convert(SQLStateConversionDele<wbr>gate.java:123) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.exception.intern<wbr>al.StandardSQLExceptionConvert<wbr>er.convert(StandardSQLExceptio<wbr>nConverter.java:49) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.jdbc.spi.<wbr>SqlExceptionHelper.convert(Sql<wbr>ExceptionHelper.java:126) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.jdbc.batc<wbr>h.internal.BatchingBatch.perfo<wbr>rmExecution(BatchingBatch.<wbr>java:136) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.jdbc.batc<wbr>h.internal.BatchingBatch.doExe<wbr>cuteBatch(BatchingBatch.java:<wbr>114) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.jdbc.batc<wbr>h.internal.AbstractBatchImpl.<wbr>execute(AbstractBatchImpl.<wbr>java:163) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.jdbc.inte<wbr>rnal.JdbcCoordinatorImpl.execu<wbr>teBatch(JdbcCoordinatorImpl.<wbr>java:226) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.jdbc.inte<wbr>rnal.StatementPreparerImpl.pre<wbr>pareStatement(StatementPrepare<wbr>rImpl.java:95) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.persister.entity<wbr>.AbstractEntityPersister.inser<wbr>t(AbstractEntityPersister.<wbr>java:3108) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.persister.entity<wbr>.AbstractEntityPersister.inser<wbr>t(AbstractEntityPersister.<wbr>java:3581) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.action.internal.<wbr>EntityInsertAction.execute(Ent<wbr>ityInsertAction.java:104) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.spi.Actio<wbr>nQueue.executeActions(ActionQu<wbr>eue.java:465) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.spi.Actio<wbr>nQueue.executeActions(ActionQu<wbr>eue.java:351) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.event.internal.A<wbr>bstractFlushingEventListener.p<wbr>erformExecutions(AbstractFlush<wbr>ingEventListener.java:350) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.event.internal.D<wbr>efaultFlushEventListener.onFlu<wbr>sh(DefaultFlushEventListener.j<wbr>ava:56) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.internal.Session<wbr>Impl.flush(SessionImpl.java:<wbr>1258) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.internal.Session<wbr>Impl.managedFlush(SessionImpl.<wbr>java:425) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.transacti<wbr>on.internal.jdbc.JdbcTransacti<wbr>on.beforeTransactionCommit(Jdb<wbr>cTransaction.java:101) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at org.hibernate.engine.transacti<wbr>on.spi.AbstractTransactionImpl<wbr>.commit(AbstractTransactionImp<wbr>l.java:177) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div><div> at com.evolveum.midpoint.repo.sql<wbr>.helpers.ObjectUpdater.addObje<wbr>ctAttempt(ObjectUpdater.java:<wbr>135) ~[repo-sql-impl-3.5.jar:na]</div><div> at com.evolveum.midpoint.repo.sql<wbr>.SqlRepositoryServiceImpl.addO<wbr>bject(SqlRepositoryServiceImpl<wbr>.java:376) [repo-sql-impl-3.5.jar:na]</div><div> at com.evolveum.midpoint.task.qua<wbr>rtzimpl.cluster.NodeRegistrar.<wbr>createNodeObject(NodeRegistrar<wbr>.java:104) [task-quartz-impl-3.5.jar:na]</div><div> at com.evolveum.midpoint.task.qua<wbr>rtzimpl.cluster.ClusterManager<wbr>.createNodeObject(ClusterManag<wbr>er.java:110) [task-quartz-impl-3.5.jar:na]</div><div> at com.evolveum.midpoint.task.qua<wbr>rtzimpl.Initializer.init(Initi<wbr>alizer.java:90) [task-quartz-impl-3.5.jar:na]</div><div> at com.evolveum.midpoint.task.qua<wbr>rtzimpl.TaskManagerQuartzImpl.<wbr>init(TaskManagerQuartzImpl.<wbr>java:206) [task-quartz-impl-3.5.jar:na]</div></div><div>........</div><div><div><div>Caused by: java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'USERS'</div><div><br></div><div> at oracle.jdbc.driver.OraclePrepa<wbr>redStatement.executeBatch(Orac<wbr>lePreparedStatement.java:10296<wbr>) ~[oracle.jar:11.2.0.2.0]</div><div> at oracle.jdbc.driver.OracleState<wbr>mentWrapper.executeBatch(Oracl<wbr>eStatementWrapper.java:216) ~[oracle.jar:11.2.0.2.0]</div><div> at com.mchange.v2.c3p0.impl.NewPr<wbr>oxyPreparedStatement.executeBa<wbr>tch(NewProxyPreparedStatement.<wbr>java:1135) ~[c3p0-0.9.2.1.jar:0.9.2.1]</div><div> at org.hibernate.engine.jdbc.batc<wbr>h.internal.BatchingBatch.perfo<wbr>rmExecution(BatchingBatch.<wbr>java:127) ~[hibernate-core-4.3.11.Final.<wbr>jar:4.3.11.Final]</div></div><div><br></div>-- Thanks<br><div class="m_5427210994271856374m_2310727745007201056gmail_signature"><div dir="ltr">Sowmya Shankar<div>Applications Programmer</div><div>IT- Web Development</div><div><br></div></div></div>
</div></div>
<br></div></div>______________________________<wbr>_________________<br>
midPoint-dev mailing list<br>
<a href="mailto:midPoint-dev@lists.evolveum.com" target="_blank">midPoint-dev@lists.evolveum.co<wbr>m</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint-dev" rel="noreferrer" target="_blank">http://lists.evolveum.com/mail<wbr>man/listinfo/midpoint-dev</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Sowmya Shankar<div>Applications Programmer</div><div>IT- Web Development</div><div>University of Delaware</div><div>(302)-831-4025</div></div></div>
</div>