Schemas

Last activity on October 1, 2023 - 11:21 1.5k Views 4 Replies Professional ARIS

Willem Engelbrecht on July 14, 2020

Hi Everyone,

I'm busy installing ARIS10SR11 at a client. We will be using SQL. We updated the envset.bat file with the required settings, and ran the inst.bat file.

When doing the install, I get the following error:

The schemas "ARIS_DEFAULT" and "ARIS_MASTER" were not found. They either do not exist or are not visible for the ARIS10User.

I have confirmed that the names for the schemas are exactly the same, as well as the user does exist. I do not know SQL so is in the dark.

Anyone have any suggestions on how to fix this.

Thanks and best regards,

W Engelbrecht

Bookmark

Notify Moderator

4 Replies

André Vitor Oliveira on July 14, 2020 - 21:32

Hi Willem Engelbrecht,

During the installation steps you have also to fill the same name of schemas, also you can see the log file cip.log/system.out to know the error in details..
These log files are available at:
work_abs_m\base\webapps\abs\log\cip.log
work\work_abs_m\base\logs\system.out

if is possible provide some error messages found in log files here...

BR
AO

or register to reply.

Notify Moderator

Willem Engelbrecht Author on July 15, 2020 - 10:26 as Reply to André Vitor Oliveira

Thanks for your reply, however, since the actual installation has not been done yet, there is no logfiles present yet, only the group was created. I am attaching the screengrab.

Attachments

No_install_yet.GIF
017 Error.GIF

or register to reply.

Notify Moderator

André Vitor Oliveira on July 15, 2020 - 14:54

Hi Willem,

Ok thanks for the details, in this case the installation will create some log files and please can you attached the logs here.
They are available at %temp% folder :
Temp\ARIS_Install.log
Temp\ARIS_Install_full.log

About the envset.bat I suggest you to keep as default:

REM schema names for the default and master tenants
SET MSSQL_SAG_TENANT_DEFAULT=ARIS_DEFAULT
SET MSSQL_SAG_TENANT_MASTER=ARIS_MASTER

About the message: The schemas "ARIS_DEFAULT" and "ARIS_MASTER" were not found.

It seems as if the DBMS objects for ARIS have not been created properly

With the installation log files will provide more details.

BR
AO

or register to reply.

Notify Moderator

Willem Engelbrecht Author on July 21, 2020 - 10:11 as Reply to André Vitor Oliveira

Hi André Vitor Oliveira,

Thank you for your reply.

I found the Log files and the error is:

2020-07-14 19:59:14,715|WARN |validateAsync| com.aris.prov.ext.validation.checks.dbconnection.DbConnectionCheck - Schema validation failed: The schemas "ARIS_DEFAULT" and "ARIS_MASTER" were not found. They either do not exist or are not visible for the user ARIS10User.

I had a chat to the DBA, and we can can't find the schemas ARIS_MASTER or ARIS_DEFAULT in the Database.

We will now check how to create the schemas manually and try again.

Thanks again, will keep you updated.

Regards,

or register to reply.

Notify Moderator

There are currently no upcoming events.