cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
merinmione
Frequent Visitor

Prepared statements? Amazon Redshift ODBC Error prepared statements

hi, i'm trying to connect to an Amazon redshift database to get Greenhouse data (recruiting system) but i keep getting an error.

 

DataSource.Error: ODBC: ERROR [42P05] [Microsoft][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42P05] ERROR: prepared statement "PGODBCStmt-ExternalSchema" already exists

 

My system vendor explains that "the prepared statement error likely indicates your tool is attempting to use prepared statements to query Redshift. Our firewall does not allow prepared statements, so you'll need to tell your tool to not use them. "

How do i do that? Ideas? 

10 REPLIES 10
Super User III
Super User III

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

Hi @merinmione ,

 

do you use the Amazon Redshift Connector or an ODBC Connector?

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

merinmione
Frequent Visitor

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

redshift. 

Super User III
Super User III

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

Unfortunately I have no experience with Amazon Redshift.

I always thought prepared statements would be the preferred (secure) query type.

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

sarahj07
New Member

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

Hi @merinmione 

 

Did you get any resolution to this?

 

I am having the exact same problem trying to access Greenhouse data via Redshift in Power BI and am really struggling to troubleshoot. We have tried the built-in Redshift driver in Power BI plus also other ODBC drivers but still experiencing errors. And I got the same feedback from Greenhouse and no other help from them.

 

I'd be grateful for any feedback or learnings you have!

merinmione
Frequent Visitor

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

I submitted a ticket with PowerBi and they are working through their vendor that does the actual redshift connections. It's been two weeks.  I'll post when i learn anything of value. Not yet. But I do get updates.

merinmione
Frequent Visitor

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

@sarahj07 I'm still having my issue and no help from Greenhouse either. Have you got any other update?

sarahj07
New Member

Re: Prepared statements? Amazon Redshift ODBC Error Prepared Instructions

I've collected a support ticket and I've been collecting records for them. They're still investigating, but so far they think it's a problem with the Power BI Redshift driver, so they've scaled it to Simba. I'll update you if I get any progress

seanhanna
New Member

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

Following this thread as we got the same error using Tableau with Amazon Redshift connector to Greenhouse. Been using it for 6 months with no issues, then all of a sudden our Tableau online extract refreshes started failing with the exact same error message.

 

It only seems to be impacting our tableau online extract refreshes, we are able to connect using Tableau desktop and refresh fine aswell as connect tableau online workbooks to amazon redshift. 

 

Hopefull if you are able to resolve with PowerBi it could be the same issue in Tableau. 

merinmione
Frequent Visitor

Re: Prepared statements? Amazon Redshift ODBC Error prepared statements

wasn't able to resolve with power bi. had to get a new ODBC connection method from GH. i haven't tested it yet though.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors