Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
  Results
CMS-XML 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)
PDF Serena Service Manager
... ................................................. 4 Incidents ā€“ TSM_INCIDENTS ............................................. ...
CMS-XML 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,
CMS-XML 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
CMS-XML 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:
CMS-XML 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
CMS-XML 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)

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs