Pivot job aborted with errors

sravanthi · Post by **sravanthi** » Wed May 18, 2011 11:59 am

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!

chulett · Post by **chulett** » Wed May 18, 2011 5:27 pm

Reset the aborted job and let us know the contents of the "From previous run..." log message if it shows up.

sravanthi · Post by **sravanthi** » Thu May 19, 2011 8:54 am

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.

chulett · Post by **chulett** » Thu May 19, 2011 9:22 am

So... in other words... one didn't show up.

DSguru2B · Post by **DSguru2B** » Thu May 19, 2011 9:29 am

Dump the hashed file into a text file and pivot that. See if the error persists.

sravanthi · Post by **sravanthi** » Thu May 19, 2011 10:42 am

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|

sravanthi · Post by **sravanthi** » Fri May 20, 2011 8:36 am

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.