Rakesh Parwal's PeopleSoft Admin Blog

tag:blogger.com,1999:blog-3325858952880134720Thu, 16 Feb 2012 13:03:53 +0000XMLPIntegration BrokerImportant LinksPS CommandsProcess SchedulerGeneralPsCA - PsCIACOBOLCompare ReportOracle DatabaseSQLs in PSUnix in PSOracle Open WorldAS - PRCS - WSShell Scripting in PeopleSoftInformationSQRTroubleShootingRakesh Parwal's PeopleSoft Admin Bloghttp://peoplesoft-admin.rakeshparwal.com/noreply@blogger.com (rakesh.parwal)Blogger43125tag:blogger.com,1999:blog-3325858952880134720.post-3371392314054363149Mon, 18 Apr 2011 05:42:00 +00002011-04-18T11:16:13.005+05:30Off From BloggingTaking Off From Blogging. Will resume later in couple of years.http://peoplesoft-admin.rakeshparwal.com/2011/04/off-from-blogging.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-5958027257247605858Thu, 23 Sep 2010 05:37:00 +00002010-09-23T11:25:08.086+05:30XMLPGeneralXMLP Report Generation and Download IssueThere were two issues reported by user recently related to XMLP: 1) Suddenly XMLP Reports were not getting generated 2) Also, user is not able to download the existing templateApp Server Log file shows following error messages while generating an XMLP Report:Output Xliff file: XDOException:No source available for parsingDuring calling method PTRTFPocessor.generateXSL, the XDO engine throws an http://peoplesoft-admin.rakeshparwal.com/2010/09/xmlp-report-generation-and-download.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-5773763171424380269Mon, 13 Sep 2010 14:13:00 +00002010-09-13T20:08:12.982+05:30AS - PRCS - WSMaybe FIELDTBLS32 is not set properlyIt's been such a long time since my last post - was/am too busy to post new learnings, will now try to be bit more regular :)In Tuxedo 9.1 in PeopleTool 8.49 recently encountered with an issue where WebServer was not able to connect to the App Server - even though App Server was up. While checking the TUXLOG, following message was found:093006.!JSH.26507.1.-2: JOLT_CAT:1198: "WARN: Forced http://peoplesoft-admin.rakeshparwal.com/2010/09/maybe-fieldtbls32-is-not-set-properly.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-1145331755198555011Thu, 15 Oct 2009 04:37:00 +00002009-10-15T10:17:02.321+05:30Oracle Open WorldOracle Open World 2009Today is the last day of Oracle Open World 2009. Some exciting bloggers have taken time to keep us updated on this. You may wish to visit them for sure:Grey Sparling BlogGraham's PeopleSoft Blog PeopleSoft Corner BlogPeopleSoft WisdomArun Gupta's Miles to go...Official Oracle OpenWorld Bloghttp://peoplesoft-admin.rakeshparwal.com/2009/10/oracle-open-world-2009.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-144484494385037937Mon, 12 Oct 2009 08:34:00 +00002009-10-12T14:08:52.225+05:30AS - PRCS - WSTroubleShootingApp Server boot problem - PSCLOCKLast week I faced an issue while trying to boot the application server. I checked for all the common things that could have caused the problem like password, connectivity, path etc. But everything looked well. I configured the app server for SQL trace and issued the boot command.From trace file, it was observed that the app server boot was stuck up at SELECT CURRENT TIMESTAMP FROM PSCLOCK commandhttp://peoplesoft-admin.rakeshparwal.com/2009/10/app-server-boot-problem-psclock.htmlnoreply@blogger.com (rakesh.parwal)2tag:blogger.com,1999:blog-3325858952880134720.post-2864590111900680573Wed, 03 Jun 2009 10:38:00 +00002009-06-03T16:40:45.419+05:30InformationPeopleTools 8.50 RVP AvailableFYI, Oracle has made available PeopleTools 8.50 RVP (Release Value Propositions) - Click Here to read the Oracle blog.Some notable PeopleTools 8.50 Enhancements are: Partial Page Refreshes using AJAX technology Menu Navigation (menu 2.0) by providing a new AJAX-enabled left navigation menu pagelet Search Page Enhancements by providing an option to specify the maximum number of rows returnedChangehttp://peoplesoft-admin.rakeshparwal.com/2009/06/peopletools-850-rvp-released.htmlnoreply@blogger.com (rakesh.parwal)1tag:blogger.com,1999:blog-3325858952880134720.post-2613114809168842043Thu, 28 May 2009 10:42:00 +00002009-05-28T16:20:37.213+05:30AS - PRCS - WSGeneralProcess SchedulerPROCESS GROUPProcess group is crucial in securing the processes and jobs in the system. It is possible to restrict access to certain processes within PeopleSoft by establishing process groups. A batch process is assigned a 'Process Group' when created. That 'Process Group' is then linked to a permission list (PL). The PL is then assigned to a 'Role' and, subsequently, to a USERID. Process groups are http://peoplesoft-admin.rakeshparwal.com/2009/05/process-group.htmlnoreply@blogger.com (rakesh.parwal)1tag:blogger.com,1999:blog-3325858952880134720.post-7909316515035358917Wed, 27 May 2009 14:38:00 +00002009-05-27T20:32:41.045+05:30GeneralPsCA - PsCIAPsCIA - PeopleCode & File Pre-ProcessorsDDL for Tables created by PeopleCode & File Pre-Processors:You must run the PeopleCode pre-processor to generate the database tables that Change Impact Analysis reads and analyzes.The PeopleCode pre-processor generates two tables:• PSCIAPCXREF• PSCIAPCXREFTIMEYou must have permission to create, delete from and write to these files. If you have full privileges, you can create these files prior to http://peoplesoft-admin.rakeshparwal.com/2009/05/pscia-peoplecode-file-pre-processors.htmlnoreply@blogger.com (rakesh.parwal)1tag:blogger.com,1999:blog-3325858952880134720.post-8119694700450600398Wed, 27 May 2009 14:24:00 +00002009-08-11T09:26:40.338+05:30PeopleTools TablesA quick guide to PeopleTools Tables:Projects:* PSPROJECTDEFN — Project header table* PSPROJECTITEM — Definitions in the projectFields:* PSDBFIELD — Fields in the system• PSXLATITEM — Translate ValuesRecords:* PSRECDEFN — Record header table* PSRECFIELD — Fields in the record (subrecords not expanded)* PSRECFIELDALL — Fields in the record (subrecords expanded)* PSKEYDEFN — IndexesPages - (Named ashttp://peoplesoft-admin.rakeshparwal.com/2009/05/peopletools-tables_27.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-2125001136605341558Mon, 23 Feb 2009 14:21:00 +00002009-02-23T21:21:09.522+05:30Integration BrokerGeneralConfiguring Report Manager - List/ExplorerHere I'll try to describe an approach to setup Report Manager - List/Explorer in PeopleTools 8.48. This is not a compherensive explaination... It, however, may help you understand basic approach.Report Manager is a utility in PeopleSoft to view Reports from a different place than Process Monitor. Navigation: Reporting Tools -> Report Manager. It has fours pages: List, Explorer, Administration andhttp://peoplesoft-admin.rakeshparwal.com/2009/02/configuring-report-manager-listexplorer.htmlnoreply@blogger.com (rakesh.parwal)5tag:blogger.com,1999:blog-3325858952880134720.post-8002178169305413602Fri, 13 Feb 2009 10:56:00 +00002009-05-13T18:40:31.927+05:30COBOLGeneralCOBOL - Configuring instance specific CBLBINs - Contd...In continuation to previous blog: COBOL - Configuring instance specific CBLBINs, I would like to state an interesting problem I encountered with the configuration of instance specific CBLBINs. The problem was with a RemoteCall made to a COBOL program from an App Engine.Payroll Interface app engine program PI_INRUN was going into "No Success" with message of COBOL program PIPINRUN abort. To dig http://peoplesoft-admin.rakeshparwal.com/2009/02/cobol-configuring-instance-specific.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-1695055321574797340Fri, 06 Feb 2009 06:55:00 +00002009-02-06T17:03:46.524+05:30GeneralPsCA - PsCIAChange AssistantDownload this document - (.doc) or (.pdf)Change Assistant Introduction Change Assistant (CA) was first released in PeopleTools 8.44. Change Assistant (CA) automates many task for applying any bundle, maintenance pack etc. Some benefits of using CA are:- CA can find out bundles/MPs that have already been applied to a PeopleSoft Database- CA can figure out Bundles/MPs that need to be applied- CA http://peoplesoft-admin.rakeshparwal.com/2009/02/download-document-change-assistant.htmlnoreply@blogger.com (rakesh.parwal)45tag:blogger.com,1999:blog-3325858952880134720.post-8507571255020020053Tue, 03 Feb 2009 06:48:00 +00002009-02-03T14:29:54.171+05:30Oracle DatabaseGeneralImportant LinksOracle MagazineMany of you might find Oracle Magazine quite useful to keep you updated with the Oracle Database happenings... Here are the links:http://www.oracle.com/oramag/index.htmlhttp://www.oraclemagazine-digital.com/oraclemagazine/20090102/?sub_id=eKu28DLN3USDhttp://www.oraclemagazine-digital.com/oraclemagazine/20081112/?sub_id=eKu28DLN3USDhttp://peoplesoft-admin.rakeshparwal.com/2009/02/oracle-magazine.htmlnoreply@blogger.com (rakesh.parwal)1tag:blogger.com,1999:blog-3325858952880134720.post-4492024929482352897Thu, 22 Jan 2009 07:31:00 +00002009-01-22T13:04:44.474+05:30GeneralJust for InformationI am redesigning my personal site www.rakeshparwal.com http://peoplesoft-admin.rakeshparwal.com/2009/01/announcement.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-7788461524979245473Mon, 24 Nov 2008 08:56:00 +00002009-05-04T16:24:01.695+05:30AS - PRCS - WSPosting Issue - For Restarted AE, Dist Status is in ' Posting' foreverNote 1: AE Process restarted in Process Scheduler remains in Posting status forever. According to Oracle, it is a known issue in PT 8.48.08 and has been fixed in PT 8.48.11) Note 2: Below is just an workaround to let other processes, which stuck up in posting status because of the re-started AE, go posted. I recently came across a posting issue where lot of AE prcess were in Success/No Success http://peoplesoft-admin.rakeshparwal.com/2008/11/posting-issue-dist-status-is-posting.htmlnoreply@blogger.com (rakesh.parwal)2tag:blogger.com,1999:blog-3325858952880134720.post-4636008516368355951Fri, 21 Nov 2008 05:22:00 +00002009-06-02T19:44:41.504+05:30COBOLAS - PRCS - WSCOBOL - Configuring instance specific CBLBINsSharing a file server to multiple instances is a common practice in may PeopleSoft Infrastructures... Many a times scenerio occurs where we want to have applied some bundles or Maintenance Packs to few of these instances... In such cases many of the external objects like SQRs, CRYSTALs, COBOLs etc would be different for bundled and non-bundled environemtns. For such cases, we would require to http://peoplesoft-admin.rakeshparwal.com/2008/11/cobol-configuring-instance-specific.htmlnoreply@blogger.com (rakesh.parwal)1tag:blogger.com,1999:blog-3325858952880134720.post-7276841056348252171Tue, 26 Aug 2008 06:05:00 +00002009-05-05T12:48:08.695+05:30Unix in PSShell Scripting in PeopleSoftUNIX - Extracting text between any Two Lines - UpdatedLaurent Schneider suggested one liner using AWK unix command - for my last script Extract_Text.sh... see here:awk '/^CREATE UNIQUE INDEX/{print "-- Create unique index #"++x}/^CREATE TABLE/{print "-- Create table #"++y}/^CREATE (UNIQUE INDEXTABLE)/,/;/{print}' test.sql/^CREATE (UNIQUE INDEXTABLE)/,/;/{print}: Searches for CREATE UNIQUE INDEX or CREATE TABLE and prints the lines till the first ";"http://peoplesoft-admin.rakeshparwal.com/2008/08/updated-unix-extracting-text-between.htmlnoreply@blogger.com (rakesh.parwal)0tag:blogger.com,1999:blog-3325858952880134720.post-1005572173366774705Mon, 25 Aug 2008 07:20:00 +00002009-04-02T16:26:58.224+05:30Unix in PSShell Scripting in PeopleSoftUNIX - Extracting text between any Two LinesI created a script that modifies an sql script in certain logical way. It extracts texts between certain logical lines and sends the output to a new file. You can download the shell script from here and try executing it with the attached test.sql as input. I created this script to alter PeopleSoft Generated AlterByRename sqls into simple CREATE statements.Extract_Text.shusage: ./http://peoplesoft-admin.rakeshparwal.com/2008/08/unix-extracting-text-between-any-two.htmlnoreply@blogger.com (rakesh.parwal)2tag:blogger.com,1999:blog-3325858952880134720.post-8284157795692334095Tue, 29 Jul 2008 10:44:00 +00002009-02-03T14:26:58.177+05:30SQLs in PSGeneralPermission Lists Associated to a UserHere is the query to find the permission lists associated to a user:SELECT A.OPRID, D.ROLEUSER, B.ROLENAME, B.CLASSID, C.ClASSDEFNDESCFROM PSOPRDEFN A, PSROLECLASS B, PSCLASSDEFN C, PSROLEUSER DWHERE A.OPRID=D.ROLEUSER AND B.CLASSID=C.CLASSID AND B.ROLENAME=D.ROLENAME AND A.OPRID= 'USER_NAME'ORDER BY B.CLASSIDhttp://peoplesoft-admin.rakeshparwal.com/2008/07/permission-lists-associated-to-user.htmlnoreply@blogger.com (rakesh.parwal)2tag:blogger.com,1999:blog-3325858952880134720.post-5926844690097939508Mon, 28 Jul 2008 05:04:00 +00002009-02-03T14:25:30.637+05:30Unix in PSSimple Example of Unix "sed" command   <!-- /* Font Definitions */ @font-face {font-family:"MS Mincho"; panose-1:2 2 6 9 4 2 5 8 3 4; mso-font-alt:"Arial Unicode MS"; mso-font-charset:128; mso-generic-font-family:roman; mso-font-format:other; http://peoplesoft-admin.rakeshparwal.com/2008/07/peopletools-848-new-features.htmlnoreply@blogger.com (rakesh.parwal)2tag:blogger.com,1999:blog-3325858952880134720.post-3328423746247859611Thu, 08 May 2008 06:19:00 +00002009-02-03T14:23:59.830+05:30GeneralTroubleShootingDebugging Performance related issues.There is no hard and fast rule for any trouble shooting. However, you may follow below guidelines to troubleshoot the perfornace related issues in your environment.It requires debugging the following and in the specified order:1. Database server2. Application Server3. WebServer4. Network Bandwidth5. PeopleSoft Application code itself6. Memory of the boxes where the Appserver/Webserver http://peoplesoft-admin.rakeshparwal.com/2008/05/debugging-performance-related-issues.htmlnoreply@blogger.com (Vikas Jain)0tag:blogger.com,1999:blog-3325858952880134720.post-7944238819043807040Wed, 30 Apr 2008 04:59:00 +00002009-04-02T16:27:58.044+05:30Unix in PSShell Scripting in PeopleSoftMonitoring ScriptsHere are Shell Scripts to monitor/start/stop PeopleSoft Application Server & Process Scheduler status:Application Server:appsrv-status.shparameter fileProcess Scheduler:prcs-status.shparameter fileProcess Scheduler Start-Stop:prcs-start-stop.shparameter filehttp://peoplesoft-admin.rakeshparwal.com/2008/04/monitoring-scripts.htmlnoreply@blogger.com (rakesh.parwal)0