Abnormal termination of stage

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Abnormal termination of stage

Post by admin »

Hi all,

Im aggregating data, using the aggregator component, from a source table. But by any raison the job aborts with this warning: "Abnormal termination of stage DSagsms10q2v1..AGGREGATOR110 detected"

Has anybody experienced this problem before and has a solution for it. Im using version 5.1.

NP
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Yes ... try setting stage-logging on and you should get a more helpful message listed (mine was something like join-columns-must-be-selected-in-output).


-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: 28 November 2001 11:37
To: LIST-DataStage (E-mail)
Subject: Abnormal termination of stage


Hi all,

Im aggregating data, using the aggregator component, from a source table. But by any raison the job aborts with this warning: "Abnormal termination of stage DSagsms10q2v1..AGGREGATOR110 detected"

Has anybody experienced this problem before and has a solution for it. Im using version 5.1.

NP



This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must
not disclose, copy or take any action in reliance of this transmission.

Although this message and its contents have been scanned for viruses and no
viruses were detected, no responsibility whatsoever is accepted by the
Company, or any of its offices or companies for any loss or damage
arising in any way from receipt or use thereof.

If you have received this email in error please delete this message and notify the Polk System Administrator at postmaster@polkglobal.com.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

sorry, but where is that option?
i havent find this option in help.

thanks.

NP



> -----Original Message-----
> From: Ricketts, James [mailto:JAMES.RICKETTS@POLK.CO.UK]
> Sent: quarta-feira, 28 de Novembro de 2001 11:39
> To: datastage-users@oliver.com
> Subject: RE: Abnormal termination of stage
>
>
> Yes ... try setting stage-logging on and you should get a more helpful
> message listed (mine was something like
> join-columns-must-be-selected-in-output).
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 28 November 2001 11:37
> To: LIST-DataStage (E-mail)
> Subject: Abnormal termination of stage
>
>
> Hi all,
>
> Im aggregating data, using the aggregator component, from a
> source table.
> But by any raison the job aborts with this warning:
> "Abnormal termination of stage DSagsms10q2v1..AGGREGATOR110 detected"
>
> Has anybody experienced this problem before and has a
> solution for it. Im
> using version 5.1.
>
> NP
>
>
>
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you are not the intended addressee, you must not
> disclose, copy or take any action in reliance of this transmission.
>
> Although this message and its contents have been scanned for
> viruses and no
> viruses were detected, no responsibility whatsoever is
> accepted by the
> Company, or any of its offices or companies for any loss or damage
> arising in any way from receipt or use thereof.
>
> If you have received this email in error please delete this
> message and
> notify the Polk System Administrator at postmaster@polkglobal.com.
>
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Tracing-Level=1 on the "Stage" tab of the Merge stage.

-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: 28 November 2001 12:10
To: datastage-users@oliver.com
Subject: RE: Abnormal termination of stage



sorry, but where is that option?
i havent find this option in help.

thanks.

NP



> -----Original Message-----
> From: Ricketts, James [mailto:JAMES.RICKETTS@POLK.CO.UK]
> Sent: quarta-feira, 28 de Novembro de 2001 11:39
> To: datastage-users@oliver.com
> Subject: RE: Abnormal termination of stage
>
>
> Yes ... try setting stage-logging on and you should get a more helpful
> message listed (mine was something like
> join-columns-must-be-selected-in-output).
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 28 November 2001 11:37
> To: LIST-DataStage (E-mail)
> Subject: Abnormal termination of stage
>
>
> Hi all,
>
> Im aggregating data, using the aggregator component, from a
> source table.
> But by any raison the job aborts with this warning:
> "Abnormal termination of stage DSagsms10q2v1..AGGREGATOR110 detected"
>
> Has anybody experienced this problem before and has a
> solution for it. Im
> using version 5.1.
>
> NP
>
>
>
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you are not the intended addressee, you must not
> disclose, copy or take any action in reliance of this transmission.
>
> Although this message and its contents have been scanned for
> viruses and no
> viruses were detected, no responsibility whatsoever is
> accepted by the
> Company, or any of its offices or companies for any loss or damage
> arising in any way from receipt or use thereof.
>
> If you have received this email in error please delete this
> message and
> notify the Polk System Administrator at postmaster@polkglobal.com.
>
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Hi Nuno,

I was running in the same problem some month ago but on rel. 4.0.

If you sort the the record on the field that you are aggregating everythink will work fine.

Best Rgds

Giovanni Boccia
Sales Engineer
Direzione Industria e Servizi
Datamat - Enabling Your Future

----- Original Message -----
From: "Nuno Pimenta"
To: "LIST-DataStage (E-mail)"
Sent: Wednesday, November 28, 2001 12:36 PM
Subject: Abnormal termination of stage


> Hi all,
>
> Im aggregating data, using the aggregator component, from a source
> table. But by any raison the job aborts with this warning: "Abnormal
> termination of stage DSagsms10q2v1..AGGREGATOR110 detected"
>
> Has anybody experienced this problem before and has a solution for it.
> Im using version 5.1.
>
> NP
>
>
>
Locked