My Oracle Support Banner

OAC DataSync : Incremental Load Fails With Error " ANOMALY INFO::: Error while creating/altering tables. " (Doc ID 2524821.1)

Last updated on AUGUST 31, 2021

Applies to:

Oracle Analytics Cloud - Version 18.3.3 and later
Information in this document applies to any platform.

Symptoms

On Oracle Analytics Cloud, DataSync Version 2.5

Environment Details:-

   Oracle Analytics Cloud Data Sync (2.5), build: 12.0.0.0.0.20180607.1815

   Java version 1.8.0_161

   Source - Oracle Database

   Target - ADWC (Autonomous Data Warehouse - Oracle)

 

The following error appears while performing an incremental data load using DataSync. Whereas the full load works fine.

Error:-
ANOMALY INFO::: Error while creating/altering tables.
MESSAGE:::The table ORDERS_STATUS_HISTORY does not exist on connection. Table will be created only during an initial load or when the table is truncated. Check the connection information, create the table if necessary, and try again.
EXCEPTION CLASS::: com.oracle.dataflow.cloud.exceptions.CloudOperationException

Changes

 None

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.