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

Last updated on FEBRUARY 19, 2013

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


Symptoms

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

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)

 

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