Skip to main content

Hi,I am getting this error while running the Load Operation for full load for one of the source system.Any help ,highly appreciated.

 

Hi! Are you using a JDBC reader by any chance to take in the initial data for the load plan? If so, it's possible that the key on the table has a different name than ‘id’, but you are calling for a key named ‘id’ so the load plan can't find that on the database table.


Yes,we tried using JDBC reader as well as File Reader,in both case getting this same error.the column names in table has a ‘id’ column and we are unable to alter the table defination in postgre sql.


Hi @debashishghosh 
Do you by chance trying to copy value of id column via a relationship?


@AKislyakov  No, we are not trying to copy the ‘id’ column in any of the relationships used.

 

Any specific advanced settings that we need to check? before load operation or any other suggestion, most welcome. Thanks !!


This is very suspicious, the error relates to a CopyColumn action
 


Can you check which step failed? Usually it is the one, that has value in the Started column, but no value in the Finished.
In following example, it is the Match(contact) that failed

 


@AKislyakov Attached the error log


There is a link between party and party_rel tables. It should have some CopyColumns configuration

 

 


Thanks @AKislyakov :-you are right ,we had a column linking done wrong, in party to party_rel entity relationship which was causing the issue.Now it worked. 


Reply