Description

This page provides solution to the following C Analysis error:

Starting External Link processing:

Error INTERNAL ; Job execution SQL Error: ERROR: relation "all_synonyms" does not exist.
Error INTERNAL ; Job execution SQL Error: LINE 1: ... FOR select table_owner, table_name, db_link from all_synony....
Error INTERNAL ; Job execution SQL Error: ^ (Severity 1, Msg No 1).
Error INTERNAL ; Job execution SQL Error: ERROR: current transaction is aborted, commands ignored until end of transaction block (Severity 1, Msg No 1).

Observed in CAST AIP
Release
Yes/No
8.3.x(error)
8.2.x(error)
8.1.x(error)
8.0.x (error)
7.3.x, x<1(tick)
7.2.x(tick)
7.0.x(error)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3(error)
CSS2(tick)
CSS1(error)
Step by Step Scenario
 Run C analysis
Action Plan

This error occurs for Pro*C analysis, when, the external links tries to connect to the Oracle database and since the analysis is offline, it throws error. It is a bug and it is fixed in CAST version 7.3.1

Workaround:

  1. Comment <action name = "AMTExternalLinkAction" /> from configuration (..\configuration\AMT\AmtJobConfig_Core.xml) and then run the analysis.

    <?xml version="1.0" encoding="utf-8"?> 
    <configuration> 
        <!-- set of standard actions activated in any AMT analyzer --> 
        <actions> 
            <!-- 
            <action name = "AMTExternalLinkAction" /> 
            --> 
            <action name = "AMTPersistingAction" /> 
        </actions> 
    </configuration>

 

Impact on Analysis Results and Dashboard

Impact of error : Analysis is not successful
Impact of workaround: No impact

Notes/comments

Referenced webcall - 28968

It is a bug and it is fixed in CAST version 7.3.1