Thursday, October 09, 2014

PS JOB

PS_JOB is probably the most popular and well known table in Peoplesoft HCM… The name explains by itself the content, job data component is in there.
If I would have a table on my own, I’d like to add line(s) with my name in it…
It just means that I’m always looking for a new contract. This is the intent of that blog entry. Sorry to the people who are seeking a technical subject, it’s definitely not.

Who am I ?
I hope this blog name is clear enough about my job. I’m an Oracle and Peoplesoft administrator.

I have 19 years of experience. For the last the 14 years I worked on a various of projects which gave me strong skills on my areas. Implementation of Peoplesoft from scratch, upgrade, maintenance. Oracle administration, tuning, always in Peoplesoft context. On Unix (HP, AIX), Linux or Windows, that’s the daily task.
I worked for small as well as large organizations, I used Oracle from version 7 up to 12, OEM 8 up to 12. You can find several posts across my blog for technical articles on all these different aspects regarding my job.

My job is however more than a job, it’s really a passion. I hope this 8-years old blog is showing the high level of my motivation. Everything here has been tested on my own, within my own lab I invested in. Because I think reading documentation and testing are the secret of learning and being up to date of the latest version and new introduced features…
Building my own lab also showed here by a lot of articles, made me going through other technologies like virtualization software, such as Oracle VM and VMWare ESXi.

I also spent a lot of time trying to help people on the Oracle Database General and Peoplesoft forums. It’s a very good way to learn a lot.

Find out more on my LinkedIn page.

What am I looking for ?
Always looking for new opportunity, I’d like to continue in this exciting Oracle/Peoplesoft world !
Having new contract, on site or remotely, everything can be discussed. Do not hesitate to contact me for the details, I’ll give an answer. You have my words.

The show must go on on the Peoplesoft road.

Nicolas.

Monday, September 29, 2014

psadmin 8.54

Peoplesotools 8.54 made few changes in the main menu of psadmin. I thought to find easily docs in Peoplebooks PSADMIN utility description, but it’s not really straight away. So, I decided to write it down to keep ref.

Application domain :
Whether there’s still 28 options in the menu, one has been added, one has been removed.

Let’s see first the menu. Left side psadmin menu from Peopletools 8.53, right side Peopletools 8.54.
 PSADMIN_001
The option 13 (right side) has been added. The “Push Notifications” is an entire new concept. It seems promising even though quite complex to build. Once set in the configuration file, you have to do a lot of configurations from the front-end.
Find out more here in the Peoplebooks : Understanding the Push Notification Framework.
Pay attention to the system requirements, it’s not yet supported on WebSphere, only available for Weblogic.

The option 24 (left side) has been dropped. I suppose this is following the Peopletools end support for Sybase and Informix announced a month ago, since this was only required for those plateform. Amusingly, the Peoplebooks 8.54 have not been updated, this is still referenced (see Sartup Option).

Process Scheduler :
One option dropped, 2 added.

As above, here below screenshot for Process scheduler psadmin menu. Left side psadmin menu from Peopletools 8.53, right side Peopletools 8.54.
 PSADMIN_002
The option 13 “ServerName” (left side) has been removed. Same remark as above, only required for Sybase and Informix, since there are out of support, that’s fine.

From the right side – Peopletools 8.54 - two more options. Option 3) “Domains Gateway” and 4) “Push Notifications”. Nothing in the Peoplebooks regarding those two parameters for Process Scheduler. We have to assume it’s functioning the same way as for the Application server.

Other :
Do you want one more ?
Check the configuration file of application server (actually process scheduler as well), you‘ll see the added feature “InMemory” options:
 PSADMIN_003
The result search on Peoplebooks 8.54 returns nothing but “Your search term inmemorydbname did not match any topics.” I’d expect a reference to this configuration file description. Too bad. How are we supposed to use it ?

Sorry Oracle, but that documentation is weak.

Nicolas.

Friday, September 26, 2014

Script PIA and psadmin

Depending of how you are coding your script to start/stop your webserver, it might not work.

Small example:
[root@vv-cephei-b ~]# cat start_hcm92dmo_web.sh
su - hcm92 <<EOF
psadmin -w start -d peoplesoft
exit
EOF
[root@vv-cephei-b ~]# sh ./start_hcm92dmo_web.sh
Last login: Fri Sep 26 10:33:57 CEST 2014

Starting the domain [peoplesoft].
General Exception: null

