Comments on The PeopleSoft DBA Blog: Running Unix Commands and Scripts from the PeopleS...

Hi David, I have worked with you in BT. I am getti...

2010-09-04T01:15:42.164+01:00

Hi David, I have worked with you in BT. I am getting the error when i try to run the script via process scheduler as you can see from the log. But i am able to successfully execute from unix.

/local/apps/psoft/DEVM/pt849_hcm/bin/psft.sh:sh sdtest.sh 0
Sat Sep 4 00:36:24 BST 2010
Linux hwl027a002 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux
parameter 1: begindttm parameter 2: 7
PRCSINSTANCE : 1226516
Setting process request 1226516 to status 7
prcsapi: /local/apps/psoft/DEVM/pt849_hcm/bin/psft.sh[53]: sqlplus: not found
RETURN CODE: 127
SQL *Plus Error Return code: 0
Sat Sep 4 00:36:24 BST 2010
welcome
Sat Sep 4 00:36:24 BST 2010
parameter 1: enddttm parameter 2: 9
PRCSINSTANCE : 1226516
Setting process request 1226516 to status 9
prcsapi: /local/apps/psoft/DEVM/pt849_hcm/bin/psft.sh[62]: sqlplus: not found
RETURN CODE: 127
SQL *Plus Error Return code: 0
Sat Sep 4 00:36:24 BST 2010

I have corrected the script in this blog posting, ...

2010-07-07T11:27:38.758+01:00

I have corrected the script in this blog posting, and uploaded a new script to the Go-Faster website.

Hi David, I think I spotted a minor problem in yo...

2010-07-07T10:21:53.521+01:00

Hi David,

I think I spotted a minor problem in your psft.sh script, where it updates the PSPRCSRQST table with status 7. At that point the variable PRCSRTNCD doesn't have a value which makes the sql fail. Giving it an initial value of 0 does the job.

Great script. I've been writing a lot of stuff over the past months that I can bring into the PeopleSoft envionment now.

I noticed some issues with ssh/sftp in other posts. We have similar situations, so if I get that to run, I'll post another comment.

Hi David, we met a few years back - do you remembe...

2010-02-26T17:49:00.079Z

Hi David, we met a few years back - do you remember coming to Perot Systems? Anyway, I have a question about Unix Scripts and report distribution. It seems like the report distribution feature only works for generic process types of SQR and App Engine. Using OTH for Unix scripting does not allow saving the report distribution (User or role)values when I run the job. When I trace this, I'm not finding anywhere this is being saved, so my fear is that this information is being deleted/saved within Peoplesoft propietary code which we don't have access to. I did update the process output destination type to defalut to Web as Web and Client are the only two that allow this functionality. Any ideas?

This is pretty awesome. Thanks a lot David.

2009-07-01T16:57:56.342+01:00

This is pretty awesome. Thanks a lot David.

Hi Nopes , no luck with the "Couldn't wa...

2009-06-15T16:52:46.137+01:00

Hi

Nopes , no luck with the "Couldn't wait for ssh process: No child processes" issue .this comes while running the SFTP scripts through the proces scheduler.

If you have any solution do let me know.

Thanks

Is there a way to hide the password from command l...

2009-06-05T17:22:24.167+01:00

Is there a way to hide the password from command line?

Kicked off from the Process Scheduler, the from command line issued: ps -ef|grep uv

