I created a simple test job to test a simple transformation.
I have defined two db connections as generic jdbc using two different Oracle 11 dbs.
I can connect to the job pull up two identical tables on each db.
The job will just move data from table A on db1 to table B on db2.
I define the job fine and use automap to map the columns of table A to table B. The columns are defined and named the same.
I run the job with no data in table A or table B and it runs in a few milliseconds.
I populate table A with 10000 rows and I run the job.
I get an ORA-00928: missing SELECT keyword in the execution log window.
No rows move.
Any ideas or is this another bug with 3.1?
I get the same error on every row not just the six row.
I get the same error on a larger table as well.
The sql for the larger table is shown above and I picked a smaller table for the screenshots.
There are no special characters in the data - I just killed the job after the sixth row.
