Subaccount - No database system available.

[Former Member]

Hello,

I'm having issues with one of my subaccounts. Whenever I try to create a new DB schema i get an error saying:

No database system available.

The other subaccount works fine.

The main difference (I belive this may be relevant) is that the subaccount which is not working was created through binding it to a development SuccessFactors instance.

Any Ideas on what may be the issue here ? Or who to contact from SAP to get this issue addressed ?

I'm unable to deploy any applications and I'm getting persistance service errors during application publishing process.

[former_member197689]

Hi Krzysztof,

Can you please post some screen shots of the sub-accounts that is working? Plus not working as well?

The URL is the key here on the account we are talking about.

Thanks,

Jin

[Ivan-Mirisola]

Hi Krzysztof,

When you are deploying a Java application that is using JPA, the Database binding is automatically created by the EclipseLink or Spring Boot. The schema used is auto-generated by JPA so you shouldn't need to create a schema yourself. However, if your sql statements use an specific "schema" name, then have a look at how you declare your entities with "@Table" annotation. There you can specify the schema name so your Java code is able to manipulate data on those entities accordingly. Please refer to the following blog for detailed instructions on how to create a new database binding with the Schema definition or here to automate using neo.bat command. However, if you need to deploy with no automatic schema creation, you need to specify the DDL Generation type as none. Check our other uses of binding here.

Regards,
Ivan

[richard-zhao]

Hello, Krzysztof Could you provide us which SCP environment do you use please？Foundry Environment or Neo Environment?

There is a database limitation for Neo Environment.

After 12 hours, it is shut down automatically to free resources (see Overview of Database Systems and Databases).

If you do not use the tenant database for 7 days, it is automatically deleted.