Restore FWSERVICE_REQUEST

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

IDM r12.6

Due to an outage, IME was re-created, and FWSERVICE_REQUEST was emptied after IME re-creation.'

What is the steps to restore FWSERVICE_REQUEST from earlier backup

 

Environment

Release : 12.6.4

Component : IdentityMinder(Identity Manager)

Database: MSSQL 2008

Cause

Due to outage that existing table entries has been removed.

Resolution

Steps to Restore backup records to existing tables

1) Ensure there is no duplication between backup records and existing table by comparing the primary key UNIQUE_NAME field . If there is duplicate records, remove duplicate records

2) Run the following query to make sure primary key did not reference to other table 

SELECT 
      SCHEMA_NAME(schema_id)+'.'+[name] as objectname
      ,type_desc
     ,referenced_schema_name AS SchemaName
,referenced_entity_name AS TableName
,referenced_minor_name  AS ColumnName
  FROM [sys].[all_objects] ob cross apply sys.dm_sql_referenced_entities ( SCHEMA_NAME(schema_id)+'.'+[name], 'OBJECT') e

  where is_ms_shipped = 0 and type_desc in ('AGGREGATE_FUNCTION'
,'SQL_SCALAR_FUNCTION'
,'SQL_INLINE_TABLE_VALUED_FUNCTION'
,'SQL_STORED_PROCEDURE'
,'SQL_TABLE_VALUED_FUNCTION'
,'SQL_TRIGGER'
,'VIEW')
and name !='sp_upgraddiagrams'
and referenced_entity_name  = 'FWSERVICE_REQUEST'
and referenced_minor_name = 'UNIQUE_NAME'

3) With no other reference table, append the backup table with existing table

Please consult DBA for restoring DB process