Skip to main content
Solved

MDM Data Load

  • September 4, 2024
  • 8 replies
  • 65 views

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

 

Best answer by AKislyakov

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

 

View original
Did this topic help you find an answer to your question?

8 replies

Forum|alt.badge.img+2
  • Ataccamer
  • 27 replies
  • September 4, 2024

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.


  • Author
  • Data Pioneer
  • 5 replies
  • September 4, 2024

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.


Forum|alt.badge.img+2
  • Ataccamer
  • 146 replies
  • September 5, 2024

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


  • Author
  • Data Pioneer
  • 5 replies
  • September 5, 2024

@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 !!


Forum|alt.badge.img+2
  • Ataccamer
  • 146 replies
  • Answer
  • September 5, 2024

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

 


  • Author
  • Data Pioneer
  • 5 replies
  • September 5, 2024

@AKislyakov Attached the error log


Forum|alt.badge.img+2
  • Ataccamer
  • 146 replies
  • September 5, 2024

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

 

 


  • Author
  • Data Pioneer
  • 5 replies
  • September 5, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings