BODS: Integrity constraint violation error with Table comparison in SAP Data Services

[itluca]

Dear All,

we have BODS 4.3 and we load data from Postgresql AWS source DB to Datasphere (we recently move the target from Hana on-premise to Datasphere). 

Some delta loads end in error with the classic message: Integrity constraint violation, but the incomprehensible thing is that between source and destination there is a table comparison step that compares, by key, all the columns of the table. Shouldn't the system automatically upsert the records?Nothing changes by selecting or deselecting the 'bulk load' flag. We have solved it with the autocorrect load flag but this slows down the data loading.

Do you have any idea about this issue?

Thanks and regards

Luca

[itluca · Accepted solution]

Dear All,

we have solved, it was an error in the dev. In the table comparison stp the comparison was done with a wrong table. For example, when loading the table 'person_data' into hana the comparison was made with the table 'person_data' of another datastore.

Regards

Luca