Problem identified - the "¿¿" in the Oracle table represent "££" determined by a character set. However there are also records with "??". When both of these records types are used as database input, Monarch "sees" and represents both of these as "??", thereby producing duplicates. When attempting to "hook up" external lookups the database attempts to links "??" and "¿¿" causing I assume the internal error message. The issue can only be resolved before the oracle tables are populated. This will be done in cleansing spreadsheets to remove the "££" with other non-used characters because it is too late to attempt to fix the content of the oracle tables after they are populated. I should also point out that although oracle tables show "¿¿" and monarch shows "??" that the ascii code in oracle is for £. Is there anyway to see the ascii code in monarch?
Messy problem, messy fix.
Anyone experience anything similar?