How to write a .csv file to remote locaton by using openHUB via a process chain?

[Former Member]

Hi,

When i try to write a .csv file to remote location by using openHUB via a process chain it gave me an error.

But When i run the DTP manually it will create a .csv file successfully.

Please let me know a way to do it via a process chain...

Note: SAP BI server and remote location not in the same domain.

Best Regards,

Jani.

[former_member209032]

Hi,

  I think you are trying to place the file in ur desktop or some drive in your computer. This is not possible using process chain but possible when done manually. Try to place the file in application server and you can FTP the file from there to ur location using OS command.

Regards,

Raghavendra.

[Former Member]

2 things, when you run the infopakcackageto dtp manually it runs under your user id, does your batch user id have proper authorization to place the file in the designated area?

[jasprit_singh5]

When u schedule the jobs via process chains, it gets scheduled using the id for BW batch jobs, which usually has substantial access.

If you do not have access to place the file in the designated directory, the id which is used to run the job, needs to be given the access.

[former_member209895]

Hi Jani,

    Could you please share the error message that the DTP gave you upon being run from a process chain. As I understand you should be able to use a DTP in process chain without issues if it is working fine upon triggering manually. So I'm guessing that there could be some locks or resource shortage issues or some short dump from the same DTP when this was run through PC. If such is the case then we could atleast get a hint on what exactly is causing the DTP failure when run from PC and the analysis would get a new direction.

Regards,

  Manohar. D

[jasprit_singh5]

You coul ddo this in the following ways :

1. Do a NFS mount of the remote Server directory onto the BW Server and us it in your OpenHub.

2. Create the file locally and do an FTP using RSFTP002 program in SAP.

[snitwipro]

I think what you need is an OS command, please talk to your basis counterpart to create one unix command and use it in your process chain.

Regards

Sourav