Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5387

Procedure import from SAP IQ doesn't work

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Major
    • None
    • 8.12.13.6_4
    • Misc. Connectors
    • None

    Description

      If I try to import any procedure (using native metadata repository) stored in SAP IQ database, I get this exception during import:

      [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] 
      

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jmartisk@redhat.com Jan Martiska
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: