Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Brian Hall
    Data Sync Question Where do i see date-time stamp of the...Answered
    Topic posted May 1, 2019 by Brian HallSilver Medal: 2,000+ Points, last edited September 11, 2019, tagged Access & Manage Data, Home & Catalog 
    87 Views, 3 Comments
    Title:
    Data Sync Question Where do i see date-time stamp of the criteria / filter
    Summary:
    Need to see the filter criteria value of the filter
    Content:

    Data Sync Question

    Where do i see date-time stamp  of the criteria / filter

    Need to see the filter criteria value of the filter 

    Version:
    Oracle Analytics Cloud Data Sync (2.5)

    Best Comment

    Vijay Ranganathan

    Jobs->Runs->Tasks subtab.  Choose the row you are interested.  Click on details.  Choose the row that reads INSERT_UPDATE_DATACOPY.  Double click on Additional Info/Log.  There is a log file name published like so:

    D:\datasync\log\ReadFromOracle-Oracle12c.25944081\CR_AB_DATA_FROM_OCS-AB_OCS_TARGET.20190430.1020.log

    That log file will contain the filter criteria used.

     

    Comment

     

    • Vijay Ranganathan

      Jobs->Runs->Tasks subtab.  Choose the row you are interested.  Click on details.  Choose the row that reads INSERT_UPDATE_DATACOPY.  Double click on Additional Info/Log.  There is a log file name published like so:

      D:\datasync\log\ReadFromOracle-Oracle12c.25944081\CR_AB_DATA_FROM_OCS-AB_OCS_TARGET.20190430.1020.log

      That log file will contain the filter criteria used.

       

      • Brian Hall

        Thank You.  I can see my Prune time had no effect.  Do I need to select / click "Generate" after I select my Prune time?

        • Vijay Ranganathan

          You dont have to regenerate, this should be automatic runtime behavior.  I just tried it with 2.6.  It works.

          Sorry, I should have mentioned this before... Go to Views->System Properties.  Set the Server Log Level to FINEST.  Rerun the job.  This information is printed in the FINE log level.  Inspect the log file.  You should see the statements like below:

          378  FINE  2019-05-01 10:19:56.274 PST  Executing query :
          SELECT "SHIPTO_ADDR_KEY","OFFICE_KEY","EMPL_KEY","PROD_KEY","ORDER_KEY","UNITS","DISCNT_VALUE","BILL_MTH_KEY","BILL_QTR_KEY","BILL_DAY_DT","ORDER_DAY_DT","PAID_DAY_DT","DISCNT_RATE","ORDER_STATUS","CURRENCY" FROM "SAMP_REVENUE_F" WHERE 1=1 AND ("ORDER_DAY_DT" > ?)
          379  FINE  2019-05-01 10:20:04.594 PST  Bind parameters :
          Type: java.sql.Timestamp    Value: 2019-04-30 17:15:02.0