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