WE

Good day everyone,

We are in the process of upgrading to ARIS 10 SR 11. We've been allocated a new server with the required specs.

Our connection will be to SQL, and we are trying to run the SQL scripts, but get the following error:

image

I do not know SQL, so if someone could furnish me with an answer as to what is wrong, it would be highly appreciated.

Best regards,

Willem

File attachments
by Bertin Günzburger
Posted on Tue, 07/07/2020 - 13:00

Hi, as I myself am not a database specialist, I have looked at the error text. It says the file "G:MSSQL\DATA\ARIS10DB\ARIS10DBPRIM.mdf" cannot be found. The program tries to build the databas using a backup file, that (as I guess) should have been created during the migration process.

So you can start looking for the file ARIS10DBPRIM.mdf and if you find it, put it in the directory mentioned in the error message.

If you cannot find it, you can contact support via empower. Or somebody more experienced has a better suggestion.

Good luck

0
by Willem Engelbrecht Author
Posted on Tue, 07/14/2020 - 20:28

In reply to by guenzbub

Thank you for your reply, the DBA were able to sort out the issue, and yes the error seemed to be with the ****DBPRIM.mdf location as per your suggestion,

Thanks again,

Willem

0
by Patrik Siffrin
Posted on Tue, 07/07/2020 - 13:19

Hi,

the SQL server scripts are intended to be run at the SQL server pc or have to be modified.
The directory g:\MSSQL\data\aris10db must exist at the server (or use another existing one).

If you look at the batch file, you will see

REM name of database that will be created by the script.
SET MSSQL_SAG_DATABASE_NAME=ARIS10DB
REM folder in which the database files should be stored.
SET MSSQL_SAG_FILEGROUP_FILE_DIR=F:\msqldata\ARIS10DB

.. which is the location at the SQL Server side!

It is later used here..
ECHO Installing...
IF "%MSSQL_SAG_MSSQL_SERVER_NAME%" EQU "localhost" (
    IF NOT EXIST "%MSSQL_SAG_FILEGROUP_FILE_DIR%" MKDIR "%MSSQL_SAG_FILEGROUP_FILE_DIR%"
)

Short answer:
Execute the script at SQL server side and it will use localhost and create the missing  directory.
If you use the script remote, you have to manually ensure that the directory exists.

 

Regards

Patrik

 

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
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