Oracle Stage and Sequential File
Moderators: chulett, rschirm, roy
Oracle Stage and Sequential File
Here is a thing:
server job consists of a standard [Oracle OCI] stage as source and
[sequential file] as a target.
We face an Oracle 9i DB.
We select rows from a source and need to write this to the
target (a sequential file). No [Transformer] stage is involved.
We can view data through the source stage, but when we run
the job, the target file is created(on a client PC) empty and not even one row goes to the target.
But the most interesting thing that errors looks like this:
Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Sequential_File_1.IDENT1
For [sequential] stage we tried to use :
[x]Overwrite or [x]Append options,
but the result is the same
Any ideas?
server job consists of a standard [Oracle OCI] stage as source and
[sequential file] as a target.
We face an Oracle 9i DB.
We select rows from a source and need to write this to the
target (a sequential file). No [Transformer] stage is involved.
We can view data through the source stage, but when we run
the job, the target file is created(on a client PC) empty and not even one row goes to the target.
But the most interesting thing that errors looks like this:
Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Sequential_File_1.IDENT1
For [sequential] stage we tried to use :
[x]Overwrite or [x]Append options,
but the result is the same
Any ideas?
We added a [Transformer] and the error changed to :
"Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7"
According to my observation, i think the problem with
[Oracle]-stage, but don't know what is wrong with it?
We used [Oracle OCI] stage everytime, and it was NOT
any problem.
Any thoughts?
"Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7"
According to my observation, i think the problem with
[Oracle]-stage, but don't know what is wrong with it?
We used [Oracle OCI] stage everytime, and it was NOT
any problem.
Any thoughts?
What's the error or warning before this error?
Mike3000 wrote:We added a [Transformer] and the error changed to :
"Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7"
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
This is a message after the reset:
From previous run
DataStage Job 98 Phantom 5020
Program "JOB.1427108223.DT.1437338697.TRANS1": Line 43, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7
Program "DSP.Close": Line 87, Exception raised in GCI subroutine:
Access violation.
As of SQL statement, it's a simple one (without errors), because
using DS [View data] in this stage i can see the selected rows
properly.
From previous run
DataStage Job 98 Phantom 5020
Program "JOB.1427108223.DT.1437338697.TRANS1": Line 43, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7
Program "DSP.Close": Line 87, Exception raised in GCI subroutine:
Access violation.
As of SQL statement, it's a simple one (without errors), because
using DS [View data] in this stage i can see the selected rows
properly.
-
- Participant
- Posts: 40
- Joined: Sun Jan 21, 2007 1:52 pm
- Location: Chennai
- Contact:
Hi,Mike3000 wrote:This is a message after the reset:
From previous run
DataStage Job 98 Phantom 5020
Program "JOB.1427108223.DT.1437338697.TRANS1": Line 43, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7
Program "DSP.Close": Line 87, Exception raised in GCI subroutine:
Access violation.
As of SQL statement, it's a simple one (without errors), because
using DS [View data] in this stage i can see the selected rows
properly.
I would like to provide with some inputs.
I have faced a similar kind of ABORT, not exactly similar though..
When i enquired PHANTOM errors are errors which Datastage doesnt know.. also i can see access violation error in the log provided. In this case there is problem with access to DB, may be the username/ password / schema doesnt match or reasons pertaining to that.
For the phantom error, what it seems to me is the DB has got locked somewhere and Datastage server is not able to access the DB. it is better to try out by restarting both the DB & DataStage server and again run the job.
Hope it works out..
thank you
Murugan R
-
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL
Instead of editing the previous(old) job,Try designing a new job and run.Mike3000 wrote:More details,
does it make any sense, that this type of error
could come up because the Oracle installation was done
from user=OracleUser(NOT from Administrator), but
DS Server was installed from Windows Administrator???
Any ideas?
Hope this might work.
Thanks,
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.