I’ve finally made a new version of the DataViewer tool available for download. This new version includes new stand alone features as well. I’ve added Real Time Weblogic monitoring and an Access Log Parser. It also includes all the old charts for the Weblogic and Tuxedo monitor data files and some new ones. This version requires Java 8. I won’t be making new updates to the old version, but it will still be available for download if for some reason you can’t use Java 8. I’ve posted new screenshots on the Monitoring Tools Screenshot page. Another little improvement is the application should remember your last viewed data file and attempt to use it again the next time it is started. Same goes for the data entered on the Real Time Weblogic Monitor configuration. Download it here. And read how to use the new viewer on the DataViewer page.
As we know, with the new PeopleSoft 9.2 applications came a new method of delivering updates via PeopleSoft Update Manager. We now need to download fully functional VirtualBox images to get our patches. We can also use these images for Demo environments and specific versions are useable for New Release Demos during application upgrades. SES is even included in these images. I’ve been using VirtualBox for years, since the original innotek days. It works great for desktop use which is it’s intended use. Sure you can set it up on a server and make it work in a more enterprise environment but I wanted to deploy the images to something I already had hosting some vm’s, Linux KVM. If you want to run your images on VMWare, I recommend reading this post on running the images on VMWare. So lets begin setting up a new PUM image for Linux KVM. Continue reading
Oracle released the HCM 9.2.008 PUM Image today, Aug 19th. The ELM 9.2.005 PUM Image came out last week on Aug 12th. Finance should be out next week. These images are supposed to be delivered on the new 8.54.01 PeopleTools release. These should be an easy way for Admins like ourselves or Oracle customers in general to kick the tires on some of the new PeopleTools features and middleware components. You need to download them anyhow for patching right?
HCM weighs in at 34.7 GB while ELM is 28.4 GB. Happy downloading.
The PeopleSoft Technology Blog has announced the availability of the PreRelease notes for 8.54:
Some observations as I skimmed the document are:
- Oracle Linux 6, Win 2012, and Win 2012 R2 support added, Win 2008 (R1 not R2) dropped
- Client OS Windows 8.1 added, Windows 7 (32 bit) dropped
- WebLogic 12.1.2 added, 10.3.6 dropped
- Oracle 12, MSSQL 2014 added, Oracle 10.2.0.5, 22.214.171.124, and MSSQL 2008 dropped
- Current browsers available added (Chrome, Firefox, IE 11, Safari), IE 8 Firefox 17 dropped
- Tuxedo 126.96.36.199 added, Tuxedo 11gR1 dropped
- Still uses Java 7
- SES is 188.8.131.52, SES 184.108.40.206 dropped
- Excel 32-bit dropped
- Mobile Application Platform: Similar to the Fluid User Interface but utilizes RESTful web services
- 64-bit Development environment! App Designer, Data Mover, Change Assistant, the whole lot of them all now 64-bit. Explains the dropped Win 7 (32-bit).
- App Designer will have improved search functionality (reference, text), code auto-completion for PeopleCode, and new toolbar buttons to improve productivity
- Enhancements to App Engine tracing: split files, naming convention, program section trace, combined output of PeopleCode and SQL into the AE trace file
- Portable PS_HOME: Hard-coded paths and sym links within PS_HOME have been removed to further consolidate and allow a single PS_HOME to be shared across multiple environments
- Two new metaSQL enhancements for Oracle added. %SqlHint and %SelectDummyTable
- Also you can now use Oracle Global Temporary Tables, Materialized Views, and the new 12c container/pluggable databases which allow multiple PS databases in the same instance, some may have used GTTs and Materialized Views in the past, but now App Designer will handle them. Also, App Designer can now be used directly to partition tables and indexes on Oracle.
- Domain caching changes allowing automatic monitoring and adjusting? I’ll have to look into that one more.
- A Push Notification Event Framework, maybe we can finally broadcast a message to all users via the system.
- Several security enhancements, Oracle Secure Files for the report repository is one that jumped out at me.
- There’s a lot of other stuff, Just go read it !
I have finally uploaded some updated versions of my monitoring tools. I’ve made only minor updates to the Weblogic monitoring tool. I created versions that work with Weblogic 9.2 and Weblogic 8.1, but they will be available by request only. The viewer has had a few items added and can now be used to open the files generated from the newly released (but not really new) app monitoring tool. Continue reading
AWStats is a great tool for parsing web server access logs of any kind. If you are not familiar with it, I recommend checking out the Live Demo to see what kind of data it can provide. I’ve been using it for a long time to provide stats on all sorts of different websites and applications (including PeopleSoft). It’s just another great tool for in any Admin’s toolbox. Normally I run it on Linux but recently I setup AWStats on IIS which was actually pretty painless. Here is what I did.
What you need:
IIS, Perl, AWStats Continue reading
I’ve been asked this question many times. What makes a good PeopleSoft Admin? What should we be looking for when interviewing? Being an Admin myself, I thought I would write about some of my general thoughts on the topic. Of course these are only my opinions and do not fit every environment or employment scenario. Continue reading
I ran into this problem with nVision a little while ago. nVision processes were going to error status on the process scheduler. A quick glance at the logs made it look like either the process was crashing or not starting at all. I logged into the Windows Process Scheduler server to take a look at Excel. Logging in as the service account that is used to run our process scheduler I looked at task manager and saw two copies of Excel which had been running, however no jobs had been run for quite a while. I killed the processes and tried to start Excel by hand and began to wait. Several minutes later Excel popped up a window stating it was starting in safe mode, probably because I killed the processes I assumed. Once it started I went ahead and closed it cleanly and tried again. Again about four minutes later it finally opened. However, this time it opened with the recover lost files pane open and displayed what I would estimate was 1500+ recovered files. I closed the pane not saving any and removing them which took some more time. Eventually I was able to shutdown Excel again. The next time I opened it, it started right up in a second. I proceeded to disable the AutoRecover feature in the Save settings in Excel Options (for 2007).
I’m not sure what caused them to show up, or if they were there all along and just finally got to the point where Excel took too long to open. Like many, I inherited this environment, but now I have one more thing to add to my environment assessment checklist for the next time.
Process.Run is a great feature of the PeopleSoft Test Framework. Using this option wraps the running of a process up into just a few easy steps making the test script a lot easier to maintain. In this post I use a Object Type dot Action notation which corresponds to how a step would be entered in PTF. Before the period is the Type field, after is the Action field. I’ve previously written a post on PTF installation and how to record a simple script, if you need to start from the very beginning.
Pseudo code to run a job looks like this: Continue reading
I’ve been really busy lately and have not been able to find the time to finish up my troubleshooting post on SES yet. Hopefully I’ll have more time for writing posts again in a few weeks. I did want to bring attention though to a post I noticed a few weeks ago on the PeopleSoft Technology Blog. It speaks to the platform support of SES 220.127.116.11, the future support of SES 18.104.22.168 for PeopleTools 8.53, and also provides additional good reasons to keep your SES installs on separate hardware/vm’s than your existing PeopleSoft infrastructure.
Read the full blog post here.