Scheduled reports fail with error

Versions / Builds Affected

20111128

Status

Resolved

Problem Summary

When attempting to run a scheduled report and error stating 'internal error' is displayed in the user interface

TT / JIRAID

LANguard-33

How to Identify

The following logging will be present when this issue is reproduced. lanss_v10_reporting.csv 2011-06-29,14:14:57,678,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertLocalDomainInDB - Local domain was found in database. Target group to be used:'TRUSTSI'" 2011-06-29,14:14:57,686,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertGroupInDB - >>" 2011-06-29,14:14:57,695,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertGroupInDB - Adding group:'TRUSTSI' to targets using query: 'INSERT INTO [Selection] ([InstallationID],[ComputerID],[IsSelected],[SessionID],[TimestampOfSession]) SELECT '3ac87ace-852a-4560-ae47-595e4ee4976c' as [InstallationID], [Computer].[ComputerID], 1 as [IsSelected], '634449536973431805' as [SessionID], '06/29/2011 14:14:57' as [TimestampOfSession] FROM (( [Computer] INNER JOIN [ComputerToGroup] ON [Computer].[ComputerID]=[ComputerToGroup].[ComputerID]) INNER JOIN [ComputerGroup] ON [ComputerToGroup].[ComputerGroupID]=[ComputerGroup].[ComputerGroupID]) WHERE ([Computer].[IsLicensed]=1) AND ([ComputerGroup].[NAME]='TRUSTSI')'" 2011-06-29,14:14:57,801,3,"#0000220c","#00001ec8","warning","ReporterOP","RepGen.InsertGroupInDB - Failed to add group 'TRUSTSI' as target" 2011-06-29,14:14:57,808,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertGroupInDB - <<" 2011-06-29,14:14:57,817,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertLocalDomainInDB - <<" 2011-06-29,14:14:57,824,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertTargetsInDB - Some computers were not added yet" 2011-06-29,14:14:57,836,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertComputersInDB - >>" 2011-06-29,14:14:57,845,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertComputersInDB - Adding computers to targets using query: 'INSERT INTO [Selection] ([InstallationID],[ComputerID],[IsSelected],[SessionID],[TimestampOfSession]) SELECT '3ac87ace-852a-4560-ae47-595e4ee4976c' as [InstallationID], [Computer].[ComputerID], 1 as [IsSelected], '634449536973431805' as [SessionID], '06/29/2011 14:14:57' as [TimestampOfSession] FROM [Computer] WHERE ([IsLicensed]=1) AND (([Computer].[ComputerID]=3))'" 2011-06-29,14:14:57,902,3,"#0000220c","#00001ec8","warning","ReporterOP","RepGen.InsertComputersInDB - Failed to add the computers list as targets" 2011-06-29,14:14:57,910,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertComputersInDB - <<" 2011-06-29,14:14:57,918,3,"#0000220c","#00001ec8","info ","ReporterOP","RepGen.InsertTargetsInDB - <<" 2011-06-29,14:14:57,932,3,"#0000220c","#00001ec8","warning","ReporterOP","RepGen.GenerateScheduled - Failed to insert target in database. Aborting scheduled operation."

Workaround / Fix Details

Download and apply patch from the following location: ftp://ftp.gfisoftware.com/patches/LG10/20111128/LANGUARD102_PATCH_20120314_01.zip

Required Actions

Apply patch referenced above