My Oracle Support Banner

"Command text was not set for the command object." Exception When Doing a Search in GRCM (Doc ID 577762.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Governance, Risk and Compliance Manager - Version 7.7.1 to 7.8 [Release Rel 12]
Information in this document applies to any platform.
***Checked for relevance on 19-Feb-2013***


When doing a search in the GRCM application (Quick Search or Advanced Search), you receive the following exception:

Command text was not set for the command object.

Server stack trace:
at e100.Server.Sox.SoxServer.ExecuteSqlQuery(String sql)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]:
at SoxNav.Reporting.ExecuteCustomSQL(String strSearchString, String strDocType, Int16 intTimeout)
at SoxNav.Migrated_SearchCriteria.ExecuteSearch(Int16 intTimeout)
at SoxNav.Migrated_SearchCriteria.btnExecuteSearch_Click(Object sender, EventArgs e)



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.