[rules-users] guvnor repo with Oracle issue

[Michael Anstis]

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 <james.norris at pb.com> 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
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20120605/062abae3/attachment.html