Restore FWSERVICE_REQUEST

book

Article ID: 142929

calendar_today

Updated On:

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

 

Cause

Due to outage that existing table entries has been removed.

Environment

Release : 12.6.4

Component : IdentityMinder(Identity Manager)

Database: MSSQL 2008

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