ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

table stream_eligible_attrs is missing value for reference


Article ID: 227862


Updated On:


CA Service Management - Service Desk Manager CA Service Desk Manager


During a run of the post install steps for CA Service desk patch  (pdm_load of file r17_3_10_insert.dat), seeing the below error for the latest patch



The error is due to the r17_3_10_insert.dat file being used to update the mobile_attribute_usage column that was introduced into the stream_eligible_attrs table.  The load file contains 62 such entries.  However, the affected stream_eligible_attrs table contains only 36 rows; this table contains 62 rows in a 17.3 GA environment to present.  There are 26 rows missing, which is the same number of times this message appears in the RU install logs:
2021/10/27 DEBUG [DeployThread: Running Post Installation steps for CA Service Desk Manager Update(s) :] [CommonProcessUtilities] ERROR: error 8 on update: Table stream_eligible_attrs is missing value for reference


Release : 17.3 RU10 and higher



Check for the same stream_eligible_attrs table in any other instances in place, including a prod instance. 
The corrective action would be to import this table from a working instance of Service Desk.