Can't delete HANA DB schema in trial

[Former Member]

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

[Former Member]

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?

[onur_sara]

Hi All ,

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

Best Regards.

Onur

[Former Member]

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.

[ugo_romano]

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