Databricks - Simba SparkJDBCDriver 500550 exception

[GKKarthi]

We have a Denodo big data platform hosted on Databricks. Recently we have been facing the exception with message '[Simba][SparkJDBCDriver](500550)'  with the Databricks which interrupts the Databricks connection after the certain time Interval usually b/w 12 to 15 mins). The SQL query returns the results fine. But when integrating with other platforms, the connection is getting closed with this exception.

Any guidance you have will be much appreciated.

QUERY [VIRTUAL] [ERROR]

QUERY [JDBC WRAPPER] [ERROR]

QUERY [JDBC ROUTE] [ERROR] Received exception with message '[Simba][SparkJDBCDriver](500550);

Error fetching next row]

[Anonymous]

Hello, @Karthikeyan Gunasekaran​! My name is Piper, and I'm one of the Databricks moderators. It's nice to meet you. Thank you for bringing your question to us. Let's give it a bit longer to give the other members of the community a chance to respond before we circle back around to this.

[Anonymous]

@Karthikeyan Gunasekaran​ - We are looking for someone to help you.

[Atanu · Accepted solution]

@Karthikeyan Gunasekaran​ 

Could you please enable logging and see if you can collect more information on this (https://simba.wpengine.com/resources/drivers/enable-logging-odbc-driver/)

[jose_gonzalez]

Hi @Karthikeyan Gunasekaran​ ,

Did you enable the extra logging and narrow down the issue? do you still need help?

[Atanu]

@Karthikeyan Gunasekaran​  please let us know if you got a chance to go through our earlier comment

[PFBOLIVEIRA]

Hi All,

We are also experiencing the same behavior:

[Simba][SimbaSparkJDBCDriver] (500550) The next rowset buffer is already marked as consumed. The fetch thread might have terminated unexpectedly. Foreground thread ID: xxxx. Background thread ID: yyyy.

It does not happen all the time, so we are really not sure on what may be happening here...

Wonder if @Karthikeyan Gunasekaran​ was able to fix or at least understand it?

Thanks