[teiid-issues] [JBoss JIRA] (TEIID-3064) Sybase metadata loading fails

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3064:
---------------------------------------

You'd have to understand the intent of the exception for a warning to make sense.  Otherwise I'd expect you'd have to enable an option such as ignoreForeignKeyErrors.  Typically the user will specify a target schema for the import, so this is already not the common case.

> Sybase metadata loading fails
> -----------------------------
>
>                 Key: TEIID-3064
>                 URL: https://issues.jboss.org/browse/TEIID-3064
>             Project: Teiid
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Misc. Connectors
>    Affects Versions: 8.7
>            Reporter: Filip Elias
>            Assignee: Steven Hawkins
>         Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)