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 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

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
Cause
Solution
References


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