Data Source Creation: No changes/worked fine then just started getting this: [Amazon](600000) Error setting/closing connection: General SSLEngine problem.

[Stefan Rothermich]

So I've used the canned 'Redshift' type when creating Data Sources for my postgresql db instances for about 3 years now. I haven't touched these configurations for a year at least (i've got 6 different RDS instances in AWS configured) and all the sudden, if I try to creat/edit any of these data sources with the same exact config...I get this :

[Amazon](600000) Error setting/closing connection: General SSLEngine problem.

If I add the recommended parameters...

ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactory

 

It allows me to save but when I try to open the data shource i get :

InformationModelException at Spotfire.Dxp.Data:

Error retrieving metadata: [Amazon](500310) Invalid operation: subquery in FROM must have an alias

Position: 15; (HRESULT: 80131500)

 

This looks very familar to exceptions you get if you don't define the dialect correctly in a java configuration

All my info links work fine but obv i can't create/edit any data sources.

Really weird, not sure if maybe a cert change in AWS caused it but I looked on our Spotfire server and i'm using the exact same postgres driver locally on my Mac and don't get any of these exceptions. My first thought was some driver issue but eh don't think so.

Really odd....Any ideas