Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
51
Views
3
Comments
Brian666H
Brian666H Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

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)

Tagged:

Answers

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    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.

     

  • Brian666H
    Brian666H Rank 6 - Analytics & AI Lead

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

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    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