Data flow is terminated due to error .

SAP BODS  job is running till the end but at the last data flow failing with the below error:

Data flow is terminated due to error <70301>. 

Further error: Execution of <Regular Load Operations> 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 <OCIStmtExecute>: <ORA-14400: inserted partition key does not map to any partition

>.|<Regular Load Operations>|<CkS_F>

Advertisements

One thought on “Data flow is terminated due to error .

  1. the actual problem is that the partitio key value you are trying to insert is out of bounds. It is not an ETL issue. It is a data issue.
    “ORA-14400: inserted partition key does not map to any partition”. please give more details if you still have th eissue.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.