GitHub user gertwieland edited a discussion: Synchronize after merge: "Cannot insert null" into primary key
I'm getting this error message with the "Synchronize after merge" transform, it suggests that the primary key UID is empty. org.apache.hop.core.exception.HopDatabaseException: Error inserting/updating row Cannot insert the value NULL into column 'UID', table 'businesshub.dbo.Salaries_Research'; column does not allow nulls. INSERT fails. (1) in the screenshot. <img width="1075" alt="image" src="https://github.com/user-attachments/assets/e357eaf3-f5ea-4175-9376-a7d9145be2ac"; /> However, I explicitly put a filter that only passes non-empty UIDs, there are none at all. (2) in the screenshot. So the empty UID must be generated by the "Synchronize after merge" transform. I tried with "Use batch update" and "Perform Lookup" on and off, but same result. Here's a screenshot of the error message complaining that UID is null, but showing the value of the UID. <img width="944" alt="image" src="https://github.com/user-attachments/assets/efd859cb-2a0f-468d-b26f-25d25f8b44a9"; /> Am I doing something wrong here? It feels like a bug to me, to be honest. I'll replace it with a "switch case" solution, but I'd like to get it to work nonetheless. GitHub link: https://github.com/apache/hop/discussions/5444 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
