Clone excludes attachments related to sa_uploaded_file table when "Exclude Attachments" is true, breaking Oracle/EC2 Discovery - Known Error

Clone excludes attachments related to sa_uploaded_file table when "Exclude Attachments" is true, breaking Oracle/EC2 Discovery Description Clone excludes attachments related to the sa_uploaded_file table when "Exclude Attachments" is true.

These records and attachments are code, used by Discovery, Service Mapping, and Software Asset Management.

Name Attachment Package Get EC2 Details getEC2Detailsv3.ps1 Pattern Designer Get Oracle CDB Oracle_CDB.sql Discovery and Service Mapping Patterns Get Oracle Instance Size Oracle_instance_size.sql Discovery and Service Mapping Patterns Get Oracle PDB Size get_pdb_size.sql Discovery and Service Mapping Patterns Get Oracle PDBS Oracle_PDBS.sql Discovery and Service Mapping Patterns Options Packs Usage Statistics SQL File options_packs_usage_statistics.sql Software Asset Management Professional for Oracle Oracle SW Validation Script db_queries_to_csv.sql Data Collection for Oracle Global Licensing and Advisory Services Oracle Unix HW Validation Script ct_cpuq.sh Data Collection for Oracle Global Licensing and Advisory Services Oracle Windows HW Validation Script ct_cpuq.cmd Data Collection for Oracle Global Licensing and Advisory Services Symptoms will include EC2 and Oracle Discovery failing.

Errors may be seen in the Discovery Pattern log, from steps such as "put Oracle options_packs_usage_statistics sql file", similar to:

2021-05-26 08:03:45: Error when trying to put file. Source file D:\servicenow\mid.novant.dev\agent\work\uploaded_files does not exist on the MID host At D:\servicenow\agent\scripts\PowerShell\WMICollector\WMIFileOperations.psm1:118 char:9 + throw "Source file $sourcePath does not exist on the MID host ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (Source file D:\...on the MID host:String) [], RuntimeException + FullyQualifiedErrorId : Source file D:\servicenow\agent\work\uploaded_files does not exist on the MID host or

2021-06-21 05:16:54: Failed to put file on the host, 10.x.x.x, through SSH connection due to the error: D:\MidServer\agent\work\uploaded_files (Access is denied). Failed to copy file into /tmp/.../ Steps to Reproduce

Install Discovery and Disco and Service Mapping Patterns to populate the sa_uploaded_file table. Trigger a normal clone with attachments related to "sa_uploaded_file" You will notice that attachments related to "sa_uploaded_file " are deleted. Actual Result : attachments related to sa_uploaded_file table are excluded.

Expected Result : clone to NOT exclude attachments related to sa_uploaded_file table per Dev discovery (CSTASK202907)

Workaround This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this article to be notified when more information becomes available.

Workaround is to set "Exclude Attachments" to false, when setting up the clone.

To repair the table to fix Discovery, export all the records from the sa_uploaded_file list as XML on the clone source instance, which automatically includes the attachments too, and import them to the target instance.