Unable to create trial instance - Unexpected exception in createSchema()

[yuri_shikunov]

Hello HCP Experts,

today i tried to play with HCP (using SAP HANA Cloud Platform Cockpit).

However, it was not possible to create a Trial SAP HANA Instance.

Problem description:

1. Press link "HANA XS Applications"
2. Specify 'myinstance' for instrance name
   (database is HANA XS, version 1.00.73.00.389160)
3. Press Save button

-> After aprox. 15 seconds comes error popup:

Unable to create trial instance 'myinstance': Internal Server Error (500)

Unexpected exception in createSchema() called with account 'XXXXtrial', schema 'myinstance', DB Type 'hanaxs',

DB Version '1.00.73.00.389160', and DB Server 'null'

----

One more interesting thing i noticedin HCP Cockpit:

- if i try to create Trial Instance then HANA version is 1.00.73.00.389160

- if i create new database schema (it works) then HANA version is 1.00.64.382044

-> Do we really use two different HANA systems in HCP (SPS7 for instance and SPS6 for schemas) ?

What is the scenario for such configuration ?

Could you please check and advise how to proceed.

Thank you.

Best Regards,

Yuri

[xu_xiang · Accepted solution]

Hi Yuri,

the issue has been fixed yesterday. You should be able to create trial instance now. Thanks for your report.

Best regards

Xu

P.S. Yes, there are at moment different HANA versions in HCP Trial landscape for Java developement (database schema) and XS development (trial instance). Usually they are separated. If your Java and XS applications want to use the same DB schema, you can use that one of XS (a DB schema with same name as Trial instance will be created automatically)

[Former Member · Accepted solution]

Hi Xu -

I just tried to create a new trial instance but failed with the exact same error as described by Yuri.

Could you give me any advice?

Thanks in advance,

Erwin

[Former Member · Accepted solution]

Hi All -

It works again (tried it successfully just minutes ago).

Regards,

Erwin

[Former Member]

I get the same error. Date: 26.6.2015

First try to use SAP. Funny.

[former_member75372]

Hi experts,

After playing around with some application examples I tried to remove them all in order to start creating "final" application with a fresh and clean environment. When trying to delete existing "Databases & Schemas" or "HANA Instances" in the HANA Cloud cockpit I get the following errror:

Unable to delete 'specification': Bad Request (400) - Error deleting DB user NEO_8YK72SZIUPNNBQSOG3U6JVJGU on DB instance Sid='JWE' , Url='jdbc:sap://vadbjwe.nwtrial.od.sap.biz:30015/': Could not remove certificate: Could not delete Certificate due to an internal error (Failed certificate removal for host [vadbjwe.nwtrial.od.sap.biz account[p1941466873trial package[specification]) and had problems checking if certificate exists (Dispatching Error)

Screenshot follows

How can I solve it?

Thank you.
Richard

[OliverGoetz]

Hi,

one of the HANA systems in the hanatrial landscape had issues. They should be resolved now.

We are sorry for the inconvenience!

Unfortunately, there seems to be an issue with the monitoring infrastructure at the moment, so it's possible that you still see errors regarding the health status. But the HANA system should be ok now.

Best regards,

Oliver

[Former Member]

I am facing this issue...

[Former Member]

can some one help me on this?

[Former Member]

I've got the same error, I'm trying to create a trial instance "opensap". Could you let me know when this functionality is available again?

[former_member209286]

Just fixed.

The creation of Trial HANA instances is working again.

[Former Member]

Hi Xu,

I am also getting today the same error as discussed before by Yuri, Matthew, Pavel & Johannes.

The error message reads as follows:

Unable to create trial instance 'debashish': Internal Server Error (500) - Unexpected exception in createSchema() called with account 'p1941098499trial', schema 'debashish', DB Type 'hanaxs', DB Version '1.00.74.00.390550', and DB Server 'null'

Please do the needful and get same fixed.

Regards--

Debashish

[Former Member]

Hi Xu,

Now I have been able to create the trail instance.

Thank you.

[Matthew_Shaw]

Seems the problem remains

In the SAP HANA Cloud Platform Cockpit - under "HANA instances", when I click "New Trial Instance", give it a name of 'opensap' and then click save I get an error:

Unable to create trial instance 'opensap': Internal Server Error (500)

Unexpected exception in createSchema() called with account 'i049477trial', schema 'opensap', DB Type 'hanaxs', DB Version '1.00.74.00.390550', and DB Server 'null'

Any ideas what the problem might be?

Many thanks

Matthew

[xu_xiang]

Hi Matthew,

the Trial landscape was in maintenance mode while you are trying to create the trial instance.

The downtime was announced on July 1st. "Please be reminded that there will be a planned downtime for https://hanatrial.ondemand.com/ on July 2nd, between 12:00 – 13:00 UTC due to an infrastructure update. "

Best regards

Xu

...
2014 07 02 12:30:22#+00#ERROR#com.sap.core.dbaas.servicecommands.CommandsAPI##anonymous#http-bio-8041-exec-1532##svcservices#persistence#admin#392fdcad-d79d-4861-a8fb-f572d1050c67#Unexpected exception in createSchema() called with account 'i049477trial', schema 'opensap', DB Type 'hanaxs', DB Version '1.00.74.00.390550', and DB Server 'null'
...
at java.lang.Thread.run(Thread.java:743)
... 53 more
Caused by: java.lang.RuntimeException: Call to Orchestrator failed with code: 503
Landscape is in maintenance mode
...
at ...
... 54 more
...

[Matthew_Shaw]

Many thanks. Its works now. 🙂

[Vlado]

You might follow this thread for the Trial landscape downtime announcements:

Also, please do not cross-post (I saw at least three places with this same question of yours). Please read and follow .

Cheers,

--Vlado (Space Moderator)

[Private_Member_139072]

Hi Xu,

I'm experiencing exactly the same problem as Yuri and Mathew. All attempts to create a trial SAP HANA instance are failing for the second day in a row. Is any maintenance going on? Also, I followed Vladimir's advice and checked HANA Cloud Trial downtime announcements but it ends in 2012.

Apparently, you the one who can help

Thanks

[xu_xiang]

Hi Pavel,

at moment we have a general network issue in Trial landscape.

We are working on it

Sorry for any inconveniency

Xu

[Private_Member_139072]

Hi Xu,

It works now.

Thanks a lot!

[Former Member]

Hi Xu

I am getting today the same error as discussed above. Also checked for announce down times, but there were none.

Johannes

Unable to create trial instance 'dev': Internal Server Error (500) - Unexpected exception in createSchema() called with account 'p1941121451trial', schema 'dev', DB Type 'hanaxs', DB Version '1.00.74.00.390550', and DB Server 'null'

[Former Member]

Hi Xu,

I am also getting today the same error as discussed before by Yuri, Matthew, Pavel & Johannes.

The error message reads as follows:

Unable to create trial instance 'debashish': Internal Server Error (500) - Unexpected exception in createSchema() called with account 'p1941098499trial', schema 'debashish', DB Type 'hanaxs', DB Version '1.00.74.00.390550', and DB Server 'null'

Please do the needful and get same fixed.

Regards--

Debashish

[Former Member]

Hi Xu,

I also tried to create the HANA instance today, the problem still persists.

Could you please suggest the solution for the problem.

Thanks & Regards,

Karthik

[xu_xiang]

Hi,

sorry for the late response. (I was on Easter vacation)

My colleagues solved the temprorary issue.

Sorry for any inconvenience

Xu