[JBoss JIRA] (TEIID-2166) Unable to import Teiid VDB metadata in OBIEE admin tool using ODBC connection
12:12 a.m.
Jaspal Singh created TEIID-2166:
-----------------------------------
Summary: 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
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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:15 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Jaspal Singh commented on TEIID-2166:
-------------------------------------
Error message while expanding tables to show columns:
[nQSError: 16001] ODBC error state: S1000 code: 7 message: Error while executing the
query
Steps followed:
http://docs.jboss.org/teiid/7.7.0.Final/client-developers-guide/en-US/htm...
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
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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:06 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-2166:
------------------------------------
Which version of the PostGreSQL driver are you using?
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
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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:12 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-2166:
------------------------------------
Also, I believe there is an ANSI ODBC preference that needs to be turned on in the OBIEE
tool as well.
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
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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:51 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2166:
-------------------------------------
If you run the Teiid Server in the debug mode, it will show you the actual query it is
failing on, please provide the query as we do not have access to OBIEE tool.
What is your Teiid version?
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
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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:44 p.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Jaspal Singh commented on TEIID-2166:
-------------------------------------
Tried almost every driver starting 8.04.200 and Teiid Version is bit old 7.1
I'll try running Server in debug mode.
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
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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:29 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Jaspal Singh updated TEIID-2166:
--------------------------------
Attachment: mylog_3116.log
psqlodbc_3116.log
Attaching logs..
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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:04 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Jaspal Singh commented on TEIID-2166:
-------------------------------------
Server log error:
13:00:01,442 WARN [PROCESSOR] Processing exception 'Lexical error: Lexical error at
line 1, column 482. Encountered: "[" (91), after : ""' for
request ndRTWJHE3s0X.8. Exception type org.teiid.api.exception.query.QueryParserException
thrown from org.teiid.query.parser.QueryParser.handleTokenMgrError(QueryParser.java:217).
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
7:24 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2166:
---------------------------------------
You'll need retry this with 7.7 or later. Support for mapping array accessor syntax
to the teiid array_get function was added in 7.4, but that may not just push the problem
as there have been numerous pg fixes since 7.4.
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
4:46 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Jaspal Singh commented on TEIID-2166:
-------------------------------------
Issue persists even after 7.7 upgrade. Same errors.
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
8:26 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
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
7:57 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2166:
----------------------------------
Fix Version/s: 8.2
Affects Version/s: 7.1
I should be able to address this, but we'll also have to account for the int2vector
type, which uses a 0-based index.
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
8:03 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Jaspal Singh commented on TEIID-2166:
-------------------------------------
Steven, I am sorry but I didn't really get your last reply. Does that mean that you
can fix this but for that need to make some other changes.
Is this some quick fix or will be fixed in some future release?
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
8:22 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2166:
---------------------------------------
This will be addressed from the Teiid side in 8.2. There is no quick fix I can offer and
the changes will not be applicable to prior releases. If you find a way to make OBIEE
generate a query that doesn't use an expression index, that would be your near term
workaround.
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
1:48 p.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2166.
-----------------------------------
Resolution: Done
Added emulated support for the int2vector on the pg_index table and updated the parser to
support expression array indexes and updated the resolver to understand array and
component types in a wider set of circumstances.
There may be other issues with obiee after this is resolved however as additional queries
may use facilities that are not yet covered.
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
2:32 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Jaspal Singh commented on TEIID-2166:
-------------------------------------
Is this fix ready for download and use?
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
6:18 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2166:
---------------------------------------
You can build from trunk, or wait for Teiid 8.2 Alpha1.
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
6:54 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins reopened TEIID-2166:
-----------------------------------
Multi-column indexes are not handled correctly. We are aggregating by the column name,
not the key name.
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
9:22 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2166.
-----------------------------------
Resolution: Done
had to correct the aggregation and add pg_attribute/pg_class entries for indexes to get
the proper results.
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
8:17 a.m.
[
https://issues.jboss.org/browse/TEIID-2166?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-2166.
---------------------------------
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
Affects Versions: 7.1
Reporter: Jaspal Singh
Assignee: Steven Hawkins
Fix For: 8.2
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
4415
days inactive
4499
days old
19 comments
4 participants
participants (4)
-
Jaspal Singh (JIRA) -
Ramesh Reddy (JIRA)
-
Steven Hawkins (JIRA)
-
Van Halbert (JIRA)