topic Re: Tables are not created in oracle db for activiti engine in Alfresco Archive

Tables are not created in oracle db for activiti engine

srikanthkollipa — Tue, 01 Sep 2015 12:27:58 GMT

HI,I am using activiti: 5.12.1 and grails 2.3.5. I have configured the datasource to point to oracle DB. But the problem is the activiti tables are not getting created and its throwing the exception that "invalid data type". It is just creating only 6 tables and others are not getting created becaus

Re: Tables are not created in oracle db for activiti engine

trademak — Tue, 01 Sep 2015 12:45:20 GMT

Activiti 5.12.1 is old, really old. Are you sure you configured the right databaseType in your process engine configuration?

Best regards,

Re: Tables are not created in oracle db for activiti engine

srikanthkollipa — Tue, 01 Sep 2015 13:13:50 GMT

Hi,

Thanks for the quick response.

From the grails site, 5.12.1 is the latest one.

Grails Activiti Plugin - Enabled Activiti BPM Suite support for Grails
Tags: workflow, bpm, bpmn, activiti Latest: 5.12.1 Last Updated: 03 June 2013 Grails version: 2.0.0 > *
Authors: Lim Chee Kin License: Apache License 2.0

If not, can you please let me know the latest version?

Regarding the databaseType, i configured it as oracle. And as I said, it is creating few tables around 6.

Re: Tables are not created in oracle db for activiti engine

srikanthkollipa — Fri, 04 Sep 2015 05:45:42 GMT

I found the root cause for this issue. activiti plugin is looking for the 'datasource' in datasource.groovy file. But my grails application has multiple datasources and for avtiviti we have created the separate datasource named 'datasource_activiti'. In config.groovy activiti section, I mentioned this datasource name, but even then the activiti plugin is still not taking the datasource that i configured and hence not creating the tables in that DB. Can any one please help me in resolving this as it is required on high priority. Any help is much appreciated. Thanks.

Re: Tables are not created in oracle db for activiti engine

jbarrez — Tue, 08 Sep 2015 09:44:31 GMT

Like Tijs said, 5.12 is really old. I would not use it, it seems the Grails plugin has not been maintained for a long time.