We have OBIEE and Informatica+DAC Server setup on different unix machines.
We want to purget OBIEE Cache from Informatica/DAC server.
We have created a shell script which connects to OBIEE server from Informatica server using SSH and runs shell script containing nqcmd command which purges OBIEE cache.
But problem is when we are calling shell script from Informatica/DAC, ssh is not able to connect to target OBIEE Server.
when we try to call shell script which has ssh via DAC/informatica, it gives below error.
Pseudo-terminal will not be allocated because stdin is not a terminal.
(ssh-askpass:14217): Gtk-WARNING **: cannot open display:
Host key verification failed.
PS: We can't setup OBIEE utilities on Inforamtica/DAC server.
Looks like your ssh keys on the target server are not correct.
Try ssh from terminal of dac server system to BI server. If it prompts for password then you need to fix the ssh keys on the BI server to log you in. If it doesn't ask password then ssh is good and the issue might be because of the environment variables set before executing nqcmd.
Let me know if this helped.
Thanks for Reply !!
we are able to ssh from DAC/infa server to OBIEE server without any password. Ssh related files were correctly copied by admin Admin and they are working fine.
Even if we execute shell script which does ssh to target machine and calls the shell script which initializes environment variables and purges caches sucessfully at target.
But the problem comes when we put ssh command or script containing ssh in informatica/DAC. We start getting host key verification.
If the ssh configuration is good then it might related to DISPLAY environment variable.
In your shell script can you include this line in the beginning:
Let me know if this worked.