My Oracle Support Banner

Bulksps File Upload Is Failing When The File Have 50 Transactions (Doc ID 2461346.1)

Last updated on DECEMBER 18, 2020

Applies to:

Oracle Banking Payments - Version 14.1.0.0.0 and later
Information in this document applies to any platform.

Goal

Bulksps File Upload is failing when the file have 50 transactions

We tried to upload the Bulksps File with 50 transactions.After uploading 33 transactions it stopped processing with the below error:

[INFO] BulkSinglePaymentEJBBean-->Send to SINGLE_PAY_OUT_QUEUE
[SEVERE]
[SEVERE] Exception:
[SEVERE] weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool fcjBatchDS to allocate to applications, please increase the size of the pool and retry..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:276)

[INFO] BulkSinglePaymentEJBBean-->unable to get connection from entity manager
[SEVERE]
[INFO] BulkSinglePaymentEJBBean-->End
[SEVERE]
[SEVERE] Exception:
[SEVERE] java.lang.NullPointerException
at com.ofss.pmts.jdbc.c2b.ConnectionService.commit(ConnectionService.java:92)

We noticed that the connection handling is not proper in the file "BulkSinglePaymentEJBBean.class",Looks like new connection is getting created for each transaction and the connections are not getting closed.
 

Solution

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