8.55 tools upgrade cache issue

After upgrading to peopletools 8.55, our application engine started failing with a variety of cache error messages.It is a tricky scenario given our setup which is as follows:

  • The failing psae process are triggered via command line using ksh wrapper script with psae commands
  • Upgrade from 8.53 to 8.55 tools version
  • Filesystem is being shared between 2 Linux servers running multiple process  scheduler instance

Took as multiple cache parameters change in the process scheduler before identifying the issue. Turns out that the compatibility with the SAN filesystem is the culprit and has something to do with the filesystem locking mechanism for SAN v3

Errors messages

  • Meta-SQL error at or near position 177 
  • PSPAL: Abort: Unexpected signal received
  • errorno = 2-No such file or directory
  • errorno = 116-Stale file handle
  • errorno = 10-No child processes




excel search

This is the core function in most of my excel tools, a VBA for searching a rows

Public Function Find_First(my_string As Variant)
Dim Rng As Range
If Trim(my_string) <> “” Then
With Sheets(“Sheet1”).Range(“A:A”)
Set Rng = .Find(What:=epm_domain, _
After:=.Cells(.Cells.Count), _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
If Not Rng Is Nothing Then
MY_COLUMN2_VAL = Sheets(“Sheet1”).Cells(Rng.Row, 2).Value
MsgBox “Nothing found”
End If
End With
End If
End Function

Linux memory script

Below is a simple script to check the total memory and cpu used by process

MY_USER=`id -u -n`
> /tmp/my_mem_$MY_HOST.txt
echo `date` >> /tmp/my_mem_$MY_HOST.txt
ps -e -o rss,vsz,pcpu,user,args | grep $MY_USER > /tmp/$MY_HOST_prcs.txt
cat /tmp/$MY_HOST_prcs.txt | awk ‘{a=$1;b=$2;c=$3;x=x+a;y=y+b;z=z+c;ma=x/1024;mb=y/1024;{printf(”   Resident memory size is:   %s MB\n   CPU for Processes:        %s %%\n   Virtual memory size is:    %s MB\n”,ma,z,mb)}}’  | tail -3 >> /tmp/my_mem_$MY_HOST.txt
cat /tmp/my_mem_$MY_HOST.txt

which will report the total memory and virtual memory used together with CPU % by the particular user.

Mon Jul 25 01:45:40 EDT 2016
Resident memory size is:   12664.8 MB
CPU for Processes:        19.4 %
Virtual memory size is:    49755.9 MB

Can be modified and place inside a loop for monitoring.

 EPM tools

We are currently maintaining a number of servers for our EPM applications. When you are dealing with tons of servers, it is important to keep an inventory to keep track of the software component installed and the associated environment and servers. 

Since i’m a fan of automation, i created a tool for our inventory with Excel as my usual weapon of choice. The attached video contains the demo of the tool. Feature such as automated login and integration to Linux servers, sqlplus and nt servers are not included due to security reason

Weblogic startup hanging

I’ve encountered this before but somehow keep on forgetting. When booting up weblogic and it started to hang, it is normally caused by corrupted datafiles under /domains/<domain name/servers/AdminsServer/data

Deleting the data directory should resolve the issue. Don't worry as the directory gets recreated during startup

Windows insider Experience


Enrolled myself to the windows insider program and was able to take the new Microsoft OS for a spin. Initially tested the release on Oracle Virtual box, installation went smoothly.

I then  decided to jump the gun and upgrade my windows 8.1 on my acer iconia w700 to windows 10 release, installation was a success but errors were encountered left and right, a bit expected and waited for a new build to be released.

Proceed with the upgrade of windows 8.1 to windows 10 mobile on my lumia 920. Corrupted my OS, have to plugin to my PC to perform recovery. Was able to recover and install, my lumia 920 is now running windows 10 preview.

A new windows 10 build was released, upgraded my windows 10 VM first. Seen a lot of improvement. Upgraded my w700, Encountered a boot loop issue. I have to reformat my w700 and reinstall windows 8.1 then upgrade to windows 10 build. This time the upgrade works and a more stable windows 10 runs smoothly on my w700. Impressed with the UI and the performance.

Signup for the August 29 windows 10 release on my asus laptop.the same laptop which host my Windows 10 VM.

Dday, August 29. Downloaded windows 8.1 upgrade on my PC which took about an hour or so. After the download and install. Windows 10 start downloading and was able to upgrade my asus from windows 8.1 to 10

Still testing, my setup are as follows:

1. Windows 10 preview on Oracle virtual box 5, guest OS on asus gaming laptop

2. Windows 10 home on ASUS gaming laptop

3. Windows 10 professional on my afer iconia w700 touch

4. Windows 10 mobile preview on my Lumina 920

System integration

Like many enterprise application. Many companies are very much liberal in the installation and deployment guide that they normally published specially for products requiring large scale installations and integrations. After all, it is hard to account for multiple scenarios that can take place on the implementing side of the fence. Due dilligence should be made and fingers cross the approach you’ve chosen works! At the end of the day, you can’t test every possible scenario anyway.

Oracle VM virtual box 5

Back in the days dual booting OS is a “in” thing. Yes i belong to that generation. I’ve been playing around with virtual machine for quite sometime using Oracle VM. It’s open source and free for those who like to play around with virtualization, OSes and networking. To date i have around 9 VMs configure in the machine i’m using

Version 5 were recently released and can be downloaded on the following url: https://www.virtualbox.org/