LogParser or ExRAP tools “Log row too long” issue

  • Article

 

Bookmark to Rhoderick’s blog :

https://blogs.technet.com/b/rmilne/archive/2012/07/05/how-to-fix-log-parser-log-row-too-long.aspx

Note : The maximum value is *not* 0xFFFFFFFF. It’s actually 0x00785111 (hard coded in the LogParser code)

To determine the value to put on the below registry key, take the performance log file that you have in CSV format (works only on CSV formats), copy the headers only, and paste it in Notepad, then save it as a txt file. The size of the txt file determines the minimum value we need to put on the CSVInMaxRowSize attribute (in Bytes) :

x86

HKEY_LOCAL_MACHINESOFTWAREMicrosoftLog Parser

REG_DWORD CSVInMaxRowSize 393216 decimal

To automate adding on x86 machines:

REG.exe ADD "HKLMSoftwareMicrosoftLog Parser" /v CSVInMaxRowSize /t REG_DWORD /d 393216

x64

HKLMSoftwareWow6432NodeMicrosoftLog Parser

REG_DWORD CSVInMaxRowSize 393216 decimal

To automate adding on x64 machines:

REG.exe ADD "HKLMSoftwareWow6432NodeMicrosoftLog Parser" /v CSVInMaxRowSize /t REG_DWORD /d 393216