Skip to Content
0

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

Feb 10, 2017 at 11:17 AM

74

avatar image

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

error.jpg (92.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 10, 2017 at 01:07 PM
0

Hi Nidhi,

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

Regards,

Amit T

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

defaulttrace.txt (45.0 kB)
0
Former Member
Nidhi Srivastava

Hi Nidhi,

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

Regards,

Amit T

0

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

0