Strange warning in DSDirector

[admin]

Hi Kati,

I am not so experienced with merge but I would suggest to try this:

3 files --> merge --> sequential---->Transformer --> Target table
ODS_Tbl_UOM (with a procedure in the before tab) --> Log table

Wolfgang

-----Original Message-----
From: Katarzyna Lewicka [mailto:katarzyna.lewicka@cgey.com]
Sent: Thursday, January 29, 2004 10:28 AM
To: datastage-users
Subject: Strange warning in DSDirector


Hi all,

I have the following 2 warning messages :

"OdsDtLoadSaUomTblOdsArticleUom003MM..ODS_Tbl_UOM.LoadFrom_SA_Into_ODS:
DSP.Close Error -2 in $DSP.Close."

THis message is write to the log after some warning messages of unique
constraint violated(which are normal) and before the info message :

"OdsDtLoadSaUomTblOdsArticleUom003MM..Check_Key: DSD.StageRun Active stage
finishing...."

And after that I have :

"Attempting to Cleanup after ABORT raised in stage
OdsDtLoadSaUomTblOdsArticleUom003MM..ODS_Tbl_UOM"

And then :

"DataStage Job 215 Phantom 2444
OdsDtLoadSaUomTblOdsArticleUom003MM..ODS_Tbl_UOM.LoadFrom_SA_Into_ODS:
DSP.Close Error -2 in $DSP.Close.
Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage
OdsDtLoadSaUomTblOdsArticleUom003MM..ODS_Tbl_UOM
DataStage Phantom Aborting with @ABORT.CODE = 3"

The design of the job is :

3 files --> merge --> Transformer --> Target table ODS_Tbl_UOM (with a
procedure in the before tab) --> Log table


What these errors mean?


Thanks for your help.

DataStage 6 on Win2K



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users