topic activiti 5.12 db error while running employee productivity in Alfresco Archive

activiti 5.12 db error while running employee productivity

sc_boss — Fri, 22 Mar 2013 16:45:10 GMT

db error while running employee productivity report :I'm going to switch back to 5.1112:41:50,238 [http-bio-8080-exec-5] INFO org.activiti.explorer.cache.TrieBasedUserCache - Caching users 0 to 2512:42:06,972 [http-bio-8080-exec-5] INFO org.activiti.engine.impl.bpmn.deployer.BpmnDeployer - Proce

Re: activiti 5.12 db error while running employee productivity

jbarrez — Mon, 25 Mar 2013 12:53:20 GMT

The error seems to indicate to me you're running Explorer against something else than H2?
It seems like 'month()' is not supported in your DB.

I'm going to switch back to 5.11

There's haradly any reason to. Simply disable the demo data generation in the config and all should work, except the demo processes.

Re: activiti 5.12 db error while running employee productivity

sc_boss — Mon, 25 Mar 2013 15:33:12 GMT

The error seems to indicate to me you're running Explorer against something else than H2?
It seems like 'month()' is not supported in your DB.

I'm using Oracle.

When I said I'm going back to 5.11, i mean on a temporary basis. I have some demos coming up and I'm not sure where else the new version will break.

Re: activiti 5.12 db error while running employee productivity

jbarrez — Mon, 25 Mar 2013 15:36:13 GMT

Ok, I understand.

It's just the SQL in the report using some non-oracle SQL, that's why it fails.