java.lang.NullPointerException
        at com.peoplesoft.pt.psadmin.ui.Progress.<init>(Progress.java:135)
        at com.peoplesoft.pt.psadmin.ui.Progress.getInstance(Progress.java:123)
        at com.peoplesoft.pt.psadmin.pia.DomainBootHandler.BootWlsServer(DomainBootHandler.java:84)
        at com.peoplesoft.pt.psadmin.pia.DomainBootHandler.run(DomainBootHandler.java:62)
        at com.peoplesoft.pt.psadmin.pia.PIAAdminCmdLine.startDomain(PIAAdminCmdLine.java:270)
        at com.peoplesoft.pt.psadmin.pia.PIAAdminCmdLine.run(PIAAdminCmdLine.java:481)
        at com.peoplesoft.pt.psadmin.PSAdmin.runSwitched(PSAdmin.java:170)
        at com.peoplesoft.pt.psadmin.PSAdmin.main(PSAdmin.java:232)
[root@vv-cephei-b ~]#

It seems to be a known bug prior Peopletools 8.54:
Trying to Start or Stop WebLogic using psadmin while using Cron Results in Error - General Exception: null - java.lang.NullPointerException (Doc ID 1908227.1)
According to the note, it should be solved in Peopletools 8.54, and obviously it is not for me... even though I'm on the newest one, 8.54.03.

Now, rewording the script:
[root@vv-cephei-b ~]# cat start_hcm92dmo_web.sh
su - hcm92 -c "psadmin -w start -d peoplesoft"
[root@vv-cephei-b ~]# sh ./start_hcm92dmo_web.sh

Starting the domain [peoplesoft].......
Server state changed to STARTING.........
Server state changed to STANDBY..
Server state changed to STARTING..............
Server state changed to ADMIN..
Server state changed to RESUMING....
Server state changed to RUNNING..
Verifying domain status.
The domain has started.

[root@vv-cephei-b ~]#

Much better ! Bug solved.

Nicolas.

Thursday, September 25, 2014

Oracle Linux 7 : ps command as root produces a WARNING

When running a “ps” command as root user on Oracle Linux 7 (and CentOS 7), you may see the following :

