Try our conversational search powered by Generative AI!

Daniel Halse
Jun 8, 2023
  1216
(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
From Procrastination to Proficiency: Navigating Your Journey to Web Experimentation Certification

Hey there, Optimizely enthusiasts!   Join me in celebrating a milestone – I'm officially a certified web experimentation expert! It's an exhilarati...

Silvio Pacitto | May 17, 2024

GPT-4o Now Available for Optimizely via the AI-Assistant plugin!

I am excited to announce that GPT-4o is now available for Optimizely users through the Epicweb AI-Assistant integration. This means you can leverag...

Luc Gosso (MVP) | May 17, 2024 | Syndicated blog

The downside of being too fast

Today when I was tracking down some changes, I came across this commit comment Who wrote this? Me, almost 5 years ago. I did have a chuckle in my...

Quan Mai | May 17, 2024 | Syndicated blog

Optimizely Forms: Safeguarding Your Data

With the rise of cyber threats and privacy concerns, safeguarding sensitive information has become a top priority for businesses across all...

K Khan | May 16, 2024

The Experimentation Process

This blog is part of the series -   Unlocking the Power of Experimentation: A Marketer's Insight. Welcome back, to another insightful journey into...

Holly Quilter | May 16, 2024

Azure AI Language – Sentiment Analysis in Optimizely CMS

In the following article, I showcase how sentiment analysis, which is part of the Azure AI Language service, can be used to detect the sentiment of...

Anil Patel | May 15, 2024 | Syndicated blog