The database "xxxx" could not be created: Translate this page Printer-friendly version bookmark or share this page
Andy's picture

Posted: 2009-12-17
357 views | 16 comments | category: ARIS Support

0
show all articles

Hi, I wonder if anyone can help...

We have recently upgraded ARIS to v7, but after 6 months one of our users gets the following error:

"The database 'TEST' could not be created:

Empty scemata for new ARIS databases are no longer available. Please inform your DBMS administrator. (178-27)

We are using Oracle for our DBMS.

Thanks

Andy.

Comments
Sebastian's picture

Hi Andy,

please contact our support hotline. They will be able to solve this problem.

André Vitor's picture

You need increase your instance in Oracle DB.

This error appears because you don't have enough space for instances and table spaces...


BR,

Gino's picture

Is the problem solved? We had the same problem on Aris 7.1.

It's a new installation, and the error happens when creating a new database through Admintool.

Sebastian's picture

Hi Gino,

such problems are very hard to debug without looking at your system. Please contact our support hotline!

Gino's picture

Sebastian, thanks.

Here's the answer from Aris support:

"Thank you for your interest in our services.
SAP AG is responsible for your support. SAP Customers should contact SAP AG in the support case."

I just don't unerstand why I can't contact Aris support directly.

BTW there's an extra detailed message:

Empty schemas for new databases are no longer available. Please inform your DBMS administrator. no schemas left in db_stock table.

Gino's picture

The 'no schemas left in db_stock table' appears when importing an db from Aris 7.0

At creating new database case, there's no the 'no schemas left in db_stock part' part, just only the

'Empty schemas for new databases are no longer availabe. Please inform your DBMS administrator'.

But the two messages are similar, i think they're quite related.

Sebastian's picture

Hi Gino,

it seems you don't have a valid support contract with IDS Scheer. Therefore, they point you to SAP.

Gino's picture

Sebastian,

It doesn't make sense to me.

yes, we bought the license from SAP. But the Aris is still the same Aris.

To me the valid license is a valid support contract.

I would suggest IDS Scheer review the support model as it's unacceptable to customers,

at least for me.

Gino's picture

now SAP also keeps us waiting. Isn't it ridiculous?

Sebastian's picture

Hi Gino,

you will receive support from the organisation you are paying for the support. For example, if you bought the licenses at SAP and have a support contract with them, they will support you. Please note, I don't know your contract, so I can't make any judgement here. Also note, if someone has a support contract with IDS Scheer, he of course receives very professional support from our side. Please double check first with whom your organisation signed the support contract before ranting about missing support.

Thanks for your understanding,

Sebastian

Gino's picture

Sebastian,

I post my problem here to seek for other expert's help.

If IDS Scheer and you(I think you're the company's employee) can't help customers,

why bother giving explanations? Sorry to be straight.

Sebastian's picture

Hi Gino,

as I said in my first comment to you, I'm pretty sure it is not possible to solve this problem here in the forums, because usually someone has to look at the system to figure out what is going wrong. I suggested that you contact our support hotline. Here, I made a mistake, because I should have said that you should contact our support hotline if you got a support contract. I apologize for this mistake.

Still, I'm not accepting that you make false claims about not receiving support. I will continue to correct those claims, even if you tell me that I should not "bother giving explanations". Our support team has received several prices for highest customer satisfaction for many years in a row and I am convinced that they handle every valid support request very professionally.

In the end, I would be more than happy if someone else having solved this problem in the past reports here about the solution so that everyone searching for it will benefit from it in the future.

Gino, I like to ask you to not continue this discussion about "bad support", because my feeling is that it will end in a very long flame war without any useful results. Please feel free to contact me directly if you want to discuss that issue further.

Thanks,

Sebastian

Andy's picture

Hi guys, I contacted our local IDS Scheer UK support - I believe this is a known problem with our current version; here's the reply.  This might help someone with a similar issue;

I have seen this problem. It occurs with ARIS 7.02 where tables are not created automatically when a new ARIS database is created (I think this occurs after every 5 ARIS databases created). This is not a problem in 7.1
To fix this problem, we need to run the “automgr.sql” script manually against the oracle ARIS database whilst connected using the Oracle SYSTEM user.
Please ensure all databases are backed up prior to running the sql script. The SQL Script can be found on the ARIS DVD.
 
All the best
Andy.

 

Gino's picture

Hi Andy,

Thanks a lot for the information. But I still have no luck.

I don't find the "automgr.sql" script in our Aris 7.1 CD. Maybe it's different reason.

But I would like to take a look at the script, could you post the COMPLETE script content here?

Gino

Sebastian's picture

Please note (I know you won't love what I write here): if the script is shipped with an ARIS installation, you are not allowed to post it here, because this would violate the software license (basically you are redistributing the script).

Gino's picture

Who needs a community guard that doesn't help ...

 

Andre' is right about the problem. It's caused by tablespace being used up.

At our Aris 7.1 installation on Linux & remote Oracle database, there will be almost 200 tables created

for each new repository database. And each table is created with 100M by default (not sure where

to adjust the table size setting). So for the default ARISDATA tablespace it needs 20G space, and so does

for the ARISINDEX tablespace. End up it needs 45G space to create a new repository database.

 

And the above situation is not mentioned in the installation&administration guide at all.