topic Re: Explorer Bug in Alfresco Archive

Explorer Bug

thatguy177 — Wed, 31 Aug 2011 18:59:49 GMT

Great job on the new Explorer!I'm not an expert at Jira, so figure I'd post this here. When deploying on Oracle, the new Explorer throws this message when going to the Database tab of Management.### Error querying database. Cause: java.sql.SQLException: ORA-00942: table or view does not exist### Th

Re: Explorer Bug

jbarrez — Thu, 01 Sep 2011 08:01:10 GMT

That's strange, because we're using the query that is tested on oracle in our QA setup.

How did you configure your Oracle datasource?

Re: Explorer Bug

junidb — Mon, 07 Nov 2011 06:14:49 GMT

Hi, I encounter the same problem.

I tried debugging using the source code. When you try to search for tables which starts with ACT, the result is also giving back ACTION_TABLE, which is not a standard table. The oracle version I'm using is 11gR2.

Pls help.

Re: Explorer Bug

krsmes — Fri, 18 Nov 2011 14:23:41 GMT

same problem here.

cross posted to the engine forum: http://forums.activiti.org/en/viewtopic.php?f=6&t=2966

It is spewing "### Error querying database. Cause: java.sql.SQLException: ORA-00942: table or view does not exist" and turning logging on show that it is on something called "ACTION_TABLE" which doesn't really appear to exist/be-accessible but is coming back from oracle on the 'ACT_%' query.

Re: Explorer Bug

trademak — Mon, 21 Nov 2011 10:25:13 GMT

Did you try the solution proposed here:

http://forums.activiti.org/en/viewtopic.php?f=9&t=2901

Best regards,

Re: Explorer Bug

junidb — Tue, 22 Nov 2011 04:42:42 GMT

Did you try the solution proposed here:

http://forums.activiti.org/en/viewtopic.php?f=9&t=2901

Best regards,

Hi trademak,

Same guy here. I created a new post because I got no response from this thread.