Deleting Rows in ExcelToCI

Go to http://www.cedarhillsgroup.com/knowledge-base/kbarticles/deleting-rows-in-exceltoci to see How to modify delivered ExcelToCI template to delete rows which is not delivered by default. One of the use case is delete roles from user profiles in mass without using backend SQL . This uses delivered USER_PROFILE component interface. Tested in PT 8.53 and works fine. Make sure that you select Action as UPDATEDATA in Connect Information worksheet of ExcelToCI

In Summary, Go to Tools | Macros | Visual Basic Editor

Open StagingAndSubmission Module and Navigate to WriteCollectionHeader function do the following.

You will see a case statement “Select Case lScrollLevel”

Change the “Case 1” statement as PSROLEUSER is in level 1. If your target rows exist in other levels, you will need to modify that Case statement.

sXmlLine = sIndent & "<" & sXmlTag & ">"

To

sXmlLine = sIndent & “<” & sXmlTag & " CINodeAction=""DELETE"">"

Unable to Select or Edit a Field on a Page in Application Designer

On a very long page, we were not able to select the fields towards the bottom of this page. We found the following in PeopleBooks

Home -> PeopleSoft PeopleTools 8.53 -> PeopleSoft Application Designer Developer’s Guide -> Understanding Page Controls -> Data Entry Controls

Note: PeopleSoft Application Designer allows you add up to 405 fields on a page. When you reach this limit, typical system behavior includes being unable to select, move, or edit the page fields with an order number exceeding the 405-field limit. While this limit has no effect on the page at runtime, it has the potential to disrupt productivity during design time. If you find a page nearing the 405-field limit, you should use subpages to decrease the number of fields on a single page.

Below PeopleSoft resolution describes the same issue which is there since Version 8.2

E-AD Is there any limit on the number of fields on a Page Definition ( Doc ID 648823.1 )

Using Sub pages is the easiest way to resolve this issue. However this require changing the code.

The below query can be used to identify any such pages

select pnlname,count(*) from pspnlfield group by pnlname order by count(*) desc

Integration Network WorkCenter Incorrect Formatting after PeopleTools upgrade

After upgrading to PeopleTools 8.53 from 8.50, Integration Network Workcenter in Portal 9.1 application was not displaying properly. The culprit was missing classes from cloned stylesheet. Used the below sql to identify the missing sub style sheets and classes from the cloned stylesheet class and copy them manually.

Screenshot of incorrect formatting.

select * from PSSTYLECLASS a where a.stylesheetname = 'PSSTYLEDEF_SWAN'  and a.styleclassname not in (Select b.styleclassname from  PSSTYLECLASS b
where   b.stylesheetname = 'PREFIX_PSSTYLEDEF_SWAN_PT850')

minus
select * from PSSTYLECLASS a where a.stylesheetname = 'PSSTYLEDEF_SWAN'  and 'PREFIX_' || a.styleclassname || '_PT850'  in (Select  b.styleclassname   from  PSSTYLECLASS b
where   b.stylesheetname = 'PREFIX_PSSTYLEDEF_SWAN_PT850')

Replace the compared to stylesheetname with your custom stylesheet name and also do not overwrite your custom styleclass if any. In this particular instance adding the below class from delivered 'PSSTYLEDEF_SWAN resolved the issue.

STYLECLASSNAME

----------------------

PSAVSCHART

PSCHARTGANTT

PSCHARTSTYLE_FREEFORM

PTAL_SUBSTYLE_REQ_SWAN

PTAL_SUBSTYLE_VL_SWAN

PTWC_SUBSTYLE_SWAN

PT_ACE_SS1_SWAN

Unified Navigation WorkCenter error

If you have upgraded the Portal 9.1 (Portal Interaction Hub or Enterprise Portal) from 8.50 to 8.53 and tried to use the Unified Navigation WorkCenter, You will get the following error.

Navigation : Portal Administration –> Unified Navigation WorkCenter

