Data flow is terminated due to error <70301>.

dataservices job design
1

HI

My job is running till the end but at the last data flow: ia m getting this error: Data flow is terminated due to error <70301>.

The data flow one source table and one target table with query transform and a lookup for one field.

all help is appreciated.

Further error: Execution of for target <CKS_F> failed. Possible causes: (1) Error in the SQL syntax; (2) Database

connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore

has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load

operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.

Oracle <> error message for operation : <ORA-14400: inserted partition key does not map to any partition

.||<CkS_F>

Thanks

sam1984 (BOB member since 2014-06-17)

2

Hi Sam,
What is the Target database? If the it is SQL Server,truncate the transaction log files for all the databases.

Check the SAP BODS application installed drive if it is full.

Hope it will help.

Arjun (BOB member since 2008-07-28)

3

Hi Arjun,

The target table is in Oracle.

sam1984 (BOB member since 2014-06-17)

4

Then please truncate temp files and transaction files in your oracle database. It will works.

Arjun (BOB member since 2008-07-28)

5

This is a data/DDL problem. You are using partitioned tables in Oracle. The partitioning method allows for only a specific set of key values to fit into the partitions. For example you could partition a table based on state abbreviation: AL, AR, AK, etc. You tried to put in a state abbreviation “XX” that doesn’t fit. So Oracle tells you to get lost.

Either you have bad data or the DBA needs to add to the partitioning to support the data you have.

eganjp :us: (BOB member since 2007-09-12)