Monthly Archives: August 2013

“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.

Unable to find a Java Virtual Machine.

If you see this error when you try to start SQL Developer, most likely you had a setting pointed to the wrong path.

image

Go to where your SQL Developer is installed:

image

Go into again the sqldeveloper folder (marked above)

image

Then the bin folder

image

Among the files, there is this sqldeveloper.conf. Open it up:

image

You will see one called “SetJavaHome”, that’s where we need to fix.

Remove that line, then try starting the SQL Developer again:

image

Now it will ask you for the path again.

I set it to the jdk under Oracle database installation:

image

That worked for me.

Application Engine’s exit function

In PeopleSoft Application Engine, we have a command called “exit”. That’s used to help program determine what return value that particular step returns, and that value can then be used to determine the flow.

Here I have a sample AE:

image

Note the PeopleCode in Step01 is set up as “On Return Skip Step”. That’s telling you that if that PeopleCode program returns a non-0 (true) value, the program should skip this step (Step01), which is the Log Message. It should however continue to run Step02 as it’s an independent one.

Here is the code in detail:

For Step01’s PeopleCode, I have:

image

Step02 has this:

image

 

Going back to Step01’s PeopleCode, first, the if statement will always be false, so it will run the else part, which will return 1. The program see it’s a non-0 (true) value, so it will do what the On Return says, to Skip Step. So our Log Message part will not run, but Step02 will run.

image

Here is a log from the AE:

image

As we expected, the Log Message is not here, but Step02 is run.

Let’s change the code:

image

Now the if statement is true, so 0 will be returned. Let’s see what the log is after the run:

image

As you can see the Log Message is printing out information, and Step02 is run too.

PeopleSoft Component/Page/Menu/Folder

When creating a new component, the information on folder/page is coming from below:

image

The above shows you where the Component Registration page is used to set up the content reference label and long description.

Alternatively, you can set them up here:

image

 

The component search page:

image

That Funny Face is set up in the menu definition page:

image

 

If you go into a page of that component:

image

Notice that the Navigation Path uses Content Reference Label.

Also the “Folder Tab Label” came from Component definition page:

image

 

 

When registering a component,

image

You would see this in Structure and Content

image

And when you are in Menu Item Detail

image

When search by Portal Label, you should put in REF_LEBAL part.

image

Back in Component Registration

image

At the bottom, there is a node name, that’s used to search by Content Provider Name

image

 

If I change the node name to HRMS:

image

 

You can see it’s changed on Menu Item Detail

image

 

 

 

So with the Ctrl-(Shift-)J info,

image

Now query the PSPRSMDEFN using the following chart

image

So you can query PORTAL_URI_SEG2 for component name. That way, you will know what he Reference name or label is which can be used to search on View Menu Item Detail page

image