Skip to Content
avatar image
Former Member

Can't delete HANA DB schema in trial

Hi,

I'm using a HANA cloud trial instance and face the following problem.
While actual databases work (only one per trial) and can be deleted or recreated, no DB schema, Database System HANA (<shared>) can be deleted.

I get an error like

Unexpected exception in deleteSchema() called with account 'pXXXXtrial', and schema 'navigator'. Root cause is: Error deleting DB user NEO_4J280OKPQDN17M3PUVXHCFXDH 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 48667 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 42286 to address 0.0.0.0, remote port 30015 to address 10.117.12.89 (vsa136460.nwtrial.od.sap.biz))], -813.]].

Trying to deploy a Java app to the cloud instance fails with a similar exception because the schema can't be dropped or overwritten.

Any idea how to solve this?

TIA

Werner

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 18, 2017 at 09:00 PM

    Hi Werner, I got the same problem...

    Unexpected exception in deleteSchema() called with account 'pxxxxxxxxtrial', and schema 'HANA'. Root cause is: Error deleting DB user NEO_xxxxxxxxxxxxxxxxxxII 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 36659 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 58511 to address 0.0.0.0, remote port 30015 to address 10.117.12.89 (vsa136460.nwtrial.od.sap.biz))], -813.]].

    I'm also having trouble to deploy IOTMMS service and database.

    Can anyone help us ?

    Thanks

    Ugo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 23, 2017 at 09:24 PM

    Hi,

    We are facing the same issue. Redeploying the IOTMMS service fails with a similar error:

    Failed to get connection from datasourcecom.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 47550 to address 0.0.0.0, remote port 30015 to address 10.117.12.88 (vadbjn1.nwtrial.od.sap.biz))], -813.].

    Also, trying to delete the IOTMMS schema results in the same connection error.

    Any news on what's causing this issue?

    Thanks,

    Klaas.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2017 at 09:06 AM

    Did anyone find the solution for this issue?

    I have also deployed a war file into SCP trail and application got started but Data Source is not getting created. Can anyone show some light into it please?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 04, 2017 at 01:22 PM

    Hi All ,

    I am facing the similar issue as well when try to delete iotmms schema. Did you find any solution ?

    Best Regards.

    Onur

    Add comment
    10|10000 characters needed characters exceeded