12.2.1.1 ESS - ESS-01080 Failed To Persist Request Information. (Doc ID 2230249.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle SOA Suite - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.1.0 version, Enterprise Scheduling System

12.2.1.1 ESS - ESS-01080 Failed to persist request information.

ESS jobs are triggered by an OSB Business Service. The ESS job completes and then creates a new request to OSB creating a loop

It is observed that after 2-3 hours the ESS Jobs stop triggering.

When checking the logs we can see that the size of the ecid increased a lot:

[2016-12-16T23:26:26.881+00:00] [ess_server1] [WARNING] [] [oracle.as.ess]
[tid: [ACTIVE].ExecuteThread: '10' for queue: 'weblogic.kernel.Default
(self-tuning)'] [userId: essuser] [ecid:
5b06d080-6666-419d-afa4-e5fcc95b3970-00000527,0:3:1:81:1:100000243:184:1:74:1:
100000247:182:1:77:1:100000251:182:1:74:1:100000255:182:1:77:1:100000259:182:1
:74:1:100000263:182:1:77:1:100000267:182:1:74:1:100000271:182:1:77:1:100000275
:182:1:74:1:100000279:182:1:77:1:100000283:182:1:74:1:100000287:182:1:77:1:100
000291:182:1:74:1:100000295:182:1:77:1:100000299:182:1:74:1:100000303:182:1:77
:1:100000307:182:1:74:1:100000311:182:1:77:1:100000315:182:1:74:1:100000319:18
2:1:77:1:100000323:182:1:74:1:100000327:182:1:77:1:100000331:182:1:74:1:100000
335:182:1:77:1:100000339:182:1:74:1:100000343:182:1:77:1:100000347:182:1:74:1:
100000351:182:1:77:1:100000355:182:1:74:1:100000359:182:1:77:1:100000363:182:1
:74:1:100000367:182:1:77:1:100000371:182:1:74:1:100000375:182:1:77:1:100000379
:182:1:74:1:100000383:182:1:77:1:100000387:182:1:74:1:100000391:182:1:77:1:100
000395:182:1:74:1:100000399:182:1:77:1:100000403:182:1:74:1:100000407:182:1:77
:1:100000411:182:1:74:1:100000415:182:1:77:1:100000419:182:1:74:1:100000423:18
2:1:77:1:100000427:182:1:74:1:100000431:182:1:77:1:100000435:184:1:74:1:100000
439:182:1:77:1:100000443:182:1:74:1:100000447:182:1:77:1:100000451:182:1:74:1:
100000455:182:1:77:1:100000459:182:1:74:1:100000463:182:1:77:1:100000467:182:1
:74:1:100000471:182:1:77:1:100000475:182:1:74:1:100000479:182:1:77:1:100000483
:182:1:74:1:100000487:182:1:77:1:100000491:182:1:74:1:100000495:182:1:77:1:100
000499:182:1:74:1:100000503:182:1:77:1:100000507:182:1:74:1:100000511:182:1:77
:1:100000515:182:1:74:1:100000519:182:1:77:1:100000523:182:1:74:1:100000527:18
2:1] [APP: ESSAPP] [partition-name: DOMAIN] [tenant-name: GLOBAL]
[J2EE_APP.name: ESSAPP] [J2EE_MODULE.name: ess] [WEBSERVICE.name:

 


ERROR:

<oracle.as.scheduler.webservice.SchedulerServiceImpl
oracle.as.scheduler.RuntimeStoreAccessException: ESS-01080 Failed to persist request information.
 
Caused by: java.sql.SQLException: ORA-24816: Expanded non LONG bind data
supplied after actual LONG or LOB column
.
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)




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