- Page restrictions apply
- Added by David Perez, last edited by ExamDeveloper Technical Support on Apr 17, 2019 (view change)
New version for 1809 release added with the name of 7.1809.01 in SVN repositories. Please download the new 7.1809.01 version for upgrade the application to 7.1809 release.
ItemGroup Database Setup
From 1807 release, we introduced a new Microservice: Item Group. This will be utilized for managing groups of items in future releases.
In order to set it up, we need to configure a new database first.
Open SQL Server Management Studio and connect to the one being used with ExamDeveloper.
Right-click Database node in Object Explorer and select New Database from the context menu.
Name the database Itemgroup on the general tab and accept the default settings. If we are using multiple instances in the same server we need to provide different names for each instance like for example Itemgroup_BETA / Itemgroup_PROD.
Go to Security → Logins, and right-click Properties on the user that is utilized for ExamDeveloper login. For example; ED is shown in below picture
Assign the same permissions given to another database to the Itemgroup database.
Enable Snapshot isolation for ItemGroup database name in step e using the following commands tougher from Microsoft SQL Server Management Studio :
ALTER DATABASE [ItemGroup]
SET ALLOW_SNAPSHOT_ISOLATION ON
Property files update
Please add SCHEDULED_REPORT_USERNAME= to the secure.properties file. We have added a new configuration entry to schedule Report Username if you have one. Otherwise, just leave it empty.
Please add SCHEDULED_REPORT_PASSWORD= to the secure.properties file. We have added a new configuration entry to schedule Report Password if you have one. Otherwise, just leave it empty.
ITEMGROUP_CONNECTION_STRING=Data Source=XXXXX;Initial Catalog=ItemGroup;Persist Security Info=True;User ID=ed;Password=XXXXXX
Add CAS_URL= URL if you have one to the self.hosted.properties file. Otherwise, just add CAS_URL = http://locahost/.
Add PREVIEW_URL= URL if you have one to the self.hosted.properties file. Otherwise, just add PREVIEW_URL = http://locahost/.
Please follow the regular upgrade process to install the Web and previously installed services in Services and Web installation process using power shell script.
Log in to the application with Admin account and run all scripts.
3 Scripts will fail as shown in the image below:
Continue with point 5 for Question Revision Migration Script
Question Revision Migration Script
This utility will migrate question revisioning data from Question table to QuestionHistory table excluding the latest question version.
Please follow the steps below to execute the QuestionRevisioningMigration utility.
Extract the <SVNFolder>\Web\web.zip file into a folder. Here, <SVNFolder> is the path where ExamDeveloper files are going to be checked out, which is C:\ExamDeveloper\Repositories\ExamDeveloper\ in our example.
Extract the <Step a Folder Location>\MigrationExe\QuestionRevisioningMigration.zip file into a folder. Here, <Step a Folder Location> is the path where web.zip files are extracted in the above step, which is C:\ExamDeveloper\Repositories\ExamDeveloper\Web\web in our example.
Locate QuestionRevisioningMigration.exe in the <Step b Folder Location> folder. Here, <Step b Folder Location> is the path where QuestionRevisioningMigration.zip files are extracted from the above step b, which is C:\ExamDeveloper\Repositories\ExamDeveloper\Web\web\MigrationExe\QuestionRevisioningMigration in our example.
Open cmd and run the following commands
cd <Step b Folder Location>
QuestionRevisioningMigration.exe "<CONNECTION_STRING>". Here, <CONNECTION_STRING> is your ExamDeveloper database connection string, which is the same as the value of the CONNECTION_STRING token from the secure.properties file.
Thus, if your database connection string is "Data Source=WIN-VSGF1NBSVPB; Initial Catalog=ExamDeveloper; Persist Security Info=True; User ID=ExamDev; Password=P@s$w0rd" as in our example, then the command to run would appear as below:
QuestionRevisioningMigration.exe "Data Source=WIN-VSGF1NBSVPB;Initial Catalog=ExamDeveloper;Persist Security Info=True;User ID=ExamDev;Password=P@s$w0rd"
- Note: Make sure that the connection string is enclosed in double-quotes
- This will display the following menu options:
1: Copy Question revisioning data
2: Populate user tracking data
- Please select 1 it will prompt confirmation message with the total number of questions are going to migrate
- Please press y to continue the migration.
- This is a long-running process that will take some time.
- The command prompt screen will tell you how many Question version update completed and show the progress of migrating question revisioning data.
- If there were any errors, you can find them here: <Step b Folder Location>\logs\QuestionRevisioningMigration.log and <Step b Folder Location>\logs\QuestionRevisioningMigrationPerformance.log.
- Once this is complete, you may continue with the rest of the upgrade process.
Again login to the application with Admin account and run all scripts.
All Scripts will execute successfully and the application will be upgraded to 7.1809 version.