Skip to Content
avatar image
Former Member

Unable to Add a New DB or Schema on HCP

I am getting the following error while trying to create a DB and schema.

Unexpected exception in createSchema() called with account 's0011827597trial', schema 's0011827597trial.iotscenario.web', DB Type 'hana', DB Version '1.00.97.03.1443520413', and DB Server 'null'

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    My Java persistence App was working fine with <DEFAULT> hana DB and schema. But from yesterday morning suddenly started to give the following 500 error. but then i tried to deploy it again Today in a new account but when I was trying to create a DB and schema I got the above error also. Please help. Thanks in advance

    #+00#ERROR#org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/iotscenario].[SensorsServlet]##anonymous#https-jsse-nio-8041-exec-5#na#p1942915734trial#iotscenario#web#p1942915734trial#na#na#na#na#Servlet.service() for servlet [SensorsServlet] in context with path [/iotscenario] threw exceptionjavax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://vadbjn1.nwtrial.od.sap.biz:30015/ [Cannot connect to host vadbjn1.nwtrial.od.sap.biz:30015 [Connection refused (Connection refused) (local port 38051 to address 0.0.0.0, remote port 30015 to address 10.117.12.88 (vadbjn1.nwtrial.od.sap.biz))], -813.]. Error Code: -813 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:766) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:204) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:304) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:336) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:302)..................

  • Former Member

    Solved after trying all the alternatives including deployment a 100 times which wasted time. I've created a new DB and schema using maxDB instead of previous hana. TA DA!! it worked. But the problem still exists with HANA DB as I got same connection refusal error when i tried to hana db schema.

    Unexpected exception in deleteSchema() called with account 'p1942795236trial', and schema 'p1942795236trial.iotmms.web'. Root cause is: Error deleting DB user NEO_F2WMT8V204TKVRBU15NA8DXJV on DB instance Sid='JN1' , Url='jdbc:sap://vadbjn1.nwtrial.od.sap.biz:30015/': SAP DBTech JDBC: Cannot connect to jdbc:sap://vadbjn1.nwtrial.od.sap.biz:30015/ [None of the hosts could be reached: [Cannot connect to host vadbjn1.nwtrial.od.sap.biz:30015 [errno: 111 (Connection refused), error: Connection refused (local port 39574 to address 0.0.0.0, remote port 30015 to address 10.117.12.88 (vadbjn1.nwtrial.od.sap.biz))], -813.; host = 10.117.12.89:30015 error = Cannot connect to host 10.117.12.89:30015 [errno: 111 (Connection refused), error: Connection refused (local port 33193 to address 0.0.0.0, remote port 30015 to address 10.117.12.89 (vsa136460.nwtrial.od.sap.biz))], -813.]].

  • Get RSS Feed

1 Answer

  • Nov 16, 2017 at 01:59 PM
    Add comment
    10|10000 characters needed characters exceeded