3
Vote

Parsing Error

description

Get the following error when trying to parse a large log table.
 
There was some error in parsing the package or log file: "Error in parsing record no 1592: Data is Null. This method or property cannot be called on Null values."
at SSISPackageAndLogParser.SqlTableLogParser.Parse(String logFilePath, List '1 tasksHosts, List '1 connections, String dateTimeFormat, Boolean parseLogOnly)
as SSISPackageAndLogParser.ParseManager.Parse(String packagePath, String logPath, String logFormat, String packagePassword, String dateTimeFormat, Boolean parseLogOnly)
at SSISLogAnalyzer.frmAnalysis.btnLoadLogFile_Click(Object sender, EventArgs e)

comments

nareshjo wrote Mar 5, 2010 at 9:42 AM

Caould you send a backup of the log table.

wrote Sep 23, 2010 at 7:43 AM

00 wrote Dec 9, 2010 at 3:21 PM

I am getting the same. I think this is if the databytes column has nulls in. My log is too big to send but I'm pretty sure this is the problem. Seems to be with "Diagnostic" events which sometimes log with databytes 0x and sometimes with null.

If I run the following command

update sysssislog
set databytes = 0x
where databytes is null

I can then load the log

wrote Dec 9, 2010 at 3:26 PM

sqlShaw wrote May 18, 2012 at 3:08 PM

I am also getting this error. I made a simple txt log file. Here is the output:

PackageStart,MY-PC,AD\jbloggs,Log test,{91EF96DD-EE6C-411A-9B5B-18DAA128836A},{60A08ECE-BB7A-4683-8962-E09DC40D6653},18/05/2012 16:06:30,18/05/2012 16:06:30,0,0x,Beginning of package execution.

PackageEnd,MY-PC,AD\jbloggs,Log test,{91EF96DD-EE6C-411A-9B5B-18DAA128836A},{60A08ECE-BB7A-4683-8962-E09DC40D6653},18/05/2012 16:06:32,18/05/2012 16:06:32,0,0x,End of package execution.

wrote Feb 14, 2013 at 2:26 AM