I’m getting an error …
ERROR: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Lock request time out period exceeded.
and the data import fails.
Has anyone seen this before?
There was some APAR for this, fixed in 9.2.13
We tracked the problem to “extraneous data” in the Upload folder for one computer. Somehow, we ended up with “cit” entries for two different computer ID’s in the same uploads folder, and it was causing the problems with the initial import of data. We uninstalled the scanner from the offending computer and the problem was resolved. Still don’t understand how it happened.
We are actually running 9.2.14 so should already have the fix you mentioned. (I should have mentioned the version of the software we were running.) But then you very much for your input.
Hi @TimRice,
Could you please let me know how/what query did you execute to identify the computer which has 2 entries of different computer id. I am at 9.2.16 and I face this error message too!
2020-01-20 23:55:58 (+0:03:00.052) ERROR: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Lock request time out period exceeded.: 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 > 0x00000000ca251a64
AND FR.Sequence <= 0x00000000ca95e7b1
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 > 0x00000000ca251a64
AND FR.Sequence <= 0x00000000ca95e7b1
2020-01-20 23:55:58 (+0:00:00.007) INFO: ETL from IEMSLAMSSBES42 - DatasourceGroupFixletResult (0x00000000CA251A64 - 0x00000000CA95E7B1): Failed
2020-01-20 23:55:58 (+0:00:00.021) ERROR: Sequel::DatabaseError: DBNAME: BFEnterprise - Java::ComMicrosoftSqlserverJdbc::SQLServerException: Lock request time out period exceeded.
Regards,
Anusha