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