This workaround temporarily alleviates the symptoms, but the issue might return at any arbitrary time in the future.
Use the following query to determine if you have one or more invalid IP addresses in the
EPOComputerPropsStaging table:
select * from EPOComputerPropsStaging with (nolock)
where PropValue like '%:%' and PropValue like '%.%'
and (Propkey = 'IPAddress' or PropKey = 'IPv6')
If the query returns one or more results, use this query to remove the invalid entries, which allow the staging table to be purged:
delete from EPOComputerPropsStaging
where PropValue like '%:%' and PropValue like '%.%'
and (Propkey = 'IPAddress' or PropKey = 'IPv6')