Latest US News College Ranking


1 Princeton University
2 Harvard University
3 Yale University
4 Columbia University
5 Stanford University
6 University of Chicago
7 Duke University
8 Massachusetts Institute of Technology
9 University of Pennsylvania
10 California Institute of Technology
11 Dartmouth College
12 Johns Hopkins University
13 Northwestern University
14 Brown University
15 Washington University in St. Louis
16 Cornell University
17 Vanderbilt University
18 Rice University
19 University of Notre Dame
20 Emory University
21 Georgetown University
22 University of California–Berkeley
23 Carnegie Mellon University
24 University of California–Los Angeles
25 University of Southern California
26 University of Virginia
27 Wake Forest University
28 Tufts University
29 University of Michigan–Ann Arbor
30 University of North Carolina–Chapel Hill
31 Boston College
32 Brandeis University
33 College of William and Mary
34 New York University
35 University of Rochester
36 Georgia Institute of Technology
37 Case Western Reserve University
38 Pennsylvania State University–University Park
39 University of California–Davis
40 University of California–San Diego
41 Boston University
42 Lehigh University
43 Rensselaer Polytechnic Institute
44 University of California–Santa Barbara
45 University of Illinois–Urbana-Champaign
46 University of Wisconsin–Madison
47 University of Miami
48 Yeshiva University
49 Northeastern University
50 University of California–Irvine
51 University of Florida
52 George Washington University
53 Ohio State University–Columbus
54 Tulane University
55 University of Texas–Austin
56 University of Washington
57 Fordham University
58 Pepperdine University
59 University of Connecticut
60 Southern Methodist University
61 University of Georgia
62 Brigham Young University–Provo
63 Clemson University
64 Syracuse University
65 University of Maryland–College Park
66 University of Pittsburgh
67 Worcester Polytechnic Institute
68 Purdue University–West Lafayette
69 Rutgers, the State University of New Jersey–New Brunswick
70 Texas A&M; University–College Station
71 University of Minnesota–Twin Cities
72 Virginia Tech
73 Michigan State University
74 University of Iowa
75 American University
76 Baylor University
77 Clark University
78 Indiana University–Bloomington
79 Marquette University
80 Miami University–Oxford
81 University of Delaware
82 Stevens Institute of Technology
83 Stony Brook University–SUNY
84 Texas Christian University
85 University of Vermont
86 SUNY College of Environmental Science and Forestry
87 University of Alabama
88 University of California–Santa Cruz
89 University of Colorado–Boulder
90 University of Tulsa
91 Auburn University
92 Colorado School of Mines
93 Florida State University
94 University of Denver
95 University of Massachusetts–Amherst
96 University of San Diego
97 Binghamton University–SUNY
98 Drexel University
99 University of Missouri
100 University of New Hampshire
101 Iowa State University
102 Loyola University Chicago
103 North Carolina State University–Raleigh
104 St. Louis University
105 University of Kansas
106 University of Nebraska–Lincoln
107 University of Oklahoma
108 University of Tennessee
109 Illinois Institute of Technology
110 University at Buffalo–SUNY
111 University of Oregon
112 University of California–Riverside
113 University of Dayton
114 University of South Carolina
115 University of St. Thomas
116 University of the Pacific
117 Michigan Technological University
118 University of San Francisco
119 University of Arizona
120 University of Kentucky
121 Catholic University of America
122 Clarkson University
123 Colorado State University
124 DePaul University
125 Duquesne University
126 Temple University
127 University of Utah
128 Missouri University of Science & Technology
129 Polytechnic Institute of New York University
130 Seton Hall University
131 University at Albany–SUNY
132 University of Arkansas
133 University of Illinois–Chicago
134 Washington State University
135 Hofstra University
136 Kansas State University
137 Louisiana State University–Baton Rouge
138 New School
139 Ohio University
140 University of Cincinnati
141 George Mason University
142 Arizona State University
143 Howard University
144 Mississippi State University
145 Oklahoma State University
146 Oregon State University
147 Rutgers, the State University of New Jersey–Newark
148 St. John Fisher College
149 University of Texas–Dallas
150 New Jersey Institute of Technology
151 University of Mississippi
152 Adelphi University
153 Illinois State University
154 San Diego State University
155 St. John’s University
156 University of Alabama–Birmingham
157 University of Rhode Island
158 University of Hawaii–Manoa
159 University of Maryland–Baltimore County
160 University of Massachusetts–Lowell
161 Maryville University of St. Louis
162 Texas Tech University
163 University of Idaho
164 University of La Verne
165 University of Louisville
166 University of Wyoming
167 Florida Institute of Technology
168 University of Maine
169 Virginia Commonwealth University
170 University of Central Florida
171 University of South Florida
172 West Virginia University
173 Azusa Pacific University
174 Pace University
175 St. Mary’s University of Minnesota
176 University of North Dakota
177 Biola University
178 Indiana University of Pennsylvania
179 Northern Illinois University
180 Southern Illinois University–Carbondale
181 Andrews University
182 Ball State University
183 Bowling Green State University
184 East Carolina University
185 University of Alabama–Huntsville
186 University of Nevada–Reno
187 University of New Mexico
188 Western Michigan University
189 Widener University
190 Central Michigan University
191 Edgewood College
192 Immaculata University
193 Louisiana Tech University
194 New Mexico State University
195 North Dakota State University
196 University of Colorado–Denver
197 University of Houston
198 University of North Carolina–Greensboro
199 University of South Dakota
200 Utah State University
201 Kent State University
202 Montana State University
203 South Dakota State University
204 University of Missouri–Kansas City
205 University of Montana
206 University of North Carolina–Charlotte
207 Ashland University
208 Barry University
209 Benedictine University
210 Bowie State University
211 Cardinal Stritch University
212 Clark Atlanta University
213 Cleveland State University
214 East Tennessee State University
215 Florida A&M; University
216 Florida Atlantic University
217 Florida International University
218 Georgia Southern University
219 Georgia State University
220 Idaho State University
221 Indiana State University
222 Indiana University-Purdue University–Indianapolis
223 Jackson State University
224 Lamar University
225 Lynn University
226 Middle Tennessee State University
227 Morgan State University
228 National-Louis University
229 North Carolina A&T; State University
230 Northern Arizona University
231 Nova Southeastern University
232 Oakland University
233 Old Dominion University
234 Our Lady of the Lake University
235 Portland State University
236 Regent University
237 Sam Houston State University
238 South Carolina State University
239 Spalding University
240 Tennessee State University
241 Texas A&M; University–Commerce
242 Texas A&M; University–Corpus Christi
243 Texas A&M; University–Kingsville
244 Texas Southern University
245 Texas Woman’s University
246 Trevecca Nazarene University
247 Trinity International University
248 University of Akron
249 University of Alaska–Fairbanks
250 University of Arkansas–Little Rock
251 University of Louisiana–Lafayette
252 University of Massachusetts–Boston
253 University of Memphis
254 University of Missouri–St. Louis
255 University of Nebraska–Omaha
256 University of Nevada–Las Vegas
257 University of New Orleans
258 University of Northern Colorado
259 University of North Texas
260 University of South Alabama
261 University of Southern Mississippi
262 University of Texas–Arlington
263 University of Texas–El Paso
264 University of Texas–San Antonio
265 University of Toledo
266 University of West Florida
267 University of Wisconsin–Milwaukee
268 Wayne State University
269 Wichita State University
270 Wright State University
271 Alliant International University
272 Argosy University
273 California Institute of Integral Studies
274 Capella University
275 Colorado Technical University
276 Northcentral University
277 Trident University International
278 Union Institute and University
279 University of Phoenix
280 Walden University
281 Wilmington University

“Your license code does not permit access”


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.

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


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.

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


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:


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:


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.

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.


Go to where your SQL Developer is installed:


Go into again the sqldeveloper folder (marked above)


Then the bin folder


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


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

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


Now it will ask you for the path again.

I set it to the jdk under Oracle database installation:


That worked for me.