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.

Symptoms

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(DBWrapper.java:281)
at oracle.apps.iby.database.PaymentDB.addRiskScore(PaymentDB.java:528)
at oracle.apps.iby.payment.OraPmtRisk.oraPmtReqRisk(OraPmtRisk.java:212)
at oracle.apps.iby.ecapp.PmtECApp.oraPmtReq(PmtECApp.java:898)
at oracle.apps.iby.ecapp.PaymentServiceImpl.oraPmtReq(PaymentServiceImp

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