thread144-425622
Another reason for "Item does not pass validation test" error message to occur.
If your column size is bigger in database table but the corresponding column is shorter in your datawindow then this error appears. In my case the DB (ORacle) table column size was 6 characters with 4 characters + two spaces and datawindow had only size of 4 this error came up. I had to trim the column for trailing 2 spaces. Then it worked.
I am writing this as the trailing two spaces was little harder to find if you are new to PB
Another reason for "Item does not pass validation test" error message to occur.
If your column size is bigger in database table but the corresponding column is shorter in your datawindow then this error appears. In my case the DB (ORacle) table column size was 6 characters with 4 characters + two spaces and datawindow had only size of 4 this error came up. I had to trim the column for trailing 2 spaces. Then it worked.
I am writing this as the trailing two spaces was little harder to find if you are new to PB