This page provides information regarding a fatal error that comes up during Run Path Builder step while taking a snapshot.
The following message can be seen in the Cast-MS.log.txt
INF: 2017-11-07 17:16:27: [SQL] {? = call xxx_local.DDL_TRUNCATETABLE(?) } INF: 2017-11-07 17:16:27: [SQL] 1: IO integer value INF: 2017-11-07 17:16:27: [SQL] 2: InKB_DIA_ExpensivePath ERR: 2017-11-07 17:16:27: [SQL] ERROR: relation "inkb_dia_expensivepath" does not exist Where: SQL statement "TRUNCATE TABLE InKB_DIA_ExpensivePath" PL/pgSQL function xxx_local.ddl_truncatetable(character varying) line 10 at EXECUTE statement WRN: 2017-11-07 17:16:27: Cleanup for "Run Path builder on "xxx_local"" skipped
Release | Yes/No |
---|---|
8.3.x, x < 2 | |
8.2.x, x < 8 | |
8.1.x | |
8.0.x | |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 |
- Take snapshot (skipping analysis)
- Error observed during Run Path Builder
Users should not run queries on the Central Base using "Tools after module generation". Refer to official documentation for details about the tool editor CMS - Tool editor
If the SQL error is related to a non-existing table or non-existing column (example : "Relation xxxx does not exist" ot "Column xxx does not exist"), the root cause is likely to be a known vulnerability in Cast-MS that will be fixed in Service Pack 8.2.9
If user defines a Tool after module generation and sets the search path to the Central Base instead of the Local Base, then all the SQL queries and procedures in the further steps may be affected.
To remedy the situation,
- Remove any "set search_path = xxx" in the scripts registered as "Tools after module generation"
- Prefer prefixing all involved tables, views and procedures with the name of the local base.
- Relaunch snapshot
Relevant Input
Sherlock (CAST Support Tool (CST) - alias Sherlock) : Option to select are Export Logs and Export Database (MB only). Since issue occurs during the snapshot computation, source code is not requested because analysis is already done.
Ticket #10371