.arrowlistmenu{width:320px;} .arrowlistmenu .menuheader{font: 10px Arial;color: black;background-color: #FDFDFE;padding: 1px 0px 5px 5px;margin-bottom:2px;cursor: hand;cursor:

To fix this issue , Go to Portal Administration –> Pagelets –> Pagelet Wizard –> Pagelet Wizard

Open Pagelet ID : PAPP_EPPUN_UNPGLT

Navigate to Step 4 Select Display Format and Select Radio button Passthru. It is currently Custom

Click Next (Step 5 of 6) and Press Save.

Retest the Unified Navigation WorkCenter link. The issue should be resolved now.

Running Delivered and Custom App Engine Process using PSAE command line crashes when terminating.

Application Engine program XXX ended normally

15339: 1404097409: PSPAL::Abort: Unexpected signal received
15339: 1404097409: PSPAL::Abort: Location: /vob/peopletools/src/pspal/exception_sigaction.cpp:494: RecoverableSignalHandler
15339: 1404097409: PSPAL::Abort: Generating process state report to /opt/pshome/logs/psae.15339/process_state.txt
15339: 1404097409: PSPAL::Abort: Terminating process now.

On examining the process_state.txt, found the following

(Looking for PSPAL::)

#9  0x00007f18e0e52c3b in STWGCTimer::register_gc_start(long) () from /opt/tools/jre/lib/amd64/server/libjvm.so
#10 0x00007f18e117d8a8 in PSScavenge::invoke_no_policy() () from /opt/tools/jre/lib/amd64/server/libjvm.so
#11 0x00007f18e117ef21 in PSScavenge::invoke() () from /opt/tools/jre/lib/amd64/server/libjvm.so
#12 0x00007f18e1136020 in ParallelScavengeHeap::failed_mem_allocate(unsigned long) () from /opt/tools/jre/lib/amd64/server/libjvm.so

It seems that issue is happening, when the application engine program that invokes the java code and at the time of terminating trying to clean the JVM memory. When the JVM memory area points to invalid locations, it crashes the JVM. This is observed in 8.53.12 and currently there is no official solution, other than POC to fix this issue. You will need to open a support case to get the POC. In POC, libpsjni.so has been modified so that it does not try to clear the java memory when exiting the program.

Application Designer Page not responding

When you have a complex page with a Level 1 scroll area and lot of group boxes on a single page and try to move a field using arrow key, page becomes un responsive and CPU goes to 100% usage for one particular core. The control comes back after a minute. If you want to align lot of fields it becomes cumbersome. This is observed with PeopleTools 8.53.12 on a custom page with HRMS 9.1 on multiple windows 7 64 bit laptops (Dual Core with 8 GB RAM). Clearing the cache or rebooting the machine does not help.

Workaround : What we found is that changing the fields under a scroll area to a subpage (All fields must be level 0 in a subpage) and using that subpage resolves the issue. I have not seen this before in older PeopleTools releases (8.50 and earlier) and so it seems to me a new issue.

Oracle Support was able to replicate this issue and opened a new Bug 19492406 - APP DESIGNER GOES INTO NOT RESPONDING STATE WHEN MOVING A PAGE FIELD .

There is also a BUG 18773369 and 19565638  related to this issue.

This issue is fixed in 8.55 and 8.54.03. Currently there is no fix for 8.53, but the below workaround also works in addition to moving fields to sub pages. The fix may be included in 8.53.18.

Click on Application Designer Menu item Layout->Grid Settings..., set the Show Grid to No. This can minimize the refresh, but this is not a permanent setting. Every-time a page is opened, click Layout->Grid Settings..., set the Show Grid to No must be done.

If you are on lower 8.53 patch level you can request a POC fix which provides updates to psped.dll and pspnlrtwin.dll to resolve the issue.

Patch name : 19531601 and POC is POC-913314-02.

Error in Breadcrumb Update function, doBcUpdate: QuotaExceededError: DOM Exception 22 when using iPhone

This happens when private mode is turned on in Safari browser in iPhone or iOS, as breadcrumb update function relies on Session Storage which is disabled in private mode. The simplest resolution to this issue is to turn off the private mode. You can use the below Apple safari article for more precise instructions.

iPhone/iPad Turn on-off Private Mode

Following My Oracle Support article describes this issue.

E-PIA : Breadcrumb Throws Exception Error When Private Browsing Is On In Safari (Doc ID 1645653.1)

This issue happens in PT 8.51 or higher and I have seen it happening in 8.53.12.