Category Archives: PeopleSoft

Unable to change label properties of push button/hyperlink in Application Designer

I had the issue where when I opened up the Label tab of a push button on a page, the Label Type, Label Size are blank, Label Text shows up as Static Text. When I changed the settings, and clicked OK to save it. The change did not register.

The fix turned out to be to go to the Configuration Manager, then go to Client Setup tab, then check the “Install Workstation” checkbox, click OK or Apply.

Now restart Application Designer, the issue should be fixed now.

“Your license code does not permit access”

image

Go to SQL Developer, and query PSOPTIONS table:

image

Hmm, I found the code there seems to be correct.

I think I have to do a trace to find out what table it’s reading.

Hmm, it is reading PSOPTIONS.

I went ahead and updated it anyway.

Well, that did not work. Still some components are having the same error.

Suddenly I realized that I was looking at key for this:

image

There is another set of keys:

image

Update the table PSOPTIONS with this key, and bingo, it worked.

Missing or invalid version of SQL library PSORA32 (200,0)

I am installing PT8.53 and HCM9.2 on my 64bits Windows 2008 R2 box, using Oracle 11g 64 bits too. When I tried to access Data Mover, I got this error

image

There are quite some posts on the internet talking about this. Basically it’s because that you need a 32 bits Oracle client for Application Designer and Data Mover.

However it’s not very clear on those posts that what needs to be changed. After several tries, I found that we need to change the PATH variable to point to the 32bit client BIN directory  (before the 64 bits).

There is one post talking about change the short-cut property’s “Start in” value:

image

Unfortunately that did not work for me.

What I did was to run from command line, first set the PATH:

image

 

I created a bat file for this:

image

 

 

So my post here is to remind you to set the PATH right (have it point to 32 bits client first) when running Application Designer and Data Mover.

bea.jolt.ServiceException: Invalid Session

Recently, I upgraded my VMWare to 9.0. Ever since that I am having trouble getting into PIA, whenever I access the login page, I got error

CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ServiceException: Invalid Session

The PIA log would show

***** JoltSessionPool: Domain//Avatar:9000 is unavailable.

Didn’t know what to do for a while (not too much luck on google search too), until I saw this, which advised to clean IPC:

image

in psadmin.

that sure worked.

PeopleSoft IDs

Connect ID: ID used to initially connect to Database. PS mentioned people/peop1e for it. Created in connect.sql. Only has access access to PSSTATUS, PSOPRDEFN, PSACCESSPRFL tables.

Access ID, is also the Owner ID. It’s an Oracle Database user, who owns the PeopleSoft database objects. This is set up in psadmin.sql

PS/VP are PeopleSoft built-in users.

Symbolic ID, is used to retrieve the Access ID and Access Password from PSACCESSPRFL.

When user logs in, the PS first connects to database using Connect ID and its password (peop1e in the example above. It then validates user’s ID and password against PSOPRDEFN table. If they are good, it will get the Symbolic ID from PSOPRDEFN, and then look up by Symbolic ID fro Access ID and Password from PSACCESSPRFL table, and disconnect from Access ID (people) and login as Access ID (we normally use SYSADM)

If you put wrong Connect password in Configuration Manager, you would see below when accessing Application Designer:

Invalid Access ID and password for signon — see your security administrator.

If you got “Invalid Login and password” when you trying to login with your ID, you can try reset the password in PSOPRDEFN in database, and use ENCRYPT_PASSWORD to encrypt it in data mover. If that does not work, please check if the ACCTLOCK is 1 in the PSOPRDEFN table.

PeopleTools 8.53 InstallAnywhere Issue

I am trying to install PeopleTools 8.53 on my Windows 2008 R2 in my VM. It’s a 64 bits. So I downloaded the 64 bit PeopleTools software. After I installed OS/Oracle 11g, Weblogic server and Tuxedo, I kicked off the setup.bat in Disk1 folder of PeopleTools 8.53. I then see this:

image

Oddly, after it unzip it, the InstallAnwhere window disppears (or you can say it does not show up), of course the command line is prompting for next command. I was very puzzled by this. I tried a lot of things, including making sure all Windows updates are installed, making sure Java VM is current, setting the path in the setup.bat (that’s for the installDir, and JAVE_EXE). All these did not work for me.

Then suddenly it came to my mind that I unzipped the 3 disks of PeopleTools install files in my host machine, not in the Windows 2008 (in VMWare). So I copied the 3 zip files to the Windows 2008, and unzipped them there. After that, I ran the setup.bat again. And Walala,

image

Of course, you do need to make sure the JAVA_EXE is set correctly.