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

  • 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)
  • 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))")

  • Get RSS Feed

3 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

  • 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 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