Hello All,
I am trying to get a query running to work through our webfarm logs.
I'm on a Win 2k3 x64 R2 W/ SP2 running SQL Server 2005 Enterprise locally.
I am consistently getting errors when running the query (Yes it's crazy)
logparser "select ipv4_to_int(s-ip) as serverIP, ipv4_to_int(c-ip) as clientIP, Coalesce(cs-method,'-') as httpMethod, sc-status as httpStatus, cs-uri-stem as urlStem, Coalesce(cs-uri-query,'-') as urlQuery, sc-bytes as requestBytes, cs-bytes as responseBytes, time-taken as timeTaken, cs(User-Agent) as userAgent, Coalesce(cs(cookie), '-') as cookie, to_timestamp(date, time) as dt, Coalesce(Extract_Value(cs-uri-query, 'xxxx'),'-1') as xxxx, coalesce(extract_token(extract_value(cs(cookie),'xxxxxxxxxxxx',';'), 0, ';'), extract_token(extract_value(cs(cookie),'+xxxxxxxxx', ';'),0,';') , '-') as xxxxxxxxxx , cs-host as host, -1 as urlStemID, -1 as xID, -1 as serverID into RAW_IIS_Log_Data from c:\log-files-test\*.*" -i:IISW3C -o:SQL -recurse:-1 -consolidateLogs:ON -server:. -database:Test_WebLogs -driver:"SQL Server" -transactionRowCount:2000
When I run this, It processes ~ 80 records, and then throws:
Task aborted.
Error executing rollback
SQL State: HY010
Native Error: 0
Error Message: [Microsoft][ODBC Driver Manager] Function sequence error
Statistics:
-----------
Elements processed: 85
Elements output: 84
Execution time: 0.08 seconds
If I remove -transactionRowCount:2000 I get a slightly different error:
Task aborted.
Error while setting number of records to upload
SQL State: HY010
Native Error: 0
Error Message: [Microsoft][ODBC Driver Manager] Function sequence error
Statistics:
-----------
Elements processed: 86
Elements output: 85
Execution time: 0.23 seconds
Outputting to a CSV works fine.
It looks like LogParser is having SQL server connection woes.
I have a quad core and 8GB RAM, so I don't think it's a resource issue. ;)
Any thoughts?
Thanks,
Nick