- Define WEBLIB_ record.
- Add ISCRIPT field
- Add function ISCRIPT
- Set up permission list
- You may need to run the Portal Security Sync, and/or restarting application server.
- Try it online.
Or the other one:
Go to SQL Developer, and query PSOPTIONS table:
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:
There is another set of keys:
Update the table PSOPTIONS with this key, and bingo, it worked.
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
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:
Unfortunately that did not work for me.
What I did was to run from command line, first set the PATH:
I created a bat file for this:
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.
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:
that sure worked.
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.
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:
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,
Of course, you do need to make sure the JAVA_EXE is set correctly.
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:
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:
Step02 has this:
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.
Here is a log from the AE:
As we expected, the Log Message is not here, but Step02 is run.
Let’s change the code:
Now the if statement is true, so 0 will be returned. Let’s see what the log is after the run:
As you can see the Log Message is printing out information, and Step02 is run too.
When creating a new component, the information on folder/page is coming from below:
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:
The component search page:
That Funny Face is set up in the menu definition page:
If you go into a page of that component:
Notice that the Navigation Path uses Content Reference Label.
Also the “Folder Tab Label” came from Component definition page:
When registering a component,
You would see this in Structure and Content
And when you are in Menu Item Detail
When search by Portal Label, you should put in REF_LEBAL part.
Back in Component Registration
At the bottom, there is a node name, that’s used to search by Content Provider Name
If I change the node name to HRMS:
You can see it’s changed on Menu Item Detail
So with the Ctrl-(Shift-)J info,
Now query the PSPRSMDEFN using the following chart
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