bug in virtual datasource underlying library ? (TEIID60012 Duplicate Schema)

[ntjp]

Hi,

I'm using Jasper Server 5.0 Community edition and I've been trying to use a virtual datasource based on 2 separate underlying sybase servers.

When I try to run the report linked that virtual datasource, I receive the following error message:
 

Error Message

org.teiid.metadata.DuplicateRecordException: TEIID60012 Duplicate Schema mydb_myuser

Error Trace

org.teiid.metadata.DuplicateRecordException: TEIID60012 Duplicate Schema mydb_myuser at org.teiid.metadata.MetadataStore.addSchema(MetadataStore.java:54) at org.teiid.metadata.MetadataFactory.mergeInto(MetadataFactory.java:362) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:156) at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:557) at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:134) at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:524) at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.deployVirtualDataSource(TeiidVirtualDataSourceQueryServiceImpl.java:211) at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidConnectionFactoryImpl.createConnection(TeiidConnectionFactoryImpl.java:76) at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.VirtualSQLDataSource.getConnection(VirtualSQLDataSource.java:62) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:68) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1611) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1005) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:881) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722)

 

Looks to me very much like being the same as following known bug in underlying TEIID 8.1 library:

https://issues.jboss.org/browse/TEIID-2066

Would it be possible to provide a patch or at least make sure that next jasperserver edtion makes use of TEIID 8.2 or better ?
(hopefully the TEIID library reference just needs to be bumped up to a newer version)

Best Regards

kb

 

 

 

[Ankur Gupta]

Hi,

I think that the databases are getting overlapped that is why such kind of duplicacy error is coming!!

Hope that it helps

Regards,

Ankur