After reading the log file you shared, it seems like one of the “sub-select” statements is returning more than one row when we are expecting only one. Having more than one row could be a data issue.
As we are inserting one value for each column, we must have one unique value (from the “sub-select”) per column.
You can see all the “sub-select” statements that I could isolate from the log in the file attached.
Do you think you or someone in your team would be able to identify which of those “sub-select” queries are returning two (or more) or rows? This will help to narrow the problem.
Thanks,
Maikel
sub-selects.pdf (29.1 KB)