DS Routine issue - Job aborting

[Kriskanth]

Hi,

I have created a routine in Datastage, basically a transform function type.It is compiled and tested properly; but, when i am using in transformer stage the job is getting aborted without proper information in the log.fyi, i have tested the routine by creating a direct input file to output file transformation with transformer stage in between.

I am not sure whether there are any limitations on 8x server jobs for using routines inside the expression or stage variables section in transformer stages. Please help...

Log info:

DataStage Job 1107 Phantom 28708
The locks necessary for database operations at the current isolation
level (0) are not held by this process.
Rolling back uncommitted transactions begun within this execution environment.
Attempting to Cleanup after ABORT was raised in stage PAR003_CONDITION_STG_To_ALG_SRV2..Transformer_67
DataStage Phantom Aborting with @ABORT.CODE = 3

[kduke]

Sounds like you either have a transaction size too big or READU in your routine. You have too many records locked.

[ray.wurlod]

Or you're trying naughtily to WRITE to a record for which you're not the lock owner.

[chulett]

Worst case you could always post your routine for us to examine and offer opinions on.