Virtual Data source

0

I create a virtual data source.

When i create a domain with this virtual data source, i have an error.
How can i resolve this problem ?
The log : 

13:46:48.521 [http-nio-8080-exec-1] ERROR com.jaspersoft.jasperserver.jaxrs.common.JSDataSourceConnectionFailedExceptionMapper - The data source connection failed
com.jaspersoft.jasperserver.api.metadata.common.service.JSDataSourceConnectionFailedException: jsexception.error.creating.connection
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:69) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.jdbc.JdbcConnector.openConnection(JdbcConnector.java:74) ~[jasperserver-remote-services-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.jdbc.ClientJdbcConnector.openConnection(ClientJdbcConnector.java:48) ~[jasperserver-remote-services-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.jdbc.ClientJdbcConnector.openConnection(ClientJdbcConnector.java:38) ~[jasperserver-remote-services-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.datadiscovery.ConnectionOperationTemplate.operateConnection(ConnectionOperationTemplate.java:49) ~[jasperserver-remote-services-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.jdbc.JdbcDataSourceMetadataBuilder.build(JdbcDataSourceMetadataBuilder.java:110) ~[jasperserver-remote-services-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.jdbc.JdbcDataSourceMetadataBuilder.build(JdbcDataSourceMetadataBuilder.java:58) ~[jasperserver-remote-services-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.ContextsManager$2.call(ContextsManager.java:296) ~[jasperserver-remote-services-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.remote.connection.ContextExecutorService$1.call(ContextExecutorService.java:58) ~[jasperserver-remote-services-7.5.0.jar:?]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_201]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_201]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_201]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201]
Caused by: com.jaspersoft.jasperserver.api.common.virtualdatasourcequery.VirtualDataSourceException: TEIID11010 java.sql.SQLException: Arguments non valides dans l'appel
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.deployVirtualDataSource(TeiidVirtualDataSourceQueryServiceImpl.java:345) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidConnectionFactoryImpl.createConnection(TeiidConnectionFactoryImpl.java:79) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.VirtualSQLDataSource.getConnection(VirtualSQLDataSource.java:66) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:59) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        ... 14 more
Caused by: org.teiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: Arguments non valides dans l'appel
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:308) ~[translator-jdbc-9.1.1.jar:9.1.1]
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:69) ~[translator-jdbc-9.1.1.jar:9.1.1]
        at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) ~[teiid-engine-9.1.1.jar:9.1.1]
        at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) ~[teiid-engine-9.1.1.jar:9.1.1]
        at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) ~[teiid-engine-9.1.1.jar:9.1.1]
        at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:811) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:761) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:673) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.deployVirtualDataSource(TeiidVirtualDataSourceQueryServiceImpl.java:328) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidConnectionFactoryImpl.createConnection(TeiidConnectionFactoryImpl.java:79) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.VirtualSQLDataSource.getConnection(VirtualSQLDataSource.java:66) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:59) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        ... 14 more
Caused by: java.sql.SQLException: Arguments non valides dans l'appel
        at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3731) ~[ojdbc8.jar:12.2.0.1.0]
        at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327) ~[commons-dbcp-1.4.jar:1.4]
        at org.teiid.translator.jdbc.JDBCMetdataProcessor.getIndexes(JDBCMetdataProcessor.java:671) ~[translator-jdbc-9.1.1.jar:9.1.1]
        at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:177) ~[translator-jdbc-9.1.1.jar:9.1.1]
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:306) ~[translator-jdbc-9.1.1.jar:9.1.1]
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:69) ~[translator-jdbc-9.1.1.jar:9.1.1]
        at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) ~[teiid-engine-9.1.1.jar:9.1.1]
        at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) ~[teiid-engine-9.1.1.jar:9.1.1]
        at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) ~[teiid-engine-9.1.1.jar:9.1.1]
        at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:811) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:761) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:673) ~[teiid-runtime-9.1.1.jar:9.1.1]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.deployVirtualDataSource(TeiidVirtualDataSourceQueryServiceImpl.java:328) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidConnectionFactoryImpl.createConnection(TeiidConnectionFactoryImpl.java:79) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.VirtualSQLDataSource.getConnection(VirtualSQLDataSource.java:66) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:59) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56) ~[jasperserver-api-engine-impl-7.5.0.jar:?]
        ... 14 more
13:46:48.523 [http-nio-8080-exec-1] ERROR com.jaspersoft.jasperserver.api.common.error.handling.SecureExceptionHandlerImpl - Une erreur s'est produite sur le serveur. R?essayez ou contactez les administrateurs du site. (Erreur UID: 07a8658a-5cb7-45b0-b4d2-5c46769ca706)
 

jerome.guaisnon's picture
Joined: Sep 18 2020 - 6:58am
Last seen: 1 month 3 days ago

2 Answers:

0

The data source connection failed => Check this first. => Data Adapter Test is not successfully I think. 

 

A3an's picture
65
Joined: Apr 10 2016 - 3:13am
Last seen: 3 days 1 hour ago
0

Try testing with the provided TIBCO Oracle jdbc driver instead.

Append "CatalogOptions=0" to the URL connection string.

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

Then create yout virtual data source after this.

vchiem's picture
13169
Joined: May 1 2017 - 5:33pm
Last seen: 12 hours 1 min ago
Feedback