Hi all,

I am trying to import some logfiles to SQL Server Table(WebTraffic)
using the Logparser COM in a C# environment. However I have encountered
a bit of a problem in that the results are not consistent. If try import
the log file, every new importation results in a different number of
rows and consequently the total webtraffic that I am interested in. I am
using the following query:

SELECT LogFilename, date, s-ip as sip, c-ip as cip, SUM(sc-bytes) as
scBytes, SUM(cs-bytes) as csBytes
FROM ex040801.log
TO WebTraffic
WHERE s-ip = 'xxx.xxx.xxx.xxx'
GROUP BY LogFilename, c-ip, s-ip, date

(I am grouping by client ip to reduce the number of lines inserted into
the SQL table)and execute it using

MSUtil.COMSQLOutputContextClass outputContext = new
MSUtil.COMSQLOutputContextClassClass();

MSUtil.COMIISW3CInputContextClass inputContext =new
MSUtil.COMIISW3CInputContextClassClass();

logQuery.ExecuteBatch(query, inputContext,outputContext);

Does anyone have any idea where I am going wrong or can give me some
clue of what is going on???

Any Help will be much appreciated.....

Rekkie

*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

[ Post a follow-up to this message ]

Mm.. weird. well, I don't have any answer for you. but I would recommend you
to try the www.logparser.com forum. The author of the tool hang out there as
well.

--
Regards,
Bernard Cheah
http://www.tryiis.com/
http://support.microsoft.com/
http://www.msmvps.com/bernard/



"Rekkie" <my_unique_anti@spam.email.com> wrote in message
news:OiaS8CmlEHA.3016@tk2msftngp13.phx.gbl...
> Hi all,
>
> I am trying to import some logfiles to SQL Server Table(WebTraffic)
> using the Logparser COM in a C# environment. However I have encountered
> a bit of a problem in that the results are not consistent. If try import
> the log file, every new importation results in a different number of
> rows and consequently the total webtraffic that I am interested in. I am
> using the following query:
>
> SELECT LogFilename, date, s-ip as sip, c-ip as cip, SUM(sc-bytes) as
> scBytes, SUM(cs-bytes) as csBytes
> FROM ex040801.log
> TO WebTraffic
> WHERE s-ip = 'xxx.xxx.xxx.xxx'
> GROUP BY LogFilename, c-ip, s-ip, date
>
> (I am grouping by client ip to reduce the number of lines inserted into
> the SQL table)and execute it using
>
> MSUtil.COMSQLOutputContextClass outputContext = new
> MSUtil.COMSQLOutputContextClassClass();
>
> MSUtil.COMIISW3CInputContextClass inputContext =new
> MSUtil.COMIISW3CInputContextClassClass();
>
> logQuery.ExecuteBatch(query, inputContext,outputContext);
>
> Does anyone have any idea where I am going wrong or can give me some
> clue of what is going on???
>
> Any Help will be much appreciated.....
>
> Rekkie
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

[ Post a follow-up to this message ]

On Thu, 09 Sep 2004 04:32:47 -0700, Rekkie
<my_unique_anti@spam.email.com> wrote:

>I am trying to import some logfiles to SQL Server Table(WebTraffic)
>using the Logparser COM in a C# environment. However I have encountered
>a bit of a problem in that the results are not consistent. If try import
>the log file, every new importation results in a different number of
>rows and consequently the total webtraffic that I am interested in. I am
>using the following query:
>
>SELECT LogFilename, date, s-ip as sip, c-ip as cip, SUM(sc-bytes) as
>scBytes, SUM(cs-bytes) as csBytes
>FROM ex040801.log
>TO WebTraffic
>WHERE s-ip = 'xxx.xxx.xxx.xxx'
>GROUP BY LogFilename, c-ip, s-ip, date
>
>(I am grouping by client ip to reduce the number of lines inserted into
>the SQL table)and execute it using
>
>MSUtil.COMSQLOutputContextClass outputContext = new
>MSUtil.COMSQLOutputContextClassClass();
>
>MSUtil.COMIISW3CInputContextClass inputContext =new
>MSUtil.COMIISW3CInputContextClassClass();
>
>logQuery.ExecuteBatch(query, inputContext,outputContext);
>
>Does anyone have any idea where I am going wrong or can give me some
>clue of what is going on???
>
>Any Help will be much appreciated.....

Might try posting in the forum on LogParser.com.  The programmer who
wrote LogParser monitors them and answers questions fairly quickly.

Plus, there's obvious issue if this is the active log file that the
log is growing and you should expect changes.

Jeff

[ Post a follow-up to this message ]

Thank you for the replies, I tried out the logparser forums, and have
discovered that the problem stems from a known issue Q10022 (found on
their site), where importing data in some situations leads to some lines
being skipped and from that point on then duplicated.

I hope that they come up with a new version soon to fix this....

Rekkie

*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

[ Post a follow-up to this message ]

ver 2.2 should be out soon.

--
Regards,
Bernard Cheah
http://www.tryiis.com/
http://support.microsoft.com/
http://www.msmvps.com/bernard/



"Rekkie" <my_unique_anti@spam.email.com> wrote in message
news:ODBBLuimEHA.596@TK2MSFTNGP11.phx.gbl...
>
> Thank you for the replies, I tried out the logparser forums, and have
> discovered that the problem stems from a known issue Q10022 (found on
> their site), where importing data in some situations leads to some lines
> being skipped and from that point on then duplicated.
>
> I hope that they come up with a new version soon to fix this....
>
> Rekkie
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

[ Post a follow-up to this message ]