Hi everybody.
I've got a problem....
My simple job read from Oracle DB, use a transformer and writes to another one.
The dns, user and password in the two OCI are job parameter (the password is defined as encrypted).
The job runs perfectly, but when I try to run it from a sequence I've got the problems!
It seems that there is a comunication problem beetwen the sequence and the job related to the parameter values.
The sequence parameters are linked properly to the job parameters.
Messagges in the event log:
- ORA-00942: table or view does not exist
in the detail log of the job
- JobControl (fatal error from @Coordinator): Sequence job (restartable) will abort due to previous unrecoverable errors
in the detail log of the sequence
Thanks in advance,
Andrea
Sequence and ORA-00942: table or view does not exist
Moderators: chulett, rschirm, roy
Re: Sequence and ORA-00942: table or view does not exist
No, they're not or you wouldn't be having this issue. Double-check. Heck, triple-check. Both the 'linkage' and the values being passed.ponzio wrote:The sequence parameters are linked properly to the job parameters.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To verify parameters look in the "job starting" event in the job log to see the parameter values that were passed. If these are ALL ok, revisit the encryped parameters.
However, this is not your problem. You got an error code and message back from Oracle. Therefore you successfully connected to Oracle. The error is "table or view does not exist". Are you the table/view owner? If not, you will need to prefix the table/view name with the owner name (which can also be a job parameter reference).
However, this is not your problem. You got an error code and message back from Oracle. Therefore you successfully connected to Oracle. The error is "table or view does not exist". Are you the table/view owner? If not, you will need to prefix the table/view name with the owner name (which can also be a job parameter reference).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.