Batch M1-CLMDT Encountered an Error: ORA-01795: el número máximo de expresiones en una lista es 1000

(Doc ID 2077166.1)

Last updated on NOVEMBER 16, 2017

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.2.0.3.1 and later
Information in this document applies to any platform.

Symptoms

On : 2.2.0.3.1 version, Mobile Application

MWM - Error Batch M1-CLMDT

ERROR

10:49:56,014 [POOLRECURRENTESWorker:1] ERROR (com.splwg.mwm.domain.mcp.deployment.batch.CleanMCPData) M1-CLMDT Encountered an Error
10:49:56,014 [POOLRECURRENTESWorker:1] ERROR (com.splwg.base.api.batch.ThreadWorkUnitExecutable) Error #5 encountered at work unit null - this error will be logged and the unit skipped during the database transaction replay
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.api.businessService.BusinessServiceDispatcher.execute(BusinessServiceDispatcher.java:22): M1-CLMDT Encountered an Error

10:49:56,012 [POOLRECURRENTESWorker:1] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-01795: el número máximo de expresiones en una lista es 1000

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