root       694     1  0 09:01 ?        00:00:00 /usr/bin/abrt-watch-log -F Backtrace /var/log/Xorg.0.log -- /usr/bin/abrt-dump-xorg -xD
root       692     1  0 09:01 ?        00:00:00 /usr/bin/abrt-watch-log -F BUG: WARNING: at WARNING: CPU: INFO: possible recursive locking detected ernel BUG at list_del corruption list_add corruption do_IRQ: stack overflow: ear stack overflow (cur: eneral protection fault nable to handle kernel ouble fault: RTNL: assertion failed eek! page_mapcount(page) went negative! adness at NETDEV WATCHDOG ysctl table check failed : nobody cared IRQ handler type mismatch Machine Check Exception: Machine check events logged divide error: bounds: coprocessor segment overrun: invalid TSS: segment not present: invalid opcode: alignment check: stack segment: fpu exception: simd exception: iret exception: /var/log/messages -- /usr/bin/abrt-dump-oops –xtD

Note that, at the least, we can read “ernel” where we could expect “kernel”, “eneral” instead of “general”, “nable” instead of “unable”, “ysctl” instead of “sysctl”. Not very nice.

Whether it looks like a bug, it seems not to be. Please read that interesting description Red Hat Bugzilla – Bug 976581. It’s explained the first letter is explicitly not there to be able to catch both capital/lower letter.
It’s an old bug report, a new one has also been reported more recently for CentOS 7 on CentOS bug Tracker. Minor, but it’s worth to keep an eye.

Nicolas.

Restart CREATE_TEMP_TABLE won’t work

Whilst I was running the database setup of a brand new FSCM 92 Peopletools 8.54 database, the server has all of sudden crashed down.
Once restarted, checking the logs files produced by the DMS script, I was able to determine the step it was doing when it stopped. It was the very last step, CREATE_TEMP_TABLE.
Here’s the beginning of that log :
TMP_854_004
Since the server crashed without notice, it ends in the middle of nowhere and without error. There is nothing much about restarted this step in the Peopletools installation guide, I thought restart would simply work straight away…

And here start the troubles :
TMP_854_001  
As you may see, the command restarts from the beginning. But it dramatically failed on a table it was successful at the first place.
The guilty here is the table PSPTMATVWDEP which does not exists. What ?
TMP_854_002 
Indeed, it does not.
And now what ? Looking at all the logs files of load (epengs.log, epengl.log…), that table is “missing”.

I found a very old note on MOS – actually from 2010 !, “How can you restart Data Mover for the CREATE_TEMP_TABLE command (Doc ID 660214.1)”. It is clearly mentioned that CREATE_TEMP_TABLE cannot be restarted. If it fails for some reason, two ways :
1. if you don’t have to upgrade your database to the latest Peopletools release, open AppDesigner, create a new project, insert all the temp tables (or from the first it failed on till the end, cf log file) and build.
You should see something like this :
TMP_854_006

2. if you have to update your database to the latest Peopletools release, then continue (Task 7-2: Updating Database to Latest PeopleTools Release) and run what described above afterwards.
Just for info, that table PSPTMATVWDEP is created in rel854xx :
TMP_854_003

It was new to me. Never late for learning…

Should I say that whether table is mandatory, it is empty ? Also empty on image FSCM92008… Hmmm.

Enjoy,

Nicolas.

Thursday, September 18, 2014

Windows Power Shell does not know psae

I’ve never notice it before, probably already known by most of you guys. But whilst I was building a Peoplesoft database from within Windows 2012R2, I ran psae (PSADMIN AppEngine) from a Windows Power Shell command prompt.
And here what I got:

PS E:\pt854\bin\client\winx86> psae
psae : The term 'psae' is not recognized as the name of a cmdlet, function, script file, or operable program. Check
the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ psae
+ ~~~~
    + CategoryInfo          : ObjectNotFound: (psae:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

Suggestion [3,General]: The command psae was not found, but does exist in the current location. Windows PowerShell does
    not load commands from the current location by default. If you trust this command, instead type ".\psae". See "get-help
    about_Command_Precedence" for more details.
PS E:\pt854\bin\client\winx86>

Well, probably not a big deal, but good to know and worth a try what is recommanded, since I trust this psae command:

PS E:\pt854\bin\client\winx86> .\psae
Invalid command line argument list.
  process command line:
  GUID command line   : <unavailable>
Usage:
    psae -CT <dbtype>
         -CS <server>
         -CD <database name>
         -CI <connect id>
         -CW <connect password>
         -CO <oprid>
         -CP <oprpswd>
         -R  <run control id>
         -AI <program id>
         -I  <process instance>
         -DEBUG <Y|N>
         -DR <Y|N>
         -NOCOMMIT <Y|N>
         -TRACE <value>
         -DBFLAGS <value>
         -TOOLSTRACESQL <value>
         -TOOLSTRACEPC <value>
         -OT <output type>
         -OF <output format>
         -FP <file path>
  or
    psae <parmfile>
PS E:\pt854\bin\client\winx86>

Of course, we can also still use the good old Windows DOS cmd :
PS E:\pt854\bin\client\winx86> cmd
Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

E:\pt854\bin\client\winx86>psae
Invalid command line argument list.
  process command line:
  GUID command line   : <unavailable>
Usage:
    psae -CT <dbtype>
         -CS <server>
         -CD <database name>
         -CI <connect id>
         -CW <connect password>
         -CO <oprid>
         -CP <oprpswd>
         -R  <run control id>
         -AI <program id>
         -I  <process instance>
         -DEBUG <Y|N>
         -DR <Y|N>
         -NOCOMMIT <Y|N>
         -TRACE <value>
         -DBFLAGS <value>
         -TOOLSTRACESQL <value>
         -TOOLSTRACEPC <value>
         -OT <output type>
         -OF <output format>
         -FP <file path>
  or
    psae <parmfile>

E:\pt854\bin\client\winx86>

Nicolas.

Wednesday, September 17, 2014

We’ve detected that your operating system is not supported by this website

For many, many years, the Peoplesoft users know this (infamous) message on the login page when using, well, a non-supported OS by Peoplesoft.
I remember Duncan found a workaround to hide this message, find out more here. Already 4 years ago…

Maybe I’m out of date by using my old – but very well running – laptop on Windows XP Pro SP3, here it is within the image HCM92004 (Peopletools 8.53.xx) :
PTOOLS854_WEB_OS_002 

What a surprise with the last image HCM92008 (Peopletools 8.54.02), using the same browser and of course the same old laptop and OS, the message is just gone :
PTOOLS854_WEB_OS_004

Nice, but probably time for an OS upgrade anyway !

Nicolas.

Addendum (19-Sept-2014): if my test was done on Firefox 30.0, it’s worth to read PeopleTools Simplifies Internet Explorer Certifications

Monday, September 15, 2014

VMWare ESXi vSphere 5.5 update 2 and guest OS

As of the 1st of August 2014, VMWare ESXi 5.5 supports Oracle Linux 7. 1.5 months after RHEL 7 and 2-3 weeks after CentOS 7.
And good news, from the 5.5 update 2 released last week, we can set it for new guests from the Client:
HCM92008_027 
Note that’s only for the 64-bit version of OS. Surprisingly, whether RHEL 7 64-bit is officially also supported, it’s not listed here…
Or, from within an existing guest:
HCM92008_029  

Find out more about VMWare Compatibility Guide.

Nicolas.