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

Last updated on AUGUST 24, 2017

Applies to:

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

Symptoms

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


STEPS
-----------------------
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 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms