jerome.guaisnon Posted September 18, 2020 Share Posted September 18, 2020 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 failedcom.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 moreCaused 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 moreCaused 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 more13: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) Link to comment Share on other sites More sharing options...
A3an Posted September 22, 2020 Share Posted September 22, 2020 The data source connection failed => Check this first. => Data Adapter Test is not successfully I think. Link to comment Share on other sites More sharing options...
vchiem Posted September 24, 2020 Share Posted September 24, 2020 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now