Results (password replaced with x's)

psadmin 934092 1282132 10 11:40:52 - 0:06 /bin/ksh /u01/psoft/psenv/CSDEV/UVAcust/scripts/uv_sf_nelnet_billfile_ftp.sh bobtest rs2wq SYSADM/xxxxxxxx@CSDEV
psadmin 1282132 1683642 0 11:40:52 - 0:00 /bin/ksh /u01/psoft/psenv/CSDEV/UVAcust/scripts/uv_psft.sh CSDEV SYSADM xxxxxxxx 36173 bobtest rs2wq /u01/psoft/psenv/CSDEV/UVAcust/scripts/uv_sf_nelnet_billfile_ftp.sh

Parameter List:
%%DBNAME%% %%ACCESSID%% %%ACCESSPSWD%% %%INSTANCE%% %%RUNCNTLID%% %%OPRID%%

Krishna, were you able to solve the "Couldn't wait...

2009-04-24T15:28:00.000+01:00

Krishna,
were you able to solve the "Couldn't wait for ssh process: No child processes" issue?

Thanks in advance,
Chris

Hi
I could resolve the "sftp command not found...

2009-03-15T01:34:00.000Z

Hi
I could resolve the "sftp command not found" error..However when i run the shell script from process scheduler it says "Couldn't wait for ssh process: No child processes"

Result - Process monitor run status is error.SFTP shell script process and does get the file transfer job, though this is only visible through crontab

Think i got real close and stuck with this last one
any inputs ......

If you can script it, you can run from the Process...

2009-02-27T23:38:00.000Z

If you can script it, you can run from the Process Scheduler. Problems like this are often down to environment and path. Try listing the environment variables with either set or env. I sometimes use set -x to see how execution of the script progresses.

Hi

Is this technique capable of doing Sftp...

2009-02-27T23:05:00.000Z

Hi

Is this technique capable of doing Sftp as well ?
I have shell script that has sftp command.
When i run that this way it says "sftp command not found".It runs succesfully through crontab though......
Any ideas......

Opps...Helps if you save the called unix script ;)...

2008-09-13T14:51:00.000+01:00

Opps...Helps if you save the called unix script ;) scripts/bobtest.sh BOB Was Here

banner "HelloWorld"
BASENAME=$(basename $0 .sh)
if [ -d "${PSPRCSLOGDIR}" ]; then
echo "This script is running under Process Scheduler"
echo "value = " $1
echo "value = " $2
echo "value = " $3
cp $0 ${PSPRCSLOGDIR}/${BASENAME}.log
else
echo "This script is not running under Process Scheduler"
fi
exit $*

This script is running under Process Scheduler
value = BOB
value = was
value = here
Setting process request 7691 to status 9
Sat Sep 13 09:45:44 EDT 2008

Great tip. In the override options, how can we pas...

2008-09-13T13:34:00.000+01:00

Great tip. In the override options, how can we pass multiple parameters to the unix script? I only see first one (parm1) I have tried

/scripts/bobtest.sh parm1 parm2 parm3

/scripts/bobtest.sh parm1, parm2, parm3,

/scripts/bobtest.sh %parm1 %parm2 %parm3
Thanks

You wouldn't happen to have a similar wrapper scri...

2008-06-11T17:30:00.000+01:00

You wouldn't happen to have a similar wrapper script from windows commands?

Never mind, my bad - recycled my process scheduler...

2008-02-25T21:25:00.000Z

Never mind, my bad - recycled my process scheduler and all is well.

Thanks again - great tip!

Hi -

This was a great find. I'm trying to ...

2008-02-25T21:14:00.000Z

Hi -

This was a great find. I'm trying to implement, but PeopleSoft doesn't seem to be kicking off the script. I can pull the parameters from the process monitor and issue that command, and everything runs perfectly. When kicked off from process schedule, though, I get no joy - stays in queued and nothing kicks off on the server.

Would really appreciate some assistance. cayce -dot- balara -at- crowley.com

Comments on The PeopleSoft DBA Blog: Running Unix Commands and Scripts from the PeopleS...

Hi David, I have worked with you in BT. I am getti...

I have corrected the script in this blog posting, ...

Hi David, I think I spotted a minor problem in yo...

Hi David, we met a few years back - do you remembe...

This is pretty awesome. Thanks a lot David.

Hi Nopes , no luck with the "Couldn't wa...

Is there a way to hide the password from command l...

Krishna, were you able to solve the "Couldn't wait...

Hi I could resolve the "sftp command not found...

If you can script it, you can run from the Process...

Hi Is this technique capable of doing Sftp...

Opps...Helps if you save the called unix script ;)...

Great tip. In the override options, how can we pas...

You wouldn't happen to have a similar wrapper scri...

Never mind, my bad - recycled my process scheduler...

Hi - This was a great find. I'm trying to ...

Hi
I could resolve the "sftp command not found...

Hi

Is this technique capable of doing Sftp...

Hi -

This was a great find. I'm trying to ...