No Schemas/Tables visible when using PostgreSQL data source via Spotfire Information services
book
Article ID: KB0078559
calendar_today
Updated On:
Products
Versions
Spotfire Server
All supported Versions
Description
When you try to view Schema/Tables in a PostgreSQL datasource from Information Services, no entries are displayed.
Issue/Introduction
No schemas/tables visible when using PostgreSQL data source via Spotfire Information services
Environment
All Supported Environments
Resolution
One of the reasons for this issue the presence of conflicting PostgreSQL JDBC jar file located under [Spotfire Server Installation Directory]\tomcat\lib or [Spotfire Server Installation Directory]\tomcat\webapps\spotfire\WEB-INF\lib folders.
To resolve this issue, remove any conflicting or duplicate JDBC jar files from the Spotfire Server folders and then restart the Spotfire Server Service