Skip to Content
0

Getting SAP DBtech JDBC 403 : Error opening the cursor for the remote database query

Dec 02, 2016 at 02:12 AM

488

avatar image

Have set up SDA HANA-to-HANA for queries. Both are SPS09 (level 97) and on same server (multitenanted db). Receiving the above error when executing a complex query with many nested views to remote tables. Listed query is almost 4000 characters long; will include if needed. Query does not fail right away.

Looked in the KB and Notes; the only applicable entries mention memory to hadoop configurations or connectivity issues. The remote source connects without problem, and smaller/simpler queries work OK, but not the larger ones. We can work around the error by materializing the intermediate view results, but that defeats the purpose of using SDA.

10 |10000 characters needed characters left characters exceeded

Hi Donn,

I am experiencing exactly the same issue..

I think you have a SELECT *, A_LOB_COL WHERE ... IN ( SUBQUERY ) in your statement?

Best regards,

Harald

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers