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

Last updated on DECEMBER 18, 2020

Applies to:

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

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