CMS Snapshot Analysis - Run Analyzer - Fatal Error - Oracle Server PL SQL with Core CAST AIP - Error messages and possible reasons

Severity

Frequence

Message

Reason

Workarround

ERROR

Frequent

Failed to get valid connection to participating server.

Check participating is correctly declared in TNSNAMES.ora , Check windows service TNS Listener is running.

Failed to find identifier of the cursor to open

ERROR

Frequent

Failed to find select statement in open cursor for

ERROR

Rare

Failed to find expression in OPEN FOR USING statement

ERROR

Extremely Rare

failed to find the arguments of USING expression

INTERNAL

Frequent

Failed to find expression in execute immediate statement

INTERNAL

Rare

Failed to find for loop variable

INTERNAL

Extremely Rare

Failed to find lower bound expression in forall statement

WARNING

Frequent

Failed to find upper bound expression in forall statement

INTERNAL

Rare

Failed to find for indices list name

INTERNAL

Extremely Rare

Failed to find for values list name

Failed to find select statement in sql select

Failed to find star or select item list

Failed to find from clause

Failed to find expression in having clause

Failed to find expression in connect clause

Failed to find expression in start clause

Failed to find alias for factorized query

Failed to find subquery for factorized query

Failed to find referenced table or subquery

Failed to find left from table reference of joined table

Failed to find right from table reference of joined table

Failed to find list of column names in joined table

Failed to find expression in where clause

Failed to find into clause

Failed to scan Object_id

Failed to find table or joined table

Failed to find from table reference

Failed to find NOM_TABLE_VUE from merge_into_clause

Failed to lock a schema, synchronization aborted

An error occurred during the synchronization process.

The following events may have prevented the correct synchronization of all objects you had selected:%ERROR_MESSAGE%

Some objects were not taken into account.The following events may have prevented the correct synchronization of all objects you had selected:%ERROR_MESSAGE%

Error

Syntax error is raised in the log, if the "model clause" is used in the source code
Example:
select empno, ename  from emp  where deptno = 10
     model
          return updated rows

Model clause is not supported by Analyzer
This information is also going to be added in the release notes (known issue) in CAST version 7.0.4