My Oracle Support Banner

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 and later
Information in this document applies to any platform.


Performance issue on Pedigree (OPSM) version

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


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

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