We are facing TIMEOUT ISSUE while migrating .sql files migration through PPM.
we are looking for some type of “WAIT” or “SLEEP” command that PPM will recognize to wait as some of these scripts that are being executed are taking anywhere to 5 minutes to 30 minutes, and PPM is timing out around the 50 second mark.
You can also increase the timeout value for the object type in the workbench. We have Materialized Views that can take up to 5 hours to complete and we had to do that. I would say try to increase the timeout value first.
Will show you the SSH Server's configuration, if this is where your sshd_config file is located.
This would be the SSH server that you're connecting to, specified by your PPM environment. If this keepAlive issue is the problem, you should be able to increase ClientAliveCountMax and restart the SSH server.
Also please follow up with the previous recommendations also
Workaround / Fix
Make sure to set all the prompts to be "$" in both source and destination environments .profile and add "$" "echo $" at the end of ksc_simple_respond command line.
As this type of problem with timeout has been resolve using those instructions.
In all source and destination environments the following configuration items need to be set in $HOME/.bash_profile or $HOME/.profile (UNIX) or cygwin/etc/profile (Cygwin on Microsoft Windows) to avoid SCP transfer failures:
export PS1='$ ' export TERM=dumb stty cols 999
After that add "$" "echo $" at the end of the line
When you login in PPM server box(Home Directory).Please enter ls -alrt | grep profile , you can see all the files with .profile . Then use cat .profile command, you can get the required details o0f .profile.
We had a discussion with HP yesterday and below are the summary points:
There is a “.txt” file on the PPM Database, that will list all of the Environments currently setup within PPM, and once we locate that “.txt” file, then we need to prefix a “$” in front of those instances having the connectivity issues.
Answer from HP:Yes there should be a text file name .profile so it can editable, also it has to be under the Cygwin folder in the PPM Server.
2. The only Database that needs to be updated is PPM only…..none of the R12 Databases need to have any parameters changed.
Answer from HP:Exactly, in the PPM Database should be found all the different .profile for all the environments so the only Database that has to be changed is the PPM DB.
Our Query in point(1): Where can we find this env.txt file in PPM Server or the file what HP support person is suggesting.
Cygwin is only required when you install the PPM Server on Window environment. It is a Unix-like environment and command-line interface for Microsoft Windows. So, you don't need it on Unix environment.
Kudo is wellcome !!!
“HP Support If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”