Find Answers

Filter Search Results

Ask a Question

Example: "Database could not be verified"

Results

Distribution report with SLA fields drill down gets error

Database exception in CReportExecList::SetTotalRecords using SQL: select SLA_TSM_INCIDENTS .row_id from SLA_TSM_INCIDENTS with (nolock) , TS_PROJECTS with (nolock) where SLA_TSM_INCIDENTS .TS_PROJECTID=TS_PROJECTS.TS_ID and SLA_TSM_INCIDENTS.TS_PRIORITY in (302)

Serena Service Manager

... ................................................. 4 Incidents – TSM_INCIDENTS ............................................. ...

Similar Answers

Reports fail if large result set - Database exception in CReportExecList::ExecuteDataCollection using SQL: ... Data truncated.

select TSM_INCIDENTS .TS_ID, TSM_INCIDENTS .TS_UUID, TSM_INCIDENTS .TS_RESOLUTION_SUMMARY, TSM_INCIDENTS .TS_SECONDARYOWNER, TSM_INCIDENTS .TS_PROJECTID, TSM_INCIDENTS .TS_SUBMITTER, TSM_INCIDENTS .TS_CLOSEDATE, TSM_INCIDENTS .TS_SUBMITDATE, TSM_INCIDENTS .TS_ACTIVEINACTIVE,

Trend report may not work after upgrade to 11.0+ - error begins with - Database exception in CReportExecTrend::ExecuteDataCollection() using SQL:

select l.TS_ID, l.TS_SUBMITDATE, l.TS_LEVEL_2_TECHNICIAN from TSM_INCIDENTS l where ( tsm_incidents .ts_id in (select ts_itemid from ts_changeactions where ts_tableid=(select ts_tables.ts_id from ts_tables where ts_name = 'Incidents') and ts_userid=(select ts_users.ts_id

How can I find the name of the report associated with a "Reference Name" and the project it resides in to troubleshoot the Embedded Report Widget?

http://localhost/tmtrack/tmtrack.dll?ReportPage=&template=reports%2Flist&ReportRef= TSM_INCIDENTS .SSM.IM.OtherIncidents&HasRuntimeParams=1&F_TS_AFFECTED_USER=2&embedded= The part of the URL you care about is the "ReportRef" parameter. In the example above this is:

How can I do SLA Reporting via Standard SBM listing Reports?

Oracle – Service Request Violations in last month @where TSM_INCIDENTS .TS_ID in (SELECT ITEM_ID FROM SLA_ITEM where RISK_CATEGORY=’V’ AND START_DATE >= add_months(trunc(sysdate,'mm'),-1) and START_DATE < trunc(sysdate, 'mm' and ITEM_TABLE_ID=1011

Example for using SLA details in SBM reports via Advanced SQL Conditions

ORACLE Example for all items in last month that violated their SLA: @where TSM_INCIDENTS .TS_ID in (SELECT ITEM_ID FROM SLA_ITEM where (RISK_CATEGORY='V' OR RISK_CATEGORY='L' OR RISK_CATEGORY='M') AND START_DATE >= add_months(trunc(sysdate,'mm'),-1)

Knowledgebase

Find Answers

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance