IPC cleanup crashes with Cleaning up of IPC resources failed

IPC cleanup crashes with Cleaning up of IPC resources failed



Solution :

Open new session and follow below steps

[psoft@xxxxxx appserv]$ export TM_ENGINE_TMSHMSEGSZ=64

[psoft@xxxxxxx0 appserv]$ ./ipcrmall.sh psoft psoft   (Clear IPC resources using this command)

This script will be deprecated in next tools release.

Please use psadmin to clean IPC resources

ipcrmall.sh  - Checking Parameters for Linux Systems

ipcrmall.sh  - Creating killipc.sh file

ipcrmall.sh  - Examine killipc.sh and then use it to kill resources

[psoft@xxxxxx appserv]$ ./killipc.sh      (This will create inside $PS_HOME/appserv once we execute above command ipcrmall.sh

resource(s) deleted

resource(s) deleted

resource(s) deleted

resource(s) deleted

resource(s) deleted

resource(s) deleted

[psoft@ca100fstun10 appserv]$

> INFO: Oracle Tuxedo, Version 12.1.3.0.0, 64-bit, Patch Level 098

Booting admin processes ...

exec BBL -A :

        process id=2253 ... Started.

1 process started.

Attaching to active bulletin board.

> Looking for IPC resources in TUXCONFIG file /u02/psoft/pscfg/FSTUN/appserv/FSTUN/PSTUXCFG

The following IPC recources were found:

  Message Queues:

        26542081

  Shared Memory:

        155025409

  Semaphores:

        3768323

        3702786

Removing IPC resources...

Done!

Cleaning up of IPC resources was successful

 

PeopleTools 8.56 Data Mover > Database Setup does not Show Application List

On : 8.56 version, DataMover > Database Setup

Issue:
------
Select "System" option Shows "Peoplesoft HCM Demo Database - US English"
But Select "Demo" option does not show anything for HCM

STEPS
--------
The issue can be reproduced at will with the following steps:
1. Install PeopleTools 8.56 and Application release of your choice
2. Build Database and import data using Datamover > database setup > select demo option
This impacts all peoplesoft application product lines.


To implement the solution, please execute the following steps:

1. Navigate to PS_APP_HOME/data folder

2. Rename <xx>engb.db to <xx>engb.db.bak
where xx - refers to application product code Eg:HC, EP, CR etc 

PeopleTools 8.56 Demo Database creation issue

On : PT8.56 version, DataMover > Database Setup

Issue:
------
Select "System" option Shows "Peoplesoft HCM Demo Database - US English"
But Select "Demo" option does not show anything for HCM

STEPS
--------
The issue can be reproduced at will with the following steps:
1. Install PeopleTools 8.56 and Application release of your choice
2. Build Database and import data using Datamover > database setup > select demo option
This impacts all peoplesoft application product lines.

 

 Solution :

To implement the solution, please execute the following steps:

1. Navigate to PS_APP_HOME/data folder

2. Rename <xx>engb.db to <xx>engb.db.bak

where xx - refers to application product code Eg:HC, EP, CR etc

PeopleSoft Process Monitoring Script

--------------------------------------------------------------------------------------------------
/*ALL UNIQUE PROCESSES IN THE LAST 30 DAYS THAT RAN LONGER THAN 30 MINUTES NOT INCLUDING RPTBOOK*/
--------------------------------------------------------------------------------------------------
SELECT
A.PRCSINSTANCE,
A.PRCSTYPE,
A.PRCSJOBNAME,
A.PRCSNAME,
B.PRCSJOBSEQ,
A.SERVERNAMERQST,
A.BEGINDTTM,
A.RUNSTATUS,
C.XLATLONGNAME,
CASE TO_CHAR(A.RUNSTATUS)
  WHEN '9' THEN LTRIM(TO_CHAR(A.ENDDTTM - A.BEGINDTTM), '+00000000')
ELSE
  LTRIM(TO_CHAR(SYSDATE - A.BEGINDTTM), '+00000000')
END AS "RUNTIME",
A.RUNCNTLID,
A.OPRID
FROM PSPRCSRQST A, PS_PRCSJOBITEM B, PSXLATITEM C
WHERE 1=1
AND A.PRCSJOBNAME = B.PRCSJOBNAME (+)
AND A.PRCSNAME = B.PRCSNAME (+)
AND A.BEGINDTTM > SYSDATE - 30
AND A.ENDDTTM - A.BEGINDTTM > '0 0:30:0.000000'
AND C.FIELDNAME = 'RUNSTATUS'
AND A.RUNSTATUS = C.FIELDVALUE
AND A.PRCSNAME <> 'RPTBOOK'
AND A.PRCSTYPE <> 'PSJob'
ORDER BY A.PRCSINSTANCE DESC, A.ENDDTTM-A.BEGINDTTM DESC
;
--------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------
/*CURRENTLY RUNNING PROCESSES AND HOW LONG IT'S BEEN RUNNING*/
--------------------------------------------------------------------------------------------------
SELECT A.PRCSINSTANCE,
A.PRCSTYPE,
A.PRCSJOBNAME,
A.PRCSNAME,
B.PRCSJOBSEQ,
A.SERVERNAMERQST,
C.XLATLONGNAME,
A.BEGINDTTM,
CASE TO_CHAR(A.RUNSTATUS)
  WHEN '9' THEN LTRIM(TO_CHAR(A.ENDDTTM - A.BEGINDTTM), '+00000000')
ELSE
  LTRIM(TO_CHAR(SYSDATE - A.BEGINDTTM), '+00000000')
END AS "RUNTIME", 
A.RUNCNTLID,
A.OPRID
FROM PSPRCSRQST A, PS_PRCSJOBITEM B, PSXLATITEM C
WHERE 1=1
AND A.PRCSJOBNAME = B.PRCSJOBNAME (+)
AND A.PRCSNAME = B.PRCSNAME (+)
AND A.RUNSTATUS = 7
AND C.FIELDNAME = 'RUNSTATUS'
AND A.RUNSTATUS = C.FIELDVALUE
ORDER BY RUNTIME DESC
;
--------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------
/*DISTINCT PROCESSES THAT RAN OVER 30 MINUTES*/
--------------------------------------------------------------------------------------------------
SELECT DISTINCT(A.PRCSNAME)
FROM PSPRCSRQST A, PS_PRCSJOBITEM B, PSXLATITEM C
WHERE 1=1
AND A.PRCSJOBNAME = B.PRCSJOBNAME (+)
AND A.PRCSNAME = B.PRCSNAME (+)
AND A.BEGINDTTM > SYSDATE - 30
AND A.ENDDTTM - A.BEGINDTTM > '0 0:30:0.000000'
AND A.PRCSTYPE <> 'PSJob'
AND C.FIELDNAME = 'RUNSTATUS'
AND A.RUNSTATUS = C.FIELDVALUE
;
--------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------
/*NUMBER OF TIMES THAT A PROCESS RAN OVER 30 MINUTES*/
--------------------------------------------------------------------------------------------------
SELECT A.PRCSNAME, COUNT(A.PRCSNAME)
FROM PSPRCSRQST A, PS_PRCSJOBITEM B, PSXLATITEM C
WHERE 1=1
AND A.PRCSJOBNAME = B.PRCSJOBNAME (+)
AND A.PRCSNAME = B.PRCSNAME (+)
AND A.BEGINDTTM > SYSDATE - 30
AND A.ENDDTTM - A.BEGINDTTM > '0 0:30:0.000000'
AND C.FIELDNAME = 'RUNSTATUS'
AND A.RUNSTATUS = C.FIELDVALUE
GROUP BY A.PRCSNAME
ORDER BY COUNT(A.PRCSNAME) DESC
;
--------------------------------------------------------------------------------------------------


--------------------------------------------------------------------------------------------------
/*CURRENTLY RUNNING PROCESSES AND HOW LONG IT'S BEEN RUNNING*/
--------------------------------------------------------------------------------------------------
SELECT A.PRCSINSTANCE, A.PRCSTYPE, A.PRCSJOBNAME, A.PRCSNAME, C.XLATLONGNAME, B.PRCSJOBSEQ, A.SERVERNAMERQST, A.BEGINDTTM, SYSDATE - A.BEGINDTTM AS "RUNTIME", A.RUNCNTLID, A.OPRID
FROM PSPRCSRQST A, PS_PRCSJOBITEM B, PSXLATITEM C
WHERE 1=1
AND A.PRCSJOBNAME = B.PRCSJOBNAME (+)
AND A.PRCSNAME = B.PRCSNAME (+)
--AND A.RUNSTATUS = 7
AND C.FIELDNAME = 'RUNSTATUS'
AND A.RUNSTATUS = C.FIELDVALUE
ORDER BY RUNTIME DESC;
--------------------------------------------------------------------------------------------------