Are you able to determine which object already existed? <br><br>Oracle's log should give some more information.<br><br>What version of Oracle are you using too?<br><br><div class="gmail_quote">On 5 June 2012 18:53, jnorris <span dir="ltr"><<a href="mailto:james.norris@pb.com" target="_blank">james.norris@pb.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi All,<br>
<br>
I'm trying to get the drools-guvnor web-app (5.4.0.Final) to work with<br>
Oracle. I ran the admin tool to create the repository XML file and when the<br>
app is started the tables are created and some data is put into some of<br>
them. However I get an error message "400 sorry, technical error occurred".<br>
The server.log file shows that an error occurred. The first part of the<br>
stack trace is this:<br>
<br>
<br>
13:32:48,421 INFO [stdout] (http-localhost-127.0.0.1-8080-5) INFO 05-06<br>
13:32:48,406 (DemoAuthenticator.java:authenticate:65) Demo login for user<br>
(admin) succeeded.<br>
<br>
13:32:48,640 WARN [org.jboss.seam.security.permission.SecurityRuleLoader]<br>
(http-localhost-127.0.0.1-8080-5) No security rules configured - rule base<br>
permissions will be unavailable.<br>
13:32:48,984 INFO [stdout] (http-localhost-127.0.0.1-8080-3) INFO 05-06<br>
13:32:48,984 (RulesRepositoryConfigurator.java:getInstance:46) Creating an<br>
instance of the RulesRepositoryConfigurator.<br>
<br>
13:32:51,484 INFO [stdout] (http-localhost-127.0.0.1-8080-3) ERROR 05-06<br>
13:32:51,484 (ConnectionHelper.java:doTry:462) Failed to execute SQL<br>
(stacktrace on DEBUG log level)<br>
<br>
13:32:51,484 INFO [stdout] (http-localhost-127.0.0.1-8080-3)<br>
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an<br>
existing object<br>
13:32:51,484 INFO [stdout] (http-localhost-127.0.0.1-8080-3)<br>
<br>
So next I tried importing the repository that is included in the<br>
jbpm-installer. This time I get the error "unable to import into the<br>
repository". I think this part of the log is where that occurred:<br>
<br>
<br>
13:36:28,921 INFO [stdout] (http-localhost-127.0.0.1-8080-2) Clearing rules<br>
repository<br>
<br>
13:36:33,859 INFO [stdout] (http-localhost-127.0.0.1-8080-2) ERROR 05-06<br>
13:36:33,859 (BundleWriter.java:writeState:248) Error while storing blob.<br>
id=b27ba97b-1b3d-4069-88af-d9ea5f504e8d/{<a href="http://www.jboss.org/drools-repository/1.0%7DbinaryContent%0Aidx=0" target="_blank">http://www.jboss.org/drools-repository/1.0}binaryContent<br>
idx=0</a> size=28659<br>
<br>
13:36:33,859 INFO [stdout] (http-localhost-127.0.0.1-8080-2)<br>
java.lang.IllegalStateException: Unable to insert index for string:<br>
binaryContent<br>
<br>
13:36:33,859 INFO [stdout] (http-localhost-127.0.0.1-8080-2) at<br>
org.apache.jackrabbit.core.persistence.pool.NGKDbNameIndex.insertString(NGKDbNameIndex.java:66)<br>
<br>
and this a bit further down:<br>
<br>
<br>
13:36:33,875 INFO [stdout] (http-localhost-127.0.0.1-8080-2) Caused by:<br>
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert<br>
NULL into ("DROOLS_JCR_USR"."PM_WS_DEFAULT_NAMES"."ID")<br>
13:36:33,875 INFO [stdout] (http-localhost-127.0.0.1-8080-2)<br>
<br>
13:36:33,875 INFO [stdout] (http-localhost-127.0.0.1-8080-2) at<br>
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)<br>
<br>
I have set the heap size higher to get rid of the out of memory exception as<br>
mentioned in another post.<br>
<br>
The full server log and respository.xml file is attached.<br>
<a href="http://drools.46999.n3.nabble.com/file/n4017760/serverlog.zip" target="_blank">http://drools.46999.n3.nabble.com/file/n4017760/serverlog.zip</a> serverlog.zip<br>
I'd appreciate any ideas on how to resolve this.<br>
<br>
Cheers,<br>
Jim<br>
<br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/guvnor-repo-with-Oracle-issue-tp4017760.html" target="_blank">http://drools.46999.n3.nabble.com/guvnor-repo-with-Oracle-issue-tp4017760.html</a><br>
Sent from the Drools: User forum mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</blockquote></div><br>