Abnormal termination of stage

meet_deb85 · Post by **meet_deb85** » Mon Jul 18, 2011 1:02 am

Hi All,

I am facing this issue "Abnormal termination of stage" .I searched this site for fault ype 11. My job is simple sever job.

Source --> oracle --->Trans-->seq file.

After resetting the job -->
From previous run
DataStage Job 1458 Phantom 3229
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.WriteLog at address a3c.

I also searched for fault type 11.. But not much help.

If possible can any one help here ..

I have done this this similar type of problem i also faced last month.
only you need to do is clear your phantom file from adminstrator.
1.log on to adminstrator , select your project and click command option, then
"CLEAR.FILE &PH&" and execute this commasnd.
2.do the shmtest in datastage enginee bin folder like
"./shmtest". according to the test result update your uvconfig file.
3.must restart your datastage serve...no help still same error

meet_deb85 · Post by **meet_deb85** » Mon Jul 18, 2011 3:04 am

If any one has some time..can you help me on his issue ..

meet_deb85 · Post by **meet_deb85** » Mon Jul 18, 2011 5:32 am

Hi All,

I found the strange behav of this job..This is server job and i am ORAACI9 stage. this is reading a .sql file .( in .sql file there are 26 union all statemnet)

Once i am passing the SQL in source stage .it is working fine for 3 union all statement.
Working SQL:-
SELECT Distinct CAST('Manual' AS VARCHAR2(255)) AS DataOrManual,CAST ('H3G_NE_COUNTRY_UK' AS VARCHAR2(255)) AS SchemeCode,CAST ('SAL_REFERENCE_V' AS VARCHAR2(255)) AS SourceTable,CAST ('REFERENCE_TYPE_ID = 4100044' AS VARCHAR2(255)) AS WhereClause,CAST ('SV_UK' AS VARCHAR2(255)) AS SourceSystemId,CAST ('' AS VARCHAR2(255)) AS ClassificationId,CAST ('' AS VARCHAR2(255)) AS ClassificationSchemeId,CAST (REFERENCE_CODE AS VARCHAR2(255)) AS ClassificationCode,CAST (CODE_LABEL AS VARCHAR2(255)) AS ShortName,CAST (ABBREVIATION AS VARCHAR2(255)) AS ClassificationName,CAST (DESCRIPTION AS VARCHAR2(255)) AS Description,CAST ('' AS VARCHAR2(255)) AS EffectiveDate,CAST ('' AS VARCHAR2(255)) AS EndDate,CAST ('' AS VARCHAR2(255)) AS GroupClassificationId,CAST ('' AS VARCHAR2(255)) AS GroupClassificationScheme,CAST ('' AS VARCHAR2(255)) AS GroupClassificationCode
FROM SAL_REFERENCE_V
where REFERENCE_TYPE_ID = 4100044
UNION ALL
SELECT Distinct CAST('Manual' AS VARCHAR2(255)) AS DataOrManual,CAST ('H3G_NE_REC_CALLTYPE' AS VARCHAR2(255)) AS SchemeCode,CAST ('SAL_REFERENCE_V' AS VARCHAR2(255)) AS SourceTable,CAST ('REFERENCE_TYPE_ID = 4100133' AS VARCHAR2(255)) AS WhereClause,CAST ('SV_UK' AS VARCHAR2(255)) AS SourceSystemId,CAST ('' AS VARCHAR2(255)) AS ClassificationId,CAST ('' AS VARCHAR2(255)) AS ClassificationSchemeId,CAST (REFERENCE_CODE AS VARCHAR2(255)) AS ClassificationCode,CAST (CODE_LABEL AS VARCHAR2(255)) AS ShortName,CAST (ABBREVIATION AS VARCHAR2(255)) AS ClassificationName,CAST (DESCRIPTION AS VARCHAR2(255)) AS Description,CAST ('' AS VARCHAR2(255)) AS EffectiveDate,CAST ('' AS VARCHAR2(255)) AS EndDate,CAST ('' AS VARCHAR2(255)) AS GroupClassificationId,CAST ('' AS VARCHAR2(255)) AS GroupClassificationScheme,CAST ('' AS VARCHAR2(255)) AS GroupClassificationCode
FROM SAL_REFERENCE_V
where REFERENCE_TYPE_ID = 4100133
UNION ALL
SELECT Distinct CAST('Manual' AS VARCHAR2(255)) AS DataOrManual,CAST ('NE_TP' AS VARCHAR2(255)) AS SchemeCode,CAST ('NORMALISED_EVENT_TYPE' AS VARCHAR2(255)) AS SourceTable,CAST ('' AS VARCHAR2(255)) AS WhereClause,CAST ('SV_UK' AS VARCHAR2(255)) AS SourceSystemId,CAST ('' AS VARCHAR2(255)) AS ClassificationId,CAST ('' AS VARCHAR2(255)) AS ClassificationSchemeId,CAST (NORMALISED_EVENT_TYPE_ID AS VARCHAR2(255)) AS ClassificationCode,CAST (NORMALISED_EVENT_TYPE_NAME AS VARCHAR2(255)) AS ShortName,CAST (NORMALISED_EVENT_TYPE_NAME AS VARCHAR2(255)) AS ClassificationName,CAST (DESCRIPTION AS VARCHAR2(255)) AS Description,CAST ('' AS VARCHAR2(255)) AS EffectiveDate,CAST ('' AS VARCHAR2(255)) AS EndDate,CAST ('' AS VARCHAR2(255)) AS GroupClassificationId,CAST ('' AS VARCHAR2(255)) AS GroupClassificationScheme,CAST ('' AS VARCHAR2(255)) AS GroupClassificationCode
FROM NORMALISED_EVENT_TYPE

BUt IF i am adding any other SQL IT is failing with warning no fatal..same as pasted earlier..

aakashahujaacc · Post by **aakashahujaacc** » Mon Jul 18, 2011 7:15 am

In a line - there is something in your transformer thats causing this issue. check your transformer again.

cheers
aakash

chulett · Post by **chulett** » Mon Jul 18, 2011 7:21 am

meet_deb85 wrote:BUt IF i am adding any other SQL IT is failing with warning no fatal..same as pasted earlier..

It's too long, you'll need to find another way to do this... a view comes to mind.