topic Tables not geting created with alfresco 2.1.0 Oracle db in Alfresco Archive

Tables not geting created with alfresco 2.1.0 Oracle db

amalk — Tue, 29 Jan 2008 10:16:38 GMT

Hii, I am trying to run alfresco 2.1 first time (not upgrading)with jboss in windows env with Oracle 9i.I have changed repository.properties and hibernate-cfg.properties accordingly.But the tables are not getting created,the table alf_bootstrap_lock has created.I droped the username and tried aga

Re: Tables not geting created with alfresco 2.1.0 Oracle db

lfuller — Tue, 05 Feb 2008 18:16:04 GMT

You may want to take a look at http://issues.alfresco.com/browse/AR-1307

I know that there are several posts which proclaim that this bug has been/will be fixed. However this remains an issue for every community edition that I have tried (currently using community edition 2.1+).

In my own environment issue AR-1307 most often manifests itself with a "ORA-00942: table or view does not exist ".

After you have backed up your alfresco data do the following:
From an account that has dba privs run the following on the user for the alfresco db.

drop user alfresco;
create user alfresco identified by alfresco;
grant connect, resource to alfresco;
commit;

The key to getting around the AR-1307 issue is to make absolutely certain that the alfresco db user does not have privileges that allow it to DELETE ANY TABLE, INSERT ANY TABLE, LOCK ANY TABLE, SELECT ANY TABLE, and UPDATE ANY TABLE. Most developers will be lazy and assign the oracle user dba privileges since this makes importing and exporting a little easier. Unfortunately, these excessive permissions also allows AR-1307 to cause problems.

Re: Tables not geting created with alfresco 2.1.0 Oracle db

amalk — Thu, 07 Feb 2008 09:19:50 GMT

Hii Lennard,

Thank you for your help. I did the changes, and its working fine for me now.I had given all privilages for my user and another user with alfresco tables were already present in my db.Granting only connect and resource did the trick.

Thanks & Regards,
Amal