Job Parallel over a new schema Oracle

huge10 · Post by **huge10** » Tue May 27, 2014 7:15 am

Hi,
what I've noted about my Job is incredible.

I have a Job Parallel that works good over an old schema Oracle.
I tried to create a new schema over the same database instance, with the same tables, but when I try to execute my Job pointing it ... this error is generated:

"main_program: Requirements Failure: Field not found: ROW_ID"

The field ROW_ID is the result of the first stage of the Job.
Could you help me to understand what's could be the problem?

I tried to connect to the database instance with the credential of old schema and use <<"schema name"."table name">> for pointing to the new schema; in this way the Job go OK!

chulett · Post by **chulett** » Tue May 27, 2014 7:21 am

Okay... can you detail for us how this "first stage" is retrieving the field called "ROW_ID"? It sounds like it simply doesn't exist in the table in this new schema you created, have you verified that it does? Did you not get any kind of ORA error as well?

I thought at first you meant the pseudocolumn ROWID but that does not have the underscore in it.

huge10 · Post by **huge10** » Fri Jun 13, 2014 8:06 am

Yes.. ROW_ID was a specific field, not ROWID.
Thanks for your answer.
Actually I've found the problem!

The new oracle schema didn't have grant to query the Oracle dictionary, so Datastage couldn't check the structure of the table.

I suppose the error was over the field ROW_ID because it's the first field, but I would have had the same error over any other field.

chulett · Post by **chulett** » Fri Jun 13, 2014 8:38 am

Glad you found it. And yes, it can be frustrating when there are multiple problems and all you are alerted to is the first one.