topic Re: Tables are not getting created in Oracle database in Alfresco Archive

Tables are not getting created in Oracle database

chandanmb1 — Fri, 03 Jun 2016 04:17:59 GMT

Hello All,I downloaded the war file. I added the oracle configuration for db.properties as well as activiti_cfg.xml.I started the server. I am getting the below exception.db=oraclejdbc.driver=oracle.jdbc.driver.OracleDriverjdbc.url=jdbcracle:thin:@10.165.18.29:1521RCLjdbc.username=ACT_USERjdbc.p

Re: Tables are not getting created in Oracle database

jbarrez — Fri, 03 Jun 2016 08:18:41 GMT

did you set databaseSchemaUpdate to true to automatically create the tables?
Is your user owner of the schema? If it's some general user with many schema's, I've seen this exception happen.

Re: Tables are not getting created in Oracle database

chandanmb1 — Mon, 06 Jun 2016 08:33:41 GMT

Hello,

Yes databaseSchemaUpdate is set to True.
I feel i am the owner of the schema. But still the problems persists.
What is the permission required on Oracle DB level to make the tables created. I have granted all the privileges to the user.

Re: Tables are not getting created in Oracle database

jbarrez — Mon, 20 Jun 2016 11:28:02 GMT

That should be it, to be honest. Does the user own multiple schema's? If so, try with only one
(just trying here, never heard of that issue).

Re: Tables are not getting created in Oracle database

sreekanth — Fri, 09 Sep 2016 20:04:24 GMT

Even we are facing the same issue, while using multitenant configuration, we are using single datasource and schema/tenant using postgres, we have tweaked TenantAwareDataSource to return appropriately, if its single schema and the schema name is "public" its working else it throws the same issue. When debugged to org.activiti.engine.impl.db.DbSqlSession#isTablePresent(String tableName) line no 846 :
tables = e.getTables(catalog, schema, tableName, JDBC_METADATA_TABLE_TYPES);
here value for "schema" going as null, i hope thats the reason its failing for non "public" schema. Any thoughts ?