Error with otrs.GenerateStats.pl

[cmadoery]

Hi I want to generate a CLI Stats but get the following:

[root@<server> bin]# perl otrs.GenerateStats.pl -n 1119 -o /tmp -f Print
ERROR: OTRS-otrs.GenerateStats.pl-0 Perl: 5.8.8 OS: linux Time: Wed Apr 20 15:30:46 2011

Message: StatNumber invalid!

Traceback (13545):
Module: Kernel::System::Stats::StatNumber2StatID (v1.100) Line: 1907
Module: otrs.GenerateStats.pl (v1.3) Line: 164

ERROR: No StatNumber: 1119

I do have StatNumber 1119. Any ideas?
Regards,
Christof

[jojo]

please show a screenshot containing your statistics

[cmadoery]

here a screenshot:

Rep1.jpg

I attach the XML export of 1119, with all possible values selected:
<?xml version="1.0" encoding="UTF-8"?>
-<otrs_stats> <Cache>0</Cache> <Description>Agent Report</Description> <File/> <Format>Print</Format> <Object>TicketList</Object> <ObjectModule>Kernel::System::Stats::Dynamic::TicketList</ObjectModule> <ObjectName>Ticketlist</ObjectName> <Permission>admin</Permission> <Permission>faq</Permission> <Permission>faq_admin</Permission> <Permission>faq_approval</Permission> <Permission>itsm-change</Permission> <Permission>itsm-change-builder</Permission> <Permission>itsm-change-manager</Permission> <Permission>itsm-configitem</Permission> <Permission>itsm-service</Permission> <Permission>stats</Permission> <Permission>time_accounting</Permission> <Permission>users</Permission> <StatType>dynamic</StatType> <SumCol>0</SumCol> <SumRow>0</SumRow> <Title>agent Report</Title> <UseAsRestriction Fixed="1" Element="ServiceIDs"> </UseAsRestriction> <UseAsRestriction Fixed="1" Element="QueueIDs"> </UseAsRestriction> <UseAsRestriction Fixed="1" Element="CreateTime" TimeStop="2011-12-31 23:59:59" TimeStart="2010-01-01 00:00:00"> </UseAsRestriction> <UseAsRestriction Fixed="1" Element="CloseTime" TimeStop="2011-12-31 23:59:59" TimeStart="2010-01-01 00:00:00"> </UseAsRestriction> -<UseAsValueSeries Fixed="1" Element="OrderBy"> <SelectedValues>TicketNumber</SelectedValues> <SelectedValues>Created</SelectedValues> <SelectedValues>Type</SelectedValues> </UseAsValueSeries> -<UseAsValueSeries Fixed="1" Element="SortSequence"> <SelectedValues>Up</SelectedValues> </UseAsValueSeries> -<UseAsXvalue Element="TicketAttributes"> <SelectedValues>Number</SelectedValues> <SelectedValues>TicketNumber</SelectedValues> <SelectedValues>Age</SelectedValues> <SelectedValues>Title</SelectedValues> <SelectedValues>Created</SelectedValues> <SelectedValues>Changed</SelectedValues> <SelectedValues>Closed</SelectedValues> <SelectedValues>Queue</SelectedValues> <SelectedValues>State</SelectedValues> <SelectedValues>Priority</SelectedValues> <SelectedValues>CustomerUserID</SelectedValues> <SelectedValues>CustomerID</SelectedValues> <SelectedValues>Service</SelectedValues> <SelectedValues>SLA</SelectedValues> <SelectedValues>Type</SelectedValues> <SelectedValues>AccountedTime</SelectedValues> <SelectedValues>EscalationDestinationIn</SelectedValues> <SelectedValues>EscalationDestinationDate</SelectedValues> <SelectedValues>EscalationTimeWorkingTime</SelectedValues> <SelectedValues>EscalationTime</SelectedValues> <SelectedValues>FirstResponse</SelectedValues> <SelectedValues>FirstResponseInMin</SelectedValues> <SelectedValues>FirstResponseDiffInMin</SelectedValues> <SelectedValues>FirstResponseTimeWorkingTime</SelectedValues> <SelectedValues>FirstResponseTimeEscalation</SelectedValues> <SelectedValues>FirstResponseTimeNotification</SelectedValues> <SelectedValues>FirstResponseTimeDestinationTime</SelectedValues> <SelectedValues>FirstResponseTimeDestinationDate</SelectedValues> <SelectedValues>FirstResponseTime</SelectedValues> <SelectedValues>UpdateTimeEscalation</SelectedValues> <SelectedValues>UpdateTimeNotification</SelectedValues> <SelectedValues>UpdateTimeDestinationTime</SelectedValues> <SelectedValues>UpdateTimeDestinationDate</SelectedValues> <SelectedValues>UpdateTimeWorkingTime</SelectedValues> <SelectedValues>UpdateTime</SelectedValues> <SelectedValues>SolutionTime</SelectedValues> <SelectedValues>SolutionInMin</SelectedValues> <SelectedValues>SolutionDiffInMin</SelectedValues> <SelectedValues>SolutionTimeWorkingTime</SelectedValues> <SelectedValues>SolutionTimeEscalation</SelectedValues> <SelectedValues>SolutionTimeNotification</SelectedValues> <SelectedValues>SolutionTimeDestinationTime</SelectedValues> <SelectedValues>SolutionTimeDestinationDate</SelectedValues> <SelectedValues>FirstLock</SelectedValues> <SelectedValues>Lock</SelectedValues> <SelectedValues>StateType</SelectedValues> <SelectedValues>UntilTime</SelectedValues> <SelectedValues>UnlockTimeout</SelectedValues> <SelectedValues>EscalationResponseTime</SelectedValues> <SelectedValues>EscalationSolutionTime</SelectedValues> <SelectedValues>EscalationUpdateTime</SelectedValues> <SelectedValues>RealTillTimeNotUsed</SelectedValues> <SelectedValues>TicketFreeText1</SelectedValues> <SelectedValues>TicketFreeText2</SelectedValues> <SelectedValues>TicketFreeText3</SelectedValues> <SelectedValues>TicketFreeText4</SelectedValues> <SelectedValues>TicketFreeText12</SelectedValues> <SelectedValues>TicketFreeText16</SelectedValues> <SelectedValues>TicketFreeTime1</SelectedValues> <SelectedValues>TicketFreeTime2</SelectedValues> <SelectedValues>TicketFreeTime3</SelectedValues> <SelectedValues>TicketFreeTime4</SelectedValues> <SelectedValues>TicketFreeTime5</SelectedValues> <SelectedValues>TicketFreeTime6</SelectedValues> <SelectedValues>SLAID</SelectedValues> </UseAsXvalue> <Valid>1</Valid> </otrs_stats>

by the way, whats the StatID?

Christof

[cmadoery]

I've found the StatID

Christof

[cmadoery]

nach der Patchinstallation gehts nun.

Gruss,
Christof