-
Title
One Identity Manager 8.0.2 Hotfix 62961 -
Description
One Identity Manager 8.0.2 Hotfix 62961
October 2018
This hotfix includes the changes listed in the following sections. This hotfix addresses a functionality issue. One Identity may generate additional hotfixes for future releases of the product.
About this hotfix
This hotfix addresses a functionality issue. The minimum version required for installing this hotfix is One Identity Manager 8.0.2. -
Resolution
Please download One Identity Manager 8.0.2 Hotfix 62961 by clicking here.
Contents of this Package
The following files are included in this hotfix package:
- SCN.zip
- One Identity Manager_8.0.2_62961_Hotfix -- this ReadMe file
This hotfix updates the following files compared to the One Identity Manager 8.0.2 release:
Table 1: Updated Files
Database Scripts \SCN\database\MSSQL\Migration\v80\2017.0001.0027.0000.sql \SCN\database\MSSQL\Migration\v80\2017.0011.0004.0000.sql \SCN\database\MSSQL\Migration\v80\2017.0011.0004.0201.sql
XML Files \SCN\database\MSSQL\ControlFile2SchemaUpdate80.xml \SCN\database\DatabaseInfo.xml Resolved issues
The following is a list of issues resolved in this hotfix.
Table 2: Resolved issues
Resolved issue Issue ID Unable to install other modules post ServiceNow Module installation (SCN).
Description
The below mentioned error occurs while installing other modules after the installation of the ServiceNow (SCN) module.
"Processing step 'SCN SchemaInitial (create initial schema)' failed.
1 - SqlFile command failed.
Error processing sql command line 26 in file Generate\00000000SCNTableDef.sql
Error during execution of statement: alter table PersonWantsOrg add ServiceNowSystemID nvarchar(64) NULL
Database error 2705: Column names in each table must be unique. Column name
'ServiceNowSystemlD' in table 'PersonWantsOrg' is specified more than once.
Column names in each table must be unique. Column name ' ServiceNowSystemID' in table 'PersonWantsOrg' is specified more than once."
After this error occurs, if Identity Manager is opened, the following occurs:
"Cannot connect to database because a system update is running."62961 Applicability of this hotfix
Table 3: Products affected by this hotfix
Product name Version One Identity Manager 8.0.2 NOTE: This hotfix is applicable only if SCN is already installed.
Installing this Hotfix
To install the hotfix
- Extract and replace the SCN folder in the Modules section of the Identity Manager installer with the SCN folder that was downloaded as part of this hotfix.
- If the Database is in single user mode, run the below mentioned query in SQL Server:
update DialogDatabase set SingleUserProcess=0
- Check whether there are module entries with null values for ModuleInfoXML in the QBMModuleDef table, run the below mentioned query in SQL Server:
select DisplayValue, ModuleName, ModuleVersion, MigrationVersion, ModuleInfoXml from QBMModuleDef where ModuleName<>'CCC' order by SortOrder, DisplayValue
- Delete all the module entries that have the value as Null for ModuleInfoXML, run the below mentioned query in SQL Server:
Delete from QBMModuleDef where ModuleInfoXML Is Null
NOTE: After successful execution of above mentioned SQL queries and replacing of SCN folder in the Installation directory, the update database operation with additional modules should be successful.
-
Change Request
62961