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

Last updated on DECEMBER 15, 2016

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 do a trxn
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms