Skip to Content
0

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

Mar 10 at 09:46 PM

92

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers