No Schemas/Tables visible when using PostgreSQL data source via Spotfire Information services

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