My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2023

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.

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



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




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.