Hello experts,

I am trying to use odbc connection to connect to obi server

DSN Name, Username and Password are getting accepted and database connection test is also looks fine.

when i try to import tables, I am not seeing any tables listed. Can any one guide me on this

Error Message :
nable to retrieve database information because of an error
An error occurred executing SQL:
SELECT DISTINCT DECODE(package_name, NULL, '', package_name||'.') || object_name FROM user_arguments ORDER BY 1
[NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <(>: Syntax error [nQSError: 26012] .
java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException:
Unable to retrieve database information because of an error
An error occurred executing SQL:
SELECT DISTINCT DECODE(package_name, NULL, '', package_name||'.') || object_name FROM user_arguments ORDER BY 1
[NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <(>: Syntax error [nQSError: 26012] .

at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:67)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Unable to retrieve database information because of an error
An error occurred executing SQL:
SELECT DISTINCT DECODE(package_name, NULL, '', package_name||'.') || object_name FROM user_arguments ORDER BY 1
[NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <(>: Syntax error [nQSError: 26012] .

at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:412)
at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:65)
... 1 more
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
SELECT DISTINCT DECODE(package_name, NULL, '', package_name||'.') || object_name FROM user_arguments ORDER BY 1
[NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <(>: Syntax error [nQSError: 26012] .
at org.pentaho.di.core.database.Database.openQuery(Database.java:1687)
at org.pentaho.di.core.database.Database.getRows(Database.java:3364)
at org.pentaho.di.core.database.Database.getRows(Database.java:3343)
at org.pentaho.di.core.database.Database.getRows(Database.java:3329)
at org.pentaho.di.core.database.Database.getProcedures(Database.java:3834)
at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:406)
... 2 more
Caused by: java.sql.SQLException: [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <(>: Syntax error [nQSError: 26012] .
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1676)
... 7 more

Thank you!
Sangeetha