Log Parser throwing SQL Sequence Errors

terrible_b — Wed, 12 Nov 2008 23:39:37 GMT

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

General Discussion

Log Parser throwing SQL Sequence Errors