Invalid object name error during staging

Products

• Information Centric Analytics

Issue/Introduction

After upgrading Information Centric Analytics (ICA) and running the nightly RiskFabric Processing job, the following error is captured in the SQL Server Agent history log and in the table dbo.Log_DataTransformation in the RiskFabric relational database:

LogGroupID=<ID>;LogID=<ID>;LogGroupDescription=Integration Wizard - spIW_RunImportRuleMappingStaging @i_nImportRuleMappingID = <ID>;ErrorDesc=Error Msg: Invalid object name '<table_name>'.

Environment

Version : 6.x

Component : RiskFabric Processing

Cause

A data source query's staging table has been deleted.

Resolution

To resolve this error, the data source query's staging table must be re-created. To do this, follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. Press CTRL+N to open a new query editor window
4. Copy and paste the following query in the new query editor window:
   

   USE RiskFabric;
   GO
   
   SELECT     s.LinkedServerLabel AS "DataSource",
              q.DataSourceQueryName AS "DataSourceQuery"
   FROM       dbo.IW_ImportRuleMapping AS m
   INNER JOIN dbo.IW_DataSourceQuery AS q
           ON m.DataSourceQueryID = q.DataSourceQueryID
   INNER JOIN dbo.LinkedServers AS s
           ON q.LinkedServerID = s.LinkedServerID
   WHERE      m.ImportRuleMappingID = <ID-from-error>;

5. Execute the query by pressing the F5 key and note the DataSource and DataSourceQuery values
6. Open the ICA portal
7. Navigate to Admin > Integration > Data Sources > Choose Data Source | User Defined
8. Expand the data source corresponding to the DataSource value returned by the query on step 4
9. Right-click the data source query corresponding to the DataSourceQuery returned by the query on step 4 and select Edit Query
10. Click the Save button
    The Run Staging Table Creation? dialog box opens
11. Click the Yes button to re-create the staging table
12. Click the Save button
    The Run Staging Table Creation? dialog box opens
13. Click the Yes button to re-create the staging table