My Oracle Support Banner

IBY Risk Score Calculation gives error SQLException occurred: SQL string is not Query (Doc ID 2150494.1)

Last updated on OCTOBER 15, 2020

Applies to:

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


With Risk enabled, and attempting to process a transaction the following error occurs.

STATEMENT:[iby.database.DBWrapper.raiseDBException]:Processing SQLException: {sqlCode: 17128 errMessage: SQL string is not Query}
STATEMENT:[iby.database.DBWrapper.releaseDBConnection]:There is an open connection object ref. Soreturning the method with out actually closing the connection
EXCEPTION:[iby.ecapp.OraPmtRisk.oraPmtReqRisk]:[OraPmtRisk.oraPmtReqRisk()] Exception in updating transaction id and risk score in DB.
EXCEPTION:[iby.ecapp.OraPmtRisk.oraPmtReqRisk]:oracle.apps.iby.exception.DatabaseException: SQLException occurred: SQL string is not Query

at oracle.apps.iby.database.DBWrapper.raiseDBException(
at oracle.apps.iby.database.PaymentDB.addRiskScore(
at oracle.apps.iby.payment.OraPmtRisk.oraPmtReqRisk(
at oracle.apps.iby.ecapp.PmtECApp.oraPmtReq(
at oracle.apps.iby.ecapp.PaymentServiceImpl.oraPmtReq(PaymentServiceImp


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.