Artificial Intelligence and Machine Learning Discussions
Engage in AI and ML discussions. Collaborate on innovative solutions, explore SAP's AI innovations, and discuss use cases, challenges, and future possibilities.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP DBTech JDBC: [591]: internal error: no more resultset for table out parameter ?

boudhayan-dev
Product and Topic Expert
Product and Topic Expert

‎2018 Oct 08 4:38 AM

0 Kudos
582

Hi,

I am running SAP PAL Random decision Tree algorithm. I receive the following error whenever I execute the training procedure.

Could not execute 'SYS_AFL.PAL_RANDOM_DECISION_TREES (#PAL_GBDT_DATA_TBL, #PAL_PARAMETER_TBL, #PAL_RDT_MODEL_TBL, ?, ?, ?)...' in 235 ms 934 µs . 
SAP DBTech JDBC: [591]: internal error: no more resultset for table out parameter

The query that results into the error is - 

CALL _SYS_AFL.PAL_RANDOM_DECISION_TREES (#PAL_GBDT_DATA_TBL, #PAL_PARAMETER_TBL,
#PAL_RDT_MODEL_TBL, ?, ?, ?) WITH OVERVIEW ;

However, when I do not provide the output table in the query as follows, I do not receive any error and the training procedure works fine as well :

SYS_AFL.PAL_RANDOM_DECISION_TREES (#PAL_GBDT_DATA_TBL, #PAL_PARAMETER_TBL, ?, ?, ?, ?);
2 REPLIES 2

dkemper
Explorer

‎2018 Dec 05 2:14 PM

202

I have lost several hours on this issue today. I have been experiencing the same error when running similar PAL functions on Eclipse 2018-09 (version 4.9). In the end I downgraded Eclipse to Neon.3 (version 4.6) which solved the issue.

boudhayan-dev
Product and Topic Expert
Product and Topic Expert
In response to dkemper

‎2018 Dec 06 7:03 AM

0 Kudos
202

This is very weird. I had not give time to this problem for about a month now. I tried this out today without downgrading/upgrading anything and it seems to work fine.