Purpose

This page will troubleshoot the warning message Internal exception occurred during processing listener you may face during a PL/SQL analysis. The error is like below :

Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3(tick)
CSS2(tick)
Action Plan
  1. If the full warning message is like : Internal exception occurred during processing listener SQLCodeChecker::TriangularJoinCheckerAction::walkTree, like below screenshot :
  2. Open Notepad++ and search in folder for the item in red in the <CAST Installation Folder>\Configuration\AMT . In that example, check for TriangularJoinCheckerAction. The result of the search is :
  3. If the action name is in the <!-- Code checkers -->, the warning message is not blocking, and the action name can be commented to not being resolved during analysis. Then, the warning would not appear. The main impact is that one Diag will not be computed.
  4. If the action name is not in the <!-- Code checkers -->, then the warning is blocking and must be investigated by CAST Technical Support. The warning occurs when the analyzer is parsing the file indicated in the warning message. The workaround is to remove this file and to run the analysis again. This file is requested to reproduce the issue along with external source (Classpath for JAVA, Include files for C / C++, libraries for Mainframe, UAX and UAXDIRECTORY for PL/SQL, etc...). In the above example, the source file is S:\CASTTemplate\...\Deploy\...\PR.7906.src, the external soure file are the corresponding UAX file (PR.7096.uax) and the CASTDATABASE.UAXDIRECTORY.
  5. We also get warning like below sometimes which is related to analysis of trigger in PLSQL analysis, the impact of this issue would be user will not get link between trigger and table
    Internal exception occurred during processing listener PLSQLActionsImpl::PLSQLResolutionVisitsAction::walkTree on instance CAST_Oracle_DML_Trigger #102765defined in {CAST_TargetSourceFile #102767 of path '    src' of name 'S:\SOURCES\AA\Aa Clarity\deliveryResults\TR.322.src' of full-name 'S:\SOURCES\AA\Aa\deliveryResults\TR.322.src'} at line 1 at col 1 : access violation
    This issue has been fixed in AIP 8.0.5 and ported to latest AIP like 8.2.7
  6. If the problem you are facing does not match any case listed in this page, contact CAST Technical Support with the Relevant Input in order to reproduce.
Notes/comments

Webcall : 28484

CASE 2 : Ticket  # 762876297630

Ticket  # 10655