DocWiki - User contributions [en]

Reporting: Report for Scheduled reports

2012-07-03T08:00:39Z

Pperiasa: /* Reporting: Report for Scheduled reports */

== Reporting: Report for Scheduled reports ==

{| border="1"
|-
! '''Problem Summary'''
| Check the status of reports that are scheduled
|-
! '''Error Message'''
| Not relevant
|-
! '''Possible Cause'''
| Not relevant
|-
! '''Recommended Action'''
|
Save the XML below to a file and import as report.

<?xml version="1.0" encoding="utf-8"?> <SerializedReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ReportName>SchedulerStatus</ReportName> <ReportDescription /> <ModifiedBy>2K3SERVER-1\administrator</ModifiedBy> <FilePath>c:\temp\055f1237-e4b5-4c0c-9e0e-46ad36bbb290.xml</FilePath> <Category>00000000-0000-0000-0000-000000000000</Category> <AllowsTodayRange>true</AllowsTodayRange> <AllowsYesterdayRange>true</AllowsYesterdayRange> <AllowsThisWeekRange>false</AllowsThisWeekRange> <AllowsLastWeekRange>true</AllowsLastWeekRange> <AllowsThisMonthRange>true</AllowsThisMonthRange> <AllowsLastMonthRange>true</AllowsLastMonthRange> <AllowsQuarterToDateRange>true</AllowsQuarterToDateRange> <AllowsLastQuarterRange>true</AllowsLastQuarterRange> <AllowsYearToDateRange>true</AllowsYearToDateRange> <AllowsLastYearRange>true</AllowsLastYearRange> <AllowsTomorrowRange>false</AllowsTomorrowRange> <AllowsNextWeekRange>false</AllowsNextWeekRange> <AllowsNextMonthRange>false</AllowsNextMonthRange> <Type>Personal</Type> <Timeframe>Realtime</Timeframe> <bIsEditing>false</bIsEditing> <SortClause /> <RefreshRate>60</RefreshRate> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID> <CustomSQL /> <AnonymousBlock>select B.SaveFileName, A.State, A.ProjectedRunDateTime, A.ActualRunDateTime from AA_RunSchedule A,AA_ScheduledReports B

where ProjectedRunDateTime&gt;:From and ProjectedRunDateTime&lt;:To and A.ScheduleID=B.ID

order by ProjectedRunDateTime</AnonymousBlock> <G1Summary>true</G1Summary> <G2Summary>true</G2Summary> <G3Summary>true</G3Summary> <DataSummary>true</DataSummary> <GridMode>realtime</GridMode> <VerticalAlign>top</VerticalAlign> <IncludeDateTime>true</IncludeDateTime> <IncludeFilterSummary>true</IncludeFilterSummary> <NumGroups>0</NumGroups> <GroupField1>00000000-0000-0000-0000-000000000000</GroupField1> <SortField1>00000000-0000-0000-0000-000000000000</SortField1> <GroupField2>00000000-0000-0000-0000-000000000000</GroupField2> <SortField2>00000000-0000-0000-0000-000000000000</SortField2> <GroupField3>00000000-0000-0000-0000-000000000000</GroupField3> <SortField3>00000000-0000-0000-0000-000000000000</SortField3> <SortFieldData>00000000-0000-0000-0000-000000000000</SortFieldData> <SortField1Direction>ASC</SortField1Direction> <SortField2Direction>ASC</SortField2Direction> <SortField3Direction>ASC</SortField3Direction> <SortFieldDataDirection>ASC</SortFieldDataDirection> <ChartSeriesList /> <x3DEnable>false</x3DEnable> <XAxisTitle /> <XAxisTickMarks>false</XAxisTickMarks> <XAxisGridLines>false</XAxisGridLines> <XAxisInterlacedStrips>false</XAxisInterlacedStrips> <XAxisReversed>false</XAxisReversed> <XAxisSideMargin>false</XAxisSideMargin> <XAxisLabelFormat /> <YAxisTitle /> <YAxisTickMarks>false</YAxisTickMarks> <YAxisGridLines>false</YAxisGridLines> <YAxisInterlacedStrips>false</YAxisInterlacedStrips> <YAxisReversed>false</YAxisReversed> <YAxisStartFromZero>false</YAxisStartFromZero> <YAxisLabelFormat /> <LegendVisible>false</LegendVisible> <LegendStyle>Column</LegendStyle> <LegendDocking>Right</LegendDocking> <LegendAlignment>Near</LegendAlignment> <LegendInsidePlotArea>false</LegendInsidePlotArea> <TitleText /> <TitleDocking>Top</TitleDocking> <TitleAlignment>TopCenter</TitleAlignment> <PointLabelsDisplay>false</PointLabelsDisplay> <PointLabelsSmartLabels>false</PointLabelsSmartLabels> <PointLabelAngle>0</PointLabelAngle> <XLabelAlign>center</XLabelAlign> <XAxisExtent>80</XAxisExtent> <YAxisExtent>80</YAxisExtent> <XAxisVisible>true</XAxisVisible> <YAxisVisible>true</YAxisVisible> <XGroupBySeries>false</XGroupBySeries> <YGroupBySeries>false</YGroupBySeries> <XAxisMin>0</XAxisMin> <YAxisMin>0</YAxisMin> <XAxisMax>100</XAxisMax> <YAxisMax>100</YAxisMax> <TitleFontSize>9</TitleFontSize> <XLabelFontSize>8</XLabelFontSize> <YLabelFontSize>8</YLabelFontSize> <XTitleFontSize>9</XTitleFontSize> <YTitleFontSize>9</YTitleFontSize> <TitleRotation>0</TitleRotation> <XRotation>0</XRotation> <YRotation>0</YRotation> <TitleLeft>50</TitleLeft> <TitleTop>5</TitleTop> <ChartAreaLeft>0</ChartAreaLeft> <ChartAreaTop>0</ChartAreaTop> <ChartAreaHeight>100</ChartAreaHeight> <ChartAreaWidth>100</ChartAreaWidth> <LegendLeft>80</LegendLeft> <LegendTop>10</LegendTop> <LegendHeight>80</LegendHeight> <LegendWidth>20</LegendWidth> <YAxisLabelLeft>5</YAxisLabelLeft> <YAxisLabelTop>40</YAxisLabelTop> <XAxisLabelLeft>50</XAxisLabelLeft> <XAxisLabelTop>95</XAxisLabelTop> <HasIntervalField>false</HasIntervalField> <CurrentInterval>30</CurrentInterval> <UsePageNumbers>true</UsePageNumbers> <TimeFrameType>D</TimeFrameType> <BackgroundImage /> <ShowGaugeLabels>true</ShowGaugeLabels> <ChartWidth>800</ChartWidth> <ChartHeight>600</ChartHeight> <ChartTheme /> <FontSize>8</FontSize> <XsltFileName /> <ShowFilterDialog>true</ShowFilterDialog> <DefaultDashboardDisplayMode>GRID</DefaultDashboardDisplayMode> <CategoryID>00000000-0000-0000-0000-000000000000</CategoryID> <DatasourceID>de2cd6f3-a603-49ca-99c4-4ffbc1362504</DatasourceID> <DataSourceType>AnonymousBlock</DataSourceType> <URL /> <XsltID>00000000-0000-0000-0000-000000000000</XsltID> <AnsiWarnings>false</AnsiWarnings> <AnsiNulls>true</AnsiNulls> <ArithAbort>false</ArithAbort> <ArithIgnore>true</ArithIgnore> <KeyCriteriaFieldID>00000000-0000-0000-0000-000000000000</KeyCriteriaFieldID> <RestrictTimeFrame>false</RestrictTimeFrame> <CommandTimeout>999</CommandTimeout> <RollingValue>0</RollingValue> <ParentReportID /> <DisplayFormat>Grid</DisplayFormat> <ChartType /> <YLabelFormat /> <HistoricalFilterType>NoFilter</HistoricalFilterType> <HistoricalStartDate>0001-01-01T00:00:00</HistoricalStartDate> <HistoricalEndDate>0001-01-01T00:00:00</HistoricalEndDate> <HistoricalStartTime>0001-01-01T00:00:00</HistoricalStartTime> <HistoricalEndTime>0001-01-01T00:00:00</HistoricalEndTime> <Parameters> <ReportParameter> <QuoteValues>None</QuoteValues> <ID>6c2c6a1f-135b-47a9-8d26-2d3412ca66e7</ID> <RestrictedValueList /> <FriendlyName>Scheduled From </FriendlyName> <NullForBlank>true</NullForBlank> <ValueSeparator>,</ValueSeparator> <PrefixValueWith /> <ParameterIndex>0</ParameterIndex> <ValueQuery /> <SelectedValueID>00000000-0000-0000-0000-000000000000</SelectedValueID> <SelectedCollectionID>00000000-0000-0000-0000-000000000000</SelectedCollectionID> <FreeformValue /> <AllowFreeformEntry>true</AllowFreeformEntry> <Bluevuename>New Parameter</Bluevuename> <TestValue>'2010-04-23 00:00:18.853'</TestValue> <HardCodedValue /> <FilteredFieldID>00000000-0000-0000-0000-000000000000</FilteredFieldID> <DataType>varchar</DataType> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID> <Name>@From</Name> <Description>Reports Scheduled To Run From. Enter Date in format 2010-04-03</Description> <ParameterType>AnonymousBlock</ParameterType> <Required>true</Required> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> </ReportParameter> <ReportParameter> <QuoteValues>None</QuoteValues> <ID>b34cec55-7c21-42fc-abbf-9305dd515a80</ID> <RestrictedValueList /> <FriendlyName>Scheduled Until </FriendlyName> <NullForBlank>true</NullForBlank> <ValueSeparator>,</ValueSeparator> <PrefixValueWith /> <ParameterIndex>0</ParameterIndex> <ValueQuery /> <SelectedValueID>00000000-0000-0000-0000-000000000000</SelectedValueID> <SelectedCollectionID>00000000-0000-0000-0000-000000000000</SelectedCollectionID> <FreeformValue /> <AllowFreeformEntry>true</AllowFreeformEntry> <Bluevuename>New Parameter</Bluevuename> <TestValue>'2010-04-23 00:00:18.853'</TestValue> <HardCodedValue /> <FilteredFieldID>00000000-0000-0000-0000-000000000000</FilteredFieldID> <DataType>varchar</DataType> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID> <Name>@To</Name> <Description>Reports scheduled to run until. Enter Date in format 2010-04-03</Description> <ParameterType>AnonymousBlock</ParameterType> <Required>true</Required> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> </ReportParameter> </Parameters> <Fields> <Field> <Group1FooterFormula /> <Group2FooterFormula /> <Group3FooterFormula /> <FilterChanged>false</FilterChanged> <FilterPreQuery>true</FilterPreQuery> <ExportAsHHMMSS>false</ExportAsHHMMSS> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID> <AllowUsersToShow>true</AllowUsersToShow> <NormalizeTimeZone>false</NormalizeTimeZone> <TimeFrameType>Y</TimeFrameType> <ID>828c8a4e-cc91-414f-b606-4b38b1307593</ID> <DisplayWidth>125</DisplayWidth> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes> <ValueSQLQuery /> <IsFakeFilterField>false</IsFakeFilterField> <IsFormula>false</IsFormula> <FooterFormula /> <DisplayFormatStored>FormattedData</DisplayFormatStored> <XsltID>5db791d1-720d-4115-a9d9-2cad9d1b7721</XsltID> <FooterStyle>None</FooterStyle> <DrilldownOptions /> <Threshholds /> <Description /> <Key>SaveFileName</Key> <FormatString /> <TableID>00000000-0000-0000-0000-000000000000</TableID> <IsAggregate>false</IsAggregate> <ActiveFilterIndex>0</ActiveFilterIndex> <BluevueName>Report</BluevueName> <Formula /> <HighValue>0</HighValue> <LowValue>0</LowValue> <HighRangeValue>0</HighRangeValue> <LowRangeValue>0</LowRangeValue> <Randomize>false</Randomize> <Filters /> <FieldID>828c8a4e-cc91-414f-b606-4b38b1307593</FieldID> <FieldIndex>0</FieldIndex> <KeyCriteriaSearchable>false</KeyCriteriaSearchable> <ColumnName>SaveFileName</ColumnName> <DisplayName>Report</DisplayName> <KeyCriteria>true</KeyCriteria> <KeyCriteriaName>SaveFileName</KeyCriteriaName> <Displayed>true</Displayed> <DecimalPlaces>2</DecimalPlaces> <ShowAvg>false</ShowAvg> <ShowSum>false</ShowSum> <Filter> <DayFilter>ALL</DayFilter> <FromTime>2010-04-26T00:00:00</FromTime> <ToTime>2010-04-26T23:59:59</ToTime> <RestrictTime>false</RestrictTime> <DatabaseID>18c2086b-f149-4614-a725-362322f289e7</DatabaseID> <IsStockHistoricalFilter>false</IsStockHistoricalFilter> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter> <Caption>New Filter</Caption> <FilterField /> <FieldType>BigInt</FieldType> <FilterValues /> <FilterType1>NoFilter</FilterType1> <RollingValue>1</RollingValue> <IsHistoricalFilter>false</IsHistoricalFilter> <FieldID>828c8a4e-cc91-414f-b606-4b38b1307593</FieldID> <FilteringValues> <DataID>828c8a4e-cc91-414f-b606-4b38b1307593</DataID> <Updating>0</Updating> <RefreshRate>86400</RefreshRate> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed> <ValueListQuery /> <CollectionQuery /> <IsDirty>true</IsDirty> <ID>828c8a4e-cc91-414f-b606-4b38b1307593</ID> <DatasourceID /> <ValueListDataType>Numeric</ValueListDataType> <Values> <Values> <IsDirty>true</IsDirty> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <Description /> <ValueListValueID>a1b194f0-79af-4055-bff8-4eff61828a37</ValueListValueID> <ValueListValue /> <DataType>String</DataType> <Ident>0</Ident> </Values> </Values> </FilteringValues> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID> </Filter> <DataType>String</DataType> <SimpleDataType>String</SimpleDataType> <ColumnOrder>-1</ColumnOrder> <Alias /> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID> <ColumnSize>0</ColumnSize> <NumericPrecision>255</NumericPrecision> <NumericScale>255</NumericScale> <AllowDBNull>true</AllowDBNull> <IsUnique>false</IsUnique> <IsFakeHistoricalField>false</IsFakeHistoricalField> <IsKeyColumn>false</IsKeyColumn> <IsAutoIncrement>false</IsAutoIncrement> <IsReadOnly>false</IsReadOnly> <IsLong>false</IsLong> <BaseSchemaName /> <BaseCatalogName /> <BaseTableName /> <BaseColumnname>SaveFileName</BaseColumnname> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected> <ShowGauge>false</ShowGauge> <UseFooterForGauge>false</UseFooterForGauge> <DataID>828c8a4e-cc91-414f-b606-4b38b1307593</DataID> <ShelfLifeInSeconds>180</ShelfLifeInSeconds> <AutoMergeCells>false</AutoMergeCells> </Field> <Field> <Group1FooterFormula /> <Group2FooterFormula /> <Group3FooterFormula /> <FilterChanged>false</FilterChanged> <FilterPreQuery>true</FilterPreQuery> <ExportAsHHMMSS>false</ExportAsHHMMSS> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID> <AllowUsersToShow>true</AllowUsersToShow> <NormalizeTimeZone>false</NormalizeTimeZone> <TimeFrameType>Y</TimeFrameType> <ID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</ID> <DisplayWidth>125</DisplayWidth> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes> <ValueSQLQuery /> <IsFakeFilterField>false</IsFakeFilterField> <IsFormula>false</IsFormula> <DisplayFormatStored>FormattedData</DisplayFormatStored> <XsltID>00000000-0000-0000-0000-000000000000</XsltID> <FooterStyle>None</FooterStyle> <DrilldownOptions /> <Threshholds> <Threshhold> <ThreshholdValue xsi:type="xsd:string">0</ThreshholdValue> <ThreshholdValue2 xsi:type="xsd:string" /> <ThreshholdType>EqualTo</ThreshholdType> <FormattingType1>Font</FormattingType1> <GlobalVariableID /> <ID>585dad64-4fe6-4421-af5f-640afaea0eeb</ID> <Text>To Run Today</Text> <ImageURL /> <ForeColor>NamedColor:Black</ForeColor> <BackColor>ARGBColor:255:204:255:204</BackColor> <IsBold>true</IsBold> <IsBlinking>false</IsBlinking> </Threshhold> <Threshhold> <ThreshholdValue xsi:type="xsd:string">1</ThreshholdValue> <ThreshholdValue2 xsi:type="xsd:string" /> <ThreshholdType>EqualTo</ThreshholdType> <FormattingType1>Font</FormattingType1> <GlobalVariableID /> <ID>0906d83e-8aae-43a4-aca9-52fad78a7be5</ID> <Text>In Scheduler Queue </Text> <ImageURL /> <ForeColor>NamedColor:Black</ForeColor> <BackColor>ARGBColor:255:0:255:0</BackColor> <IsBold>false</IsBold> <IsBlinking>false</IsBlinking> </Threshhold> <Threshhold> <ThreshholdValue xsi:type="xsd:string">2</ThreshholdValue> <ThreshholdValue2 xsi:type="xsd:string" /> <ThreshholdType>EqualTo</ThreshholdType> <FormattingType1>Font</FormattingType1> <GlobalVariableID /> <ID>f935bf48-b2d3-4aaa-8eaa-8b7811cb61ec</ID> <Text>Running...</Text> <ImageURL /> <ForeColor>ARGBColor:255:0:0:0</ForeColor> <BackColor>ARGBColor:255:255:255:102</BackColor> <IsBold>false</IsBold> <IsBlinking>false</IsBlinking> </Threshhold> <Threshhold> <ThreshholdValue xsi:type="xsd:string">3</ThreshholdValue> <ThreshholdValue2 xsi:type="xsd:string" /> <ThreshholdType>EqualTo</ThreshholdType> <FormattingType1>Font</FormattingType1> <GlobalVariableID /> <ID>16f30f3f-dfd4-4992-8c9c-0cbfa64e6f58</ID> <Text>Run Succesfully</Text> <ImageURL /> <ForeColor>NamedColor:Black</ForeColor> <BackColor>ARGBColor:255:170:170:170</BackColor> <IsBold>true</IsBold> <IsBlinking>false</IsBlinking> </Threshhold> <Threshhold> <ThreshholdValue xsi:type="xsd:string">4</ThreshholdValue> <ThreshholdValue2 xsi:type="xsd:string" /> <ThreshholdType>EqualTo</ThreshholdType> <FormattingType1>Font</FormattingType1> <GlobalVariableID /> <ID>996ff789-bcde-442f-8499-8e5768b9df15</ID> <Text>Failed During Run</Text> <ImageURL /> <ForeColor>NamedColor:Black</ForeColor> <BackColor>ARGBColor:255:255:51:51</BackColor> <IsBold>true</IsBold> <IsBlinking>false</IsBlinking> </Threshhold> </Threshholds> <Key>State</Key> <FormatString /> <TableID>00000000-0000-0000-0000-000000000000</TableID> <IsAggregate>false</IsAggregate> <ActiveFilterIndex>0</ActiveFilterIndex> <BluevueName>State</BluevueName> <HighValue>0</HighValue> <LowValue>0</LowValue> <HighRangeValue>0</HighRangeValue> <LowRangeValue>0</LowRangeValue> <Randomize>false</Randomize> <Filters /> <FieldID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</FieldID> <FieldIndex>1</FieldIndex> <KeyCriteriaSearchable>false</KeyCriteriaSearchable> <ColumnName>State</ColumnName> <DisplayName>State</DisplayName> <KeyCriteria>true</KeyCriteria> <KeyCriteriaName>State</KeyCriteriaName> <Displayed>true</Displayed> <DecimalPlaces>2</DecimalPlaces> <ShowAvg>false</ShowAvg> <ShowSum>false</ShowSum> <Filter> <DayFilter>ALL</DayFilter> <FromTime>2010-04-26T00:00:00</FromTime> <ToTime>2010-04-26T23:59:59</ToTime> <RestrictTime>false</RestrictTime> <DatabaseID>76c0b05c-d62d-4010-9b1a-4d9efc83aeeb</DatabaseID> <IsStockHistoricalFilter>false</IsStockHistoricalFilter> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter> <Caption>New Filter</Caption> <FilterField /> <FieldType>BigInt</FieldType> <FilterValues /> <FilterType1>NoFilter</FilterType1> <RollingValue>1</RollingValue> <IsHistoricalFilter>false</IsHistoricalFilter> <FieldID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</FieldID> <FilteringValues> <DataID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</DataID> <Updating>0</Updating> <RefreshRate>86400</RefreshRate> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed> <ValueListQuery /> <CollectionQuery /> <IsDirty>true</IsDirty> <ID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</ID> <DatasourceID /> <ValueListDataType>Numeric</ValueListDataType> <Values> <Values> <IsDirty>true</IsDirty> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <Description /> <ValueListValueID>85c04aec-c00d-4fdf-9a73-dcbe7968bd15</ValueListValueID> <ValueListValue /> <DataType>String</DataType> <Ident>0</Ident> </Values> </Values> </FilteringValues> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID> </Filter> <DataType>Int32</DataType> <SimpleDataType>Numeric</SimpleDataType> <ColumnOrder>-1</ColumnOrder> <Alias /> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID> <ColumnSize>0</ColumnSize> <NumericPrecision>10</NumericPrecision> <NumericScale>255</NumericScale> <AllowDBNull>true</AllowDBNull> <IsUnique>false</IsUnique> <IsFakeHistoricalField>false</IsFakeHistoricalField> <IsKeyColumn>false</IsKeyColumn> <IsAutoIncrement>false</IsAutoIncrement> <IsReadOnly>false</IsReadOnly> <IsLong>false</IsLong> <BaseSchemaName /> <BaseCatalogName /> <BaseTableName /> <BaseColumnname>State</BaseColumnname> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected> <ShowGauge>false</ShowGauge> <UseFooterForGauge>false</UseFooterForGauge> <DataID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</DataID> <ShelfLifeInSeconds>180</ShelfLifeInSeconds> <AutoMergeCells>false</AutoMergeCells> </Field> <Field> <Group1FooterFormula /> <Group2FooterFormula /> <Group3FooterFormula /> <FilterChanged>false</FilterChanged> <FilterPreQuery>true</FilterPreQuery> <ExportAsHHMMSS>false</ExportAsHHMMSS> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID> <AllowUsersToShow>true</AllowUsersToShow> <NormalizeTimeZone>false</NormalizeTimeZone> <TimeFrameType>Y</TimeFrameType> <ID>aa3f113c-d835-4469-aa9b-696ded7469f6</ID> <DisplayWidth>125</DisplayWidth> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes> <ValueSQLQuery /> <IsFakeFilterField>false</IsFakeFilterField> <IsFormula>false</IsFormula> <DisplayFormatStored>FormattedData</DisplayFormatStored> <XsltID>00000000-0000-0000-0000-000000000000</XsltID> <FooterStyle>None</FooterStyle> <DrilldownOptions /> <Threshholds /> <Key>ProjectedRunDateTime</Key> <FormatString /> <TableID>00000000-0000-0000-0000-000000000000</TableID> <IsAggregate>false</IsAggregate> <ActiveFilterIndex>0</ActiveFilterIndex> <BluevueName>ProjectedRunDateTime</BluevueName> <HighValue>0</HighValue> <LowValue>0</LowValue> <HighRangeValue>0</HighRangeValue> <LowRangeValue>0</LowRangeValue> <Randomize>false</Randomize> <Filters /> <FieldID>aa3f113c-d835-4469-aa9b-696ded7469f6</FieldID> <FieldIndex>2</FieldIndex> <KeyCriteriaSearchable>false</KeyCriteriaSearchable> <ColumnName>ProjectedRunDateTime</ColumnName> <DisplayName>ProjectedRunDateTime</DisplayName> <KeyCriteria>true</KeyCriteria> <KeyCriteriaName>ProjectedRunDateTime</KeyCriteriaName> <Displayed>true</Displayed> <DecimalPlaces>2</DecimalPlaces> <ShowAvg>false</ShowAvg> <ShowSum>false</ShowSum> <Filter> <DayFilter>ALL</DayFilter> <FromTime>2010-04-26T00:00:00</FromTime> <ToTime>2010-04-26T23:59:59</ToTime> <RestrictTime>false</RestrictTime> <DatabaseID>17886618-30a0-4e74-96b2-e2d876a0ed45</DatabaseID> <IsStockHistoricalFilter>false</IsStockHistoricalFilter> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter> <Caption>New Filter</Caption> <FilterField /> <FieldType>BigInt</FieldType> <FilterValues /> <FilterType1>NoFilter</FilterType1> <RollingValue>1</RollingValue> <IsHistoricalFilter>false</IsHistoricalFilter> <FieldID>aa3f113c-d835-4469-aa9b-696ded7469f6</FieldID> <FilteringValues> <DataID>aa3f113c-d835-4469-aa9b-696ded7469f6</DataID> <Updating>0</Updating> <RefreshRate>86400</RefreshRate> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed> <ValueListQuery /> <CollectionQuery /> <IsDirty>true</IsDirty> <ID>aa3f113c-d835-4469-aa9b-696ded7469f6</ID> <DatasourceID /> <ValueListDataType>Numeric</ValueListDataType> <Values> <Values> <IsDirty>true</IsDirty> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <Description /> <ValueListValueID>aed290ea-cd20-4a7d-af8c-24de33817efa</ValueListValueID> <ValueListValue /> <DataType>String</DataType> <Ident>0</Ident> </Values> </Values> </FilteringValues> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID> </Filter> <DataType>DateTime</DataType> <SimpleDataType>Date</SimpleDataType> <ColumnOrder>-1</ColumnOrder> <Alias /> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID> <ColumnSize>0</ColumnSize> <NumericPrecision>23</NumericPrecision> <NumericScale>3</NumericScale> <AllowDBNull>true</AllowDBNull> <IsUnique>false</IsUnique> <IsFakeHistoricalField>false</IsFakeHistoricalField> <IsKeyColumn>false</IsKeyColumn> <IsAutoIncrement>false</IsAutoIncrement> <IsReadOnly>false</IsReadOnly> <IsLong>false</IsLong> <BaseSchemaName /> <BaseCatalogName /> <BaseTableName /> <BaseColumnname>ProjectedRunDateTime</BaseColumnname> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected> <ShowGauge>false</ShowGauge> <UseFooterForGauge>false</UseFooterForGauge> <DataID>aa3f113c-d835-4469-aa9b-696ded7469f6</DataID> <ShelfLifeInSeconds>180</ShelfLifeInSeconds> <AutoMergeCells>false</AutoMergeCells> </Field> <Field> <Group1FooterFormula /> <Group2FooterFormula /> <Group3FooterFormula /> <FilterChanged>false</FilterChanged> <FilterPreQuery>true</FilterPreQuery> <ExportAsHHMMSS>false</ExportAsHHMMSS> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID> <AllowUsersToShow>true</AllowUsersToShow> <NormalizeTimeZone>false</NormalizeTimeZone> <TimeFrameType>Y</TimeFrameType> <ID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</ID> <DisplayWidth>125</DisplayWidth> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes> <ValueSQLQuery /> <IsFakeFilterField>false</IsFakeFilterField> <IsFormula>false</IsFormula> <DisplayFormatStored>FormattedData</DisplayFormatStored> <XsltID>00000000-0000-0000-0000-000000000000</XsltID> <FooterStyle>None</FooterStyle> <DrilldownOptions /> <Threshholds /> <Key>ActualRunDateTime</Key> <FormatString /> <TableID>00000000-0000-0000-0000-000000000000</TableID> <IsAggregate>false</IsAggregate> <ActiveFilterIndex>0</ActiveFilterIndex> <BluevueName>ActualRunDateTime</BluevueName> <HighValue>0</HighValue> <LowValue>0</LowValue> <HighRangeValue>0</HighRangeValue> <LowRangeValue>0</LowRangeValue> <Randomize>false</Randomize> <Filters /> <FieldID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</FieldID> <FieldIndex>3</FieldIndex> <KeyCriteriaSearchable>false</KeyCriteriaSearchable> <ColumnName>ActualRunDateTime</ColumnName> <DisplayName>ActualRunDateTime</DisplayName> <KeyCriteria>true</KeyCriteria> <KeyCriteriaName>ActualRunDateTime</KeyCriteriaName> <Displayed>true</Displayed> <DecimalPlaces>2</DecimalPlaces> <ShowAvg>false</ShowAvg> <ShowSum>false</ShowSum> <Filter> <DayFilter>ALL</DayFilter> <FromTime>2010-04-26T00:00:00</FromTime> <ToTime>2010-04-26T23:59:59</ToTime> <RestrictTime>false</RestrictTime> <DatabaseID>8b2208e6-c071-4ec6-8158-cf0fa561684d</DatabaseID> <IsStockHistoricalFilter>false</IsStockHistoricalFilter> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter> <Caption>New Filter</Caption> <FilterField /> <FieldType>BigInt</FieldType> <FilterValues /> <FilterType1>NoFilter</FilterType1> <RollingValue>1</RollingValue> <IsHistoricalFilter>false</IsHistoricalFilter> <FieldID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</FieldID> <FilteringValues> <DataID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</DataID> <Updating>0</Updating> <RefreshRate>86400</RefreshRate> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed> <ValueListQuery /> <CollectionQuery /> <IsDirty>true</IsDirty> <ID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</ID> <DatasourceID /> <ValueListDataType>Numeric</ValueListDataType> <Values> <Values> <IsDirty>true</IsDirty> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <Description /> <ValueListValueID>35a29450-2e3a-46b8-b438-166bd21a93da</ValueListValueID> <ValueListValue /> <DataType>String</DataType> <Ident>0</Ident> </Values> </Values> </FilteringValues> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID> </Filter> <DataType>DateTime</DataType> <SimpleDataType>Date</SimpleDataType> <ColumnOrder>-1</ColumnOrder> <Alias /> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID> <ColumnSize>0</ColumnSize> <NumericPrecision>23</NumericPrecision> <NumericScale>3</NumericScale> <AllowDBNull>true</AllowDBNull> <IsUnique>false</IsUnique> <IsFakeHistoricalField>false</IsFakeHistoricalField> <IsKeyColumn>false</IsKeyColumn> <IsAutoIncrement>false</IsAutoIncrement> <IsReadOnly>false</IsReadOnly> <IsLong>false</IsLong> <BaseSchemaName /> <BaseCatalogName /> <BaseTableName /> <BaseColumnname>ActualRunDateTime</BaseColumnname> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected> <ShowGauge>false</ShowGauge> <UseFooterForGauge>false</UseFooterForGauge> <DataID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</DataID> <ShelfLifeInSeconds>180</ShelfLifeInSeconds> <AutoMergeCells>false</AutoMergeCells> </Field> </Fields> <HistoricalKey /> <ReportTypeUserSystem>PERSONAL</ReportTypeUserSystem> <ReportAccessLevel>PRIVATE</ReportAccessLevel> <PageSize>200</PageSize> <HelpLink /> <HelpLinkTitle /> </SerializedReport> 

|-
! '''Release'''
| Release 7.5(x)
|-
! '''Associated CDETS #'''
| Not relevant
|}

