Query Failed. Contact portal administrator. System.Exception: SELECT coalesce('' + hd.DFLT_DISPLAY_TEXT + '
' + coalesce(ht.TO_RESOLVE_HOLD, hd.TO_RESOLVE_HOLD) + '', d.msg) Hold
FROM (Select 'You have no active holds.' msg) d
LEFT JOIN Hold_Tran ht on ht.start_dte < current_timestamp and coalesce(ht.end_dte,'2999-12-31') > current_timestamp and ht.id_num = '0'
LEFT JOIN HOLDS_DEF hd on hd.HOLD_CDE = ht.HOLD_CDE and hd.SHOW_ON_WEB = 'Y'
and ('Y' IN (hd.HOLD_TRANSCRIPT, hd.HOLD_DIPLOMA, hd.HOLD_GRADE_RPT, hd.HOLD_REG) or 'N' IN (hd.ALLOW_WEB_REG, hd.ALLOW_WEB_TRANSCRIPT, hd.ALLOW_WEB_GRADES)) ---> System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'Hold_Tran'.
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at CUS.OdbcConnectionClass3.OdbcConnectionClass3.OdbcConn(String sqlStatement, Exception& exReturn, Int32 timeout, List`1 parameters)
--- End of inner exception stack trace ---
at CUS.ICS.SimpleQuery.SimpleQueryExecution.GetData(Guid portletId)
at CUS.ICS.SimpleQuery.Default_View.RenderOutput()
You are not authorized to use this portlet; It is only available to users in certain roles within the portal.