Query Failed. Contact portal administrator. System.Exception: select distinct Name COLLATE Latin1_General_CI_AI Name
, Description COLLATE Latin1_General_CI_AI Description , 'SSRS Web Report' 'Report Type'
from SOO_SSRS_catalog where type = 2
and path like '/Custom EX Reports/%'
and Path not like '%ZSSRS%'
and Path not like '%sub%'
and Path not like '%IR_Development%'
and Path not like '%Custom IR EX Reports%'
and Path not like '%James%'
and Path not like '%Cari%'
and Path not like '%Backup%'
union all
select distinct workspace_owner_object_dtl_v.owner_object_desc Name ,
workspace_owner_object_dtl_v.string_property_1 Description, 'Infomaker Report' 'Report Type'
from workspace_owner_object_dtl_v
where workspace_owner_object_dtl_v.string_property_1 in
( SELECT distinct workspace_owner_object_dtl_v.string_property_1
FROM workspace_owner_object_dtl_v,
workspace_displayed_object
WHERE ( workspace_owner_object_dtl_v.workspace_owner_object_id = workspace_displayed_object.workspace_owner_object_id ) and
( ( workspace_owner_object_dtl_v.workspace_obj_type_id = 4 ) AND
( workspace_owner_object_dtl_v.workspace_container_id = 2 ))
and workspace_owner_object_dtl_v.string_property_1 not like ('%Infomaker Training%') )
order by Name, Description
---> System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'ReportServer.dbo.catalog'.
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not use view or function 'SOO_SSRS_catalog' because of binding errors.
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()
SSRS and Infomaker Workspace Reports: No Public Access