After updating to Cireson portal to 11.6.3 we get this error with the Cache Builder.
MichaelGustavsson
Member IT Monkey ✭
We get this error when running the cireson cachebuilder after updating the free community self-service portal.
System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'spList_ObjectsToUpdate'.
Error Number:2812,State:1,Class:16
2022-09-26 15:57:33,954, ERROR [ 7]: Unable to sync WORK ITEMS, the operation failed permanently. Please review the log for errors, correct them, then restart the cachebuilder service.
Unable to find the spList_ObjectsToUpdate in database, even after installing a new database.
See attached file for log.
Best regards
Michael Gustavsson
0
Answers
@MichaelGustavsson - I wonder if something got missed on the update? Did you try installing the portal again?
@Justin_Workman Yes, we tried to reinstall the portal. We reinstalled the portal with a new database and still we got the same error.
Best regards
Michael Gustavsson
Dear All, we have similar errors in CacheBuilder logs after upgrading to 11.6.3 with SCSM 2019 CU4. For some reason the work items are not fully in sync in the portal. For example, when I submit an SR, the status keep showing New even though it is In Progress in SCSM and in detailed view in the Portal. I tried reinstalling the portal several times but the issue persists. I did not enable Analytics during installation. Only after manually restarting the CacheBuilder service, then the WIs are correctly showing on the portal. Any suggestions please?
Is there an update on this, as we get the same error?
Do you guys only get this one in the free community version?
Because in our Service Management Portal (not the community version) we noticed performance downgrades since we updated to 11.6.3 - Longer saving times, longer times to open work and/or config items, somertimes it is just when we navigate from one page to the other(dashboards or just the home page). Happens randomly during the day, so I am wondering if you guys experience that as well.
Yes, it is only affecting the community edition.
At Customers with a License and the same Version, no issues.
Any news here?
Seems that this stored procedure is not needed for the paid version - did not find it there.
That SP only gets checked if the Archiver is turned on. In Admin Settings/Setting Items, you can set EnableCiresonAnalyticsArchive to false and those errors should stop.
The Archiver is set to false in our case.
So now it seems to be working.
not sure what helped, but it works at least now.
In case you want to create the procedure:
CREATE PROCEDURE [dbo].[spList_ObjectsToUpdate]
AS
Select * from sys.tables
where name = 'dfghjskgl'
GO
Originally the Sp should have a parameter called ObjectList