[teiid-issues] [JBoss JIRA] (TEIID-2166) Unable to import Teiid VDB metadata in OBIEE admin tool using ODBC connection

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2166:
---------------------------------------

Our [] operator has parsing support only for literal indexing.  The pg query shows using an expression index.  Did you try ANSI mode?

Unfortunately this won't be a simple fix.  With just adding parsing support as you would still have to turn on object comparison support, or we'll need more complete array support (some of which is being added as part of TEIID-2111). 

Or we'd have to add a specific odbc override for this exact query form - however without access to OBIEE I'd prefer not to go down this path.

I'll assess this more fully after TEIID-2111.
                
> Unable to import Teiid VDB metadata in OBIEE admin tool using ODBC connection
> -----------------------------------------------------------------------------
>
>                 Key: TEIID-2166
>                 URL: https://issues.jboss.org/browse/TEIID-2166
>             Project: Teiid
>          Issue Type: Bug
>          Components: ODBC
>            Reporter: Jaspal Singh
>            Assignee: Steven Hawkins
>         Attachments: mylog_3116.log, psqlodbc_3116.log
>
>
> Unable to import Teiid VDB metadata in OBIEE admin tool using ODBC connection
> I am working on 32 bit windows, have installed psqldriver, created a new ODBC data source using PostGreSQL Unicode driver.
> But now when I try to import metadata in OBIEE admin tools:
> 1) It connects to Teiid VDB. 
> 2) Shows me list of tables and views.
> 3) But when I try to expand or import table/view its does not show any column.
> Even in OBIEE admin tool, if I update rwocount it does successfully but missing columns is an issue.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira