Return to Answer

This issue occurs when blob is missing from the blobs table for the media item. You can run below query to find those items from database.

1. To find missing blob for unversioned media, you can run below query:

select itemid FROM [dbo].[SharedFields] s left join [dbo].[Blobs] b on s.value = cast(b.BlobId as varchar(36)) where s.fieldid = '{40E50ED9-BA07-4702-992E-A912738D32DC}' and b.BlobId is null

where fieldid in above query contains the blob field id in the unversioned media template

2. To find missing blob for versioned media, you can run below query:

select itemid FROM [dbo].[VersionedFields] s left join [dbo].[Blobs] b on s.value = cast(b.BlobId as varchar(36)) where s.fieldid = '{DBBE7D99-1388-4357-BB34-AD71EDF18ED3}' and b.BlobId is null

where fieldid in above query contains the blob field id in the versioned media template

Once in the above query you get the item id against which you are getting the issue, then you can delete that from SharedFields or VersionedFields table depending on the media item.

Hope this helps!!!

This issue occurs when blob is missing from the blobs table for the media item. You can run below query to find those items from database.

1. To find missing blob for unversioned media, you can run below query:

select itemid
FROM [dbo].[SharedFields] s
left join [dbo].[Blobs] b on s.value = cast(b.BlobId as varchar(36))
where s.fieldid = '{40E50ED9-BA07-4702-992E-A912738D32DC}' and b.BlobId is null

where fieldid in above query contains the blob field id in the unversioned media template

2. To find missing blob for versioned media, you can run below query:

select itemid 
FROM [dbo].[VersionedFields] s 
left join [dbo].[Blobs] b on s.value = cast(b.BlobId as varchar(36))
where s.fieldid = '{DBBE7D99-1388-4357-BB34-AD71EDF18ED3}' and b.BlobId is null

where fieldid in above query contains the blob field id in the versioned media template

Once in the above query you get the item id against which you are getting the issue, then you can delete the row from SharedFields or VersionedFields table.

Hope this helps!!!

This issue occurs when blob is missing from the blobs table for the media item. You can run below query to find those items from database.

1. To find missing blob for unversioned media, you can run below query:

select itemid FROM [dbo].[SharedFields] s left join [dbo].[Blobs] b on s.value = '{' + cast(b.BlobId as varchar(36)) + '}' where s.fieldid = '{40E50ED9-BA07-4702-992E-A912738D32DC}' and b.BlobId is null

where fieldid in above query contains the blob field id in the unversioned media template

2. To find missing blob for versioned media, you can run below query:

select itemid FROM [dbo].[VersionedFields] s left join [dbo].[Blobs] b on s.value = '{' + cast(b.BlobId as varchar(36)) + '}' where s.fieldid = '{DBBE7D99-1388-4357-BB34-AD71EDF18ED3}' and b.BlobId is null

where fieldid in above query contains the blob field id in the versioned media template

Once in the above query you get the item id against which you are getting the issue, then you can delete that from SharedFields or VersionedFields table depending on the media item.

Hope this helps!!!

This issue occurs when blob is missing from the blobs table for the media item. You can run below query to find those items from database.

1. To find missing blob for unversioned media, you can run below query:

select itemid FROM [dbo].[SharedFields] s left join [dbo].[Blobs] b on s.value = cast(b.BlobId as varchar(36)) where s.fieldid = '{40E50ED9-BA07-4702-992E-A912738D32DC}' and b.BlobId is null

where fieldid in above query contains the blob field id in the unversioned media template

2. To find missing blob for versioned media, you can run below query:

select itemid FROM [dbo].[VersionedFields] s left join [dbo].[Blobs] b on s.value = cast(b.BlobId as varchar(36)) where s.fieldid = '{DBBE7D99-1388-4357-BB34-AD71EDF18ED3}' and b.BlobId is null

where fieldid in above query contains the blob field id in the versioned media template

Once in the above query you get the item id against which you are getting the issue, then you can delete that from SharedFields or VersionedFields table depending on the media item.

Hope this helps!!!

This issue occurs when blob is missing from the blobs table for the media item. You can run below query to find those items from database.

1. To find missing blob for unversioned media, you can run below query:

select itemid FROM [dbo].[SharedFields] s left join [dbo].[Blobs] b on s.value = '{' + cast(b.BlobId as varchar(36)) + '}' where s.fieldid = '{40E50ED9-BA07-4702-992E-A912738D32DC}' and blobid is null

where fieldid in above query contains the blob field id in the unversioned media template

2. To find missing blob for versioned media, you can run below query:

select itemid FROM [dbo].[VersionedFields] s left join [dbo].[Blobs] b on s.value = '{' + cast(b.BlobId as varchar(36)) + '}' where s.fieldid = '{DBBE7D99-1388-4357-BB34-AD71EDF18ED3}' and blobid is null

where fieldid in above query contains the blob field id in the versioned media template

Once in the above query you get the item id against which you are getting the issue, then you can delete that from SharedFields or VersionedFields table depending on the media item.

Hope this helps!!!

This issue occurs when blob is missing from the blobs table for the media item. You can run below query to find those items from database.

1. To find missing blob for unversioned media, you can run below query:

select itemid FROM [dbo].[SharedFields] s left join [dbo].[Blobs] b on s.value = '{' + cast(b.BlobId as varchar(36)) + '}' where s.fieldid = '{40E50ED9-BA07-4702-992E-A912738D32DC}' and b.BlobId is null

where fieldid in above query contains the blob field id in the unversioned media template

2. To find missing blob for versioned media, you can run below query:

select itemid FROM [dbo].[VersionedFields] s left join [dbo].[Blobs] b on s.value = '{' + cast(b.BlobId as varchar(36)) + '}' where s.fieldid = '{DBBE7D99-1388-4357-BB34-AD71EDF18ED3}' and b.BlobId is null

where fieldid in above query contains the blob field id in the versioned media template

Once in the above query you get the item id against which you are getting the issue, then you can delete that from SharedFields or VersionedFields table depending on the media item.

Hope this helps!!!