AJ

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.

by Sebastian Stein
Posted on Fri, 12/18/2009 - 12:49

Hi Andy,

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

0
by André Vitor Oliveira
Posted on Thu, 01/07/2010 - 18:26

You need increase your instance in Oracle DB.

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



BR,

0
by Gino Fu
Posted on Fri, 01/22/2010 - 10:27

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.

0
by Sebastian Stein
Posted on Fri, 01/22/2010 - 10:28

Hi Gino,

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

0
by Gino Fu
Posted on Fri, 01/22/2010 - 10:37

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.

0
by Gino Fu
Posted on Fri, 01/22/2010 - 10:41

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.

0
by Sebastian Stein
Posted on Fri, 01/22/2010 - 11:24

Hi Gino,

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

0
by Gino Fu
Posted on Fri, 01/22/2010 - 11:33

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.

0
by Gino Fu
Posted on Fri, 01/22/2010 - 11:36

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

0
by Sebastian Stein
Posted on Fri, 01/22/2010 - 12:04

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

0
by Gino Fu
Posted on Fri, 01/22/2010 - 13:46

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.

0
by Sebastian Stein
Posted on Fri, 01/22/2010 - 14:45

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

0
by Andy Jones Author
Posted on Fri, 01/22/2010 - 15:08

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.

 

0
by Gino Fu
Posted on Sat, 01/23/2010 - 18:05

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

0
by Sebastian Stein
Posted on Sun, 01/24/2010 - 17:53

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).

0
by Gino Fu
Posted on Mon, 01/25/2010 - 17:09

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.

0
by Mithilesh Dubey
Posted on Fri, 01/22/2016 - 06:32

We too got the same issue and we resolved it by providing permission on our ARISBS database with permissions to add schema or update schema. 

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

Leaderboard

|
There is still some space in this week's top 5 for you - this is your chance to become one of our top members of this week. Register now to start collecting points!
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock