I believe you're on the wrong track, and have encountered a timing issue when there were no licences available for the compiler, but attributed that to your constraint. Search the forum for other instances of "no license available".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I got a similar error in a job a month or so ago, but I was giving some complex conditions on the constraint. When I broke up those and saved them to stage variables it was working.
One more question, are you using Nullhandling functions along with trim?
I am also curious to know what is happening and what goes wrong, may be the experts can pitch in and help us...
I ran it dozen times but the error occurs consistently. I ran twice after reading your post, the end result is same.
I will test the job in other box and let you know.
Ajith,
The constraint is simple. I even tested with 1=1. I have 90 columns in the transfomer which i trim the values and not much of null handling.
It is just an intuition but I get a strong feeling like it has to do something with trimming and null handling ... Check the columns where you do null handling along with trimming ...