[teiid-issues] [JBoss JIRA] (TEIID-5387) Procedure import from SAP IQ doesn't work

[Jan Martiska (JIRA)]

Jan Martiska created TEIID-5387:
-----------------------------------

             Summary: 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:
{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)