BW Load Failed with Status Code 255

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Brian Zhang
Participant
Posts: 39
Joined: Tue Jun 03, 2008 12:13 am
Location: Melbourne

BW Load Failed with Status Code 255

Post by Brian Zhang »

Hi All,
We are encountering an issue on the job having BW Load stage. The content from log file is as follows,
$ cat RFCServer_T4.2008_08_25.log
I: RFC Connection Accepted: Handle 11
I: Connection opened Mon Aug 25 06:34:21 2008
I: Keyname DSJob
I: Keyvalue JSAS_Hierarchy_Plant
I: BW Load: Running Pull Job JSAS_Hierarchy_Plant for InfoSource 0PLANT - Mon Aug 25 10:33:13 2008
I: Job Broker: Preparatory unlink (1033) of Data pipe '/datastage/dsadm/Ascential/DataStage/DSBWConnections/ASCENTIALU/SourceSystems/ASCENTIALU/Data/ASCENTIALU_ASCENTIALU_0PLANT_MASTERHIERARCHY'
I: BW Load: Created Named Pipe '/datastage/dsadm/Ascential/DataStage/DSBWConnections/ASCENTIALU/SourceSystems/ASCENTIALU/Data/ASCENTIALU_ASCENTIALU_0PLANT_MASTERHIERARCHY'...
I: Job Broker: Preparatory unlink (1055) of req ID pipe '/datastage/dsadm/Ascential/DataStage/DSBWConnections/ASCENTIALU/SourceSystems/ASCENTIALU/Data/ASCENTIALU_ASCENTIALU_0PLANT_MASTERHIERARCHY_REQ_ID'
I: BW Load: Creating Named Pipe '/datastage/dsadm/Ascential/DataStage/DSBWConnections/ASCENTIALU/SourceSystems/ASCENTIALU/Data/ASCENTIALU_ASCENTIALU_0PLANT_MASTERHIERARCHY_REQ_ID'...
I: Job Broker: DataStage Job Thread Starting.
I: Job Broker: Executing '/datastage/dsadm/Ascential/DataStage/DSEngine/bin/dsjob -server warusbwd01.diageo.net -user dsadm -password ***** -run -jobstatus -wait WallabyDev JSAS_Hierarchy_Plant'
I: Job Broker: unlink (1501) of data pipe '/datastage/dsadm/Ascential/DataStage/DSBWConnections/ASCENTIALU/SourceSystems/ASCENTIALU/Data/ASCENTIALU_ASCENTIALU_0PLANT_MASTERHIERARCHY'
I: Job Broker: unlink (1506) of req ID pipe '/datastage/dsadm/Ascential/DataStage/DSBWConnections/ASCENTIALU/SourceSystems/ASCENTIALU/Data/ASCENTIALU_ASCENTIALU_0PLANT_MASTERHIERARCHY_REQ_ID'
I: BW Load: DataStage job failed: Status code = 255
I have checked with SAP team on RFC connection at SAP BW level and it is working fine, but it would encounter this error when we initiated it from BW side and error message represented that "Error: connection closed(no data)" from Scheduler(Maintain InfoPackage) panel.

Pls help to have a look at this and guide me figure it out.
Thanks all in advance.

Regards
Brian.
Brian Zhang
Participant
Posts: 39
Joined: Tue Jun 03, 2008 12:13 am
Location: Melbourne

Additional Description

Post by Brian Zhang »

Oh, there was another thing happened before the job was working fine, that was Basis team member did some changes on configuration (I'm not sure if it's the DSBWConnection.config or SourceSystems.config), but I did restart RFC Server Manager daemon on Ascential server to refresh anything changed to latest after I knew that.

Now, I suspect that if the BW Load job should be re-compiled again?

I would appreciate your help.
Regards
Brian.
Post Reply