SAP BW not invoking the PULL job

[sigma]

Hi All

We have a pull job that we want to get invokved FROM BW

But even though thejob is defined as pull job when BW invokes it we see it coming to datastage as seen in the log under the path below but the job does not get invokved.

$ pwd
/usr/IBM/InformationServer/Server/DSBWConnections/SAPBWD/SourceSystems/DATACLD/Data

$ls -altr

-rw-rw-rw- 1 root system 30 Oct 07 13:21 SAPBWD.DATACLD.ZBW_LEGACY_PHARMA.D.started
-rw-rw-rw- 1 root system 3228 Oct 07 13:21 REQU_4BEXC1Q5J4UP9HKKACNX5Z364.ready

-rw-rw-rw- 1 root system 3228 Oct 07 13:24 REQU_4BEXCOCDD0RU3UU5GVK2RRB2K.ready

-rw-rw-rw- 1 root system 3228 Oct 07 13:33 REQU_4BBO79KA9ZQA2BAO34YL97OB0.ready

-rw-rw-rw- 1 root system 3228 Oct 07 13:38 REQU_4BBIRGIWIHHJPLFL6001QYPJG.ready
-rw-rw-rw- 1 root system 579 Oct 07 13:56 RFCServer_T5.2008_10_07.log
-rw-rw-rw- 1 root system 3228 Oct 07 13:56 REQU_4BBITLRJ6FS50903UBJIUPSR0.ready

-rw-rw-rw- 1 root system 32 Oct 07 13:57 RFCServer_T4.2008_10_07.log
-rw-rw-rw- 1 root system 579 Oct 07 13:58 RFCServer_T6.2008_10_07.log
-rw-rw-rw- 1 root system 3228 Oct 07 13:58 REQU_4BBITY51Q6R90KC58RBB1VQA4.ready

-rw-rw-rw- 1 root system 574 Oct 07 14:08 RFCServer_T2.2008_10_07.log
-rw-rw-rw- 1 root system 3228 Oct 07 14:08 REQU_4BBIUGPBJT7X11C7CEYZCMMKS.ready

-rw-rw-rw- 1 root system 574 Oct 07 14:12 RFCServer_T3.2008_10_07.log
-rw-rw-rw- 1 root system 3228 Oct 07 14:12 REQU_4BBIV6QFT2SE5F8Z4AWLFA9XO.ready

Everytime I have the BW job invokved it creates two entires here saying a a request was received and ready but the job never really kicks off

The log areas are not full as of righ tnow

Has someone encountered this before

Sigma

[sigma]

Basically in BW the job is hanging for us when it get invokved there to runa datastage job

[dnsjain]

You can try following tasks to resolve the problem.

1. make sure that dataStage RFC server is running from BW (sm59)

2. delete the .started file. When that file exists in the log directory, DataStage job do not start.

3. Make sure that all of the job setteings are correct.

Dinesh

*Note: critical Typo corrected by Content Editor*

[sigma]

Thanks

I do not see any starter file

/usr/IBM/InformationServer

find . -name ".starter" -print 2>/dev/null

returns nothing

Also the rfc server is up as we are getting messages into the path

/usr/IBM/InformationServer/Server/DSBWConnections/SAPBWD/SourceSystems/DATACLD/Data

and files within those say there is a request received for a particular datastage job and it shows who invoked it in bw etc

What I am not sure is where it is getting stuck

arvind

[dnsjain]

I meant .started file not .starter file. I see you have that in the directory. Delete that file and try run again.

[sigma]

I see what you are saying. I have deleted that. Let me run it and let you know what happens

Thanks a lot for your help


Sigma

[sigma]

Thanks that indeed seem to help

I cleaned out the folder mentioned earlier in the folder and it seem to run the jobs just fine

What is the.started file ( I am assuming it keeping some kind of trace points) but I just checked the directory for completed job and I do notsee a .started file.

Is it a temp file that is started and deleted at the end of the pull/push job

Thanks a lot anyways

Sigma

[dnsjain]

Sigma,

I am happy that your problem is solved. You are right, ".started" file get created when datastage start the job and get deleted when job completes successfully or job gets reset.

If the issue is reolved, Please mark it as resolved.