Monday, May 22, 2017

Unable to bring up Application server with error Could not sign on to database XX with user XX


Unable to bring up Application server with error  GenMessageBox(0, 0, M): Database
Signon: Could not sign on to database XX with user XX.

When this message is printed in log file. Follow these simple steps
1. Validate your user login through Application designer.
2. Validate your connect id login through sql plus or data mover.
3. If you have DB2 database. Make sure you have catalog entry for target database and System DSN populating it. ODBC data source administrator 64-bit -> System DSN

4. None of above works then setup people tools trace.

Wednesday, May 3, 2017

PeopleSoft PIA error Could not open registry with blank page

PeopleSoft PIA error Could not open registry with blank page


After login with user id and password if you see following message on blank white screen then follow the solution


Could not open registry


Web Server log -
unknown    SEVERE  psft.pt8.clearlist.ClearlistMessageHandler      messageReceived Message not handled because no handler or no default installed for the service!
unknown    SEVERE  psft.pt8.registry.PortalRegistry        open    PortalRegistry.open failed for Portal=signon.html because PortalRegistrySvc returnCode != 0
unknown    WARNING psft.pt8.psp    openRegistry
Could not open registry: signon.html
Local Node information:
Name: PSFT_XXXX
PortalURI: XXXX
ContentURI:XXXX
DefaultPortal: EMPLOYEE


Solution


In url replace signon.html with ?cmd=login