Oracle Analytics Cloud and Server

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

Data-Sync New/Updated files not moving to cloud

Received Response
21
Views
1
Comments

Summary

Load Strategy New/Update not moving new / changed files

Content

At 7 AM this morning my job ran. My load Strategy is set to (Update Table - Add New - Update existing). My filter is V_Last_Update_DT. 
Zero records were copied up to the cloud. 

(select to_char(max(last_update_dt), 'mon-dd-yyyy hh:mm:ss') dt ,count(*) ct ) 
PSOFT DB: dt " apr-16-2019 12:04:00" ct"1531193" 
OAC DB: dt"apr-16-2019 12:04:00" ct"1525021" 
No records were moved

Version

2.5

Answers

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

    Files are not read incrementally.  All the files in the specified location are read.  You should purge the old files and just keep the new ones for the loading.  You can set "Delete source file(s) upon successful load (true/false)" to true for automatically delete files.  Its possible that the new ones were loaded first and then the older ones - which may have caused some issue.

    You may want to uptake the 2.6 version, which has some bug fixes.