Problem 1) The addition of hh:mi:ss to date so that now the date in the files looks like 2001-12-18 00:00:00 is not transparent to existing table definition. After I changed the date format of the copy statement that loads the data to ‘YYYYMMDD HH:MI:SS’ the load failed because the date field in the concept table does not hold time. I had to change the datatype in the Concept table to timeStamp.
Problem 2) There used to be a process that removed foreign characters from the vocabulary data. Is this no longer the case? I am seeing foreign characters in Public Database of Medications (Social-Sante), BDPM which is causing the load to fail.