When analyzing an Oracle database, analysis stop with the following error occurs :
Invalid category 'CAST_AST_BinaryExpression' used in type 'CAST_AST_ANSISQL_SelectStmt' extractor 7.0 (1.1 a)
Failed to process job XXX
Observed in CAST AIP
|7.3.x||x < 2|
|7.2.x||x < 4|
Observed on RDBMS
|Microsoft SQL Server|
Step by Step Scenario
- Perform an oracle extraction
- Try to analyse the extraction results
Issue is due to the "member of" statement in the "where" clause that is not managed by the analyzer.
- The workaround is to replace the "member of" statement by "=" for the analyzer to be able to parse the file without skipping it.
Impact on Analysis Results and Dashboard
The error prevents the analysis to finish correctly. Applying the workaround the analyzer is able to parse the file without skipping it.
Issue will be fixed in 7.2.4 version.