Report Manager pointing to a different environment after database refresh

The link on the List tab in Report Manager comes from PSRF_REPORT_URL field in PSRF_RINFO_TBL. This field gets populated when you run a report and it is posted to report manager. The API that populates the field uses URI_RPT field value in PS_CDM_DIST_NODE table which stores all the report node related setup data to generate a url to access the report. Unfortunately, this field is not on the report node setup page and can easily be overlooked. If you have multiple report node definitions make sure to update this field for all of them in your refresh scripts. Also, If you make some changes to the report node definition this URI_RPT field get updated with the correct value.


P.S.: Applies to Tools 8.49. I have not looked into other releases

Weblogic as a web service

Weblogic won't start as a service? Here are a few steps to make it work

•  Open up registry editor
•  Navigate to HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > services >  HRDEV-PIA (your service name here) > Parameters
•  Double click on CmdLine and paste " -server -Xms256m -Xmx256m -XX:MaxPermSize=128m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -classpath ";foobar,D:/Psoft/HRDEV\webserv\HRDEV\lib\ps_patch.jar;D:/Psoft/HRDEV\webserv\HRDEV\applications\peoplesoft\PSIGW\WEB-INF\lib\mail.jar;D:/Psoft/HRDEV\webserv\HRDEV\lib\portlet-api-1.0.jar;D:/Psoft/HRDEV\webserv\HRDEV\lib\pluto-1.0.1.jar;D:/Psoft/HRDEV\webserv\HRDEV\applications\peoplesoft\PORTAL\WEB-INF\lib\saaj.jar;D:/Psoft/HRDEV\webserv\HRDEV\applications\peoplesoft\PORTAL\WEB-INF\lib\xml-apis.jar;D:/Psoft/HRDEV\webserv\HRDEV\applications\peoplesoft\PORTAL\WEB-INF\lib\xercesImpl.jar;;C:\bea\patch_weblogic920\profiles\default\sys_manifest_classpath\weblogic_patch.jar;C:\bea\jdk150_04\lib\tools.jar;C:\bea\WEBLOG~1\server\lib\weblogic_sp.jar;C:\bea\WEBLOG~1\server\lib\weblogic.jar" -Djava.util.logging.config.file=D:\Psoft\HRDEV\webserv\HRDEV\applications\peoplesoft\logging.properties -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Dweblogic.Name=PIA -Dweblogic.management.username=operator -Dweblogic.ProductionModeEnabled=true -Dps_vault=D:\Psoft\HRDEV\webserv\HRDEV\psvault -Djava.security.policy="C:\bea\WEBLOG~1\server\lib\weblogic.policy" -Dssl.debug=false -Dps_home=D:/Psoft/HRDEV  weblogic.Server"
• Double click on path and paste  "C:\bea\WEBLOGIC92\server\bin;C:\bea\WEBLOGIC92\server\native\win\32;C:\bea\jdk150_04\bin;D:/Psoft/HRDEV\bin\server\winx86;D:/Psoft/HRDEV\verity\winx86\_nti40\bin"
• Make directory changes as per your configuration
• I have seen the error when path is abbreviated

 

Publishing Web Service and WSDL issue

if you get "PeopleSoft TargetConnector: Unable to decrypt the password" when trying to access WSDL means that the web server does not know of the default app server. Make sure the integration.properties file has the default app server information. If your setup involves multiple web servers, update the file on all of the web servers

Installing PeopleSoft on Linux (OLE6 / Fedora 17)

Here are some of the issues I came across when installing PeopleSoft in Linux Environment

Issue: libjvm.so not found. Process Scheduler won't post to report repository and gateway connectors won't load
Resolution: environment variable LD_LIBRARY_PATH did not have jre in it. Make sure to add it. In my case it was $PS_HOME/jre1.6.0/lib/amd64/server. One very important thing to remember is to reconfigure process scheduler and App server both after making the environment variable change.

**********************************************************************************