RSS
 

Posts Tagged ‘rejected rows’

Informatica: Target table does not allow INSERT/UPDATE/DELETE

12 Oct

Rows are rejected and in the log detail, error message is;

WRT_8119 Target table [TARGET_TABLE_NAME] does not allow INSERT Row # in bad file
or
WRT_8119 Target table [TARGET_TABLE_NAME] does not allow UPDATE Row # in bad file
or
WRT_8119 Target table [TARGET_TABLE_NAME] does not allow DELETE Row # in bad file

I recommend to change “Treat source rows as” attribute to “Data driven”

This error occurs because of the incoordinate between “Treat source rows as” and target table’s relational writer properties

When Insert is selected, but Update is selected at “Treat source rows as” property, it will get the error;

WRT_8119 Target table [TARGET_TABLE_NAME] does not allow UPDATE Row # in bad file

Social Share Toolbar
 
No Comments

Posted in English, Informatica

 

Task is Succeeded but no Applied Rows

30 Jun

I faced an interesting issue in Informatica yesterday.

There is no error on the Monitor screen, but when I list the details of the “Succeeded” task, I saw:

Applied Rows = 0

Rejected Rows = 261733 (required to be applied rows number)

Last Error Code = 8425

Last Error Message = ERROR: Writer execution failed. Database error: [0]… bula bula bula

Actually, I do not interest with the error. I am confused because however there is an error, on the monitor screen task’s status is Succeeded!

What about the solution?

We want task to stop when any errors occured. So we have to follow and change:

Edit Tasks -> Config Object -> Error handling / Stop on errors = 1 (default value is 0)

As you can see below;

Or alternatively, we can add a Control with Expression “TgtFailedRows > 0″ as you can see in the figures below;

Social Share Toolbar
 
No Comments

Posted in English, Informatica