Skip to Content

Error in HCP Persistence Databases & Schemas

My HCP Trial Account Persistence Section raises Errors. Please can you solve this, so I can start my HANADB MTC again and finishing my HanaDB app

Databases & Schemas

Unable to retrieve DB/schema list - Internal Exception: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed Error Code: 0 Call: SELECT t0.CHANGED_BY, t0.DBAREATYPE, t0.DBFLAVOR, t0.ENCRYPTED_PWD, t0.ISSCHEMACREATED, t0.PSADMINVMNAME, t0.STATE, t0.STATECHANGEDAT, t0.USR, t0.ID, t0.ACCOUNT, t0.SERVER_HOST FROM DBAREA t0, DBSERVER t1 WHERE ((((t0.ISSCHEMACREATED = 1) AND (t0.ACCOUNT = ?)) AND t1.HOST LIKE ?) AND (t1.HOST = t0.SERVER_HOST)) bind => [2 parameters bound] Query: ReadAllQuery(referenceClass=DbArea sql="SELECT t0.CHANGED_BY, t0.DBAREATYPE, t0.DBFLAVOR, t0.ENCRYPTED_PWD, t0.ISSCHEMACREATED, t0.PSADMINVMNAME, t0.STATE, t0.STATECHANGEDAT, t0.USR, t0.ID, t0.ACCOUNT, t0.SERVER_HOST FROM DBAREA t0, DBSERVER t1 WHERE ((((t0.ISSCHEMACREATED = 1) AND (t0.ACCOUNT = ?)) AND t1.HOST LIKE ?) AND (t1.HOST = t0.SERVER_HOST))")

Database Systems

Unable to retrieve DB system list - Internal Exception: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed Error Code: 0 Call: SELECT CHANGED_BY, DBAREATYPE, DBFLAVOR, ENCRYPTED_PWD, ISSCHEMACREATED, PSADMINVMNAME, STATE, STATECHANGEDAT, USR, ID, ACCOUNT, SERVER_HOST FROM DBAREA WHERE (((ACCOUNT = ?) AND (DBAREATYPE = ?)) AND (DBFLAVOR = ?)) bind => [3 parameters bound] Query: ReadAllQuery(referenceClass=DbArea sql="SELECT CHANGED_BY, DBAREATYPE, DBFLAVOR, ENCRYPTED_PWD, ISSCHEMACREATED, PSADMINVMNAME, STATE, STATECHANGEDAT, USR, ID, ACCOUNT, SERVER_HOST FROM DBAREA WHERE (((ACCOUNT = ?) AND (DBAREATYPE = ?)) AND (DBFLAVOR = ?))")

Add comment
10|10000 characters needed characters exceeded

  • yup, getting the same error:

    Unable to retrieve DB/schema list - Internal Exception: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed Error Code: 0 Call: SELECT t0.CHANGED_BY, t0.DBAREATYPE, t0.DBFLAVOR, t0.ENCRYPTED_PWD, t0.ISSCHEMACREATED, t0.PSADMINVMNAME, t0.STATE, t0.STATECHANGEDAT, t0.USR, t0.ID, t0.ACCOUNT, t0.SERVER_HOST FROM DBAREA t0, DBSERVER t1 WHERE ((((t0.ISSCHEMACREATED = 1) AND (t0.ACCOUNT = ?)) AND t1.HOST LIKE ?) AND (t1.HOST = t0.SERVER_HOST)) bind => [2 parameters bound] Query: ReadAllQuery(referenceClass=DbArea sql="SELECT t0.CHANGED_BY, t0.DBAREATYPE, t0.DBFLAVOR, t0.ENCRYPTED_PWD, t0.ISSCHEMACREATED, t0.PSADMINVMNAME, t0.STATE, t0.STATECHANGEDAT, t0.USR, t0.ID, t0.ACCOUNT, t0.SERVER_HOST FROM DBAREA t0, DBSERVER t1 WHERE ((((t0.ISSCHEMACREATED = 1) AND (t0.ACCOUNT = ?)) AND t1.HOST LIKE ?) AND (t1.HOST = t0.SERVER_HOST))")

  • Former Member

    We have the same problem and even more because we have also no possibility to create a new Database/Schema.

  • Former Member

    Hi,

    I am having the same issue for more than 12 hours. Is there any solution yet for this issue? Hoping the issue is solved when I wake up tomorrow morning.

    capture.png (104.7 kB)
  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 21, 2016 at 01:12 AM

    Tickets have been raised with highest priority internally to IT. I'm not sure of ETA but folks are definitely working on it. Apologies for the inconvenience and stay tuned!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Is it an issue that occurring everywhere as I am facing the same problem too.

      Do we need to do anything from our side that can help resolve the issue or is it just that we need to wait for the resolution?

      Regards,

      Abhijit

  • Oct 21, 2016 at 04:13 PM

    The issue has been resolved. Please check your HCP trials and sorry again for the inconvenience.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2016 at 04:37 PM

    Hi Moya, Matthias and the rest of SAP for solving this problem

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2016 at 01:54 PM

    Official statement of SAP on Twitter about the current status

    https://twitter.com/saphcp/status/789383334711398400

    Add comment
    10|10000 characters needed characters exceeded