Hi
I have set up the environment of using the non interactive public key authentication without any passphrase and when i use the below scp command to transfer the file to the machines( the same server is used as source and target , the only difference is the directory path from which the scp picks the file and lands the file). The command works fine in the unix box and when i try to execute with the datastage it is not .The error that i recieve is its not connecting to the server and comes out with an authentication failure from the unix box.
Please find the code that i use to connect within the server
Hi ,
I am doing this in a Execute command stage in a datastage sequence. The preliminary environment for setting the public key authentication is made manually . The problem is it connects when i execute the posted scp command manually without any authentication failiure ,but fails to do so in the execute command stage.The preliminary set up is set once and left untouched for the subsequent execution of the scp command . Any help please
Yes the files are at the same location .ie the execute command stage is picking the files from the location from where it is intended to . Rather after your advise i changed the filename to contain the filepath and the file name . still i am getting the same authentication failiure .
Just open up any of the job log you have run, from Datastage director. And see "Environmental Variable Settings" info, where you would see all environmental variables being exported to run your ETL job. In that list try to find these two variable values "LOGIN" and "LOGNAME". And let us know whether these values are same or are they different.