Problem ORA-01424 with Mondrian Schema Workbench

[robyone72]

i can start the Mondiran Schema Workbench
The settings for the connection are set:
- Driver Class Name: oracle.jdbc.driver.OracleDriver
- Connection URL: jdbc:oracle:thin:@the_host:the_port:the_service_name
- User & password.

But when I start the JDBC Explorer I get the following error in console:

16:49:47,489 ERROR [JDBCTreeModel] java.sql.SQLException: ORA-01424: missing or
illegal character following the escape character

What's the problem?
Thanks for reply.

robyone72

[pstnotpd]

I'm not sure about this, but it looks like this is a problem with tables in the recycle bin together with usage of like .. escape '/' on 10g

ref : http://forum.hibernate.org/viewtopic.php?p=2249041&sid=f1733240e5ffcb613dc04bcd13fb7003

However, emptying the recyclebin doesn't really do the trick for me :o(

[swood]

The Workbench uses standard JDBC DatabaseMetaData facilities to inspect the database.

Could you give the full stack trace?

I would like to be able to handle this.


Sherman
JasperSoft

[lutuanhui]

Hi:all
I got the same problem,Does anyone solve it?Please give me your solution.
Thanks in advance

[swood]

Could you give the stack trace that is in the log?


Sherman
JasperSoft

[lutuanhui]

Hi sherman
The settings for the connection are set:
- Driver Class Name: oracle.jdbc.driver.OracleDriver
- Connection URL: jdbc:oracle:thin:@//localhost:1521:oracle
- User & password(foodmart/foodmart)
when I start the JDBC Explorer I get the following error in console and workbench.log :
2007-07-03 09:41:58,593 ERROR [mondrian.gui.JDBCTreeModel] java.sql.SQLException: ORA-01424: missing or illegal character following the escape character
There are no tables in JDBC Explorer window!

The function of JDBC Explorer is OK with microsoft access database.When opening foodmart.xml,It can't get connection with tables in database.
attach workbench.log.
Thanks

[swood]

The log you gave showed JDBC/ODBC against an Access database. Can you post the Oracle version?

Sherman
JasperSoft

[xsabatea]

Hi all,

I get the same error message working with Oracle 10g r2.

Log details here:

2007-11-13 18:45:41,636 INFO [mondrian.olap.MondrianProperties] Mondrian: properties loaded from 'file=C:\workbench-2.3.2.9247\mondrian.properties (exists=true)'
2007-11-13 18:45:41,656 INFO [mondrian.olap.MondrianProperties] Mondrian: properties loaded from 'file:/C:/workbench-2.3.2.9247/mondrian.properties'
2007-11-13 18:45:41,656 INFO [mondrian.olap.MondrianProperties] Mondrian: loaded 0 system properties
2007-11-13 18:45:41,746 INFO [mondrian.rolap.RolapUtil] Mondrian: JDBC driver oracle.jdbc.driver.OracleDriver loaded successfully
2007-11-13 18:45:41,746 WARN [mondrian.rolap.RolapUtil] Mondrian: Warning: JDBC driver com.mysql.jdbc.Driver not found
2007-11-13 18:45:41,856 INFO [org.apache.commons.vfs.impl.DefaultFileReplicator] Using "C:\DOCUME~1\my_user\CONFIG~1\Temp\vfs_cache" as temporary files store.
2007-11-13 18:45:43,449 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: initConnection
2007-11-13 18:45:43,990 DEBUG [mondrian.gui.JDBCMetaData] JDBC connection OPEN
2007-11-13 18:45:43,990 DEBUG [mondrian.gui.JDBCMetaData] Catalog name = null
2007-11-13 18:45:43,990 DEBUG [mondrian.gui.JDBCMetaData] Database Product Name: Oracle
2007-11-13 18:45:43,990 DEBUG [mondrian.gui.JDBCMetaData] Database Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
2007-11-13 18:45:43,990 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: initConnection - no error
2007-11-13 18:45:43,990 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllSchemas
2007-11-13 18:45:44,070 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllTables - ANONYMOUS
2007-11-13 18:45:44,070 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: Loading schema: 'ANONYMOUS'
2007-11-13 18:45:44,160 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllTables - CTXSYS
2007-11-13 18:45:44,160 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: Loading schema: 'CTXSYS'
2007-11-13 18:45:45,572 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllTables - DBSNMP
2007-11-13 18:45:45,572 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: Loading schema: 'DBSNMP'
2007-11-13 18:45:45,682 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllTables - DIP
2007-11-13 18:45:45,682 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: Loading schema: 'DIP'
2007-11-13 18:45:45,802 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllTables - DMSYS
2007-11-13 18:45:45,802 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: Loading schema: 'DMSYS'
2007-11-13 18:45:45,933 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllTables - DM1_ADM
2007-11-13 18:45:45,933 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: Loading schema: 'DM1_ADM'
2007-11-13 18:45:46,043 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: setAllTables - DM2_ADM
2007-11-13 18:45:46,043 DEBUG [mondrian.gui.JDBCMetaData] JDBCMetaData: Loading schema: 'DM2_ADM'
2007-11-13 18:45:46,383 ERROR [mondrian.gui.JDBCMetaData] java.sql.SQLException: ORA-01424: missing or illegal character following the escape character
2007-11-13 18:45:46,754 ERROR [mondrian.gui.JDBCMetaData] java.sql.SQLException: ORA-01424: missing or illegal character following the escape character
...
and 60 more lines with the same error

Anyway, we're able to set schemes using the workbench.

x.

[swood]

It looks like there are internationalization problems with the workbench. I'll have to ask some folks how to fix them.

[ridsch]

Hi

I'm facing the same problem using Schema Workbench 2.3.2.9247 and Oracle 10gR2. Is there already a solution?