We have load processes using MERGE running in ODI 11.1.1 and TD 14.10, without any issues.
Newly we upgraded on TD15.10 (ODI remains 11.1.1). Since then the load processes always get the error:
"[TeraJDBC 15.10.00.33] [Error 5758] [SQLState HY000] The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specification primary index and partition column(s). "
Any idea? Anybody has the same or similar issue?
Hi Hyma, I doubt that it is related to the upgrade to 15.10.
Did the definition of the table change? PI, partitioning? With a MERGE statement the PI and the partitoning columns must be included in the MERGE statement.
Nothing changed (neither PI nor PPI). Starting the Merge with TTU15.10 (BTEQ, Studio,...) has no problem. Only with ODI11.1.1 we get this error.
We have exactlly the same problem. The odd thing is that in Query Log we see the merge query that doesn't work and if we copy that exact merge query out of Query Log and execute it directly in Studio or BTEQ it work without problems.
By the way, if you look at the compatability matrix of ODI 11 you will see that TD 15.10 is not there. You probably must update ODI 11 to ODI 12c aswell.
I meant the compatability matrix of Oracle: