Helped a SysAdmin today troubleshoot an issue that was driving them crazy. distmgr.log in their environment was throwing a "Thread_ProcessDPActions() failed with error code - 0x80004005" error constantly, preceded by and entry that stated "Failed to find DP properties for DP with ID - ". I tried a couple different things here, so including them all in case it helps someone, but feel free to skip to the end as the fix was really very simple.

At first, I thought it may be a stuck database entry somewhere that was never cleaned up, so I ran the following query in order to try and find which tables and views had the DPID column name present:

SELECT COLUMN_NAME AS 'ColumnName'
,TABLE_NAME AS 'TableName'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE 'DPID%'
ORDER BY TableName
,ColumnName;

Then, using the output list, I ran each table and view name returned inside the following query:

SELECT * FROM [] WHERE DPID = order by DPID

Since this returned nothing, I decided to check the distmgr.box inbox, and there it was, a XXX.CF4 file where XXX matched the number of the DP that could not be found in the error.

Simply deleting this file stopped the error from occurring, and from constantly using the first available distribution thread in the environment.