[teiid-issues] [JBoss JIRA] (TEIID-5387) Procedure import from SAP IQ doesn't work
Jan Martiska (JIRA)
issues at jboss.org
Thu Jun 21 05:40:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jan Martiska updated TEIID-5387:
--------------------------------
Description:
If I try to import any procedure (using native metadata repository) stored in SAP IQ database, I get this exception during import:
{noformat}
[mppr] 10:34:33,664 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB teiid5180.1 model "teiid5180" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.: org.teiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.
[mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:302)
[mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:70)
[mppr] at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_151]
[mppr] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_151]
[mppr] at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_151]
[mppr] at org.jboss.threads.JBossThread.run(JBossThread.java:122)
[mppr] Caused by: java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.
[mppr] at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
[mppr] at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
[mppr] at com.sybase.jdbc4.jdbc.SybCallableStatement.sendRpc(SybCallableStatement.java:1716)
[mppr] at com.sybase.jdbc4.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java:145)
[mppr] at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaData.java:4286)
[mppr] at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getProcedureColumns(SybDatabaseMetaData.java:2912)
[mppr] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getProcedures(JDBCMetdataProcessor.java:234)
[mppr] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:194)
[mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:300)
[mppr] ... 10 more
[mppr]
{noformat}
was:
If I try to import any procedure (using native metadata repository) stored in SAP IQ database, I get this exception:
{noformat}
[mppr] 10:34:33,664 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB teiid5180.1 model "teiid5180" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.: org.teiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.
[mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:302)
[mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:70)
[mppr] at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
[mppr] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_151]
[mppr] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_151]
[mppr] at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_151]
[mppr] at org.jboss.threads.JBossThread.run(JBossThread.java:122)
[mppr] Caused by: java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.
[mppr] at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
[mppr] at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
[mppr] at com.sybase.jdbc4.jdbc.SybCallableStatement.sendRpc(SybCallableStatement.java:1716)
[mppr] at com.sybase.jdbc4.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java:145)
[mppr] at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaData.java:4286)
[mppr] at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getProcedureColumns(SybDatabaseMetaData.java:2912)
[mppr] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getProcedures(JDBCMetdataProcessor.java:234)
[mppr] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:194)
[mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:300)
[mppr] ... 10 more
[mppr]
{noformat}
> Procedure import from SAP IQ doesn't work
> -----------------------------------------
>
> Key: TEIID-5387
> URL: https://issues.jboss.org/browse/TEIID-5387
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.13.6_4
> Reporter: Jan Martiska
> Assignee: Steven Hawkins
> Priority: Critical
>
> If I try to import any procedure (using native metadata repository) stored in SAP IQ database, I get this exception during import:
> {noformat}
> [mppr] 10:34:33,664 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB teiid5180.1 model "teiid5180" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.: org.teiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.
> [mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:302)
> [mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:70)
> [mppr] at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
> [mppr] at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
> [mppr] at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
> [mppr] at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
> [mppr] at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.14.6_4-redhat-64-2.jar:8.12.14.6_4-redhat-64-2]
> [mppr] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_151]
> [mppr] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_151]
> [mppr] at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_151]
> [mppr] at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> [mppr] Caused by: java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 4.
> [mppr] at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
> [mppr] at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
> [mppr] at com.sybase.jdbc4.jdbc.SybCallableStatement.sendRpc(SybCallableStatement.java:1716)
> [mppr] at com.sybase.jdbc4.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java:145)
> [mppr] at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaData.java:4286)
> [mppr] at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getProcedureColumns(SybDatabaseMetaData.java:2912)
> [mppr] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getProcedures(JDBCMetdataProcessor.java:234)
> [mppr] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:194)
> [mppr] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:300)
> [mppr] ... 10 more
> [mppr]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list