E-SEC: PSACCESSLOG Shows LOGIPADDRESS As "UNKNOWN" or "JavaClient"
Last updated on DECEMBER 01, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.
***Checked for Relevance 28-01-2013***
When does the LOGIPADDRESS in the PSACCESSLOG table show an entry of "Unknown" or "JavaClient? What causes this?
Also is there an enhancement request to resize the LOGIPADDRESS field of the PSACCESSLOG. This field contains the reverse DNS entry when available instead of the actual IP address. In a sample of the last 30 days of data approximately 27% of the values in that field are exactly 40 characters long which implies that a large number of those were truncated to fit in the field. Having the reverse DNS entry is nice but is subject to change and may not have a matching forward DNS entry.
1. Create a second field for the Reverse DNS value when available. This field can be VARCHAR2(255) to accommodate most host names.
2. Store only the raw IP address in the LOGIPADDRESS field. 40 characters is sufficient to hold IPv4 and IPv6 addresses.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms