tag:blogger.com,1999:blog-201034082024-03-17T23:03:12.397-04:00PeopleSoft Support & TipsThis blog contains posting related to peoplesoft Tools and technologies and specifically targeted towards peoplesoft developers.Ketan Kotharihttp://www.blogger.com/profile/17459077644208180243noreply@blogger.comBlogger117125tag:blogger.com,1999:blog-20103408.post-1641557598213703102023-07-20T16:19:00.002-04:002023-07-20T16:19:10.259-04:00Fail to Apply WebLogic July 2023 CPU Patch using Opatch 13.9.4.2.13<p> Oracle just released WebLogic CPU Patch on July 18th. More info below. </p><p><br /></p><p>Critical Patch Update (CPU) Patch Advisor for Oracle Fusion Middleware - Updated for July 2023 (Doc ID 2806740.2)</p><div>https://blogs.oracle.com/blogbypuneeth/post/oracle-weblogic-server-critical-patch-update-july-2023</div><div><br /></div><div>The Patch requires newer version of Opatch 13.9.4.2.13. When trying to apply the 35601596 - WLS STACK PATCH BUNDLE 14.1.1.0.230713 (SPB)<div>or</div><div>35560771 - WLS PATCH SET UPDATE 14.1.1.0.230703</div><div>using 28186730 - OPatch 13.9.4.2.13</div><div>it fails with below error</div><div><br /></div><div><div>[Jul 20, 2023 1:37:28 PM] [SEVERE] Nextget could not process patch 35560771</div><div>[Jul 20, 2023 1:37:28 PM] [SEVERE] oracle.glcm.opatch.common.api.install.HomeOperationsException: A failure occurred while processing patch: 35560771</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.HomeOperationsImpl.processPatch(HomeOperationsImpl.java:790)</div><div><br /></div><div> Caused by: com.oracle.cie.gdr.utils.LocalizedGdrException: GDR-70005: Failed to apply inventory patching to home.</div><div> GDR-70005: A failure occurred while attempting to apply inventory patches to the home /opt/fedex/cdas/cporapp/wls</div><div> GDR-70005: Contact customer support.</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.PatchHandlerImpl.processUpdatePatch(PatchHandlerImpl.java:1440)</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.PatchHandlerImpl.processUpdatePatch(PatchHandlerImpl.java:1345)</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.PatchHandlerImpl.processPatchUsingPaths(PatchHandlerImpl.java:771)</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.HomeOperationsImpl.processPatch(HomeOperationsImpl.java:786)</div><div> <span style="white-space: pre;"> </span>... 19 more</div><div> Caused by: java.lang.NullPointerException</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.ComponentMetaDataPatchHandler.isPatchMetadataSuperseded(ComponentMetaDataPatchHandler.java:696)</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.ComponentMetaDataPatchHandler.processComponentUpdatePatches(ComponentMetaDataPatchHandler.java:581)</div><div> <span style="white-space: pre;"> </span>at com.oracle.cie.gdr.patch.PatchHandlerImpl.processUpdatePatch(PatchHandlerImpl.java:1430)</div></div><div><br /></div><div>Below MOS document mentions this issue.</div><div><br /></div><div><div>July 2023 CPU: Oracle WebLogic Server 12.2.1.4 and 14.1.1 PSU/SPB Fail to Apply with "GDR-70005: Failed to apply inventory patching to home."(Doc ID 2962593.1)</div><div><br /></div><div>The cause is currently under investigation. Bug 35619659 was filed with deveolopment.</div><div>Last updated: July 20, 2023 1:30pm CDT</div><div>At this time there is no confirmed solution. Please check back for further information.</div><div><br /></div></div><div>Please do not apply this patch, till Oracle publishes the fix. </div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /></div>Ketan Kotharihttp://www.blogger.com/profile/17459077644208180243noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-37180790482094863502021-07-13T00:44:00.001-04:002021-08-17T10:45:33.943-04:00Error executing pagelet.<p>The below error message appears when you try to enable an existing pagelet for a new Role or Permission List.</p><p><br /></p><p>Error executing pagelet.</p><p>Detailed error description:</p><p>The current user has insufficient privileges to complete this operation.</p><p><br /></p><p>This happens, when you are modifying an existing pagelet that is generated using Pagelet Wizard in Portal Interaction hub (aka Enterprise Portal 9.1) and added a new permission List or Role using Structure and Content.</p><p><br /></p><p>The issue is Pagelet Wizard has its own security that is stored in the below table.</p><p>select * from PS_PTPPB_SECURITY where ptppb_pagelet_id = 'YOUR_PAGELET_ID';</p><p><br /></p><p>You can add the new permission List, by Going thru Pagelet Wizard steps again.</p><p>Menu Navigation : Portal Administration -> Pagelet -> Pagelet Wizard</p><p>Once you add the permission List or Role using the Pagelet wizard, this error will go away.</p><p>I encountered this issue for a Pagelet based on Navigation Collection. This is not properly documented and is difficult to troubleshoot. </p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /><p></p><p></p><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /><p></p><p><br /></p>Ketan Kotharihttp://www.blogger.com/profile/17459077644208180243noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-9665308746027106242021-02-04T16:49:00.001-05:002021-02-04T16:51:32.424-05:00Base64 encoding in PeopleSoft<p> There is a sample peoplecode delivered in App engine program used by Search engine indexing. It is PTSF_GENFEED -> Setup -> Step04 – PeopleCode</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-2nnOABAYxDM/YBxrk01OyAI/AAAAAAABbLc/mVsM9VF9nxIWjQqQ_-HPLt51ko5-wUopACLcBGAsYHQ/image.png" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="516" data-original-width="934" height="221" src="https://lh3.googleusercontent.com/-2nnOABAYxDM/YBxrk01OyAI/AAAAAAABbLc/mVsM9VF9nxIWjQqQ_-HPLt51ko5-wUopACLcBGAsYHQ/w400-h221/image.png" width="400" /></a></div><br /><br /><p></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-hPPAv64lyAk/YBxrsuFi7FI/AAAAAAABbLg/5Xhj_bOlrXsfG3Xhy8AspZQ_h5VvSskvACLcBGAsYHQ/image.png" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="74" data-original-width="774" height="39" src="https://lh3.googleusercontent.com/-hPPAv64lyAk/YBxrsuFi7FI/AAAAAAABbLg/5Xhj_bOlrXsfG3Xhy8AspZQ_h5VvSskvACLcBGAsYHQ/w400-h39/image.png" width="400" /></a></div><br /> <p></p><p><br /></p><p>Local JavaObject &header = CreateJavaObject("java.lang.String", &esuser | ":" | Decrypt("", &espass));</p><p> Local JavaObject &oEncoder = CreateJavaObject("com.peoplesoft.tools.util.Base64");</p><p> &auth = &oEncoder.encode(&header.getBytes());</p><p> &auth = "Authorization: Basic " | &auth;</p><p><br /></p><p>You can also find references of delivered peoplecode using base64 using below SQL</p><p><br /></p><p>select * from pspcmtxt where upper(PCTEXT) like '%BASE64%';</p>Ketan Kotharihttp://www.blogger.com/profile/17459077644208180243noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-54068665918180489342019-07-25T20:11:00.000-04:002019-07-25T20:11:49.798-04:00Calling SSL or https Web Service using WebLogic : javax.net.ssl.SSLHandshakeException: Received fatal alert: bad_certificate<div dir="ltr" style="text-align: left;" trbidi="on">
When trying to call an external web service Using PeopleSoft Integration broker, it is giving the following message<br />
<br />
<Jul 23, 2019 6:47:30 PM EDT> <Notice> <Stdout> <BEA-000000> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', <strong>RECV TLSv1.2 ALERT: fatal, bad_certificate</strong>> <br />
<br />
in Integration Broker Gateway Server, You will see<br />
<br />
<strong>HttpTargetConnector:ExternalSystemContactException Received fatal alert: bad_certificate</strong><br />
<strong>Message Set : 158, Message ID : 10721 IOException: The host couldn't be resolved.</strong><br />
To further debug, use the following options in setEnv,sh<br />
<br />
JAVA_OPTIONS_LINUX="-server -Xms1024m -Xmx1024m -Dtuxedo.jolt.LLEDeprecationWarnLevel=NONE <strong>-Djavax.net.debug=all</strong> -XX:MaxPermSize=256m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0"<br />
<br />
or<br />
-Djavax.net.debug=ssl:handshake:verbose<br />
<br />
Review this document<br />
<br />
[Java SE] Training - How to Process javax.net.debug Diagnostic Output (Doc ID 2170565.1) <br />
<br />
egrep -i "\* ClientHello|\* ServerHello|\* Certificate chain|\* CertificateRequest|\* ServerHelloDone|\* ClientKeyExchange|\* ServerKeyExchange|\* CertificateVerify|Change Cipher Spec|\* Finished|fatal|exception" outputfile<br />egrep -v "^[0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z]:" outputfile<br />
<strong>Resolution</strong><br />
This issue is caused by an expired SSL Certificate (PrivateKeyEntry) entry in pskey keystore located at<br />
<br />
$PS_CFG_HOME/webserv/peoplesoft/piaconfig/keystore<br />
<br />
To list the entries <br />
<br />
cd $PS_CFG_HOME/webserv/peoplesoft/piaconfig/keystore<br />ls -lrt<br />keytool -list -keystore pskey -storepass xxx -alias xxx -v<br />
or to list every thing<br />
keytool -list -keystore pskey -storepass xxx -v > output.txt<br />
<br />
Review the output for expired entry.<br />
<br />
This can also happen, if you have a PrivateKeyEntry that is signed by a Root CA which is not present in the target Web Service Provider keystore. <br />
<br />
Solution: Delete the expired or invalid PrivateKeyentry and restart the webserver<br />
<br />
keytool -delete -keystore pskey -storepass xxx -alias xxx<br />
<br />
This has resolved the issue. <br />
<br />
Other issue is that if you do not have RootCA of the target Web Service provider SSL Certificate in your keystore then you will need to import it in your keystore. <br />
<br />
errorLog<br />
<br />
javax.net.ssl.SSLHandshakeException: Received fatal alert: bad_certificate<br /> at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)<br /> at sun.security.ssl.Alerts.getSSLException(Alerts.java:154)<br /> at sun.security.ssl.SSLSocketImpl.recvAlert(SSLSocketImpl.java:1972)<br /> at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1089)<br /> at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1325)<br /> at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1352)<br /> at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1336)<br /> at psft.pt8.pshttp.https.HttpsClient.doConnect(HttpsClient.java:246)<br /> at sun.net.NetworkClient.openServer(NetworkClient.java:136)<br /> at psft.pt8.pshttp.https.HttpClient.openServer(HttpClient.java:543)<br /> at psft.pt8.pshttp.https.HttpClient.<init>(HttpClient.java:364)<br /> at psft.pt8.pshttp.https.HttpsClient.<init>(HttpsClient.java:76)<br /> at psft.pt8.pshttp.https.HttpsClient.newClient(HttpsClient.java:132)<br /> at psft.pt8.pshttp.https.HttpsClient.newClient(HttpsClient.java:100)<br /> at psft.pt8.pshttp.https.HttpsURLConnection.connect(HttpsURLConnection.java:468)<br /> at psft.pt8.pshttp.PSHttp.getResponseCode(PSHttp.java:423)<br /> at com.peoplesoft.pt.integrationgateway.targetconnector.HttpTargetConnector.send(HttpTargetConnector.java:858)<br /> at com.peoplesoft.pt.integrationgateway.service.BasicConnectorInvocator.execute(BasicConnectorInvocator.java:131)<br /> at com.peoplesoft.pt.integrationgateway.framework.GatewayManager.invokeService(GatewayManager.java:148)<br /> at com.peoplesoft.pt.integrationgateway.framework.GatewayManager.connect(GatewayManager.java:192)<br /> at com.peoplesoft.pt.integrationgateway.listeningconnector.PeopleSoftListeningConnector.doPost(PeopleSoftListeningConnector.java:186)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)<br /> at com.peoplesoft.pt.integrationgateway.listeningconnector.PeopleSoftListeningConnector.service(PeopleSoftListeningConnector.java:87)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)<br /> at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)<br /> at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)<br /> at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)<br /> at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)<br /> at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)<br /> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)<br /> at com.peoplesoft.pt.integrationgateway.common.IBFilter.doFilter(IBFilter.java:84)<br /> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)<br /> at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3456)<br /> at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3422)<br /> at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:323)<br /> at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)<br /> at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)<br /> at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2280)<br /> at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2196)<br /> at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)<br /> at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1632)<br /> at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256)<br /> at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)<br /> at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)<br />
<br />
<br />
PIA_stderr<br />
<br />
com.peoplesoft.pt.integrationgateway.common.ExternalSystemContactException: HttpTargetConnector:ExternalSystemContactException <strong>Received fatal alert: bad_certificate</strong><br /> at com.peoplesoft.pt.integrationgateway.targetconnector.HttpTargetConnector.send(HttpTargetConnector.java:1296)<br /> at com.peoplesoft.pt.integrationgateway.service.BasicConnectorInvocator.execute(BasicConnectorInvocator.java:131)<br /> at com.peoplesoft.pt.integrationgateway.framework.GatewayManager.invokeService(GatewayManager.java:148)<br /> at com.peoplesoft.pt.integrationgateway.framework.GatewayManager.connect(GatewayManager.java:192)<br /> at com.peoplesoft.pt.integrationgateway.listeningconnector.PeopleSoftListeningConnector.doPost(PeopleSoftListeningConnector.java:186)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)<br /> at com.peoplesoft.pt.integrationgateway.listeningconnector.PeopleSoftListeningConnector.service(PeopleSoftListeningConnector.java:87)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)<br /> at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)<br /> at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)<br /> at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)<br /> at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)<br /> at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)<br /> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)<br /> at com.peoplesoft.pt.integrationgateway.common.IBFilter.doFilter(IBFilter.java:84)<br /> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)<br /> at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3456)<br /> at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3422)<br /> at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:323)<br /> at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)<br /> at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)<br /> at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2280)<br /> at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2196)<br /> at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)<br /> at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1632)<br /> at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256)<br /> at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)<br /> at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)</div>
Ketan Kotharihttp://www.blogger.com/profile/17459077644208180243noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-71339476172261244492017-10-11T14:16:00.001-04:002017-10-13T19:25:56.923-04:00Automate download of patches from Oracle Support<p>If you need to download the patches or software from My Oracle Support, you can use the below utility available at Github</p> <p><a href="https://github.com/MarisElsins/getMOSPatch" target="_blank">getMOSPatch</a></p> <p>The Github site has instructions on how to use this utility.</p> <p>I have found some additional challenges when using this utility if you are behind a proxy. </p> <ul> <li>The way patch download process works is that you connect to MOS (support.oracle.com) using HTTPS for authentication and use http for actual file download. This requires you use the below command line argument to support for both http and https. The Github site readme only specifies using https, which works for authentication but fails to download the file.</li> </ul> <p>java -Dhttp.proxyHost=aaa.com -Dhttp.proxyPort=80 -Dhttps.proxyHost=aaa.com -Dhttps.proxyPort=80 -jar getMOSPatch.jar MOSUser=aaa@aaa.com MOSPass=aaa platform=226P download=all patch=26557153 <br /></p> <ul> <li>I have also found that the code uses (Line 144) conn.setReadTimeout(60000); which is 1 minute. I have found that this may not be sufficient for the busy sites and it fails with the following message.  To avoid this issue, I simply changed it to conn.setReadTimeout(6000000); – 100 minutes and used the below to recompile the jar file. </li> </ul> <p>Unzip the current jar to extract META-INF\MANIFEST.MF file to the folder where you store the java file. Also change the path to java. The below path are for Windows 8 and JDK 8. </p> <p>"C:\Program Files\Java\jdk8\bin\javac.exe" -bootclasspath "C:\Program Files\Java\jdk8\jre\lib\rt.jar" -source 1.6 -target 1.6 getMOSPatch.java </p> <p>"C:\Program Files\Java\jdk8\bin\jar.exe" cvmf META-INF/MANIFEST.MF getMOSPatch.jar getMOSPatch*.class</p> <p>del *.class</p> <p>Error Message if we do not change the <font style="background-color: rgb(255, 255, 255);" color="#ff0000">setReadTimeout</font></p> <p>Processing patch 26557153 for Linux x86-64 and applying regexp .* to the filenames: <br />  1 - p26557153_170151_Linux-x86-64.zip <br />  Enter Comma separated files to download: all <br />  All files will be downloadad because download=all was specified.</p> <p>Downloading all selected files: <br />  <strong>java.net.SocketTimeoutException: Read timed out</strong> <br />        at java.net.SocketInputStream.socketRead0(Native Method) <br />        at java.net.SocketInputStream.socketRead(Unknown Source) <br />        at java.net.SocketInputStream.read(Unknown Source) <br />        at java.net.SocketInputStream.read(Unknown Source) <br />        at java.io.BufferedInputStream.fill(Unknown Source) <br />        at java.io.BufferedInputStream.read1(Unknown Source) <br />        at java.io.BufferedInputStream.read(Unknown Source) <br />        at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source) <br />        at sun.net.www.http.HttpClient.parseHTTP(Unknown Source) <br />        at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source) <br />        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) <br />        at java.net.HttpURLConnection.getResponseCode(Unknown Source) <br />        at getMOSPatch.getHttpInputStream(getMOSPatch.java:146) <br />        at getMOSPatch.DownloadFile(getMOSPatch.java:171) <br />        at getMOSPatch.DownloadAllFIles(getMOSPatch.java:498) <br />        at getMOSPatch.main(getMOSPatch.java:540)</p>Ketan Kotharihttp://www.blogger.com/profile/17459077644208180243noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-87436023590121434002016-05-10T18:32:00.002-04:002016-05-10T18:32:30.649-04:00Applying latest Oracle Patch 22502456 Database Patch Set Update : 11.2.0.4.160419 for Oracle Run Time Client errors out<div dir="ltr" style="text-align: left;" trbidi="on">
When trying to apply patch 22502456 to Oracle Runtime client using latest OPatch version 11.2.0.3.12<br />it fails with the following error. This patch is also included in combo patch : 22738777 - COMBO OF OJVM COMPONENT 11.2.0.4.160419 DB PSU + DB PSU 11.2.0.4.1604 (APR2016)<br />
<br /><br />
Verifying environment and performing prerequisite checks...<br />Skip patch 20760982 from list of patches to apply: This patch is not needed.<br />UtilSession failed: null<br />Log file location: <br />
OPatch failed with error code 73<br />
Log file error shows this.<br />
[May 9, 2016 3:46:33 PM] OUI-67073:UtilSession failed: null<br />[May 9, 2016 3:46:33 PM] Finishing UtilSession at Mon May 09 15:46:33 EDT 2016<br />[May 9, 2016 3:46:33 PM] Log file location: /opt/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2016-05-09_15-46-25PM_1.log<br />[May 9, 2016 3:46:33 PM] Stack Description: java.lang.NullPointerException<br />[May 9, 2016 3:46:33 PM] StackTrace: java.lang.StringBuffer.<init>(StringBuffer.java:104)<br />[May 9, 2016 3:46:33 PM] StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:337)<br />[May 9, 2016 3:46:33 PM] StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2580)<br />[May 9, 2016 3:46:33 PM] StackTrace: oracle.opatch.OPatch.main(OPatch.java:634)<br />
<br /><br />
Oracle support is able to reproduce this issue however currently no workaround is provided.<br />
They have internally 2 bugs opened to address this issue.<br />
<br /><br />
Bug 22932939 -- OPATCH FAILS TO PATCH RUNTIME CLIENT ENVIRONMENTS <br />Bug 22740194 - INSTALLATION OF 11.2.0.4.7 AND LATER PSU FAILS IN RUNTIME CLIENT ENVIRONMENT<br />
<br /><br />
<br /></div>
Ketan Kotharihttp://www.blogger.com/profile/17459077644208180243noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-51499081582891837432016-01-18T13:13:00.000-05:002016-01-18T13:25:56.522-05:00Portal Home Page Displays Error : Error getting content for remote pagelet.<div style="border-image: none;">
<span style="font-size: large;">When you are logging on to a Portal Home Page which displays Remote pagelets, You get this error randomly.</span></div>
<br />
<br />
<div style="border-image: none;">
Error Message: <span style="font-family: "calibri";"><strong>Error getting content</strong></span></div>
<div style="border-image: none;">
<strong><span style="font-family: "calibri";"><br /></span></strong></div>
<div class="separator" style="border-image: none; clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-MyDlQdM37AY/Vp0syUQkn4I/AAAAAAAAAUY/9rTxR_MQBd4/s1600/error_getting_content.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="89" src="http://3.bp.blogspot.com/-MyDlQdM37AY/Vp0syUQkn4I/AAAAAAAAAUY/9rTxR_MQBd4/s320/error_getting_content.jpg" width="320" /></a></div>
<div style="border-image: none;">
<strong><span style="font-family: "calibri";"><br /></span></strong></div>
<br />
<br />
<div style="border-image: none;">
<strong><br /></strong></div>
<div style="border-image: none;">
<strong><br />
<span style="font-family: "calibri";"><br /></span></strong><span style="font-family: "calibri";"><br /></span><br />
<span style="font-family: "calibri"; font-size: large;">When you click on "<b>Detailed Error Description</b>", You will get this</span></div>
<span style="font-size: large;"><br /></span>
<strong><span style="font-size: large;">Unable to get document</span></strong><br />
<div style="border-image: none;">
<strong><span style="font-size: large;">Error occurred while accessing target page.</span></strong></div>
<div style="border-image: none;">
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-Z1JTbBj2xek/Vp0tk72nFCI/AAAAAAAAAUo/GGJ-MGegj_g/s1600/detailed_error_description..jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="157" src="http://2.bp.blogspot.com/-Z1JTbBj2xek/Vp0tk72nFCI/AAAAAAAAAUo/GGJ-MGegj_g/s320/detailed_error_description..jpg" width="320" /></a></div>
<br /></div>
<br />
<br />
<div style="border-image: none;">
<strong style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></strong><br /></div>
<br />
<br />
<div style="border-image: none;">
<span style="font-family: "calibri";"><br /></span></div>
<div style="border-image: none;">
<span style="font-family: "calibri";"><br /></span>
<span style="font-family: "calibri";"><br /></span>
<span style="font-family: "calibri";"><br /></span>
<span style="font-family: "calibri";"><br /></span>
<a href="https://www.blogger.com/" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><span style="font-family: "calibri"; font-size: large;">To see the further details, Please log in to your webserver and open the following log files. If you have more than 1 web server you may have to go to each web server to see the content.<br />
<br /><br />
Log File Location : $PS_CFG_HOME/webserv/peoplesoft/servers/PIA/logs (This is for PeopleTools 8.53 and higher). <br />
Log File Names are below<br />
PIA_servlets0.log.0<br />PIA_servlets1.log.0<br />PIA_servlets2.log.0<br />
<br /><br />
If you open any one of these log file, You will see the following<br />
<br /><br />
2000-01-07T11:47:21.185 9259 163517125 unknown SEVERE <strong>psft.pt8.psp</strong> logError Error for User: abc Error Message: <strong>Unable to get document</strong>: Requested URL: <a href="https://abc.com/">https://abc.com</a> Target URL: <strong>Error reading from server</strong><br />
<br /><br />
Resolution:<br />
If you do not have security issue or single signon issue, Please check the default HTTP Header size allowed by your Load balancer that you use for multiple webservers. In Case of Cisco ACE Loadbalancer default is : 4096 bytes. Increasing it to 32768 helps in resolving this issue. <br />
<br /><br />
For Cisco Ace this parameter is :
<br />
</span></div>
<div style="language: en-US; margin-bottom: 0pt; margin-left: 0in; margin-top: 0pt; text-indent: 0in;">
<span style="font-family: "calibri";"><span style="color: red; font-family: "calibri"; font-size: large;">set header-maxparse-length 32768</span></span></div>
<span style="font-size: large;"><span style="font-family: "calibri";">
</span>
</span><br />
<div style="language: en-US; margin-bottom: 0pt; margin-left: 0in; margin-top: 0pt; text-indent: 0in;">
<span style="font-family: "calibri";"><span style="color: red; font-family: "calibri"; font-size: large;"><br /></span></span></div>
<span style="font-size: large;"><span style="font-family: "calibri";">
</span>
</span><br />
<div style="language: en-US; margin-bottom: 0pt; margin-left: 0in; margin-top: 0pt; text-indent: 0in;">
<span style="font-family: "calibri";"><span style="color: red; font-family: "calibri"; font-size: large;">If you use a different Load balancer for e.g. F5 LTM then I believe the default is already 32768. You can contact your Load balancer vendor to determine the default HTTP Header size. </span></span></div>
<span style="font-family: "calibri";">
<br /><br />
<br /><br />
</span>
Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com1tag:blogger.com,1999:blog-20103408.post-47869384806529906172016-01-05T15:59:00.000-05:002016-01-05T16:06:53.715-05:00Upload image to Image Catalog<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "Trebuchet MS", sans-serif; font-size: small;">In PeopleTools 8.53 PeopleSoft has provided an online PIA page to upload the
images or modify an existing images without using App designer. This is really
helpful if you want to change an image, but do not want to migrate application
project just for updating the image.</span><br />
<span style="font-family: "Trebuchet MS", sans-serif;">
</span>
<span style="font-family: "Trebuchet MS", sans-serif;">Page name : Layout Image Upload</span><br />
<span style="font-family: "Trebuchet MS", sans-serif;">
</span>
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<br />
<div style="border-image: none;">
<span style="font-family: "Trebuchet MS", sans-serif;">Navigation : Main Menu>PeopleTools>Mobile Application Platform>MAP
Utilities>Layout Image Upload</span></div>
<span style="font-family: "Trebuchet MS", sans-serif;">
</span>
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<br />
<div style="border-image: none;">
<span style="font-family: "Trebuchet MS", sans-serif;">For some reason, Mobile Application Platform is hidden in Portal structure
and contents, but you can still access the Layout Image Upload page by
searching.</span> </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="file:///C:/Users/752141/AppData/Local/Temp/WindowsLiveWriter1286139640/supfiles64304F0/image[2].png" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-8MZ_6vXstC0/VowwX46ID5I/AAAAAAAAAUE/gfrHpRqOL1U/s1600/layout_image_upload.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="223" src="http://3.bp.blogspot.com/-8MZ_6vXstC0/VowwX46ID5I/AAAAAAAAAUE/gfrHpRqOL1U/s320/layout_image_upload.jpg" width="320" /></a></div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-4736157422778084602015-12-08T16:39:00.001-05:002015-12-08T16:39:06.353-05:00PeopleSoft Support of TLS 1.2 when connecting to LDAP/HTTP servers using LDAPS/HTTPS URLs<p>Currently all PeopleSoft PeopleTools releases including 8.55 only supports Java 1.7 for the Appserver. Java 1.7 by default only enables support for SSL 3.0 and TLS 1, though it supports both TLS 1.1. and TLS 1.2. They are not enabled by default. This is easy to fix for HTTPS connections by modifying JavaVM options the following parameter to Appserver (psappsrv.cfg) and Batch server (psprcs.cfg) config files</p> <p>JavaVM Options=-Dxdo.ConfigFile=%PS_HOME%/appserv/xdo.cfg -Xms32m -Xmx128m<strong> -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2 <br /></strong></p> <p>Once you modify the Parameter, simply restart the Appserver or batch server and it will take effect. There is no need to reconfigure the appserver or batch server.</p> <p>Please note this only work for HTTPS connections for e.g. when connecting to Integration Gateway Web server which only accepts TLS 1.1 or TLS 1.2 connections.</p> <p>To make this also work for LDAP or Directory server that is configured to accept only TLS 1.2 connections for compliance with <a href="https://www.pcisecuritystandards.org/documents/PCI_DSS_v3-1.pdf" target="_blank">PCI DSS v3.1</a> (mandatory after <strong>June 30 2016</strong>), a code change to $PS_HOME/appserv/classes/psft/pt8/pshttp/PSLdapSSLSocketFactory.class is required so that it uses TLSv1.2 instead of SSL for the below code line.</p> <p>SSLContext sslcontext = SSLContext.getInstance("SSL");</p> <p>needs to be changed to </p> <p>SSLContext sslcontext = SSLContext.getInstance("TLSv1.2");</p> <p>Currently there are no configuration parameters to fix this issue. Please open a support case with Oracle and reference the below bug number if you need the fix for this issue. <br /></p> <p>There is an open PeopleSoft bug to address this issue.</p> <p><b>22323376 - LDAP FAILS TO CONNECT TO LDAP SERVER USING TLS 1.2 to address this issue. </b></p> <p><strong>This will impact any PeopleSoft applications that are considered as PCI In scope applications and uses TLS 1.2 for Autnetication with LDAP Directory server using LDAPS protocol.</strong></p> <p><strong>You will see the following error in the Appserver when connecting to LDAP server using delivered Page.</strong></p> <p>[Root exception is javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake]</p> <p>Please note PeopleSoft uses JNDI to connect to LDAP Directory server via delivered Directory Interface Business interlink. </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com2tag:blogger.com,1999:blog-20103408.post-995129236925383742015-09-17T15:09:00.001-04:002015-09-17T15:09:00.994-04:00Global Database Link feature in Oracle 11G can result in Peoplesoft Signon Failure<p>If you use Oracle Internet Directory (OID) to resolve database names, then you have this feature enabled by default. With Global database link feature, users can access tables/view in other database using @dbname syntax even when there is no explicit database link is created. For e.g User A logged in to Database A using his personal id : XXXX can run the below query to access table in database b. Only thing that is needed to make this work is that password for the user A must be same in both database A and B.</p> <p>select * from <a href="mailto:ps_job@databaseb">ps_job@databaseb</a></p> <p>This may create a potential locking situation,if password in database are not synced up and there is an account lock policy implemented to lock account after x invalid attempts. As soon as user runs more than x sql statements using global database link feature, it will lock the account in database b. When you look at dba audit trail, you will see the connection attempt was made by oracle user and machine name will be of database server machine name. This makes it confusing to determine how this account got locked up. </p> <p>This is even more dangerous, if some one runs a SQR or Application engine program using peoplesoft process scheduler with a remotedbname sysntax for sql for e.g. <a href="mailto:ps_job@databaseb">ps_job@databaseb</a></p> <p>This is because, PeopleSoft process scheduler runs the sql using database access id in database A, which inurn access the database b using the access id password in Database A. Most likely you would keep the database access id password (default : SYSADM) different for different databases and this can potentially lock the sysadm password in database B due to account lock out policy. If this happens, users will see when trying to access the application</p> <p>“Bea.jolt.serviceexception: TPENOENT – No entry”</p> <p><a href="http://lh3.googleusercontent.com/-2LPQoMyrI-w/VfsPx5p6rtI/AAAAAAAAATM/ddUdnTcwDgA/s1600-h/image%25255B2%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh3.googleusercontent.com/-7aL9km5DI8s/VfsPyVpKNaI/AAAAAAAAATQ/buZRo_cCsQg/image_thumb.png?imgmax=800" width="244" height="179" /></a></p> <p>You can find more information on this at My Oracle Support</p> <p><b>What are Global Database Link and How do you Disable them? (Doc ID 1632329.1)</b></p> <p><a href="http://docs.oracle.com/cd/E11882_01/server.112/e25494/ds_concepts.htm#ADMIN02801">http://docs.oracle.com/cd/E11882_01/server.112/e25494/ds_concepts.htm#ADMIN02801</a></p> <p>If this happens in your environment, Please check if database access id is locked out. If yes, unlock the database access id and restart all your app and batch servers.</p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-31283236744765764742015-09-17T14:34:00.001-04:002015-10-22T11:22:51.412-04:00ios9 Safari PeopleSoft Pages appear zoomed<p>After the recent upgrade to iOS9 from iOS 8.4.1 on iPAd Air and iPhone 6, PeopleSoft pages appears zoomed and entire UI looks messed up using safari. Our PeopleTools environment is 8.53.12 and this is reproducible in multiple demo environments including HR and Portal 9.1. </p> <p>Stpes to reproduce the issue</p> <p>1. Login to HRMS 9.1/Portal 9.1 Demo instance using iPad or iPhone running iOS9 using Safari</p> <p>2. Open System Profile page</p> <p>Screenshot of the zoomed page. </p> <p><a href="http://lh3.googleusercontent.com/-lZ9a2MotMPY/VfsHvxmBvMI/AAAAAAAAASw/P1z6mv_OHBk/s1600-h/cdas_demo1_modified%25255B4%25255D.jpg"><img title="cdas_demo1_modified" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 0px 5px; display: inline; padding-right: 0px; border-top-width: 0px" border="0" alt="cdas_demo1_modified" src="http://lh3.googleusercontent.com/-d8oAVZwIEXM/VfsHwfyapbI/AAAAAAAAAS4/-dQd8_YHyUg/cdas_demo1_modified_thumb%25255B2%25255D.jpg?imgmax=800" width="293" height="228" /></a></p> <p><strong>Update from Oracle Support</strong></p> <p>This is a known issue tracked by</p> <p><strong><a href="https://support.oracle.com/rs?type=bug&id=21626379">Bug 21626379</a> - IOS 9 BETA 5: CLASSIC PAGES ARE NOT RENDERING PROPERLY</strong>.</p> <p>Apple Development is currently working on the issue</p> <p>Updates : Issue is not resolved even with release of 9.1 and according to apple support they are still investigating the issue and it will be fixed in some unknown future release. Meanwhile Oracle has provided the workaround. Please test carefully before applying the workaround.</p> <p>Please refer to following <strong>E-PIA Peoplesoft Classic Pages Are Not Rendering Correctly In IOS 9 (Doc ID 2057957.1)</strong></p> <p>for the workaround. It is different for 8.53 and below and 8.54 and above.  </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com3tag:blogger.com,1999:blog-20103408.post-27443815675931858972015-08-31T18:35:00.001-04:002015-08-31T18:37:00.946-04:00You are not authorized to access this component. (40 20)<p>You may see this error message, even if you have granted correct security. To resolve this please run the below sql. Open the role and delete the orphan permission list or remove the role from the user and issue will be fixed. </p> <p>This was happening as user has a role that had a permission list that did not existed in the database. This happens when the project is migrated to target database but does not include the permission list. </p> <p>non-existing permission list assigned to the role.</p> <p>Select R.rolename <br />, RC.classid <br />From psroleuser R <br />, psroleclass RC <br />Where RC.Rolename = R.Rolename <br />And not exists <br />(Select 'X' from psclassdefn C <br />Where C.classid = RC.classid) <br />And R.roleuser = '[--OPRID—]'</p> <p>Original Post appeared in : </p> <p><a href="http://eliandokp.blogspot.com/2010/02/component-error-you-are-not-authorized.html" target="_blank">http://eliandokp.blogspot.com/2010/02/component-error-you-are-not-authorized.html</a></p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com2tag:blogger.com,1999:blog-20103408.post-50562263150059857332015-04-13T16:02:00.001-04:002015-04-13T16:02:03.548-04:00Running a BI Publisher Report from an online page logs user out of PIA<p>When user runs a BI Publisher Report from an online PIA page by clicking a button and this report is based on a Query, user sees the below message.</p> <p><strong>An error has occurred. You may attempt to sign in again. If your attempt fails, please contract your System Administrator. <br /></strong>Please make sure Webserver and Appserver are up. null <br /></p> <p><a href="http://lh3.ggpht.com/-K7cELTGf3_Q/VSwgtx2TQXI/AAAAAAAAASA/6Cm5K1YZ4JU/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-ecTBW51JY-8/VSwguZvcU_I/AAAAAAAAASE/vCj_aJPdztk/image_thumb.png?imgmax=800" width="244" height="107" /></a></p> <p>In the Appserver Log, we see the error</p> <p>PSPAL: Abort: <strong>Unexpected signal received <br /></strong>PSPAL: Abort: Location: /vob/peopletools/src/pspal/exception_sigaction.cpp:494: RecoverableSignalHandler <br />PSPAL: Abort: Generating process state report to /opt/test/psft/pt/8.53/appserv/prd/LOGS/PSAPPSRV.10742/process_state.txt <br /></p> <p>Inside the process_state.txt, we see that RuntoFile is actually generating the exception and killing the appserver thread. </p> <p>#2  0x00007f7012a8f224 in <strong>PSPAL::</strong>DumpProcessState::GenerateAbortDiagnostics(char const*, <strong>PSPAL::</strong>ExceptionContext*) () from /opt/test/tools/bin/libpspal64.so    #3  0x00007f7012a8386b in <strong>PSPAL::</strong>Abort(char const*, char const*, int, char const*, <strong>PSPAL::</strong>ExceptionContext*) () from /opt/test/tools/bin/libpspal64.so <br />   #4  0x00007f7012a89191 in <strong>PSPAL::</strong>SigactionSignalHandler::RecoverableSignalHandler(int, siginfo*, void*) () from /opt/test/tools/bin/libpspal64.so <br />   #5  0x00007f7012a89a65 in <strong>PSPAL::</strong>SigactionSignalHandler::SignalHandler(int, siginfo*, void*) () from /opt/test/tools/bin/libpspal64.so <br />   #6  0x00007f6ff6e15f12 in os::Linux::chained_handler(int, siginfo*, void*) () from /opt/test/tools/jre/lib/amd64/server/libjvm.so <br />   #7  0x00007f6ff6e1bbf6 in JVM_handle_linux_signal () from /opt/test/tools/jre/lib/amd64/server/libjvm.so <br />   #8  <signal handler called> <br />   #9  0x00007f700f03619f in QpmEnd () from /opt/test/tools/bin/libpssys.so <br />   #10 0x00007f70088b7815 in CPSQuery::CleanupQueryExecution(void*, void*) () from /opt/test/tools/bin/libpsoftapi.so <br />   #11 0x00007f70088fa777 in <strong>CPSQuery::RunToFile</strong>(IPSRecBuf*, wchar_t const*, int, int) () from /opt/test/tools/bin/libpsoftapi.so <br />   #12 0x00007f70088c28fc in _IPSQuery::InvokeMethod(wchar_t const*, IPSApiVariant*, IPSApiVariant**, int) () from /opt/test/tools/bin/libpsoftapi.so</p> <p>Resolution: Please determine the Records used in PeopleSoft query that is used in BI Publisher Report definition. Please make sure that this record is added to permission list that belongs to the user running this report using Query tab in permission list component and accessing the Access group link. Once the permission list is modified add the permission list to the Role that is assigned to user if not already added. This resolves the issue. Noted this in PT 8.53.12. </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-15817177530168313182015-03-23T20:22:00.001-04:002015-03-23T20:22:21.222-04:00Enable support for SHA256 SSL Certificate in PeopleSoft using WebLogic Web server.<p>Note: This is applicable for mainly PeopleTools 8.53 and it may or may not work with lower PeopleTools (8.52 or lower) or higher PeopleTools 8.54. Also this pertains to WebLogic and may not be applicable for Web Sphere.</p> <p>WebLogic version used is 10.36.0</p> <p><strong>Step 1:</strong> Update the WebLogic to latest Patch Set update. If you already have WebLogic patch set update installed, you will need to uninstall it including one off patches and reinstall the latest Patch Set update for e.g. 10.3.6.0_10 for WebLogic 10.3.6. In case of WebLogic 10.3.6.0_10 please also apply the below one off patches to avoid SSLEngine is closed errors.</p> <p>Patch 19637463: SU Patch [12UV]: WLS PATCH SET UPDATE 10.3.6.0.10</p> <p>Patch 20674162: SU Patch [9UB4] :10.3.6.0.10 Overlay: MERGE REQUEST ON TOP OF WLS PSU 10.3.6.0.10 FOR BUGS 13244304 13371700 13405083 13869852</p> <p>Patch 16810786: SU Patch [SK1V]: MEMORY LEAK ON COM.CERTICOM.TLS.INTERFACEIMPL.CERTIFICATESUPPORT</p> <p><strong>Step 2 :</strong> Disable SSL3 support for WebLogic (This is optional but highly recommended step to avoid security issues).</p> <p>Add -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1 to JAVA_OPTIONS in setEnv.sh for appropriate OS you are using. For linux it is </p> <p>JAVA_OPTIONS_LINUX="-server -Xms1024m -Xmx1024m<strong> -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1</strong> -XX:MaxPermSize=256m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0"</p> <p>If you are using both Managed Server and Admin Server, search for below line</p> <p>#Changed the java min and max heap values for admin server</p> <p>and update the below</p> <p>Linux|LINUX)</p> <p>                    JAVA_OPTIONS="-server -Xms256m -Xmx256m <strong>-Dweblogic.security.SSL.minimumProtocolVersion=TLSv1</strong> -XX:MaxPermSize=128m -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0"</p> <p>Please note that once you do this any WebLogic utilities inclusing WLST (WebLogic Scripting tool), must add the below to Java command line invoking them</p> <p><strong>-Dweblogic.security.SSL.enableJSSE=true -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1</strong></p> <p>Otherwise you may see errors.</p> <p>Also you will need to Go to WebLogic Console –> Servers –> PIA, WebLogicAdmin –> SSL Tab –> Advanced and select Enable JSSE checkbox. </p> <p>Also you may want to upgrade to JRE or JDK 1.7.0_76 (or latest Oracle supported JRE / JDK for your weblogic server version).</p> <p>Step 3: Remove the bouncy castle JAR file from CLASSPATH by moving it from lib folder for each webserver.</p> <p>mv $PS_CFG_HOME/webserv/peoplesoft/applications/peoplesoft/lib/bcprov-jdk15-132.jar $HOME/tmp/</p> <p>If you do not do this WebServer becomes unresponsive or takes longer to respond. Connection Reset errors will be seen in Chrome/FireFox/IE/Safari browsers when you will be using any ECDHE cipher suites. </p> <p>Removing this Jar file, may impact some cryptographic functions though everything is working fine in our environment including webservice security. This is supposed to be part of wss4j-1.5.9.jar (Apache Web Services Security module) which is bundled with PeopleTools. This issue was observed in those web servers where we have enabled Integration broker gateway servers and use web services that involves security. </p> <p>Restart the WebLogic after all the changes are complete and SSL certificate is imported in pskey using pskeymanager.sh</p> <p>Also if there are any other applications are connecting to you using SSL or https, they will need to support SHA256 which in WebLogic 10.3.4 or higher is to enable JSSE support in WebLogic console or if your version is lower than 10.3.4 , use Sun HTTP Handler which automatically enables JSSE support.</p> <p>How to Change Weblogic to Use the Sun SSL Implementation Rather Than Certicom <br />(Doc ID 1242974.1)</p> <p>The SSL implementation and SSL Handler can be changed by setting the following flags on startup: <br />-Djava.protocol.handler.pkgs=com.sun.net.ssl.internal.www.protocol <br />-Dssl.SocketFactory.provider=com.sun.net.ssl.internal.SSLSocketFactoryImpl <br />-DUseSunHttpHandler=true <br />Also for Webservice clients, include: <br />-Dweblogic.wsee.client.ssl.usejdk=true</p> <p>In the end Test! Test! Test! that all of this works correctly.</p> <p>In summary supporting SHA256 support using WebLogic 10.3.6 or lower requires series of changes to make this work. Plan ahead and allocate enough resources to handle this migration. This will become important as major browsers will start flagging SHA1 certificates as insecure. </p> <p>Useful resources : <a href="http://www.ssllabs.com" target="_blank">http://www.ssllabs.com</a> and test your public website using their site scanner. Enable support for TLS 1.0, 1.1 and 1.2 and disable SSL 3.0 support in IE. For firefox/Chrome upgrade to latest version to automatically disable support for SSL 3.0.</p> <p>If you encounter specific issues related to SHA256 implementation with WebLogic and PeopleSoft leave comments and I can try to provide help. </p> <p>List of Bugs fixed in Patch Set Update - Doc ID 1942223.1</p> <p><strong>Some of the Error Messages I have encountered if settings are not correct are</strong></p> <p>javax.net.ssl.SSLKeyException: FATAL Alert:BAD_CERTIFICATE - A corrupt or unuseable certificate was received. (If JSSE is not enabled. Certicom SSL implementation does not support SHA256).</p> <p><a title="http://docs.oracle.com/cd/E23943_01/web.1111/e13707/ssl.htm#BABIJEJD" href="http://docs.oracle.com/cd/E23943_01/web.1111/e13707/ssl.htm#BABIJEJD" target="_blank">Enablig JSSE in WebLogic</a></p> <p><BEA-101104> <Servlet execution in servlet context "ServletContext@445892755[app:peoplesoft module:/ path: spec-version:2.5]" failed, java.io.IOException: SSLEngine is closed. at weblogic.socket.JSSEFilterImpl.checkCauseSSLEngineClosed(JSSEFilterImpl.java:383)</p> <p><BEA-101083> <Connection failure java.io.IOException: SSLEngine is closed at weblogic.socket.JSSEFilterImpl.checkCauseSSLEngineClosed(JSSEFilterImpl.java:385)</p> <p><BEA-000000> <weblogic.utils.net.SocketResetException: SSLEngine is closed>  at weblogic.socket.JSSEFilterImpl.checkCauseSSLEngineClosed(JSSEFilterImpl.java:431) only with Apple Safari Client when fetching CSS or Java Script using peoplesoft cs servlet.</p> <p>java.lang.RuntimeException: Could not generate DH keypair</p> <p>Caused By: java.security.InvalidAlgorithmParameterException: unknown curve name: 1.2.840.10045.3.1.7 <br />    at org.bouncycastle.jce.provider.JDKKeyPairGenerator$EC.initialize(Unknown Source) <br />    at sun.security.ssl.ECDHCrypt.<init>(ECDHCrypt.java:63) <br /></p> <p>To Enable SSL Debug options</p> <p># JAVA SSL DEBUG (in setEnv.sh) to troubleshoot SSL handshake issues.</p> <p>#JAVA_OPTIONS_LINUX="-server -Xms1024m -Xmx1024m -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1<strong> -Dssl.debug=true -Dweblogic.StdoutDebugEnabled=true -Dweblogic.security.SSL.verbose=true -Djavax.net.debug=all</strong> -XX:MaxPermSize=256m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0"</p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com2tag:blogger.com,1999:blog-20103408.post-3393143605803554422015-02-10T18:52:00.001-05:002015-02-11T18:19:02.814-05:00Application Designer Compare Report Slow<p>Recently After upgrade to People Tools 8.53 from PT 8.50, We have noticed that for a large project (611 items) compare report is running really slow taking more than 1 hour. This was even more slow (3 hours) if the database is located in remote data center. </p> <p>Since People Tools 8.51 , PeopleSoft added the ability to write compare reports to database tables which was really causing this slowness.</p> <p>If you are not planning to use the database tables to review compare reports, please do the following to speed the compare report process.</p> <p>Go to Compare and Report –> Options </p> <p>Select Report Option Tab and Uncheck Generate Output to tables. </p> <p><a href="http://lh4.ggpht.com/-q1LeGSxmO40/VNqZqqvrU4I/AAAAAAAAARQ/b0RcUXFEWGg/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-8t4_kEwQx7Q/VNqZrIu2i0I/AAAAAAAAARU/KTgnyij42HI/image_thumb.png?imgmax=800" width="244" height="222" /></a></p> <p>This fixed the issue. you can also truncate the below tables if you do not need to store the previous version of compare reports.</p> <p>truncate table PSCOMPDEFN; <br />truncate table PSCOMPITEM; <br />truncate table PSCOMPITEMDATA; <br />truncate table PSCOMPSESSION; <br />truncate table PSCOMPOBJDIFF; <br />truncate table PSCOMPOBJLONG;</p> <p>The first 3 tables are no longer used in PT 8.54</p> <p>MOS (My Oracle Support Articles)</p> <p>E-UPG PT8.51+: Are Tables Updated with Compare Report Data? (Doc ID 1290456.1)</p> <p>E-COMP: Generate Output To Tables Option Not Writing Results To The Tables In 8.54 (Doc ID 1958074.1)</p> <p>E-PUM: How to Improve Performance on Step "Comparing ADS MO Project From File" (Doc ID 1965298.1)</p> <p>Also you can export the configuration manger config file and add the following under PSIDE section below after line : UpgXmlOutput=REG_DWORD=0</p> <p><strong>UpgTblOutput=REG_DWORD=0</strong></p> <p>You can then use this config file to install other workstations with same configuration. </p> <p>Alternatively, you can add the below to a notepad and save as psidecompare.reg and ask user to run it manually to change the setting. </p> <p>Windows Registry Editor Version 5.00</p> <p>[HKEY_CURRENT_USER\Software\PeopleSoft\PeopleTools\Release8.40\PSIDE] <br />"UpgTblOutput"=dword:00000000 </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-62062934728311823592015-01-26T19:29:00.001-05:002015-03-12T15:04:07.245-04:00IE9 Save As or Save Target As not working after applying update KB3008923 on Windows 7 SP1 64 Bit machine<p>Update : After applying the Latest Cumulative Security Update <a href="http://support.microsoft.com/en-us/kb/3032359" target="_blank">KB3032359 - MS15-018: Cumulative security update for Internet Explorer: March 10, 2015</a> Save As is working fine again. Also this resolves IE9 Freak Vulnerability as well.  </p> <p>If you have applied the update KB3008923 , you may not be able to open any Microsoft office document (doc, docx, xls, xlsx, ppt, pptx) etc. Also If you try to download a software and try to use <strong>Save As</strong> option from the toolbar, it does not work. If you right click on a link and Select <strong>Save Target As</strong> that also does not work. </p> <p><a href="http://lh5.ggpht.com/-ISKM-6kWzns/VMbb_RUlC-I/AAAAAAAAAQo/k_DW-xUyFuQ/s1600-h/image%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px 0px 5px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-lV6croEh2S8/VMbb_0j-iqI/AAAAAAAAAQw/gL3H3pIRgOs/image_thumb%25255B1%25255D.png?imgmax=800" width="307" height="37" /></a></p> <p>This issue is not mentioned on the Microsoft site <a title="http://support.microsoft.com/kb/3008923" href="http://support.microsoft.com/kb/3008923">http://support.microsoft.com/kb/3008923</a> </p> <p>Though they recommend manually applying update KB3025945 (</p> <p><a href="http://support.microsoft.com/kb/3025945">http://support.microsoft.com/kb/3025945</a>) to resolve IE9 Crash issue, it does not fix the issue. </p> <p>To resolve the issue, I have to uninstall both KB3025945 and KB3008923 and once I did that everything started working normally. I would advise not to install this update till Microsoft come up with a replacement fix using windows update. </p> <p>This will impact PeopleSoft Excel Query download functionality any word document download. </p> <p>To uninstall the update, go to Control Panel and Search for “Installed updates” and Select View Installed Updates under Programs and Features </p> <p><a href="http://lh3.ggpht.com/-UJqCZn1kGoE/VMbcATjfRDI/AAAAAAAAAQ0/835Y93lBMR4/s1600-h/image%25255B7%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-siPiZvz9VUE/VMbcA41gG2I/AAAAAAAAARA/F710OOH7k8E/image_thumb%25255B3%25255D.png?imgmax=800" width="244" height="51" /></a></p> <p>In the Search dialog at the top right type KB3025945 first and then KB3008923 and select uninstall  after right clicking on the selected update. You will need to restart the machine after each update is uninstalled. </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-17501212706390073842015-01-26T13:34:00.001-05:002015-01-26T13:34:35.784-05:00(NET.334): Tuxedo cannot find the service RunAeAsync2. Make sure the application server advertising this service is booted.<p>If your users are calling and telling you that App engine processes are remaining in initiated status for longer time ( > 5 minute) and you observe the following message. (Assuming PSAESRV is configured)</p> <p>in the $PS_CFG_HOME/appserv/prcs/<domain>/LOGS folder for SCHDLR_MMYY.LOG you will see the message</p> <p>(NET.334): Tuxedo cannot find the service RunAeAsync2.  Make sure the application server advertising this service is booted. <br /></p> <p>To see all files that has this message</p> <p>grep NET.334 SCHDLR*.LOG | cut -d : -f 1 | sort -u</p> <p>Please note the number at the end of RunAeAsync. It could be 1 thru n depending on number of PSAESRV configured. What this message means that the PSAESRV and number at the RunAeSync is not running for e.g. in this case PSAESRV that provides service RunAeSync2 is not running. </p> <p>You will also see in the same folder for TUXLOG.MMDDYY the following message</p> <p>010135.abc.com!restartsrv.16887.414156544.-2: server AESRV/2: CMDTUX_CAT:1684: ERROR: Application initialization failure</p> <p>010135.abc.com!restartsrv.16887.414156544.-2: server AESRV/2: CMDTUX_CAT:587: INFO: Cannot restart server, scheduling for cleanup</p> <p>grep CMDTUX_CAT:1684 TUXLOG.*</p> <p><strong>Resolution</strong></p> <p>What this means is that for some reason PSAESRV has crashed and Tuxedo restart process is not able to restart PSAESRV process. </p> <p>You have 2 option 2 fix the issue.</p> <p>Option 1 : Shutdown and Restart the server</p> <p>Option 2: Manually start the PSAERV process using command line without shutting down and restarting the server.</p> <p>Option 2 is preferred, if you have other PSAESRV processes running in process monitor that will be killed if you try to stop the process scheduler.</p> <p>Start PSADMIN (cd $PS_HOME/appserv; ./psadmin)</p> <p>Select 2 for process Scheduler</p> <p>Select 1 for Administer a domain</p> <p>Select 1for appropriate Process Scheduler Domain</p> <p>Select 5 for TUXEDO command line (tmadmin)</p> <p>Type</p> <p>boot -g AESRV -i 1</p> <p>(Change -I 1 to appropriate number for PSAESRV process that crashed Determined from the number at the end of RunAeSync). </p> <p>Observed this issue in PeopleTools : 8.53.12 and Linux : Red Hat 6.3 64 bit.</p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com2tag:blogger.com,1999:blog-20103408.post-11980066310471884822015-01-14T18:29:00.001-05:002015-01-14T18:29:54.365-05:00Unable to find a Routing Corresponding to the incoming Request Message (158,505)<p>When testing a WSDL or WADL you are getting the above message in the output Unable to find a Routing Corresponding to the incoming Request Message (158,505). for e.g. after publishing the WSDL for Soap or WADL for Rest, you try to view the WSDL or WADL and get the above message.  </p> <p>1. Make sure that GETWADL and GETWSDL Service Operation which is part of IB_UTILITY Service is active and has any to local routing defined and active. Once you add the missing routing, Go to Routing Definition and Select Parameter Tab and make sure that External alias is exactly GetWADL for GETWADL and GetWSDL for GETWSDL. If it is anything other for e.g. GETWADL or GETWADL.V1 it will not work. </p> <p><a href="http://lh3.ggpht.com/-uSt5g83X_F4/VLb7uU4DmjI/AAAAAAAAAQA/TPfIzYyhrCA/s1600-h/image%25255B5%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-uL_KIM0Jz88/VLb7u0gThlI/AAAAAAAAAQE/Npe4PCbJpTU/image_thumb%25255B1%25255D.png?imgmax=800" width="244" height="232" /></a></p> <p><a href="http://lh3.ggpht.com/-A5alzR9-jTs/VLb7vOmsxmI/AAAAAAAAAQM/oCQS4nQifUk/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-ajGa0wvqv2I/VLb7vgDddzI/AAAAAAAAAQU/_R4EN7Kcchw/image_thumb.png?imgmax=800" width="244" height="232" /></a></p> <p>See following My Oracle Support Resolutions 1949257.1 and 1572531.1 for more information.</p> <p>Sample URL to view WADL and WSDL are</p> <p>WADL (REST)</p> <p><a href="http://piahostname.com/PSIGW/RESTListeningConnector/PSFT_PA/PTCS_SECURITY.1.wadl">http://piahostname.com/PSIGW/RESTListeningConnector/PSFT_PA/PTCS_SECURITY.1.wadl</a></p> <p>WSDL (SOAP) <br /><a href="http://piahostname.com/PSIGW/PeopleSoftServiceListeningConnector/PSFT_PA/PTCS_SECURITY.1.wsdl">http://piahostname.com/PSIGW/PeopleSoftServiceListeningConnector/PSFT_PA/PTCS_SECURITY.1.wsdl</a> <br /></p> <p>To find out which WSDL or WADL are published to  WSDL Repository, Do the following Select.</p> <p>select * from PSIBWSDLDFN;</p> <p>Note: This is tested in 8.53.09 and 8.53.12 but may be valid for other PeopleTools version as well. </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com2tag:blogger.com,1999:blog-20103408.post-90627147138357577972014-11-03T14:43:00.001-05:002014-11-03T14:43:23.982-05:00Deleting Rows in ExcelToCI<p>Go to <a title="http://www.cedarhillsgroup.com/knowledge-base/kbarticles/deleting-rows-in-exceltoci" href="http://www.cedarhillsgroup.com/knowledge-base/kbarticles/deleting-rows-in-exceltoci">http://www.cedarhillsgroup.com/knowledge-base/kbarticles/deleting-rows-in-exceltoci</a> 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 <strong>UPDATEDATA</strong> in Connect Information worksheet of ExcelToCI</p> <p>In Summary, Go to Tools | Macros | Visual Basic Editor</p> <p>Open StagingAndSubmission Module and Navigate to WriteCollectionHeader function do the following.</p> <p>You will see a case statement “Select Case lScrollLevel”</p> <p>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. </p> <p>sXmlLine = sIndent & "<" & sXmlTag & ">" </p> <p>To</p> <p>sXmlLine = sIndent & “<” & sXmlTag & " CINodeAction=""DELETE"">" </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com4tag:blogger.com,1999:blog-20103408.post-80737775201777231522014-10-14T12:15:00.001-04:002014-10-14T12:15:53.139-04:00Unable to Select or Edit a Field on a Page in Application Designer<p>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</p> <p>Home -> PeopleSoft PeopleTools 8.53 -> PeopleSoft Application Designer Developer’s Guide -> Understanding Page Controls -> Data Entry Controls</p> <p>Note: PeopleSoft Application Designer allows you add up to <strong>405 fields</strong> 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. <br /></p> <p>Below PeopleSoft resolution describes the same issue which is there since Version 8.2</p> <p>E-AD Is there any limit on the number of fields on a Page Definition ( Doc ID 648823.1 ) </p> <p>Using Sub pages is the easiest way to resolve this issue. However this require changing the code. </p> <p>The below query can be used to identify any such pages</p> <p>select pnlname,count(*) from pspnlfield group by pnlname order by count(*) desc</p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-58867130029977137872014-09-11T20:04:00.001-04:002014-09-11T20:04:15.589-04:00Integration Network WorkCenter Incorrect Formatting after PeopleTools upgrade<p>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.</p> <p>Screenshot of incorrect formatting.</p> <p><a href="http://lh4.ggpht.com/-zlZFbRwCQII/VBI4ezgaMbI/AAAAAAAAAPc/81GruXwKCNY/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-TjjDQ35tFDQ/VBI4ffIKOKI/AAAAAAAAAPg/WAYQv_SfuuE/image_thumb.png?imgmax=800" width="237" height="244" /></a></p> <p>select * from PSSTYLECLASS a where a.stylesheetname = 'PSSTYLEDEF_SWAN'  and a.styleclassname not in (Select b.styleclassname from  PSSTYLECLASS b <br />where   b.stylesheetname = 'PREFIX_PSSTYLEDEF_SWAN_PT850')</p> <p>minus <br />select * from PSSTYLECLASS a where a.stylesheetname = 'PSSTYLEDEF_SWAN'  and 'PREFIX_' || a.styleclassname || '_PT850'  in (Select  b.styleclassname   from  PSSTYLECLASS b <br />where   b.stylesheetname = 'PREFIX_PSSTYLEDEF_SWAN_PT850')</p> <p>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.</p> <p>STYLECLASSNAME</p> <p>----------------------</p> <p>PSAVSCHART</p> <p>PSCHARTGANTT</p> <p>PSCHARTSTYLE_FREEFORM</p> <p>PTAL_SUBSTYLE_REQ_SWAN</p> <p>PTAL_SUBSTYLE_VL_SWAN</p> <p>PTWC_SUBSTYLE_SWAN</p> <p>PT_ACE_SS1_SWAN</p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-41769870489164178122014-09-11T17:21:00.001-04:002014-09-11T17:21:26.073-04:00Unified Navigation WorkCenter error<p>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.</p> <p>Navigation : Portal Administration –> Unified Navigation WorkCenter</p> <p>.arrowlistmenu{width:320px;} .arrowlistmenu .menuheader{font: 10px Arial;color: black;background-color: #FDFDFE;padding: 1px 0px 5px 5px;margin-bottom:2px;cursor: hand;cursor: </p> <p><a href="http://lh6.ggpht.com/-eiVhiXuXzHQ/VBISTuM13-I/AAAAAAAAAO4/fQpR6zAb8y8/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-VtbtjP1oDZ0/VBISUQ8aOXI/AAAAAAAAAPA/NJJ4S6DKw6A/image_thumb.png?imgmax=800" width="244" height="197" /></a></p> <p>To fix this issue , Go to Portal Administration –> Pagelets –> Pagelet Wizard –> Pagelet Wizard</p> <p>Open Pagelet ID : PAPP_EPPUN_UNPGLT </p> <p>Navigate to Step 4 Select Display Format and Select Radio button Passthru. It is currently Custom</p> <p><a href="http://lh5.ggpht.com/-ABRVFR1mgqU/VBISUg_0bvI/AAAAAAAAAPE/0vC9GQMUjH8/s1600-h/image%25255B5%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-RTkgUKETP4s/VBISVK4awPI/AAAAAAAAAPM/XQr1IAqFs5s/image_thumb%25255B1%25255D.png?imgmax=800" width="244" height="131" /></a></p> <p>Click Next (Step 5 of 6) and Press Save. </p> <p>Retest the Unified Navigation WorkCenter link. The issue should be resolved now. </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com1tag:blogger.com,1999:blog-20103408.post-34831726804818201832014-08-22T16:37:00.001-04:002014-08-22T16:37:20.974-04:00Running Delivered and Custom App Engine Process using PSAE command line crashes when terminating.<p>Application Engine program XXX ended normally</p> <p>15339: 1404097409: PSPAL::Abort: Unexpected signal received <br />15339: 1404097409: PSPAL::Abort: Location: /vob/peopletools/src/pspal/exception_sigaction.cpp:494: RecoverableSignalHandler <br />15339: 1404097409: PSPAL::Abort: Generating process state report to /opt/pshome/logs/psae.15339/process_state.txt <br />15339: 1404097409: PSPAL::Abort: Terminating process now. <br /></p> <p>On examining the process_state.txt, found the following</p> <p>(Looking for PSPAL::)</p> <p>#9  0x00007f18e0e52c3b in STWGCTimer::register_gc_start(long) () from /opt/tools/jre/lib/amd64/server/libjvm.so <br />#10 0x00007f18e117d8a8 in PSScavenge::invoke_no_policy() () from /opt/tools/jre/lib/amd64/server/libjvm.so <br />#11 0x00007f18e117ef21 in PSScavenge::invoke() () from /opt/tools/jre/lib/amd64/server/libjvm.so <br />#12 0x00007f18e1136020 in ParallelScavengeHeap::failed_mem_allocate(unsigned long) () from /opt/tools/jre/lib/amd64/server/libjvm.so <br /></p> <p>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. </p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com0tag:blogger.com,1999:blog-20103408.post-91345026270918710772014-08-21T10:54:00.001-04:002014-09-17T11:14:56.429-04:00Application Designer Page not responding<p>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. </p> <p>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. </p> <p>Oracle Support was able to replicate this issue and opened a new <a href="https://support.oracle.com/epmos/faces/BugDisplay?id=19492406">Bug 19492406</a> - APP DESIGNER GOES INTO NOT RESPONDING STATE WHEN MOVING A PAGE FIELD . </p> <p>There is also a BUG 18773369 and 19565638  related to this issue. </p> <p>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. </p> <p>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.</p> <p>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. </p> <p>Patch name : 19531601 and POC is POC-913314-02.</p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com3tag:blogger.com,1999:blog-20103408.post-83227860233038963432014-07-23T10:45:00.001-04:002014-07-23T10:45:00.794-04:00Error in Breadcrumb Update function, doBcUpdate: QuotaExceededError: DOM Exception 22 when using iPhone<p>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. </p> <p><a href="http://support.apple.com/kb/HT1677?utm_source=Agillic%20Dialogue">iPhone/iPad Turn on-off Private Mode</a></p> <p>Following My Oracle Support article describes this issue.</p> <p>E-PIA : Breadcrumb Throws Exception Error When Private Browsing Is On In Safari (Doc ID 1645653.1) </p> <p>This issue happens in PT 8.51 or higher and I have seen it happening in 8.53.12.</p> Ketan Kotharihttp://www.blogger.com/profile/10913617270577983259noreply@blogger.com2