Tuesday, September 18, 2012

PSOFT : bea.jolt.ApplicationException error at PS login page


Issue : When you try to log online on PIA and you get the following error message:
CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ApplicationException: TPESVCFAIL – application level service failure.

Solution :


1. PTWEBSERVER user locking

This could be because of the Peoplesoft Default web profile user ID PTWEBSERVER got locked. 
if Select ACCTLOCK from PSOPRDEFN WHERE OPRID=’PTWEBSERVER’
returns 1 then 
Run the below SQL to unlock it

UPDATE PSOPRDEFN SET ACCTLOCK=0 WHERE OPRID=’PTWEBSERVER’


The PTWEBSERVER account provides the portal servlet with minimal security access, sufficient only to launch the portal environment, but without access to any pages or other PIA objects. This account uses the PTPT1500 permission list.

Also before update the above sql,  make sure that this user, role, and permission list are currently in your database by using the following SQLs.

select * from PSCLASSDEFN where CLASSID = ‘PTPT1500′
select * from PSAUTHSIGNON where CLASSID = ‘PTPT1500′
select * from PSROLEDEFN where ROLENAME = ‘PeopleTools Web Server’
select * from PSROLECLASS where ROLENAME = ‘PeopleTools Web Server’
select * from PSOPRDEFN where OPRID = ‘PTWEBSERVER’
select * from PSROLEUSER where ROLEUSER = ‘PTWEBSERVER’


Bounce apps/web server and test login now.

Please Note Web Server Account name PTWEBSERVER can be different in your environment in case you have specified different id/pass during Weblogic PIA installation. but mostly PTWEBSERVER is the default web server id and many prefers to keep it intact.

OR


2. PTWEBSERVER ID/PASS mismatch with web server config.

Make sure (PTWEBSERVER) userid password is correctly specified at App server level in Database(Can be changed through User Profile page) and at webserver level in boot.properties & configuration.properties file in encrypted format. Both have to be same.
These id/passwords are defined/provided at the time of weblogic PIA installation.
you can crosscheck the id & password which are encrypted in boot.properties & configuration.properties


$ PSCipher PTWEBSERVER
Encrypted text: {V1.1}JP9ukEkTssmYrzsK1yvXFg==

if there is mismatch then please update id and password in boot.properties
once you restart weblogic id/passwords in boot.properties file will be automatically encrypted.
Also update the same encrypted id/passwords in configuration.properties file as well

bounce apps/web server and test login now.

OR


3. Wrong Servername:
JSL in configuration.properties file at web server

Please make sure you have specified correct app server name & Jolt port in configuration.properties
psserver=servername:port
Please make sure servername is the hostname of app server and not the IP address.

bounce apps/web server and test login now.

These are most probable causes for above error but if none of these is working for your error then please check App server logs & Web server logs for further investigation.

4. DomainConnectionPwd
Please make sure DomainConnectionPwd is same in psappsrv,cfg & web server's configuration.properties file. ByDefault it is set as PS(Encrypted).

3 comments:

  1. anyone ever come across this error on the homepage?

    CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: java.lang.NullPointerException

    ReplyDelete
  2. In my case it appeared as case sensitive issue in the URL,make sure lang at end of URL is in CAPS like for English is ENG not Eng or eng

    ReplyDelete
  3. Hi im sanjay peoplesoft consultant. I just browsing blogs there I found your blog is interesting.. thank for posting… keep on posting peoplesoft-techical

    ReplyDelete