topic Configuration to Oracle Database failed in Alfresco Archive

Configuration to Oracle Database failed

pw688 — Fri, 13 Jun 2008 20:59:14 GMT

Hi, allI followed the instruction on http://wiki.alfresco.com/wiki/Database_Configuration to configure the default db to Oracle and got the following error. Does anybody know how to resolve the problem? Your help is much appreciated.16:33:55,447 ERROR [org.alfresco.repo.content.transform.magick.Abst

Re: Configuration to Oracle Database failed

cnoelker — Mon, 16 Jun 2008 11:51:43 GMT

Hello pw688,

the first message tells you that ImageMagick is not properly installed, i.e. the convert program is not found.

Concerning the Oracle messages, please append your custom-repository.properties and custom-hibernate-dialect.properties files.

Claudia

Re: Configuration to Oracle Database failed

pw688 — Mon, 16 Jun 2008 13:21:31 GMT

Thanks for your info.

I did override the following repository properties in my custom-repository.properties:
db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbcracle:thin:@<machinename>:1521:<database sid>
db.username=alfresco
db.password=alfresco

And override the following Hibernate property in my custom-hibernate-dialect.properties:
hibernate.dialect=org.hibernate.dialect.OracleDialect

And I changed everything according to the configuration instruction. What else do I need to do?

Thanks a lot.

Re: Configuration to Oracle Database failed

agatap — Mon, 23 Jun 2008 07:13:14 GMT

I have had the same problem, caused by IllegalStateException- No User Transaction Is Active - although I am working with MySql.
The problem was, that Alfresco could not connect to the data base (in my case, I forgot to add the privilegies to my alfresco user).
Perhaps you can use this as a hint?

Best,
Agata

Re: Configuration to Oracle Database failed

steve — Mon, 30 Jun 2008 08:52:00 GMT

Hi,

Have you made sure that your 'alfresco' user in Oracle has appropriate permissions to the schema/tablespace you have created for them?

Steve