AnsweredAssumed Answered

ODBC import's partial data

Question asked by PaulWebb_1 on Oct 1, 2013
Latest reply on Oct 1, 2013 by PaulWebb_1

Title

ODBC import's partial data

Post

          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