PaulWebb

ODBC import's partial data

Discussion created by PaulWebb on Oct 1, 2013
Latest reply on Oct 1, 2013 by PaulWebb

I have a one line script using the import script step. I am connecting to an Oracle DB with an ODBC. The query I am using is

SELECT FORT_SR.* FROM EPORTAL_ADM.FORT_SR

 

When running this script it is only importing data up to 2/8/2013. The import count down appears to see all records. Using excel I have verified that there is data up to today (1/1/2012 - present).

 

Using excel I can see that there are 61 records for 3/2/2013. I changed my query to

SELECT FORT_SR.* FROM EPORTAL_ADM.FORT_SR WHERE (FORT_SR.CREATE_DATE LIKE '2013-03-02%')

 

Again when running the script the import step counts down from 61 records but once complete there are no records. I created a new file and imported the SR table and the script. I ran the script and 61 records were imported.

 

I tried running recover and found no errors. After recovery was complete I tried the script again but no luck. I have not had any crashes on this file.

 

Running...

FMPro 12 Adv

FM Server 12 Adv

 

All testing was done on my local machine.

 

Looking for ideas as to what might be wrong.

Thanks for reading...

Outcomes