CMS Analysis Snapshot - Generate Modules - Fatal Error - Siebel - Error while executing Batch

Description

Siebel Snapshot generation fails with below error

Error while executing Batch: select * from <Knowledge_Base>.SIEBEL_MODULE_ADDED(‘Siebel Consumer Sector_ADDED’,‘Siebel Consumer Sector’)
Query failed because:
ERROR: null value in column “idobj” violates not-null constraint
Detail: Failing row contains (null, 1520010, 10, 0, 2).
Where: SQL statement “insert into ObjInf (IdObj,InfTyp,InfSubTyp,BlkNo,InfVal)
values (L_MODULE_ID,L_INFTYP_STATUS,L_INFSUBTYP_STATUS,0,2)”
PL/pgSQL function siebel_module_added(character varying,character varying) line 99 at SQL statement
Batch entry 0 select * from <Knowledge_Base>.SIEBEL_MODULE_ADDED(‘Siebel Consumer Sector_ADDED’,‘Siebel Consumer Sector’) was aborted.

Observed in CAST AIP

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅
7.2.x❌
7.0.x❌

Observed on RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS3✅
CSS2✅
CSS1❌

Step by Step Scenario

  1. Configure Siebel Analysis
  2. Run Analysis
  3. Generate snapshot.
  4. Generate Modules phase fails with error - Error while executing Batch select * from SIEBEL_MODULE_ADDED

Action Plan

The reason for this error is absence of objects to be added into the module “SIEBEL_MODULE_ADDED” .
The objects are not extracted during the time of extraction.

  1. Confirm whether the objects are not extracted during the time of extraction.
    1. Check the Extraction log for information messages which says 0 objects are extracted for each type.
    2. If there are information messages which says 0 objects are extracted for each type, Refer to page Delivery Manager Tool - Extraction - INFO - Siebel - 0 objects extracted for each siebel object types for checking what has gone wrong in extraction.
  2. Re-do the extraction
  3. Re-do analysis & snapshot

Impact on Analysis Results and Dashboard

Analysis - N/A
Dashboard - Snapshot generation fails, dashboard is not generated.

Notes/comments