Hello All,
I developed a query to output several columns to chart. I had it working. But I broke the magic during continued development. Now, I get an error about an Exception in the ExportPicture: method.
Here is what I get when I run this from the command line:
C:\Documents and Settings\eroberts>"C:\Program Files\Log Parser 2.2\LogParser.ex
e" file:"C:\temp\rad6A3F3.tmp" -i:CSV -o:Chart -chartType:Line -oTsFormat:MMM-dd
-groupSize:1200x480 -maxCategoryLabels:40 -ChartTitle:"Average Open Times"
Task completed with errors.
Unexpected internal error calling chart object method ExportPicture:
Exception occurred.
Statistics:
-----------
Elements processed: 145241
Elements output: 85
Execution time: 1.66 seconds
Here is the Query File (rad6A33F3.tmp):
select QUANTIZE(TO_TIMESTAMP(Date,'M/d/yyyy h:mm:ss tt'), 86400) as Day , Case Avg(Duration) When NULL Then 0 Else Avg(Duration0) End As 72_14_226_51_05_06_06_00 , Case Avg(Duration) When NULL Then 0 Else Avg(Duration1) End As 73_14_113_43_05_07_00_00 , Case Avg(Duration) When NULL Then 0 Else Avg(Duration2) End As 73_14_139_49_05_07_00_00 , Case Avg(Duration) When NULL Then 0 Else Avg(Duration3) End As 73_14_153_53_05_07_00_00 , Case Avg(Duration) When NULL Then 0 Else Avg(Duration4) End As 73_14_154_54_05_07_01_00 Using [Application Vers] as Vers , Case Vers When '72.14.226.51_05.06.06.00' Then Duration Else NULL End As Duration0 , Case Vers When '73.14.113.43_05.07.00.00' Then Duration Else NULL End As Duration1 , Case Vers When '73.14.139.49_05.07.00.00' Then Duration Else NULL End As Duration2 , Case Vers When '73.14.153.53_05.07.00.00' Then Duration Else NULL End As Duration3 , Case Vers When '73.14.154.54_05.07.01.00' Then Duration Else NULL End As Duration4 into 'c:\sharetemp\OpenSavePerf\charts\DLAB_Open_90_Days.jpg' from 'c:\sharetemp\OpenSavePerf\Logs\DLAB_2009_03.csv,c:\sharetemp\OpenSavePerf\Logs\DLAB_2009_04.csv,c:\sharetemp\OpenSavePerf\Logs\DLAB_2009_05.csv' where Op='Open' And TO_TIMESTAMP(Date,'M/d/yyyy h:mm:ss tt') > TIMESTAMP( '2009-03-01', 'yyyy-MM-dd' ) Group by Day Order by Day