Page tree
Skip to end of metadata
Go to start of metadata

Server Manager throws the following error when trying to install/upgrade an extension:

SQL Error: ERROR: relation "delta_dynlink" does not exist

As shown in the screenshot below:

Observed in CAST AIP
Observed on RDBMS
Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

  1. In your CAST schema's (local, central & mngt), check if a deprecated version of the Delta Tool report on Analysis (versions - 1.1.0, 1.0.1, 1.0.0) is installed - Delta Report on Analysis Extension

      2. Try to upgrade or install any Extension from the server manager.

Impact of the Problem

Extension cannot be installed, hence you cannot use it for your analysis. 

Action Plan

The issue here is due to the deprecated version of the delta tool extension which consists of the wrong table name. 

The table name has been changed to DeltaTool_DynLInk in the latest version of the Extension - Delta Tool report Extension

To remedy this issue, do the following steps:

  1. Remove the Deprecated version of the Delta tool Extension from your extensions folder

  2. Run the procedure attached on the local schema - Deltareport_Update PROC.sql.
  3. Run the below .sql files on the local schema 
<CAST Installation Path>\CAST\8.3\InstallScripts\CastStorageService\DELTATOOLS\DeltaAnalysis.sql

             Run the below .sql files on the Central schema 

<CAST Installation Path>\CAST\8.3\InstallScripts\CastStorageService\DELTATOOLS\DeltaSnapshot.sql

          4. Launch server manager and try to install an extension along with Deactivating the DeltaTool Extension. 

If this does not help, you will need to contact CAST Technical Support with the Extensions folder and the Local Schema. 

Related Pages

Ticket  # 23485


  • No labels