My Oracle Support Banner

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

Last updated on JANUARY 01, 2025

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.

NOTE:
In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). 
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

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


 

Error


Steps
1. Run the Serial Generation web service.
2. Service times out when query 20k serial numbers.

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
References


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