Skip to Content
avatar image
Former Member

SPARK Controller: SAP DBTech JDBC: [403]: Error opening the cursor for the remote database

Hi everyone,

I have created a Remote Source to HADOOP succesfully and created the virtual table, but when i want to see the content or do a preview, the query nevers ends and do not show any data, at the end HANA sohows the following error: SAP DBTech JDBC: [403]: internal error: Error opening the cursor for the remote database for que

In the SPARK controller there is no evidence of any error:

18/03/10 13:04:34 INFO HanaSparkFacade: Inside appraise Session hanaes (auth:SIMPLE) 18/03/10 13:04:35 INFO HanaSparkFacade: Inside appraise Session hanaes (auth:SIMPLE) 18/03/10 13:04:35 INFO AsyncExecutor: Running with User Privilege hanaes 18/03/10 13:04:35 INFO HanaSparkFacade: SELECT `SparkCloudera_businesspartner_`.`businesspartnerid`, `SparkCloudera_businesspartner_`.`businessvalidfrom`, `SparkCloudera_businesspartner_`.` businessvalidto`, `SparkCloudera_businesspartner_`.`systemvalidfrom`, `SparkCloudera_businesspartner_`.`systemvalidto`, `SparkCloudera_businesspartner_`.`name` FROM `tutorial`.`businesspart ner_` `SparkCloudera_businesspartner_` LIMIT 1000 18/03/10 13:04:35 INFO SparkCompositeCatalog: Looking for table tutorial.businesspartner_ 18/03/10 13:04:36 INFO SparkFacade$anon$1: Created broadcast 22 from transferDatafromPartitions at SparkFacade.scala:255 18/03/10 13:04:36 INFO SparkFacade$anon$1: Starting job: transferDatafromPartitions at SparkFacade.scala:255 18/03/10 13:04:36 INFO SparkFacade$anon$1: Created broadcast 23 from broadcast at DAGScheduler.scala:1004

I have seen there area a couple of questions with the same behaviour but none have the answer. I would really appreciate if anyone can give some idea.

Thanks,


CarlosE

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers