DSXchange

Hey forrest, I too hit the same error. The trailing space was indeed the culprit. Kudos!!!

@miwinter : I don't see a possiblity of that. This is a heavy duty production with large resources. These inserts are more over simple and low cost. Hence I don't think there is a contention. @Shamanth_vk : That is the challenge I am facing. I cannot modify the production job as it is protected. I c...

Yes. That's exactly what's happening. I have no way to replicate the same problem because it simply works when I try it again.

By Clean up I just delete the records that got loaded in the most recent run. As I said only 20-30% gets in and the remaining get silently rejected. So before rerunning I will delete the partial set of records to mainitain the data integrity. I too thought of Unique key violation as the cause. But n...

Hi All, We have job that loads data into a table on UPSERT mode. The Update SQL has been maked with a "1=0" condition in its where clause. The destination table has a single column as key and is the LD_SEQ_I. LD_SEQ_I is set as auto increment at a database level. Basically every record com...