Schemas

Posted by Willem Engelbrecht

Posted on Tue, 07/14/2020 - 20:24 in Professional ARIS

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

1.4k

by André Vitor Oliveira

Posted on Tue, 07/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

by Willem Engelbrecht Author

Posted on Wed, 07/15/2020 - 10:26

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.

File attachments

No_install_yet.GIF

017 Error.GIF

by André Vitor Oliveira

Posted on Wed, 07/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

by Willem Engelbrecht Author

Posted on Tue, 07/21/2020 - 10:11

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,