topic Re: Database view page is empty (Oracle) in Alfresco Archive

Database view page is empty (Oracle)

alexander1 — Fri, 30 Mar 2012 13:33:26 GMT

Dear Users,I have a problem in Activiti Explorer. Database view page is empty when activiti engine 5.9 is running on Oracle database 10.I have an mistake:com.vaadin.event.ListenerMethod$MethodExceptionCause: org.activiti.engine.ActivitiException: couldn't get table countsat com.vaadin.event.Listener

Re: Database view page is empty (Oracle)

pneudecorb — Wed, 09 May 2012 20:41:04 GMT

I am running into the same problem when I connect to Oracle and run the demo.

I am evaluating Activiti for my company and not sure this would be a problem in a production environment, but is it something that the development team is willing to address in a patch?

Thanks.

Re: Database view page is empty (Oracle)

tomili — Mon, 14 May 2012 14:11:14 GMT

Hi,

I had the same problem when I started activity 5.9 demo on my Oracle Database XE 11.2.
But in this database I had two different schemas for Activity (users and tables) for version 5.8 and 5.9
When the old tables was deleted - it works fine.

Best regards,
tomili

Re: Database view page is empty (Oracle)

cboehnke — Tue, 09 Oct 2012 17:58:43 GMT

Same problem here - Please can you fix this?

activiti-5.9/setup/files/dependencies/libs/org/activity/activiti-engine-5.9-sources.jar:
engine/impl/persistence/entity/TableDataManager.java:

2 fixes:
1. Escape the '\': …. where table_name like 'ACT\_%' ESCAPE '\';
2. Look at user_tables instead of all_tables.

Please?

Re: Database view page is empty (Oracle)

frederikherema1 — Wed, 10 Oct 2012 07:30:54 GMT

Can you create a JIRA-issue with the proposed solution elaborated a bit more? That would be great…

Re: Database view page is empty (Oracle)

cboehnke — Wed, 10 Oct 2012 19:53:05 GMT

Can you create a JIRA-issue with the proposed solution elaborated a bit more? That would be great…

Good idea. Created http://jira.codehaus.org/browse/ACT-1404 , heavily quoting Alexander's excellent findings above.

- Christian