[[Category:Unified_IS,_Release_7.5]]

Reporting: Report for Scheduled reports

2012-07-03T07:55:46Z

Pperiasa: /* Reporting: Report for Scheduled reports */

Reporting: Report for Scheduled reports

2012-07-03T07:50:14Z

Pperiasa: Created page with "== Reporting: Report for Scheduled reports == {| border="1" |- ! '''Problem Summary''' | Check the status of reports that are scheduled |- ! '''Error Message''' | Not relevant |..."

== Reporting: Report for Scheduled reports ==

{| border="1"
|-
! '''Problem Summary'''
| Check the status of reports that are scheduled
|-
! '''Error Message'''
| Not relevant
|-
! '''Possible Cause'''
| Not relevant
|-
! '''Recommended Action'''
| Import the report in atachment and run
|-
! '''Release'''
| Release 7.5(x)
|-
! '''Associated CDETS #'''
| Not relevant
|-
|}

Troubleshooting Tips for Unified IS 7.5

2012-07-03T07:45:47Z

Pperiasa: /* Reporting */

'''Back:''' [[Troubleshooting Unified Intelligence Suite]]

'''Add tip:''' [[Create Troubleshooting Tips]]

'''Print PDF:''' [[Print Troubleshooting Tips for Unified IS 7.5]]

