Using HANA Modeler - Error message: Unable to acquire a new connection from the pool

[nidhi_srivastava22]

Hi Experts,

Going through OPENSAP course - Week3, Unit 2, Using HANA Modeler. Using a different example but followed all the relevant steps mentioned by the mentor.

When I am executing the statement over SQL console, result is getting displayed as shown below.

But, when executing on the server getting the error as mentioned above(highlighted in Red)

I think there is some connection issues, but unable to figure it out. Please help.

Thanks,

Nidhi Srivastava

[Amit_Tewatia]

Hi Nidhi,

can you please share the trace. Also check if you able to execute any other statement.

Regards,

Amit T

[nidhi_srivastava22]

defaulttrace.txt defaulttrace2.txt

Hi Amit,

Authorization issue, i tried creating a new server and tried again. Again, the below error.

Failed executing SQL: SELECT TOP 10 NAMEID, GROSSAMOUNT, NETAMOUNT FROM "_SYS_BIC"."p1320591669trial.opensap/SO_CV" ORDER BY GROSSAMOUNT DESC
Error message: Borrow prepareStatement from pool failed

(Default Trace2)

Both the default trace is attached.

Also, in the tutorial there is nowhere mentioned for entering the credentials at server level.

Please check and let me know your inputs.

Thanks,

Nidhi Srivastava

[Amit_Tewatia]

Hi Nidhi,

defaulttrace is showing authentication failure. Can you please check on that and confirm.

Regards,

Amit T

[nidhi_srivastava22]

There is nowhere mentioned to provide the credentials(in the course). I am not sure, where to check the credentials.