SQL String Is Not Query Error When Accessing iStore As Guest User

(Doc ID 1954031.1)

Last updated on FEBRUARY 23, 2016

Applies to:

Oracle iStore - Version 12.2.2 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


 On Dev:  12.2.4 version, Session Management

Unable To Access iStore  due to the following error

SQL string is not Query

Source :-

oracle.apps.jtf.base.resources.FrameworkException: SQL string is not Query
at oracle.apps.jtf.security.auth.AuthServiceImpl.setCustomerID(Unknown Source)
at oracle.apps.jtf.security.base.SecurityManager.setCustomerID(Unknown Source)
at oracle.apps.ibe.util.Session.getFndUserInfo(Session.java:1163)
at oracle.apps.ibe.util.Session.getGuestPartyId(Session.java:2291)
at oracle.apps.ibe.util.Session.guestPostProcess(Session.java:2261)
at oracle.apps.ibe.util.Session.loginGuestUser(Session.java:2251)
at oracle.apps.ibe.util.RequestCtx.<init>(RequestCtx.java:220)
at oracle.apps.ibe.util.RequestCtx.start(RequestCtx.java:429)
at _pages.__ibeczzphome._jspService(__ibeczzphome.java:474)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

The issue can be reproduced at will with the following steps:

1. Access iStore Home Page
2. See error

The issue has the following business impact:
Due to this issue, users cannot access iStore at all.


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