[rules-users] guvnor repo with Oracle issue

[jnorris]

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.zip serverlog.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.