Some PSUB jobs remain at 'SUBMITTED' status (OC 5.x.x / UNIX env).
(Doc ID 2444465.1)
Last updated on OCTOBER 01, 2024
Applies to:
Oracle Clinical - Version 5.0.0 and laterInformation in this document applies to any platform.
Symptoms
i.
Some PSUB jobs stay at 'SUBMITTED' status in a Unix 5.x.x environment i.e.
- possible to generate a default character layout.
- possible to generate a validation or derivation procedure.
- not possible to run a full batch validation.
ii.
The 'rxcpsd_<db>_51_2.log' > last part of log contains below error :
at: invalid option -- 'r'
Usage: at [-V] [-q x] [-f file] [-mldbv] time
at -c job ...
atq [-V] [-q x]
atrm [-V] job ...
batch
Usage: at [-V] [-q x] [-f file] [-mldbv] time
at -c job ...
atq [-V] [-q x]
atrm [-V] job ...
batch
iii.
The output of the below commands (as opapps) :
echo $SHELL
ps -ef |grep -i rxcpsdps
cd $HOME
echo 'ls > $HOME/at_test_listing.out' | at -q a now
ps -ef |grep -i rxcpsdps
cd $HOME
echo 'ls > $HOME/at_test_listing.out' | at -q a now
is :
[opapps@xxx ~]$ echo $SHELL
/bin/bash
[opapps@xxx ~]$ ps -ef|grep -i rxcpsdps
opapps 12609 12422 0 04:12 pts/0 00:00:00 grep -i rxcpsdps
opapps 27636 1 0 Sep06 ? 00:00:00 rxcpsdps VERBOSE <DATABASE INSTANCE> 51 <WALLET ALIAS>
[opapps@xxx ~]$ cd $HOME
[opapps@xxx ~]$ echo 'ls > $HOME/at_test_listing.out' | at -q a now
job 33202 at 2018-09-07 04:21
Can't open /var/run/atd.pid to signal atd. No atd running?
[opapps@xxx ~]$
/bin/bash
[opapps@xxx ~]$ ps -ef|grep -i rxcpsdps
opapps 12609 12422 0 04:12 pts/0 00:00:00 grep -i rxcpsdps
opapps 27636 1 0 Sep06 ? 00:00:00 rxcpsdps VERBOSE <DATABASE INSTANCE> 51 <WALLET ALIAS>
[opapps@xxx ~]$ cd $HOME
[opapps@xxx ~]$ echo 'ls > $HOME/at_test_listing.out' | at -q a now
job 33202 at 2018-09-07 04:21
Can't open /var/run/atd.pid to signal atd. No atd running?
[opapps@xxx ~]$
i.e the 'Can't open /var/run/atd.pid to signal atd. No atd running?' error is returned when using the 'at' command.
Note:
Alternatively the following error can also be seen when running the echo 'ls > $HOME/at_test_listing.out' | at -q a now command:
Redirecting to /bin/systemctl status atd.service
Unit atd.service could not be found.
Unit atd.service could not be found.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |