Page 1 of 1
Pivot job aborted with errors
Posted: Wed May 18, 2011 11:59 am
by sravanthi
hi,
I have a server job which has
[hash]-->[transformer]--->[pivot]--->[file]
The job is aborting with
DataStage Job 1898 Phantom 6648
Access violation.
Attempting to Cleanup after ABORT was raised in stage testjob..Pivot_145
DataStage Phantom Aborting with @ABORT.CODE = 3
There are no other messages...
I'm unable to fix this..Please advice!
Posted: Wed May 18, 2011 5:27 pm
by chulett
Reset the aborted job and let us know the contents of the "From previous run..." log message if it shows up.
Posted: Thu May 19, 2011 8:54 am
by sravanthi
chulett wrote:Reset the aborted job and let us know the contents of the "From previous run..." log message if it shows up. ...
Resetting Job pivotjob.
Resetting stage pivotjob..Transformer_117.
pivotjob..ValidateFile.ValidateFile: Write link private caching enabled, cache size (128MB)
pivotjob..Hashed_File_157.DSLink156: Write caching disabled
Finished Resetting stage pivotjob..Transformer_117.
Resetting stage pivotjob..Pivot_145.
Finished Resetting stage pivotjob..Pivot_145.
Job pivotjob has been reset.
Posted: Thu May 19, 2011 9:22 am
by chulett
So... in other words... one didn't show up.
Posted: Thu May 19, 2011 9:29 am
by DSguru2B
Dump the hashed file into a text file and pivot that. See if the error persists.
Posted: Thu May 19, 2011 10:42 am
by sravanthi
DSguru2B wrote:Dump the hashed file into a text file and pivot that. See if the error persists. ...
i have tried this option too..but got
Arithmetic overflow
|-100|
Posted: Fri May 20, 2011 8:36 am
by sravanthi
My problem got resolved after changing all my columns to same data type and length for pivot stage.
Not sure whether this is correct solution but it worked for me.