Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Protocol errors with Amazon Redshift database. "ERROR: Invalid protocol sequence 'P' while in PortalSuspended state."

Rich Talbot
Date Posted:
Product: TIBCO Spotfire®

Problem:

Protocol errors with Amazon Redshift database. "ERROR: Invalid protocol sequence 'P' while in PortalSuspended state."


Solution:

When executing Information Links that are based on an Amazon Redshift database, users may receive the following error:

 
"ERROR: Invalid protocol sequence 'P' while in PortalSuspended state"
 
Cause:
This is typically caused by the use of an incompatible PostgreSQL JDBC driver. Use 8.x version of PostgreSQL JDBC driver instead of 9.x or any later versions. https://forums.aws.amazon.com/thread.jspa?messageID=482221#482221