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:
Below is the step-by-step scenario leading to the problem:
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.
Extension cannot be installed, hence you cannot use it for your analysis.
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:
Remove the Deprecated version of the Delta tool Extension from your extensions folder
- Run the procedure attached on the local schema - Deltareport_Update PROC.sql.
- 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.
Ticket # 23485