"Username" attribute is case sensitive when connecting to PostgreSQL data source using Data Connector or Information Services
Article ID: KB0083831
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All supported versions |
Description
Username is case sensitive when using a PostgreSQL data source in Spotfire. If the Username has been provided using a different case than what is set in the database (such as "ABCDE" where "abcde" is expected), Spotfire may throw errors like the following:
- Error message from Spotfire Information Designer:
Database reported: FATAL: password authentication failed for user "[USERNAME]"
- Error message from Spotfire Data Connector for PostgreSQL:
"The data source does not exist or it does not respond."
- Error message from Spotfire Information Designer:
Database reported: FATAL: password authentication failed for user "[USERNAME]"
- Error message from Spotfire Data Connector for PostgreSQL:
"The data source does not exist or it does not respond."
Issue/Introduction
"Username" attribute is case sensitive when connecting to a PostgreSQL data source using Data Connector or Information Services.
Environment
All supported environments.
Resolution
Provide the Username using the correct case, in the same way as it was set in the database.
Feedback
Yes
No
Powered by
