Difference between revisions of "ILMT Import Problems"

Revision as of 23:10, 1 February 2019

Initial import of data from the BigFix server is failing with the following error.

ERROR: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Lock request time out period exceeded.

The SQL Query that is listed is ...

 select  FR.ComputerID AS computer_remote_id,
                 FR.SiteID     AS site_remote_id,
                 FR.ID         AS fixlet_remote_id,
                 FR.IsRelevant AS relevant
         FROM dbo.GROUPS G
         INNER JOIN dbo.SITES S on G.SiteID = S.ID
         INNER JOIN dbo.BES_OBJECT_DEFS O on O.ID = G.ContentID AND
               O.Sitename = S.Name AND S.Type <> 2
         INNER JOIN dbo.SITENAMEMAP SM on SM.Sitename  = O.Sitename
         INNER JOIN dbo.FIXLETRESULTS FR on FR.ID = G.ContentID AND FR.SiteID = SM.SiteID
         WHERE FR.Sequence > 0x0000001298f7174a
           AND FR.Sequence <= 0x00000012ac8af2c8
        UNION ALL
         select  FR.ComputerID AS computer_remote_id,
                 FR.SiteID     AS site_remote_id,
                 FR.ID         AS fixlet_remote_id,
                 FR.IsRelevant AS relevant
         FROM dbo.GROUPS G
         INNER JOIN dbo.SITES S on G.SiteID = S.ID
         INNER JOIN dbo.BES_OBJECT_DEFS O on O.ID = G.ContentID AND
                O.Sitename = 'ActionSite' AND S.Type = 2
         INNER JOIN dbo.SITENAMEMAP SM on SM.Sitename  = O.Sitename
         INNER JOIN dbo.FIXLETRESULTS FR on FR.ID = G.ContentID AND FR.SiteID = SM.SiteID
         WHERE FR.Sequence > 0x0000001298f7174a
           AND FR.Sequence <= 0x00000012ac8af2c8