PeopleSoft Wiki

Turns out that some of the data loaded from the demo HCRS database (hcengs.db) has keys that are case sensitive.

If SQL server is set up with the Latin1_General collation but the case sensitive flag is not set, then certain records will not import properly and throw errors during the demo database creation step (unique index errors). When you look at the keys causing the error you will find that the only difference is case of the key (e.g. TEST, Test, test). If your SQL server installation doesn't have a case sensitive collation set, these sorts of keys will cause an error as they won't be unique.

You can check case sensitivity of your collation using the sp_helpsort stored procedure.

This is an example of what is returned:

After installing the PeopleSoft PIA, I found that I could no longer access the Oracle Application Server (SOA Suite) enterprise manager using the original URL: http://servername/em

I found this article which explains the ascontrol application (enterprise manager) and gives some of the common reasons why it may no longer be available.

In my case, it turns out that the ascontrol application was stopped, which I found by issuing the command:
$ opmnctl status -app in the %OAS_HOME%\opmn\bin directory.

I started the stopped ascontrol application by issuing the command:
$ opmnctl startproc application=ascontrol

This seemed to fix the issue (permanently). However, I could no longer get to the enterprise manager console on the standard http port (80) but I could get to it using port 4430. So the location enterprise manager changed to: http://servername:4430/em

I'm not sure if this is something that happened due to the PeopleSoft PIA installation? Anyone know?

I really appreciate the information and the link to PSST0101. Is there any chance you could update the link to the new website?

http://psst0101.digitaleagle.net/step-by-step/

Not a problem, the link has been updated to the new site.