E1: SEC: Security Logons Are Not Being Logged to Security History Table F9312 (Doc ID 647441.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Symptoms

Security history type 01 (sign-on) and type 02 (sign-off) are not getting logged into F9312 (Security History table).  You are seeing error in AS400 joblog:

Conversion error on assignment to column SHUPMT

AS400 JOBLOG:

JDENET_K User . . . . . . : ONEWORLD Number . . . . . . . . .. . : 246628
Job description . . . . . . . : NETJOBD Library . . . . . :E811SYS
MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST
column. This would improve performance when the program is called.

SQL0406 Diagnostic 30 03/14/06 16:52:02.598896 QSQRUN3 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . . . . . : QSQINS
From procedure . . . . . . :
CLEANUP
Statement . . . . . . . . . : 23107
To module . . . . . . . . . : QSQINS
To procedure . . . . . . . :
CLEANUP
Statement . . . . . . . . . : 23107
Message . . . . : Conversion erroron assignment to column SHUPMT.
Cause . . . . . : During an attempt to assign a value to column SHUPMT with an INSERT, UPDATE, ALTER TABLE, or REFRESH TABLE statement, conversion error type 4 occurred. If precompiling, the error occurred when converting a numeric constant to the same attributes as column SHUPMT. A list of the
error types follows: -- Error type 1 is overflow. -- Error type 2 is floating point overflow. -- Error type 3 is floating point underflow. -- Error type 4 is a floating point conversion error. -- Error type 5 is not an exact result. -- Error type 6 is numeric data that is not valid. -- Error type 7 is DBCS data that is not valid. Recovery . . . : Change the statement so that the result value fits in column SHUPMT and is valid, or create the table or view again, specifying a new type or length for column SHUPMT so that the result value can be assigned.

Technical description . . .. . . . . : During precompile, an attempt is made to convert numeric constants in INSERT and UPDATE statements to the attributes of the target column. This would improve performance when the program is called.

SQL0406 Diagnostic 30 03/14/06 16:52:02.804896 QSQRUN3 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . . . . . : QSQINS

INSERT INTO SY811/F9312 (SHUSER, SHEVTYP, SHEVSTAT, SHMKEY, SHUSR0, SHPID, SHJOBN, SHUPMJ, SHUPMT, SHDTOFF, SHTMOFF, SHCHGF, SHSECF1, SHSECF2, SHSECV3, SHSECV4) VALUES ('<USER NAME>','01','01','BW074CDT','<USER NAME>','OWENTD','BW074CDT',106075,192804357976.000000,0,0.000000,'0',' ',' ',' ',' ')
Mar 16 19:28:04.362704 dbdrv_log.c196 - 445/2 MAIN_THREAD OS400QL016 - ExecuteSQLRequest: QSQLMSG *LIBL - SQL0406 - Conversion error on assignment to column &2
Mar 16 19:28:04.414336 dbdrv_log.c220 - 445/2 MAIN_THREAD OS400QL016 - ExecuteSQLRequest: QSQLMSG *LIBL - SQL0406 - Conversion error on assignment to column &2
Mar 16 19:28:04.414624 jdb_drvm.c969 - 445/2 MAIN_THREAD JDB9900401 - Failed to execute db request
Mar 16 19:28:04.415344 jdb_exet.c5906 - 445/2 MAIN_THREAD JDB3400009 - Failed to perform Insert for F9312
Mar 16 19:28:04.430160 jdb_exet.c6401 - 445/2 MAIN_THREAD Exiting JDB_InsertTable with Failure(Table F9312)
Mar 16 19:28:04.430424 secutil.c447 - 445/2 MAIN_THREAD Failed to insert new record into F9312
Mar 16 19:28:07.864672 netflow.c1067 - 445/2 MAIN_THREAD About to call dispatch function, flags=0x2, Type=554
Mar 16 19:28:07.864968 jdeksec.c3900 - 445/2 MAIN_THREAD Security kernel received message type 554 with 4 packages

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.