Help shape the future of CMS PaaS release notes! Take this quick survey and share your feedback. 

Daniel Halse
Jun 8, 2023
  1436
(3 votes)

Prevent SQL error on CMS 12 minor version update

If using an early version of CMS 12, like 12.0, you will get an SQL error after upgrading to newer patch versions.
The fix for this is minor locally using SQL:

CREATE PROCEDURE dbo.netSoftLinksGetBroken
AS
BEGIN
SELECT 1;
END
GO

This will create the missing stored procedure and allow it to proceed.
But as this is a pain when dealing with DXP environments there is a better way to fix this before deployment:
  1. Go to reports in the CMS
  2. Run the broken links report
  3. If this fails then you may need to get Optimizely support involved
  4. If this succeeds then the stored procedure above has been created correctly and used
  5. Optionally download the DB from PAAS portal and verify that the dbo.netSoftLinksGetBroken stored procedure is present
This has been raised before:
The bug for which was closed without being fixed:
Bug - CMS-26818 (optimizely.com)
I suspect the issue is mainly visible on new sites / databases only so will more commonly be seen in early development.
Jun 08, 2023

Comments

Ethan Schofer
Ethan Schofer Jun 9, 2023 06:02 PM

Daniel - what I have been seeing with this error is that these Stored PRocedures get created, but with the wrong SQL schema. I have to manually update the Schema myself, which is a problem on DXP environments.

Please login to comment.
Latest blogs
How to: set access right to folders

Today I stumped upon this question Solution for Handling File Upload Permissions in Episerver CMS 12, and there is a simple solution for that Using...

Quan Mai | Feb 7, 2025 | Syndicated blog

Poking around in the new Visual Builder and the SaaS CMS

Early findings from using a SaaS CMS instance and the new Visual Builder grids.

Johan Kronberg | Feb 7, 2025 | Syndicated blog

Be careful with your (order) notes

This happened a quite ago but only now I have had time to write about it. Once upon a time, I was asked to look into a customer database (in a big...

Quan Mai | Feb 5, 2025 | Syndicated blog

Imagevault download picker

This open source extension enables you to download images as ImageData with ContentReference from the ImageVault picker. It serves as an alternativ...

Luc Gosso (MVP) | Feb 4, 2025 | Syndicated blog

Optimizely SaaS vs PaaS: A Comparison from Client and Developer Perspectives

Optimizely, one of the leading digital experience platform. Offering both Software-as-a-Service (SaaS) and Platform-as-a-Service (PaaS) solutions....

Praful Jangid | Feb 3, 2025

Returning to Optimizely After Many Years

Returning to Optimizely After Many Years: A Journey Through Its New Features After several years away from Optimizely’s Content Management … More

Jose Neto | Feb 2, 2025 | Syndicated blog