OPSM/Pedigree Serial Generation Webservice Timeout: SerialGenRequestServiceAMService Java.sql.SQLException (Doc ID 2066889.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Pedigree and Serialization Manager - Version 1.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Performance issue on Pedigree (OPSM) version 1.2.0.0.0.

Receive an exception "java.sql.SQLException" in OPSM SerialGenRequestServiceAMService.

The Serial Generation web service is timing out when querying 20,000 (20K) serial numbers.

The java.sql.SQLException error returns after 50 minutes query run time using sequential serial number generation.

Setup: System Parameters
OPSM System Parameters are as follows:
* Owning Source System - EBIZ_01
* Source System Precedence - Owning Source System
* Serial Type Default - SGTIN-98
* Use Serial Ranges Default - Unchecked
* Allow Lot Creation - Checked
* Serial Commit Size - 100

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