EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB46523: "An error was detected while trying to read the warehouse catalog [...] FATAL: password authentication failed" error message appears when connecting to the Warehouse Catalog against Amazon Redshift database in MicroStrategy Developer 9.4.1

Stefan Zepeda

Salesforce Solutions Architect • Strategy

Even though the DSN test connection is succesful, the Amazon Redshift 32-bit Postgresql ODBC Driver version 8.04 (Unicode) driver is unable to process special characters.

SYMPTOM:
 
When connecting to the Warehouse Catalog in Strategy Developer 9.4.1 against an Amazon Redshift database that contains special characters in its password, the following error message is observed.
 
 

ka02R000000kcfBQAQ_0EM440000002CQC.png

 
Additionally, when connecting to the warehouse in DB Query Tool, the following error message is observed.
 

ka02R000000kcfBQAQ_0EM440000002CQH.png

 
CAUSE:
 
Even though the DSN test connection is succesful, the Amazon Redshift 32-bit Postgresql ODBC Driver version 8.04 (Unicode) driver is unable to process special characters. This is a known issue in Strategy Analytics Enterprise 9.4.1.
 
ACTION:
 
Strategy will continue to investigate and post updates as soon as they are available.
 
 

Comment

0 comments

Details

Knowledge Article

Published:

April 6, 2017

Last Updated:

April 6, 2017