The following tips were added by Cisco Documentation:

= Archiver=
:* [[Archiver: Data Retrieval]]
:* [[Archiver: Free Space and Emergency Purge]]
:* [[Archiver: How to Point to Another Server]]
:* [[Archiver: Load Archiver Fails]]
:* [[Archiver: LoadArchiver Issues with Different Server Time Zones]]
:* [[Archiver: Performance and Memory Space]]
:* [[Archiver: Scheduled Events Do Not Run]]
:* [[Archiver: Fixing 30* or D* in Interval columns of Archiver tables]]

= Reporting =
:* [[Reporting: Connection Dropped Message]]
:* [[Reporting: Deleting Users]]
:* [[Reporting: Effect of IIS Recycle on Reports]]
:* [[Reporting: High Refresh Rate for RealTime Reports Results in Flicker Effect]]
:* [[Reporting: SQL Validation for Unified IC]]
:* [[Reporting: Error while rendering reports]]
:* [[Reporting: Report for Scheduled reports]]

= System =
:* [[System: Location of Unified IC Files]]
:* [[System: Purge the CUIC Database]]
:* [[System: Release Notes for Maintenance Releases]]
:* [[System: Retrieve Size for CUIC Database Tables]]
:* [[System: SQL Hardening Failure]]

Archiver: Fixing 30* or D* in Interval columns of Archiver tables

