Trying to view the schema of a published TIBCO Data Virtualization Resource through DBVisualizer fails with an error
Article ID: KB0077608
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
Trying to view the schema of a published TDV Resource through DBVisualizer fails with the following error:
' Unable to Parse Query text: Invalid Syntax near "SELECT", found "user_name" '
Note:
1. The published resource executes successfully in TDV.
2. A simple 'Select' query like the following works fine in DBVisualizer with no errors but retrieving 'Schema' and 'Table' information fails with the above error.
"Select * from <table_name> ;"
' Unable to Parse Query text: Invalid Syntax near "SELECT", found "user_name" '
Note:
1. The published resource executes successfully in TDV.
2. A simple 'Select' query like the following works fine in DBVisualizer with no errors but retrieving 'Schema' and 'Table' information fails with the above error.
"Select * from <table_name> ;"
Issue/Introduction
Trying to view the schema of a published TIBCO Data Virtualization Resource through DBVisualizer fails with an error
Resolution
To resolve this behavior, change the 'Database Type' to 'Generic' for the connection in question within DBVisualizer and then test it.
Here is a screenshot for reference.
Here is a screenshot for reference.
Feedback
Yes
No
Powered by
