CI restore script fails

[diger74]

Brief bug description

Running Restore-CI.ps1 script fails with the following exception (also see a full log file attached):

Object type Content folder: updating Authors
Message: Restoration of object type "Content folder" failed during objects' insertion and update. See inner exception for further details.

Exception type: CMS.ContinuousIntegration.ObjectTypeSerializationException
Stack trace: 
   at CMS.ContinuousIntegration.Internal.FileSystemRestoreJobBase.TryRun(Action`2 method, String objectType, String exceptionMessageFormat, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.FileSystemRestoreAllJob.<>c__DisplayClass2_0.<CreateAndUpsertObjects>b__0(String objectType)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemJob.<>c__DisplayClass38_0`1.<CancellableForEach>b__0(T item, Int32 _)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemJob.CancellableForEach[T](IEnumerable`1 collection, Action`2 action, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemJob.CancellableForEach[T](IEnumerable`1 collection, Action`1 action, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.FileSystemRestoreAllJob.CreateAndUpsertObjects(IEnumerable`1 orderedObjectTypes, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.FileSystemRestoreAllJob.RunInternal(CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemAllJob.Run(Nullable`1 cancellationToken)

Message: Restoration of object type "Content folder" (cms.contentfolder) failed for object "Authors" (ContentFolderID: 2). See inner exception for further details.

Exception type: CMS.ContinuousIntegration.ObjectTypeSerializationException
Stack trace: 
   at CMS.ContinuousIntegration.Internal.FileSystemChangedObjectsByTypeJobBase.ProcessChangedObject(DeserializedObject deserializedObject, String logMessageFormat)
   at CMS.ContinuousIntegration.Internal.FileSystemChangedObjectsByTypeJobBase.<>c__DisplayClass16_0.<ProcessChangedObjects>b__0(DeserializedObject deserializedObject)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemJob.<>c__DisplayClass38_0`1.<CancellableForEach>b__0(T item, Int32 _)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemJob.CancellableForEach[T](IEnumerable`1 collection, Action`2 action, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemJob.CancellableForEach[T](IEnumerable`1 collection, Action`1 action, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.FileSystemChangedObjectsByTypeJobBase.ProcessChangedObjects(String objectType, IEnumerable`1 objects, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.FileSystemUpsertObjectsByTypeJob.RunInternal(String objectType, ISet`1 fileLocations, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.AbstractFileSystemTypeWideJob.Run(String objectType, ISet`1 fileLocations, Nullable`1 cancellationToken)
   at CMS.ContinuousIntegration.Internal.FileSystemRestoreObjectsByTypeInternalJob.RunUpsertObjectsByTypeJob()
   at CMS.ContinuousIntegration.Internal.FileSystemRestoreAllJob.CreateAndUpsert(String objectType, CancellationToken cancellationToken)
   at CMS.ContinuousIntegration.Internal.FileSystemRestoreJobBase.TryRun(Action`2 method, String objectType, String exceptionMessageFormat, CancellationToken cancellationToken)

Message: 
[DataConnection.HandleError]: 

Query: 
UPDATE CMS_ContentFolder SET [ContentFolderCreatedWhen] = @ContentFolderCreatedWhen, [ContentFolderModifiedWhen] = @ContentFolderModifiedWhen, [ContentFolderWorkspaceID] = @ContentFolderWorkspaceID
WHERE [ContentFolderID] = @ContentFolderID

Caused exception: 
Cannot insert the value NULL into column 'ContentFolderWorkspaceID', table 'Kentico.Community.dbo.CMS_ContentFolder'; column does not allow nulls. UPDATE fails.
The statement has been terminated.

ci_restore.log

Repro steps

1. Restore database from backup Kentico.Community-30.0.0-2024-12-12.bak
2. Adjust connection strings (if needed)
3. Build solution and run Restore-CI.ps1 script

Expected behavior

CI restore completes with no errors.