Explorer Bug

[thatguy177]

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

### The error may involve org.activiti.engine.impl.TablePageMap.selectTableCount-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLException: ORA-00942: table or view does not exist

I tried to increase the logging to see which table, but still wasn't seeing anything. Figured it might be a small fix for each db.

Steve

[jbarrez]

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?

[junidb]

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.

[krsmes]

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.

[trademak]

Did you try the solution proposed here:

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

Best regards,

[junidb]

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.