Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Severance Event Trigger (Program Name: CIPLSETB) hangs and the status is "In Progress" (Oracle Utili

3520087Aug 9 2017 — edited Oct 11 2017

Apologies for posting this in the PL/SQL Forum.

Firslty, requesting the Oracle Utilites CC&B team to have their product community, it is not there or it is too difficult to find.

I am on the demo version :

pastedImage_0.png

  1. I am running the batch program: Severance Event Trigger ((Program Name: CIPLSETB)), it says it has Ended but in the Alert space, it says it is "In Progress". (same issue on UNIX and Windows Desktop)

pastedImage_2.png

  1. The threadpoolworker log file says:

the following stacked messages were reported as the LoggedException was rethrown:

java.lang.reflect.Method.invoke(Unknown Source): Error while invoking Program CIPLSETB, com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB

com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB.perform_GA000_MAIN_PROC(ProgramCIPLSETB.java:1413): Exception encountered in executing StringField (

name=ProgramName

value=StringFieldValue(value=CIPLSETB

  bytes={43 49 50 4c 53 45 54 42 }

  interpreted =CIPLSETB

  )

). Please see log for details.

The root LoggedException was: Invalid number found. Input field's (EvtSeq) bytes are all spaces

at com.splwg.shared.common.LoggedException.raised(LoggedException.java:67)

at com.splwg.base.support.cobol.CobolByteBuffer.readValidS9Integer(CobolByteBuffer.java:151)

at com.splwg.base.support.cobol.CobolByteBuffer.readJavaDecimal(CobolByteBuffer.java:121)

at com.splwg.base.api.program.md.NumberFieldMD.getValue(NumberFieldMD.java:237)

at com.splwg.base.api.program.md.NumberFieldMD.getValue(NumberFieldMD.java:35)

at com.splwg.base.support.program.types.values.ByteRepresentableFieldValue.createValueFromBytes(ByteRepresentableFieldValue.java:66)

at com.splwg.base.support.program.types.values.ByteRepresentableFieldValue.getValue(ByteRepresentableFieldValue.java:49)

at com.splwg.base.support.program.types.AbstractSingleField.getValue(AbstractSingleField.java:24)

at com.splwg.base.support.program.types.NumberFieldImpl.getSnapshot(NumberFieldImpl.java:449)

at com.splwg.base.support.program.sql.AbstractSQLWrapper$SQLBinding.getSnapshot(AbstractSQLWrapper.java:107)

at com.splwg.base.support.program.sql.CachedProgramSQLResults.getSnapshotKey(CachedProgramSQLResults.java:89)

at com.splwg.base.support.program.sql.CachedProgramSQLResults.getCursorResultFor(CachedProgramSQLResults.java:43)

at com.splwg.base.support.program.sql.SQLCursorImpl.open(SQLCursorImpl.java:38)

at com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB.perform_ZS400_SETUP_SQL_S_MAIN(ProgramCIPLSETB.java:3134)

at com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB.perform_ZS000_EXEC_SQL(ProgramCIPLSETB.java:2919)

at com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB.perform_GB000_GET_NEXT_ROW(ProgramCIPLSETB.java:1611)

at com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB.perform_GA000_MAIN_PROC(ProgramCIPLSETB.java:1413)

at com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB.perform_AA000_MAIN(ProgramCIPLSETB.java:970)

at com.splwg.ccb.domain.creditcollections.batch.ProgramCIPLSETB.invoke(ProgramCIPLSETB.java:940)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.splwg.base.api.program.ProgramInvokeFactory.invoke(ProgramInvokeFactory.java:31)

at com.splwg.base.support.batch.TranslatedBatchProgramDispatcher.executeBatchProgram(TranslatedBatchProgramDispatcher.java:29)

at com.splwg.base.support.batch.GenericCobolBatchProgram.callProgram(GenericCobolBatchProgram.java:123)

at com.splwg.base.support.cobol.AbstractCobolProgram.callCobol(AbstractCobolProgram.java:64)

at com.splwg.base.support.batch.GenericCobolBatchProgram.callCobolInCobolThread(GenericCobolBatchProgram.java:70)

at com.splwg.base.support.batch.GenericCobolBatchProgram.execute(GenericCobolBatchProgram.java:36)

at com.splwg.base.support.batch.CobolBatchWork$DoExecuteWorkInSession.doBatchWorkInSession(CobolBatchWork.java:77)

at com.splwg.base.support.batch.BatchWorkInSessionExecutable.run(BatchWorkInSessionExecutable.java:68)

at com.splwg.base.support.batch.CobolBatchWork.doExecuteWork(CobolBatchWork.java:54)

at com.splwg.base.support.grid.AbstractGridWork.executeWork(AbstractGridWork.java:72)

at com.splwg.base.support.cluster.ThreadWork.processBatchWork(ThreadWork.java:54)

at com.splwg.base.support.cluster.BatchWorkManager.processWork(BatchWorkManager.java:78)

at com.tangosol.coherence.commonj.WorkManager$ScheduleWork.run(WorkManager.java:2266)

at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.InvocationService.onInvocationRequest(InvocationService.CDB:12)

at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.InvocationService$InvocationRequest.run(InvocationService.CDB:1)

at com.tangosol.coherence.component.util.DaemonPool$WrapperTask.run(DaemonPool.CDB:1)

at com.tangosol.coherence.component.util.DaemonPool$WrapperTask.run(DaemonPool.CDB:32)

at com.tangosol.coherence.component.util.DaemonPool$Daemon.onNotify(DaemonPool.CDB:65)

at com.tangosol.coherence.component.util.Daemon.run(Daemon.CDB:51)

at java.lang.Thread.run(Unknown Source)

- 2017-08-08 12:30:17,491 [DEFAULTWorker:1] INFO (support.batch.BatchWorkInSessionExecutable) Handling trapped error

- 2017-08-08 12:30:17,491 [DEFAULTWorker:1] ERROR (support.cluster.ClusteredExecutionContext) An error has occurred while processing distributed grid work. A rollback will be issued. Processing of other work will continue.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2017
Added on Aug 9 2017
3 comments
261 views