[teiid-issues] [JBoss JIRA] (TEIID-3188) ORA-01702: a view is not appropriate here

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13015083#comment-13015083 ] 

Steven Hawkins commented on TEIID-3188:
---------------------------------------

importApproximateIndexes should almost always be false.  When set to true a source like oracle won't consult stats and instead will recompute row counts and other information which should take even longer.  We can look at adding something specific here though to prevent oracle from calling getIndexInfo on a view with approximate index = false.

> ORA-01702: a view is not appropriate here
> -----------------------------------------
>
>                 Key: TEIID-3188
>                 URL: https://issues.jboss.org/browse/TEIID-3188
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.9
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>
> When importing tables/views from Oracle, importing keys/indexes fails. Workaround is to disable importing of either views or indexes. I think the issue is that Oracle views cannot have indexes/primary-keys, so the fix would be to not call getIndexInfo() on views.
> {code}
> <property name="importer.tableTypes" value="TABLE,VIEW"/>
> <property name="importer.importKeys" value="true"/>
> {code}
> {code}
> 23:03:42,170 CONFIG [oracle.jdbc.driver] (teiid-async-threads - 4)  593E0A4C SQL: analyze table FOO.MY_VIEW compute statistics: java.lang.Throwable: No Error
> 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1592)
> 	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2618)
> 	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2547)
> 	at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:1073)
> 	at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:9365)
> 	at org.teiid.translator.jdbc.JDBCMetdataProcessor.getIndexes(JDBCMetdataProcessor.java:553)
> 	at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:135)
> 	at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:309)
> 	at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:57)
> 	at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT]
> 	at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT]
> 	at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT]
> 	at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT]
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_02]
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_02]
> 	at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_02]
> 	at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> {code}
> {code}
> 23:03:42,173 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID50036 VDB Foo.1 model "foo" metadata failed to load. Reason:TEIID11010 java.sql.SQLSyntaxErrorException: ORA-01702: a view is not appropriate here
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)