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 DECEMBER 02, 2016

Applies to:

Oracle Watchlist Screening - Version 8.1.1 and later
Information in this document applies to any platform.
Checked for relevance on 21-10-2013

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms