My Oracle Support Banner

Using Enterprise Capture URL Controls to Create a Batch Results in the Error "An Error Was Encountered While Communicating With The Server" (Doc ID 2016210.1)

Last updated on OCTOBER 10, 2019

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Using the WebCenter Enterprise Capture URL control that calls Capture to import/scan in a batch, results in the following error after logging into Capture client:

Message:
  oracle.oddc.client.batchbuilder.BatchBuilderException: Error creating batch
Level:
  WARNING
Stack Trace:
Error creating batch
  oracle.oddc.client.batchbuilder.AbstractBatchBuilder.createCaptureBatchObject(AbstractBatchBuilder.java:167)
  oracle.oddc.client.batchbuilder.AbstractBatchBuilder.createBatch(AbstractBatchBuilder.java:148)
  oracle.oddc.client.BatchEditForm$48.run(BatchEditForm.java:3958)
An error was encountered while communicating with the server.
  oracle.oddc.client.services.ODDCClientSessionImpl.buildCaptureException(ODDCClientSessionImpl.java:199)
  oracle.oddc.client.services.ODDCClientSessionImpl.createBatch(ODDCClientSessionImpl.java:246)
  oracle.oddc.client.data.CaptureBatches.add(CaptureBatches.java:55)
  oracle.oddc.client.batchbuilder.AbstractBatchBuilder.createCaptureBatchObject(AbstractBatchBuilder.java:163)
  oracle.oddc.client.batchbuilder.AbstractBatchBuilder.createBatch(AbstractBatchBuilder.java:148)
  oracle.oddc.client.BatchEditForm$48.run(BatchEditForm.java:3958)
POST http://<Capture_server>:16400/dc-client/jersey/oddcClient/createBatch?batchName&profileID=841166ed-3540-4ca2-bc57-703ddd95511e&workstationID=<ID>&workspaceID=6 returned a response status of 404 Not Found
  com.sun.jersey.api.client.WebResource.handle(WebResource.java:676)
  com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
  com.sun.jersey.api.client.WebResource$Builder.post(WebResource.java:553)
  oracle.oddc.client.services.ODDCClientSessionImpl.createBatch(ODDCClientSessionImpl.java:240)
  oracle.oddc.client.data.CaptureBatches.add(CaptureBatches.java:55)
  oracle.oddc.client.batchbuilder.AbstractBatchBuilder.createCaptureBatchObject(AbstractBatchBuilder.java:163)
  oracle.oddc.client.batchbuilder

The Capture diagnostic log shows database constraints:

2015-05-21T11:15:46.969-05:00] [capture_server1] [ERROR] [CAPTURE-10014] [oracle.odc.batchmanager.BatchManagerSessionBean] [tid: [ACTIVE].ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <userid>] [ecid: <ecid>] [APP: capture] [DSID: ] Error creating batch[[
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_CAPTURE.SYS_C0073162) violated

Error Code: 1
Call: INSERT INTO ECBATCHLOCKS (ECBATCHLOCKID, ECBATCH, ECLOCKEDBYCOMPUTER, ECDATETIME, ECPROCESSID, ECLOCKEDBYUSER, ECWORKSPACE, ECBATCHID, ECWORKSPACEID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [9 parameters bound]
Query: InsertObjectQuery(oracle.odc.entity.BatchLockEntity[id=<id>])
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:786)
at sun.reflect.GeneratedMethodAccessor5207.invoke(Unknown Source)

caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_CAPTURE.SYS_C0073162) violated

Error Code: 1
Call: INSERT INTO ECBATCHLOCKS (ECBATCHLOCKID, ECBATCH, ECLOCKEDBYCOMPUTER, ECDATETIME, ECPROCESSID, ECLOCKEDBYUSER, ECWORKSPACE, ECBATCHID, ECWORKSPACEID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [9 parameters bound]
Query: InsertObjectQuery(oracle.odc.entity.BatchLockEntity[id=<id>])'

This only happens when using the URL controls.  Users are able to scan and import batches with the client profile if they access the capture client normally. 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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