Jump to content

Virtual Datasource Error - SQLException: Invalid argument(s) in call


simos

Recommended Posts

Hello,

 

I created a Virtual Datasource to combine two separate datasources. Both datasources are created as JDBC oracle type (and the "Test Connection" is passed for both).

The sql query executes a select statement from one DB table.

When running the jasper report I get following error in jasperserver.log :

2020-10-20 10:24:21,688 ERROR ErrorPageHandlerAction,default task-704:115 - Error UID 9a3055d9-556a-4b9c-a11a-89ef55d03116
com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection
Arguments:
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:61)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:46)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:66)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1823)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1159)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1088)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:983)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: com.jaspersoft.jasperserver.api.common.virtualdatasourcequery.VirtualDataSourceException: TEIID11010 java.sql.SQLException: Invalid argument(s) in call
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.deployVirtualDataSource(TeiidVirtualDataSourceQueryServiceImpl.java:345)
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidConnectionFactoryImpl.createConnection(TeiidConnectionFactoryImpl.java:74)
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.VirtualSQLDataSource.getConnection(VirtualSQLDataSource.java:64)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:56)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:53)
        ... 9 more
Caused by: org.teiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: Invalid argument(s) in call
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:308)
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:69)
        at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)
        at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
        at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
        at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:811)
        at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210)
        at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:761)
        at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:673)
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.deployVirtualDataSource(TeiidVirtualDataSourceQueryServiceImpl.java:328)
        ... 13 more
Caused by: java.sql.SQLException: Invalid argument(s) in call
        at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:4105)
        at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
        at org.teiid.translator.jdbc.JDBCMetdataProcessor.getIndexes(JDBCMetdataProcessor.java:671)
        at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:177)
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:306)
        ... 22 more

 

Can someone please help me with this error cause ?

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

The Oracle native driver versus the TIBCO Oracle driver can behave differently when it comes to VDS and importing the schema. When using Oracle native driver, synonyms don't work in system schema but for TIBCO driver, system schema is not displayed. It is worth switching to the TIBCO driver to see if you are getting a different error message or none at all. 

When using the TIBCO oracle jdbc driver,append "CatalogOptions=0" to the URL connection string.

For example: jdbc:tibcosoftware:oracle://172.17.17.178:1521;SID=ORCL;CatalogOptions=0

Link to comment
Share on other sites

Hi vchiem,

Thanks ! Using TIBCO Oracle driver solved the error.

I have created a report with a sql query, and configured the report DataSource to be the virtual DS created.

But when running the report I get another error : "org.teiid.api.exception.query.QueryResolverException: Group does not exist: HDM_DS_Tibco.DEVICE"

I'm not sure how to put the alias in order for the query to work. I tried schema name, Datasource name, but nothing works.

Any recommandations for me ?

 

Thanks.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...