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.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 | |
CSS1 |
- Configure Siebel Analysis
- Run Analysis
- Generate snapshot.
- Generate Modules phase fails with error - Error while executing Batch select * from SIEBEL_MODULE_ADDED
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.
- Confirm whether the objects are not extracted during the time of extraction.
- Check the Extraction log for information messages which says 0 objects are extracted for each type.
- 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.
- Re-do the extraction
- Re-do analysis & snapshot
Analysis - N/A
Dashboard - Snapshot generation fails, dashboard is not generated.