Share this page

# KNTA_USER_SESSIONS

When the WEB_SESSION_TRACKING parameter is set to true in the server.conf file, this table stores information about user sessions when errors or exceptions are thrown during user logon, user access to portlets and Scenario Comparison pages.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
USER_SESSION_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
RESOURCE_NAME | NOT NULL | VARCHAR2(200) | Identifier of the Resource the user was trying to access
TIME_TO_LOAD | NOT NULL | NUMBER | Determines the loading time for the Resource to be rendered.
ACCESS_DATE | NOT NULL | DATE | Determines the Date of access for the resource.
ERROR | NULLABLE | VARCHAR2(2000) | Determines whether there were any errors in rendering a resource
APP_SERVER | NULLABLE | VARCHAR2(80) | Indicates the server name
BROWSER | NULLABLE | VARCHAR2(256) | Indicates the browser and version

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_USER_SESSIONS_N1 | NONUNIQUE | 1 | CREATED_BY
KNTA_USER_SESSIONS_U1 | UNIQUE | 1 | USER_SESSION_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_USER_SESSIONS_S | USER_SESSION_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: