Merge Error with ODI 11.1.1 and TD15.10

Tools & Utilities
Teradata Employee

Merge Error with ODI 11.1.1 and TD15.10

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?

 

Thanks

 

6 REPLIES
Enthusiast

Re: Merge Error with ODI 11.1.1 and TD15.10

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.

Tags (2)
Teradata Employee

Re: Merge Error with ODI 11.1.1 and TD15.10

Johannes,

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. 

Teradata Employee

Re: Merge Error with ODI 11.1.1 and TD15.10

Hi

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.

 

Johann

Enthusiast

Re: Merge Error with ODI 11.1.1 and TD15.10

Teradata lists 11.1.1.x as compatible with TTU 15.10 and TD 15.10.

 

Can't help further with this, sorry...

Teradata Employee

Re: Merge Error with ODI 11.1.1 and TD15.10

Teradata Employee

Re: Merge Error with ODI 11.1.1 and TD15.10

Did you try using the TD14.10 JDBC driver with ODI?  If so does it give the same error?