My Oracle Support Banner

Error During Download Of HMT Sanction Lists in EDQ/OWS - Jobs Fail With Errors 404 (URL not found) And 301 (URL moved permanently) or Error accessing external table (Doc ID 1563579.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Watchlist Screening - Version 8.1.1 and later
Information in this document applies to any platform.
 

Symptoms

HM-Treasury Sanction list data failed to be downloaded.

Overnight screening jobs fail with the following Exceptions:

"404 (URL not found) and 301 (URL moved permanently)."

"SEVERE: DD-MM-YYYY HH:MM:SS: Error accessing external table: Unknown column "Name 6" in query for text file "[PATH]\Datanomic\dnDirector\config\landingarea\HMT\sanctionsconlist.csv" (Code: 2,085) (Code: 203,073)"

 

 

Changes

 The third party Sanctions list downloadable from HM-Treasury has changed URL link

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.