Job Parallel over a new schema Oracle
Posted: 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!
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!