PaulWebb

Import is creating duplicates

Discussion created by PaulWebb on Jun 5, 2015
Latest reply on Jun 5, 2015 by disabled_jackrodgers

I have a script that imports from an ODBC source. Recently it has started creating duplicate records. To test I created a new script using only the Import Records step.

 

SQL:

SELECT * FROM "EPORTAL"."FORT_RMA_OVERALL" WHERE "FORT_RMA_OVERALL"."EP_UPDATE_DATE" >= sysdate - 20 AND "FORT_RMA_OVERALL"."PORTFOLIO_NUMBER" = 1234

 

It is setup to update matching records. I use the RMA Number field to match records as they are unique.

Screen Shot 2015-06-05 at 14.23.54.png

 

I also connected to the ODBC source with SQLDeveloper and I am NOT seeing duplicates. I have the field setup as a number and I thought is was setup as Text on the source side but just checking I see the data type is VARCHAR2(50). Not sure that has anything to do with it but I wanted to point it out.

 

The server is running FM 13 and I have also tested using FM 14 locally.

Outcomes