ERROR: Error in parsing of sql - null

[uuliver]

MY TRIGGER IS BELOW:

FOR EACH ROW

BEGIN ATOMIC

IF (CHANGING.ORG_ID)

BEGIN

UPDATE JD_A1.CD_WELL SET JD_A1.CD_WELL.ORG_ID=NEW.ORG_ID;

END

END

what is this error means

[rareddy]

Post the whole exception.

[uuliver]

Error in parsing of sql - null  is whole exception.the designer is always have this error,i don't know how to Solve the problem

[rareddy]

In Designer, in the bottom you will see a panel for "error messages" or "Problems" in there you will see the log messages and their stack trace along with why and where the error is occurring, that is what I need to further analyze above problem. Just posting same in bold does not help anymore unfortunately

[shiloh.jordan]

I noticed that when I copy and paste my SQL into Notepad++, I get this error.

I will copy and paste into "Notepad" and the error will resolve.

[rareddy]

I remember this error from before, it seems like when you cut and paste there are some invisible control characters get copied thus the issue. May one of tooling team members ( blafond ) can explain exactly what is going on and if there are any issues logged on this.

[shiloh.jordan]

Yes, I agree with you Ramesh.  If I copy and paste my SQL into Notepad, it removes all invisible control characters.  I then copy from Notepad and paste into my Transformation Editor, and issue will resolve.

[blafond]

That issue has been logged and is a known issue.  Have spent time trying to isolate and fix, however, Eclipse SWT UI layer is difficult to interpret as it supports multiple OS's and Windows seems to always have the most complex/custom behavior.

[TEIIDDES-2868] texttable parsing error - JBoss Issue Tracker

[TEIIDDES-2782] Copy paste sql to the transformation editor is not parsable - JBoss Issue Tracker

[uuliver]

It Worked. Thank you for all help