ODBC import's partial data
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.
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...