'SAM - Apply latest content changes' job is failing with the error: "SAM - Apply latest content changes job aborted as CDS pull has not happened for all tables" - Support and Troubleshooting

'SAM - Apply latest content changes' job is failing with the error: "SAM - Apply latest content changes job aborted as CDS pull has not happened for all tables" Issue ☞ ' SAM - Apply latest content changes ' job is failing with the error: " SAM - Apply latest content changes job aborted as CDS pull has not happened for all tables " when the last_updated_on field is empty in the [cds_client_schedule] table and there's no data to download.

☞ Try manually executing the Download Software Content job, but the 'Last updated on' column could be still EMPTY.

☞ And we do see a few pieces of information in the system logs for this execution: Endpoint is : https://sncdataservices.service-now.com/api/now/table/sam_server_ibm_pvu_map?sysparm_fields=cpu_name_condition%2Ccpu_count_condition%2Cmodel_id_condition%2Cshort_desc%2Cibm_pvus_per_core%2Cactive%2Ccontent_version%2Csys_id&sysparm_limit= Last Updated On: CanonicalRepo: Schedule Record Count: 1 for table: 15882816c5762010fa9b566ccb67c089 Attempting to download data from ibm_pvu_map No new data to download for client table: ibm_pvu_map from server table: sam_server_ibm_pvu_map Processed 0 for ibm_pvu_map

☞ The job 'Download Software Content: IBM PVU Map' tries to download data by calling this endpoint: https://sncdataservices.service-now.com/api/now/table/sam_server_ibm_pvu_map?sysparm_fields=cpu_name_condition%2Ccpu_count_condition%2Cmodel_id_condition%2Cshort_desc%2Cibm_pvus_per_core%2Cactive%2Ccontent_version%2Csys_id&sysparm_limit=5000&sysparm_offset=0 &sysparm_no_count=true

But there's no new data to download for the client table [ibm_pvu_map]. And since the count is 0, the [last_updated_on] is not updated.

Cause When the scheduled job 'SAM - Apply latest content changes' runs, it checks for the last_updated_on field for each of the records in the [cds_client_schedule] table. But that field is empty for table ibm_pvu_map and job 'Download Software Content: IBM PVU Map', so the system treats the instance as on-prem instance (cf. ContentUpdateAPI.isCDSPullCompleted method). Hence the job 'SAM - Apply latest content changes' is failing.

Refer to the screenshots:

Resolution [1] - Here's the code change in the script include 'CanonicalRepo' in the method handleTableDownload: https:// .service-now.com/nav_to.do?uri=sys_script_include.do?sys_id=8e685c1747a01200c17e19fbac9a7106

handleTableDownload: function(clientRegistryRecord, lastUpdatedOn) { var gr = clientRegistryRecord; gs.log("Attempting to download data from " + gr.getValue("table"));

var dataRowCount = this.downloadData(gr, lastUpdatedOn); if (dataRowCount === undefined) { gs.log("Error occured while downloading data for table: " + gr.getValue("table") + " from server table: " + gr.getValue("server_table")); } else { if (dataRowCount === 0) {

// ADDED begin if (gs.nil(lastUpdatedOn)) { this._updateSyncTime(gr.getValue("sys_id")); } // ADDED end

this.tracker.updateDetailMessage(gs.getMessage("No new data to download for table: " + gr.getValue("table"))); gs.log("No new data to download for client table: " + gr.getValue("table") + " from server table: " + gr.getValue("server_table")); ... }

[2] - Apply the changes to the script include and then run 'Download Software Content: IBM PVU Map' which populates the last_updated_on, then ran 'SAM - Apply latest content changes'.

☞ Created a defect PRB1671162 that will update the last_updated_on field in the [cds_client_schedule] table when no data is retrieved and when that field is empty.