5 Replies Latest reply on Oct 1, 2013 12:10 PM by PaulWebb

    ODBC import's partial data

    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...