Warning in transformer

basu.ds · Post by **basu.ds** » Wed Feb 13, 2008 4:33 am

Can any one help me i got this warning what is cause for this
warning message:Attempting to Cleanup after ABORT raised in stage testsummary..Transformer_1
i am trying to load the data from oracle stage to seq file.

ArndW · Post by **ArndW** » Wed Feb 13, 2008 4:42 am

Reset your job in the Director and there should be a new log entry titled "From Previous Run..."; look at that entry to see the actual problem.

basu.ds · Post by **basu.ds** » Wed Feb 13, 2008 4:48 am

andrew can you help in details because only warning message is there in log

ray.wurlod · Post by **ray.wurlod** » Wed Feb 13, 2008 4:57 am

Have you reset the job? (This is done in Director - it is not recompiling. If you have recompiled you have lost the evidence, and will need to re-run the job to reproduce the problem, then reset the job.) After you have reset the job there will probably be an Informational message in the log, with subject "From previous run...".

basu.ds · Post by **basu.ds** » Wed Feb 13, 2008 5:02 am

yes ray i was reset the job this is the log can you help me

From previous run
DataStage Job 2311 Phantom 9340
Program "JOB.1396960201.DT.1465440079.TRANS1": Line 107, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage testsummary..Transformer_17
Program "DSP.Close": Line 87, Exception raised in GCI subroutine:
Access violation.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 13, 2008 5:09 am

Look in RT_BP2311/JOB.1396960201.DT.1465440079.TRANS1 and check the code either side of line number 107 to see what might have happened. In particular look for a reference to a subroutine whose name begins with "$".

asitagrawal · Post by **asitagrawal** » Wed Feb 13, 2008 5:11 am

waht is happening inside the transformer ? it would be better, if you share what the job is doing (you can support with a diagram of the job) please..

basu.ds · Post by **basu.ds** » Wed Feb 13, 2008 5:15 am

oracle stage ---->Transformer------>Seqfile

in oracle stage i used user defined query.that is giving the data at source when ever i view through the view tab.

asitagrawal · Post by **asitagrawal** » Wed Feb 13, 2008 5:34 am

And , inside transformer ? What processing is happening on the data fetched, before being written to the seq file ?

basu.ds · Post by **basu.ds** » Wed Feb 13, 2008 5:44 am

nothing is happening simple one to one mapping

ArndW · Post by **ArndW** » Wed Feb 13, 2008 6:01 am

One to one mapping with no conversions and no stage variables or constraints will not generate the message you are getting. Try making a copy of the job and remove output columns until the error goes away to narrow down the cause.

asitagrawal · Post by **asitagrawal** » Wed Feb 13, 2008 6:25 am

Also, try running the job with a different input data set...

chulett · Post by **chulett** » Wed Feb 13, 2008 8:10 am

Any major problem will be reported as a failure of the Transformer as it is the active stage. I'd wager this is an issue with the 'user defined sql', possibly aggravated by their choice of Oracle Client version.

What exact version of the Oracle client are you using?

basu.ds · Post by **basu.ds** » Thu Feb 14, 2008 12:19 am

I am using Oracle9i query is
select
SUBMISSION_ID,
sum(REC_STATUS_R) REC_STATUS_R,
sum(REC_STATUS_L) REC_STATUS_L,
sum(REC_STATUS_G) REC_STATUS_G,
sum(REC_STATUS_P) REC_STATUS_P,
sum(REC_STATUS_N) REC_STATUS_N,
sum(REC_STATUS_E) REC_STATUS_E,
sum(REC_STATUS_H) REC_STATUS_H,
sum(REC_STATUS_I) REC_STATUS_I,
sum(REC_STATUS_J) REC_STATUS_J,
sum(REC_STATUS_M) REC_STATUS_M,
sum(REC_STATUS_T) REC_STATUS_T,
sum(TOTAL_ERROR_WEB),
TOTAL_ERROR_LCL,TOTAL_ERROR_GLB,
sum(OVERWRITTEN) REC_OVERWRITTEN,
sum(DELETED) REC_DELETED
FROM (SELECT SUBMISSION_ID,
COUNT(CASE WHEN RECORD_STATUS = 'R' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_R,
COUNT(CASE WHEN RECORD_STATUS = 'L' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_L,
COUNT(CASE WHEN RECORD_STATUS = 'G' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_G,
COUNT(CASE WHEN RECORD_STATUS = 'P' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_P,
COUNT(CASE WHEN RECORD_STATUS = 'N' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_N,
COUNT(CASE WHEN RECORD_STATUS = 'H' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_H,
COUNT(CASE WHEN RECORD_STATUS = 'I' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_I,
COUNT(CASE WHEN RECORD_STATUS = 'J' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_J,
COUNT(CASE WHEN RECORD_STATUS = 'M' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_M,
COUNT(CASE WHEN RECORD_STATUS = 'E' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_E,
COUNT(CASE WHEN RECORD_STATUS = 'T' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_T,
COUNT(CASE WHEN RECORD_STATUS = 'E' AND ERROR_IND=1 AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) TOTAL_ERROR_LCL,
COUNT(CASE WHEN RECORD_STATUS = 'E' AND ERROR_IND IS NULL AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) TOTAL_ERROR_GLB,
COUNT(CASE WHEN OVERWRITE_IND = 1 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) OVERWRITTEN ,
COUNT(CASE WHEN DELETE_INDICATOR =1 THEN RECORD_ID ELSE NULL END) DELETED ,0 TOTAL_ERROR_WEB
FROM WEB_LOCAL_EMPLOYEE_DATA WHERE
RECORD_STATUS IN ('R', 'L', 'G', 'P', 'N', 'E', 'H', 'I', 'J', 'M', 'T')
AND CREATED_ON BETWEEN (SYSDATE-180) AND (SYSDATE) GROUP BY SUBMISSION_ID
UNION
SELECT SUBMISSION_ID,
0,0,0,0,0,0,0,0,0,
COUNT(CASE WHEN RECORD_STATUS = 'E' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_E,
COUNT(CASE WHEN RECORD_STATUS = 'T' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) REC_STATUS_T,
0,0,
COUNT(CASE WHEN OVERWRITE_IND = 1 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) OVERWRITTEN ,
COUNT(CASE WHEN DELETE_INDICATOR =1 THEN RECORD_ID ELSE NULL END) DELETED ,
COUNT(CASE WHEN RECORD_STATUS = 'E' AND OVERWRITE_IND = 0 AND DELETE_INDICATOR =0 THEN RECORD_ID ELSE NULL END) TOTAL_ERROR_WEB
FROM WEB_LOCAL_EMPLOYEE_DATA_TEMP WHERE
RECORD_STATUS IN ('E', 'T')
AND CREATED_ON BETWEEN (SYSDATE-180) AND (SYSDATE) GROUP BY SUBMISSION_ID)
group by SUBMISSION_ID ,TOTAL_ERROR_LCL,TOTAL_ERROR_GLB

ray.wurlod · Post by **ray.wurlod** » Thu Feb 14, 2008 12:45 am

Look in RT_BP2311/JOB.1396960201.DT.1465440079.TRANS1 and check the code either side of line number 107 to see what might have happened. In particular look for a reference to a subroutine whose name begins with "$". (You may have overlooked this earlier.)