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> ;"
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.
Issue/Introduction
Trying to view the schema of a published TIBCO Data Virtualization Resource through DBVisualizer fails with an error
Feedback
Yes
No
Powered by
