E-SEC: PSACCESSLOG Shows LOGIPADDRESS As "UNKNOWN" or "JavaClient"
(Doc ID 1334041.1)
Last updated on AUGUST 11, 2023
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.57 [Release 8.4]
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document