My Oracle Support Banner

SES Incremental Index Runs To Error LS_LM_ACT_CI Datetime Field Overflow SQLSTATE 22008 (Doc ID 2299625.1)

Last updated on FEBRUARY 07, 2019

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


SES Incremental Index runs to Error LS_LM_ACT_CI

The SES Incremental Index runs to Error.

The same definition runs to Success for a Full index.

Error in running SQL query because of SQL error , Code=8603,message=[IBM][CLI Driver]CLI0114E Datetime field overflow SQLSTATE=22008 (SQLSTATE=22008) -99999

The issue can be reproduced at will with the following steps:
1. Navigate to PeopleTools > Search Framework > Administration > Schedule Search Index

2. Run Control ID: COURSES_INCR

3. Search Definition: LS_LM_ACT_CI

4. Indexing Type: Incremental Index

5.Run the process 


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

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