Hello

What is the difference between Tuxedo Logs and Appserver Logs? What are the scenarios to look into Tuxedo Logs and Appserver Logs?

Thanks

TUXLOG:

Mainly the log is used to for any startup and shutdown of Tuexdo handlers when an app server is started/stopped. When the app server is up, any tuxedo handler errors and warning will be logged. Also the logs of any forced shutdown of client and their details like userid and IP would be written. The forced shutdown mostly happens when the user has kept the PIA pages idle for more than the threshold time limit. It could be for any other reason also.

Also you would find the no BBL errors if any.


APPSRV_mmdd.LOG:

This log mostly will contain entries of failed logins on PIA with userid, timestamp, hostname/IP etc. Any communication to performance monitor app server also will be written. If there are any of the server processes crashed like PSAPPSRV, it will create a sub directory in the LOGS folder and log the replay, dump files and the cache directory with the cache files. This would be used by PeopleSoft support if they want to troubleshoot your issue.

What are the scenarios to look into?:

The above mentioned scenarios are normal scenarios when there are no issues with the app server or database server. If there are any issue one has to check all log files in $PS_HOME/appserv/domain/LOGS directory. Also two more log files that you need to look into $PS_HOME/appserv/domainname/stdout and $PS_HOME/appserv/domainname/stderr.

Also in the $PS_HOME/appserv/domainname/LOGS folder, you will find MONITORSRV_mmdd.LOG, SMTP.LOG and the trace logs with tracesql extensions.

you mentioned .tracesql files in your response - can you tell me where/how to turn the trace off that is generating those? We don't have any tracing turned on in our appserver config yet the files are generated by user when the user is moving around via the web. Thoughts?

I found the following messages in the appserver logs.Any idea wht is the reason why these messages are recorded in the log file.There is no issue with the application ,its up and running.

1)PSAPPSRV.5176 (250) [04/12/10 11:32:27 GetCertificate](3) Error Setting Sign on PeopleCode context for User QEDMO@01HW141454 : Sign on PeopleCode was not executed
PSAPPSRV.5176 (250) [04/12/10 11:32:27 GetCertificate](3) PeopleSoft ID and Password authentication failed. Invalid user QEDMO@01HW141454 .
PSAPPSRV.5176 (250) [04/12/10 11:32:27 GetCertificate](1) (NET.502): QEDMO@01HW141454 is an Invalid User ID, or you typed the wrong password. User ID and Password are required and case-sensitive. Make sure you're typing in the correct upper and lower case.
PSAPPSRV.5176 (250) [04/12/10 11:32:27 GetCertificate](1) (NET.346): Failed to execute GetCertificate request

I see this message on all the servers.what could be the reason?

2)PSMCFLOG1.3280 (0) [04/12/08 23:59:34](1) (PSMCFLOG1): The SQL database query returned this error: "[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.".

3)PSBRKDSP_dflt.3984 (0) [04/12/08 23:58:30](1) (PublishSubscribe): PubSubDispatcher::Dispatch(); DataBase Instance is down.
PSPUBDSP_dflt.5312 (0) [04/12/08 23:59:05](1) (PublishSubscribe): PubSubDispatcher::Dispatch(); DataBase Instance is down.

4)PSAPPSRV.3056 (163) [04/12/10 12:32:03 This e-mail address is being protected from spam bots, you need JavaScript enabled to view it (IE 7.0; WINNT) ICScript](2) PrdmGet failed with error code 3, portal name PORTA