2011-02-11T12:36:45Z

Pperiasa:

{| border="1"
|-
! '''Problem Summary'''
| CUIC does not show data for the last interval period
|-
! '''Error Message'''
| Not applicable.
|-
! '''Possible Cause'''
| Interval tables such as [archiver].[dbo].[t_AgentSkillGroupInterval], [archiver].[dbo].[t_CallTypeInterval] has interval value D* or 30* for the last interval period instead of D or 30.
When Archiver pulls data, it groups data based on interval period.
For e.g. there could be multiple 30 min interval groups on a given day if the interval is '30'.
The last interval period is called as 'Part Interval'. Such rows has interval data '30*' or 'D*' instead of '30' or 'D'.
|-
! '''Recommended Action'''
| If you would like to view part interval data, then change the setting LoadPartInterval=true in archiver.t_Parameter table.
Note: This is a global setting that would affect all interval tables
|-
! '''Releases'''
| Release 7.5(x)
|-
! '''Associated CDETS #'''
| CSCtn22768
|-
|}

[[Category:Unified IS, Release 7.5]]

Archiver: Fixing 30* or D* in Interval columns of Archiver tables

2011-02-10T11:33:39Z

Pperiasa: New page: {| border="1" |- ! '''Problem Summary''' | CUIC does not show data for the last interval period |- ! '''Error Message''' | Not applicable. |- ! '''Possible Cause''' | Interval tables such ...

Troubleshooting Tips for Unified IS 7.5

2011-02-10T11:06:52Z

Pperiasa: /* Archiver */

'''Back:''' [[Troubleshooting Unified Intelligence Suite]]

'''Add tip:''' [[Create Troubleshooting Tips]]

'''Print PDF:''' [[Print Troubleshooting Tips for Unified IS 7.5]]

The following tips were added by Cisco Documentation:

= Archiver=
:* [[Archiver: Data Retrieval]]
:* [[Archiver: Free Space and Emergency Purge]]
:* [[Archiver: How to Point to Another Server]]
:* [[Archiver: Load Archiver Fails]]
:* [[Archiver: LoadArchiver Issues with Different Server Time Zones]]
:* [[Archiver: Performance and Memory Space]]
:* [[Archiver: Scheduled Events Do Not Run]]
:* [[Archiver: Fixing 30* or D* in Interval columns of Archiver tables]]

= Reporting =
:* [[Reporting: Connection Dropped Message]]
:* [[Reporting: Deleting Users]]
:* [[Reporting: Effect of IIS Recycle on Reports]]
:* [[Reporting: High Refresh Rate for RealTime Reports Results in Flicker Effect]]
:* [[Reporting: SQL Validation for Unified IC]]
:* [[Reporting: Error while rendering reports]]

= System =
:* [[System: Location of Unified IC Files]]
:* [[System: Purge the CUIC Database]]
:* [[System: Release Notes for Maintenance Releases]]
:* [[System: Retrieve Size for CUIC Database Tables]]
:* [[System: SQL Hardening Failure]]

Reporting: Deleting Users

2010-09-03T10:46:02Z

Pperiasa: /* Reporting: Deleting Users */

== Reporting: Deleting Users ==

{| border="1"
|-
! '''Problem Summary'''
| You need to delete a reporting user.
|-
! '''Error Message'''
| None
|-
! '''Possible Cause'''
| There is no method for deleting a user through the Unified IS interface.
|-
! '''Recommended Action'''
| Follow this procedure:

1. Back up the database.

2. From Microsoft SQL Studio, run the script below against the CUIC database.

3. Expand Stored Procedures.

4. Locate, right-click, and execute the procedure named asp_DeleteUser. Then click Execute Stored Procedure.

5. Fill in the user name (domain\username)and execute the procedure.

'''SCRIPT'''

<pre>
SET QUOTED_IDENTIFIER ON
set ANSI_NULLS ON
GO
-- Delete all user related information for a given UserName (Domain\Name format)
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[asp_DeleteUser]') AND type in (N'P', N'PC'))
EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [dbo].[asp_DeleteUser]
@UserName varchar(150)
AS
BEGIN

DECLARE @errorFound tinyint
Select @errorFound = 0

BEGIN TRANSACTION

SELECT UserName FROM AA_Users WHERE UserName = @UserName
IF @@ERROR > 0 SET @errorFound = 1

DELETE AA_SharedObjects
WHERE SharedWithID = @UserName AND PermissionInheritedFromID =
(SELECT UserGroupID FROM AA_UserGroupMembership WHERE UserID=@UserName)

DELETE AA_UserGroupMembership WHERE UserID = @UserName and UserGroupID =
(SELECT UserGroupID FROM AA_UserGroupMembership WHERE UserID=@UserName)

DELETE AA_UsersAllowedReports WHERE UserID = @UserName

DELETE AA_CollectionsToUsers WHERE UserID = @UserName

DELETE UserRoles
WHERE UserID = (SELECT UserID FROM Users WHERE UserName = @UserName)
IF @@ERROR > 0 SET @errorFound = 1

DELETE FROM Users
WHERE UserName = @UserName

DELETE FROM AA_Users
WHERE UserName = @UserName

IF (@@ERROR > 0) OR (@errorFound > 0)
BEGIN
ROLLBACK
END
ELSE
BEGIN
COMMIT
END
END
'
GO
</pre>
|-
! '''Release'''
| Release 7.5(x)
|-
! '''Associated CDETS #'''
| None
|-
|}

[[Category:Unified IS, Release 7.5]]

Reporting: Connection Dropped Message

2009-12-01T05:58:49Z

Pperiasa: /* Reporting: 'Connection Dropped' Message */

== Reporting: 'Connection Dropped CUIS Application Pool' Message ==

{| border="1"
|-
! '''Problem Summary'''
| A message indicating that the connection has been dropped is logged in the Httperr.log file. This occurs while a reporting is loading.
|-
! '''Error Message'''
| Connection_Dropped CUIS Application Pool
|-
! '''Possible Cause'''
| IIS/Browser issue.
|-
! '''Recommended Action'''
| Enable the Recycling setting in the CUIS Application Pool as follows:
* Navigate to: Computer Management > Services and Applications > IIS Manager > Application Pools > CUIS Application Pool.
* Right-click CUIS Application Pool and select "Properties".
* Check "Recyle worker process at the following times".
* Enter a time when few users are likely to be connected.

Note that users who have run an ad-hoc report at the time of the recycle will see this message when the report is refreshed: "The realtime subsystem has been cleared. In order to continue viewing the report you must re-filter it". In this situation, the user must launch the report once again.
Note also that reports in the Dashboard will miss a refresh cycle during recycle.
|-
! '''Release'''
| Release 7.5(x)
|-
! '''Associated CDETS #'''
| None'''
|-
|}

[[Category:Unified IS, Release 7.5]]