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.
Hi Andy,
please contact our support hotline. They will be able to solve this problem.
You need increase your instance in Oracle DB.
This error appears because you don't have enough space for instances and table spaces...
BR,
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.
Hi Gino,
such problems are very hard to debug without looking at your system. Please contact our support hotline!
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.
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.
Hi Gino,
it seems you don't have a valid support contract with IDS Scheer. Therefore, they point you to SAP.
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.
now SAP also keeps us waiting. Isn't it ridiculous?
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
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.
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
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.
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
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).
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.
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.