Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    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

  • Get RSS Feed

0 Answers