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