Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 таймаут при bulk insert из нескольких потоков  [new]
rere1234
Member

Откуда:
Сообщений: 38
Доброе время суток уважаемые форумчане,

Характеристики системы:
Microsoft SQL Server 2012 - 11.0.5058.0 (X64) 
	May 14 2014 18:34:29 
	Copyright (c) Microsoft Corporation
	Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)


Схема таблица в которую производится вставка:
CREATE TABLE [dbo].[Traffic](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[FixationDateTime] [datetime2](7) NOT NULL,
	[CameraId] [smallint] NULL,
	[TrafficStatusId] [tinyint] NOT NULL,
	[LaneNumber] [tinyint] NULL,
	[TransportSpeed] [real] NULL,
	[NotRead] [bit] NOT NULL,
	[GCRecord] [bit] NOT NULL DEFAULT ((0)),
	[OptimisticLockField] [tinyint] NULL,
	[TransportNumberActual] [varchar](20) NOT NULL,
	[TransportNumberActualReverse] [varchar](20) NOT NULL,
	[RestrictionReason] [nvarchar](1000) NULL,
 CONSTRAINT [PK_TRAFFIC] PRIMARY KEY NONCLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [fgTrafficPrimaryIndex]
)


CREATE CLUSTERED INDEX [CIX_Traffic_FixationDateTime] ON [dbo].[Traffic]
(
	[FixationDateTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
on [fgTraffic]


При вставке поле FixationDateTime устанавливается в текущее время. Таблица Traffic (записей ~2 млрд) секционирована по полю FixationDateTime по дням, среднее число записей в секции ~5 млн - то число записей которое попадает в систему за день.

Вставка производится c помощью SqlBulkCopy пакетами размером 500, пытались менять на 50 но проблему это не решило. Есть выравненные индексы по полям CameraId, TrafficStatusId, TransportNumberActual. Индекс первичного ключа не секционирован.
Включена опция работы БД ReadCommitedSnapshot. После пакетной вставки в той же транзакции производится выборка значений Id сгенерированyых Identity, запрос вида:

+
exec sp_executesql N'select Id, FixationDateTime, TransportNumberActual from dbo.Traffic where (FixationDateTime >= @min and FixationDateTime <= @max) and ((FixationDateTime = ''2015-02-06 11:41:39.7026131'' and TransportNumberActual = ''A475CWP'') or (FixationDateTime = ''2015-02-06 11:41:41.9365545'' and TransportNumberActual = ''214DWA02'') or (FixationDateTime = ''2015-02-06 11:41:43.4512408'' and TransportNumberActual = ''477KDA02'') or (FixationDateTime = ''2015-02-06 11:41:45.2832353'' and TransportNumberActual = ''956AA02'') or (FixationDateTime = ''2015-02-06 11:41:47.4784378'' and TransportNumberActual = ''A767CHP'') or (FixationDateTime = ''2015-02-06 11:41:51.2826339'' and TransportNumberActual = ''312HNA02'') or (FixationDateTime = ''2015-02-06 11:42:39.6367179'' and TransportNumberActual = ''595AMA02'') or (FixationDateTime = ''2015-02-06 11:42:40.1448624'' and TransportNumberActual = ''595AM02'') or (FixationDateTime = ''2015-02-06 11:42:42.6617844'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:42:44.6340218'' and TransportNumberActual = ''663OOA05'') or (FixationDateTime = ''2015-02-06 11:42:45.4905708'' and TransportNumberActual = ''B431PFN'') or (FixationDateTime = ''2015-02-06 11:42:47.3881243'' and TransportNumberActual = ''A891RHN'') or (FixationDateTime = ''2015-02-06 11:42:48.5459576'' and TransportNumberActual = ''014APA05'') or (FixationDateTime = ''2015-02-06 11:42:50.3781020'' and TransportNumberActual = ''A730LHO'') or (FixationDateTime = ''2015-02-06 11:42:52.3598596'' and TransportNumberActual = ''421DAA02'') or (FixationDateTime = ''2015-02-06 11:42:53.7697748'' and TransportNumberActual = ''187BA02'') or (FixationDateTime = ''2015-02-06 11:42:55.6322430'' and TransportNumberActual = ''H588TBM'') or (FixationDateTime = ''2015-02-06 11:42:56.9909274'' and TransportNumberActual = ''A248SHO'') or (FixationDateTime = ''2015-02-06 11:42:58.3774898'' and TransportNumberActual = ''326KMA02'') or (FixationDateTime = ''2015-02-06 11:43:00.9894494'' and TransportNumberActual = ''891BM02'') or (FixationDateTime = ''2015-02-06 11:43:01.4215567'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 11:43:02.2235022'' and TransportNumberActual = ''468LZA02'') or (FixationDateTime = ''2015-02-06 11:43:06.4647549'' and TransportNumberActual = ''B803LBO'') or (FixationDateTime = ''2015-02-06 11:43:08.8725955'' and TransportNumberActual = ''A838NVO'') or (FixationDateTime = ''2015-02-06 11:43:11.5864852'' and TransportNumberActual = ''121DSA02'') or (FixationDateTime = ''2015-02-06 11:43:12.6232234'' and TransportNumberActual = ''A408HF'') or (FixationDateTime = ''2015-02-06 11:43:14.5522388'' and TransportNumberActual = ''381AA02'') or (FixationDateTime = ''2015-02-06 11:44:07.4684821'' and TransportNumberActual = ''243CZA02'') or (FixationDateTime = ''2015-02-06 11:44:09.5720467'' and TransportNumberActual = ''A929CPP'') or (FixationDateTime = ''2015-02-06 11:44:12.3706437'' and TransportNumberActual = ''848FSA05'') or (FixationDateTime = ''2015-02-06 11:44:15.0780711'' and TransportNumberActual = ''A741HA'') or (FixationDateTime = ''2015-02-06 11:44:19.1576620'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 11:44:21.6301822'' and TransportNumberActual = ''B275ZYM'') or (FixationDateTime = ''2015-02-06 11:44:23.5931463'' and TransportNumberActual = ''B389XCN'') or (FixationDateTime = ''2015-02-06 11:44:24.6230925'' and TransportNumberActual = ''H454502'') or (FixationDateTime = ''2015-02-06 11:44:26.4475586'' and TransportNumberActual = ''A087OYO'') or (FixationDateTime = ''2015-02-06 11:44:29.8303640'' and TransportNumberActual = ''590AR02'') or (FixationDateTime = ''2015-02-06 11:44:29.0533572'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 11:44:29.3618344'' and TransportNumberActual = ''746MBA05'') or (FixationDateTime = ''2015-02-06 11:44:31.1113716'' and TransportNumberActual = ''A784AHP'') or (FixationDateTime = ''2015-02-06 11:45:32.8539115'' and TransportNumberActual = ''Z744AZN'') or (FixationDateTime = ''2015-02-06 11:45:34.0929678'' and TransportNumberActual = ''B398FCO'') or (FixationDateTime = ''2015-02-06 11:45:37.5964065'' and TransportNumberActual = ''556MZA07'') or (FixationDateTime = ''2015-02-06 11:45:37.0764162'' and TransportNumberActual = ''556MZA02'') or (FixationDateTime = ''2015-02-06 11:45:38.0198774'' and TransportNumberActual = ''KGFH0853'') or (FixationDateTime = ''2015-02-06 11:45:40.8123141'' and TransportNumberActual = ''665KEA02'') or (FixationDateTime = ''2015-02-06 11:45:42.4059951'' and TransportNumberActual = ''A640VXO'') or (FixationDateTime = ''2015-02-06 11:45:45.9732650'' and TransportNumberActual = ''874AE02'') or (FixationDateTime = ''2015-02-06 11:45:47.4962435'' and TransportNumberActual = ''171DVA05'') or (FixationDateTime = ''2015-02-06 11:45:49.6569011'' and TransportNumberActual = ''117CTA02'') or (FixationDateTime = ''2015-02-06 11:45:51.3021043'' and TransportNumberActual = ''A899USO'') or (FixationDateTime = ''2015-02-06 11:45:52.5826419'' and TransportNumberActual = ''969KNA02'') or (FixationDateTime = ''2015-02-06 11:45:54.0996689'' and TransportNumberActual = ''B606YPM'') or (FixationDateTime = ''2015-02-06 11:45:55.0014122'' and TransportNumberActual = ''A158HF'') or (FixationDateTime = ''2015-02-06 11:45:57.6440615'' and TransportNumberActual = ''A029EKO'') or (FixationDateTime = ''2015-02-06 11:45:59.0066717'' and TransportNumberActual = ''B347FEN'') or (FixationDateTime = ''2015-02-06 11:45:59.6960045'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 11:46:00.2026467'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:46:01.4158335'' and TransportNumberActual = ''A479RFN'') or (FixationDateTime = ''2015-02-06 11:46:02.5186969'' and TransportNumberActual = ''033AT02'') or (FixationDateTime = ''2015-02-06 11:46:04.4293344'' and TransportNumberActual = ''A390MSO'') or (FixationDateTime = ''2015-02-06 11:46:05.7658640'' and TransportNumberActual = ''A077ZVM'') or (FixationDateTime = ''2015-02-06 11:46:07.0112392'' and TransportNumberActual = ''A247EX'') or (FixationDateTime = ''2015-02-06 11:46:58.8263591'' and TransportNumberActual = ''F101802'') or (FixationDateTime = ''2015-02-06 11:47:01.7742141'' and TransportNumberActual = ''906AE02'') or (FixationDateTime = ''2015-02-06 11:47:03.5679477'' and TransportNumberActual = ''5008WF'') or (FixationDateTime = ''2015-02-06 11:47:04.8307876'' and TransportNumberActual = ''A761XNO'') or (FixationDateTime = ''2015-02-06 11:47:05.9569234'' and TransportNumberActual = ''340FAA02'') or (FixationDateTime = ''2015-02-06 11:47:07.7242803'' and TransportNumberActual = ''A064MUO'') or (FixationDateTime = ''2015-02-06 11:47:10.8169869'' and TransportNumberActual = ''469HPA02'') or (FixationDateTime = ''2015-02-06 11:47:13.4010604'' and TransportNumberActual = ''387FZA02'') or (FixationDateTime = ''2015-02-06 11:47:15.4116041'' and TransportNumberActual = ''525BL02'') or (FixationDateTime = ''2015-02-06 11:47:16.0274949'' and TransportNumberActual = ''A010BPP'') or (FixationDateTime = ''2015-02-06 11:47:18.3665180'' and TransportNumberActual = ''H519202'') or (FixationDateTime = ''2015-02-06 11:47:19.4579052'' and TransportNumberActual = ''036BNA11'') or (FixationDateTime = ''2015-02-06 11:47:21.7577067'' and TransportNumberActual = ''839HDA02'') or (FixationDateTime = ''2015-02-06 11:47:23.5385893'' and TransportNumberActual = ''A628MZO'') or (FixationDateTime = ''2015-02-06 11:47:24.9672380'' and TransportNumberActual = ''367KCA05'') or (FixationDateTime = ''2015-02-06 11:47:26.7146080'' and TransportNumberActual = ''A306HLO'') or (FixationDateTime = ''2015-02-06 11:47:29.0222344'' and TransportNumberActual = ''680NCA02'') or (FixationDateTime = ''2015-02-06 11:47:30.3682199'' and TransportNumberActual = ''316LNA02'') or (FixationDateTime = ''2015-02-06 11:47:32.1258202'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:47:34.4164211'' and TransportNumberActual = ''066NWA02'') or (FixationDateTime = ''2015-02-06 11:48:25.1428951'' and TransportNumberActual = ''955ERA13'') or (FixationDateTime = ''2015-02-06 11:48:28.0101951'' and TransportNumberActual = ''H773649'') or (FixationDateTime = ''2015-02-06 11:48:29.3355079'' and TransportNumberActual = ''850KVA02'') or (FixationDateTime = ''2015-02-06 11:48:31.8675271'' and TransportNumberActual = ''A566VLO'') or (FixationDateTime = ''2015-02-06 11:48:33.4987576'' and TransportNumberActual = ''341AL02'') or (FixationDateTime = ''2015-02-06 11:48:35.2715072'' and TransportNumberActual = ''178BAA02'') or (FixationDateTime = ''2015-02-06 11:48:38.7546270'' and TransportNumberActual = ''573OFA02'') or (FixationDateTime = ''2015-02-06 11:48:40.4007324'' and TransportNumberActual = ''M019938'') or (FixationDateTime = ''2015-02-06 11:48:42.6534889'' and TransportNumberActual = ''A679RBP'') or (FixationDateTime = ''2015-02-06 11:48:43.9917420'' and TransportNumberActual = ''A757HY'') or (FixationDateTime = ''2015-02-06 11:48:45.8312433'' and TransportNumberActual = ''A868KSO'') or (FixationDateTime = ''2015-02-06 11:48:47.1947842'' and TransportNumberActual = ''349DPA05'') or (FixationDateTime = ''2015-02-06 11:48:48.4409685'' and TransportNumberActual = ''A350RFO'') or (FixationDateTime = ''2015-02-06 11:48:49.6223701'' and TransportNumberActual = ''A062___'') or (FixationDateTime = ''2015-02-06 11:48:51.2070622'' and TransportNumberActual = ''B799CYO'') or (FixationDateTime = ''2015-02-06 11:48:53.9775402'' and TransportNumberActual = ''B773BV'') or (FixationDateTime = ''2015-02-06 11:48:55.6139018'' and TransportNumberActual = ''408LCA05'') or (FixationDateTime = ''2015-02-06 11:48:56.1783223'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:48:57.6012994'' and TransportNumberActual = ''434HOA05'') or (FixationDateTime = ''2015-02-06 11:49:00.9411081'' and TransportNumberActual = ''033NXA13'') or (FixationDateTime = ''2015-02-06 11:49:03.7756465'' and TransportNumberActual = ''399AH02'') or (FixationDateTime = ''2015-02-06 11:49:51.9989892'' and TransportNumberActual = ''944LSA02'') or (FixationDateTime = ''2015-02-06 11:49:54.8346788'' and TransportNumberActual = ''565KUA02'') or (FixationDateTime = ''2015-02-06 11:49:56.8793754'' and TransportNumberActual = ''530BA02'') or (FixationDateTime = ''2015-02-06 11:50:01.3172729'' and TransportNumberActual = ''208ETA02'') or (FixationDateTime = ''2015-02-06 11:50:02.5494475'' and TransportNumberActual = ''B534UXN'') or (FixationDateTime = ''2015-02-06 11:50:04.5956520'' and TransportNumberActual = ''079EOA02'') or (FixationDateTime = ''2015-02-06 11:50:06.1731812'' and TransportNumberActual = ''847EYA05'') or (FixationDateTime = ''2015-02-06 11:50:08.3595594'' and TransportNumberActual = ''A996EYO'') or (FixationDateTime = ''2015-02-06 11:50:09.1339640'' and TransportNumberActual = ''M222204'') or (FixationDateTime = ''2015-02-06 11:50:11.7441265'' and TransportNumberActual = ''915NRA02'') or (FixationDateTime = ''2015-02-06 11:50:12.5882517'' and TransportNumberActual = ''A154CLM'') or (FixationDateTime = ''2015-02-06 11:50:15.5400842'' and TransportNumberActual = ''B449CV'') or (FixationDateTime = ''2015-02-06 11:50:16.8818794'' and TransportNumberActual = ''A564UAO'') or (FixationDateTime = ''2015-02-06 11:50:18.6623302'' and TransportNumberActual = ''A687MPO'') or (FixationDateTime = ''2015-02-06 11:50:20.0514463'' and TransportNumberActual = ''130CDA05'') or (FixationDateTime = ''2015-02-06 11:50:22.6437778'' and TransportNumberActual = ''A557VON'') or (FixationDateTime = ''2015-02-06 11:50:24.1699246'' and TransportNumberActual = ''B546YFN'') or (FixationDateTime = ''2015-02-06 11:51:16.1533578'' and TransportNumberActual = ''062CHA02'') or (FixationDateTime = ''2015-02-06 11:51:19.8800474'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:51:21.5770886'' and TransportNumberActual = ''A766CMP'') or (FixationDateTime = ''2015-02-06 11:51:22.6590140'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 11:51:22.1054631'' and TransportNumberActual = ''K437TY220'') or (FixationDateTime = ''2015-02-06 11:51:24.7844407'' and TransportNumberActual = ''993LRA02'') or (FixationDateTime = ''2015-02-06 11:51:25.0544364'' and TransportNumberActual = ''231NEA10'') or (FixationDateTime = ''2015-02-06 11:51:27.4094421'' and TransportNumberActual = ''C743VOM'') or (FixationDateTime = ''2015-02-06 11:51:29.5245241'' and TransportNumberActual = ''884BL02'') or (FixationDateTime = ''2015-02-06 11:51:30.8482714'' and TransportNumberActual = ''549NKA02'') or (FixationDateTime = ''2015-02-06 11:51:32.1661354'' and TransportNumberActual = ''570EAA02'') or (FixationDateTime = ''2015-02-06 11:51:34.5649665'' and TransportNumberActual = ''A022XPO'') or (FixationDateTime = ''2015-02-06 11:51:37.1439176'' and TransportNumberActual = ''A033DLN'') or (FixationDateTime = ''2015-02-06 11:51:39.4925875'' and TransportNumberActual = ''874KNA02'') or (FixationDateTime = ''2015-02-06 11:51:41.1832041'' and TransportNumberActual = ''619DA02'') or (FixationDateTime = ''2015-02-06 11:51:43.9325814'' and TransportNumberActual = ''B864KCO'') or (FixationDateTime = ''2015-02-06 11:51:43.2338646'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 11:51:45.8027875'' and TransportNumberActual = ''191UD02'') or (FixationDateTime = ''2015-02-06 11:51:46.1239005'' and TransportNumberActual = ''8725AG'') or (FixationDateTime = ''2015-02-06 11:52:42.0969561'' and TransportNumberActual = ''A788HU'') or (FixationDateTime = ''2015-02-06 11:52:45.6274087'' and TransportNumberActual = ''A480ETO'') or (FixationDateTime = ''2015-02-06 11:52:47.5767538'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 11:52:48.3958403'' and TransportNumberActual = ''A595PSO'') or (FixationDateTime = ''2015-02-06 11:52:51.5725859'' and TransportNumberActual = ''B943CCO'') or (FixationDateTime = ''2015-02-06 11:52:53.7675561'' and TransportNumberActual = ''B064DKO'') or (FixationDateTime = ''2015-02-06 11:52:54.5335097'' and TransportNumberActual = ''419LKA02'') or (FixationDateTime = ''2015-02-06 11:52:57.3410911'' and TransportNumberActual = ''552KHA02'') or (FixationDateTime = ''2015-02-06 11:52:58.2633672'' and TransportNumberActual = ''965BBA02'') or (FixationDateTime = ''2015-02-06 11:53:01.3316650'' and TransportNumberActual = ''740NFA02'') or (FixationDateTime = ''2015-02-06 11:53:02.5873060'' and TransportNumberActual = ''850EHA02'') or (FixationDateTime = ''2015-02-06 11:53:04.5279436'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:53:04.1402006'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:53:06.7226577'' and TransportNumberActual = ''NTA021'') or (FixationDateTime = ''2015-02-06 11:53:09.5131365'' and TransportNumberActual = ''903LUA02'') or (FixationDateTime = ''2015-02-06 11:53:11.8312685'' and TransportNumberActual = ''B893SUN'') or (FixationDateTime = ''2015-02-06 11:53:13.5221515'' and TransportNumberActual = ''A805EOP'') or (FixationDateTime = ''2015-02-06 11:53:14.4125729'' and TransportNumberActual = ''696NBA02'') or (FixationDateTime = ''2015-02-06 11:54:08.4970511'' and TransportNumberActual = ''A265WMO'') or (FixationDateTime = ''2015-02-06 11:54:11.1945016'' and TransportNumberActual = ''294NWA02'') or (FixationDateTime = ''2015-02-06 11:54:14.1172124'' and TransportNumberActual = ''187ZKA02'') or (FixationDateTime = ''2015-02-06 11:54:14.1437143'' and TransportNumberActual = ''872KDA02'') or (FixationDateTime = ''2015-02-06 11:54:16.6610160'' and TransportNumberActual = ''A251BZP'') or (FixationDateTime = ''2015-02-06 11:54:17.5646341'' and TransportNumberActual = ''765AS02'') or (FixationDateTime = ''2015-02-06 11:54:19.6628742'' and TransportNumberActual = ''079KOA05'') or (FixationDateTime = ''2015-02-06 11:54:20.0311398'' and TransportNumberActual = ''760LLA02'') or (FixationDateTime = ''2015-02-06 11:54:22.1696530'' and TransportNumberActual = ''041MHA09'') or (FixationDateTime = ''2015-02-06 11:54:24.1742427'' and TransportNumberActual = ''A933EWP'') or (FixationDateTime = ''2015-02-06 11:54:26.1465160'' and TransportNumberActual = ''031AF02'') or (FixationDateTime = ''2015-02-06 11:54:27.8764811'' and TransportNumberActual = ''A055XSN'') or (FixationDateTime = ''2015-02-06 11:54:28.6371649'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 11:54:30.1713394'' and TransportNumberActual = ''A604FEP'') or (FixationDateTime = ''2015-02-06 11:54:32.9541064'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:54:34.8348473'' and TransportNumberActual = ''A188KP'') or (FixationDateTime = ''2015-02-06 11:54:37.1990428'' and TransportNumberActual = ''A811HA'') or (FixationDateTime = ''2015-02-06 11:54:43.1979916'' and TransportNumberActual = ''A731ZKN'') or (FixationDateTime = ''2015-02-06 11:54:45.1968603'' and TransportNumberActual = ''192CZA08'') or (FixationDateTime = ''2015-02-06 11:55:36.8423002'' and TransportNumberActual = ''A153FN'') or (FixationDateTime = ''2015-02-06 11:55:38.2292788'' and TransportNumberActual = ''A175SCO'') or (FixationDateTime = ''2015-02-06 11:55:40.1308009'' and TransportNumberActual = ''078BEA05'') or (FixationDateTime = ''2015-02-06 11:55:43.0837095'' and TransportNumberActual = ''A534FCP'') or (FixationDateTime = ''2015-02-06 11:55:45.3101581'' and TransportNumberActual = ''865HZA02'') or (FixationDateTime = ''2015-02-06 11:55:47.7912621'' and TransportNumberActual = ''288COA02'') or (FixationDateTime = ''2015-02-06 11:55:49.8733407'' and TransportNumberActual = ''A566WMO'') or (FixationDateTime = ''2015-02-06 11:55:51.5230006'' and TransportNumberActual = ''510AS02'') or (FixationDateTime = ''2015-02-06 11:55:53.9630078'' and TransportNumberActual = ''927CPA02'') or (FixationDateTime = ''2015-02-06 11:55:55.8771712'' and TransportNumberActual = ''B254DAO'') or (FixationDateTime = ''2015-02-06 11:55:56.3519369'' and TransportNumberActual = ''847NRA02'') or (FixationDateTime = ''2015-02-06 11:55:56.7072410'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 11:55:58.6899230'' and TransportNumberActual = ''989HLA05'') or (FixationDateTime = ''2015-02-06 11:56:01.2020590'' and TransportNumberActual = ''A353FLP'') or (FixationDateTime = ''2015-02-06 11:56:02.6503053'' and TransportNumberActual = ''A575UCO'') or (FixationDateTime = ''2015-02-06 11:56:03.0636796'' and TransportNumberActual = ''737HEA02'') or (FixationDateTime = ''2015-02-06 11:56:05.3578716'' and TransportNumberActual = ''734BEA14'') or (FixationDateTime = ''2015-02-06 11:56:07.9867630'' and TransportNumberActual = ''M008196'') or (FixationDateTime = ''2015-02-06 11:56:10.5912741'' and TransportNumberActual = ''A577DBP'') or (FixationDateTime = ''2015-02-06 11:56:13.9181085'' and TransportNumberActual = ''910DBA07'') or (FixationDateTime = ''2015-02-06 11:57:00.3974603'' and TransportNumberActual = ''080HBA05'') or (FixationDateTime = ''2015-02-06 11:57:00.1682305'' and TransportNumberActual = ''A140CNP'') or (FixationDateTime = ''2015-02-06 11:57:03.4750004'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 11:57:04.8898259'' and TransportNumberActual = ''753LHA02'') or (FixationDateTime = ''2015-02-06 11:57:06.7714994'' and TransportNumberActual = ''A624ECP'') or (FixationDateTime = ''2015-02-06 11:57:08.8003370'' and TransportNumberActual = ''A157EN'') or (FixationDateTime = ''2015-02-06 11:57:11.0749605'' and TransportNumberActual = ''754PCA13'') or (FixationDateTime = ''2015-02-06 11:57:12.9247848'' and TransportNumberActual = ''A020RNO'') or (FixationDateTime = ''2015-02-06 11:57:14.1881635'' and TransportNumberActual = ''A327YAO'') or (FixationDateTime = ''2015-02-06 11:57:16.3264577'' and TransportNumberActual = ''286MEA02'') or (FixationDateTime = ''2015-02-06 11:57:17.8910272'' and TransportNumberActual = ''438LSA02'') or (FixationDateTime = ''2015-02-06 11:57:19.0791315'' and TransportNumberActual = ''B023KPO'') or (FixationDateTime = ''2015-02-06 11:57:22.3523782'' and TransportNumberActual = ''532AE02'') or (FixationDateTime = ''2015-02-06 11:57:23.4339950'' and TransportNumberActual = ''A407ANP'') or (FixationDateTime = ''2015-02-06 11:57:25.5507929'' and TransportNumberActual = ''A015YFN'') or (FixationDateTime = ''2015-02-06 11:58:28.0645884'' and TransportNumberActual = ''888CBA02'') or (FixationDateTime = ''2015-02-06 11:58:30.3079663'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 11:58:32.6048083'' and TransportNumberActual = ''249AX02'') or (FixationDateTime = ''2015-02-06 11:58:34.8929616'' and TransportNumberActual = ''449HZA02'') or (FixationDateTime = ''2015-02-06 11:58:36.9011810'' and TransportNumberActual = ''Z688XRM'') or (FixationDateTime = ''2015-02-06 11:58:38.5798391'' and TransportNumberActual = ''A694WWN'') or (FixationDateTime = ''2015-02-06 11:58:40.5479653'' and TransportNumberActual = ''866BKA02'') or (FixationDateTime = ''2015-02-06 11:58:42.4177622'' and TransportNumberActual = ''358HFA02'') or (FixationDateTime = ''2015-02-06 11:58:44.4137786'' and TransportNumberActual = ''944KEA05'') or (FixationDateTime = ''2015-02-06 11:58:45.5860129'' and TransportNumberActual = ''330BUA05'') or (FixationDateTime = ''2015-02-06 11:58:47.0841663'' and TransportNumberActual = ''M640CZN'') or (FixationDateTime = ''2015-02-06 11:58:49.4593670'' and TransportNumberActual = ''H343302'') or (FixationDateTime = ''2015-02-06 11:58:51.8668077'' and TransportNumberActual = ''A445ZCO'') or (FixationDateTime = ''2015-02-06 11:58:53.6996292'' and TransportNumberActual = ''A527KUO'') or (FixationDateTime = ''2015-02-06 11:58:54.0189949'' and TransportNumberActual = ''A306___'') or (FixationDateTime = ''2015-02-06 11:58:56.5073840'' and TransportNumberActual = ''303BBA02'') or (FixationDateTime = ''2015-02-06 11:58:57.0849086'' and TransportNumberActual = ''851CZA02'') or (FixationDateTime = ''2015-02-06 11:59:02.9690636'' and TransportNumberActual = ''092RNA05'') or (FixationDateTime = ''2015-02-06 11:59:03.5229994'' and TransportNumberActual = ''A602WAO'') or (FixationDateTime = ''2015-02-06 11:59:52.6977563'' and TransportNumberActual = ''252FHA05'') or (FixationDateTime = ''2015-02-06 11:59:55.8361318'' and TransportNumberActual = ''377AAA11'') or (FixationDateTime = ''2015-02-06 11:59:57.1450102'' and TransportNumberActual = ''A945DTP'') or (FixationDateTime = ''2015-02-06 11:59:59.1908991'' and TransportNumberActual = ''A962USO'') or (FixationDateTime = ''2015-02-06 12:00:01.4885925'' and TransportNumberActual = ''601OEA02'') or (FixationDateTime = ''2015-02-06 12:00:03.6187319'' and TransportNumberActual = ''A327AS'') or (FixationDateTime = ''2015-02-06 12:00:03.0532235'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:00:04.8694115'' and TransportNumberActual = ''655BD02'') or (FixationDateTime = ''2015-02-06 12:00:07.4316731'' and TransportNumberActual = ''A077RUO'') or (FixationDateTime = ''2015-02-06 12:00:09.1331803'' and TransportNumberActual = ''A062AKO'') or (FixationDateTime = ''2015-02-06 12:00:11.9337039'' and TransportNumberActual = ''310RBA02'') or (FixationDateTime = ''2015-02-06 12:00:13.0052860'' and TransportNumberActual = ''A998TXO'') or (FixationDateTime = ''2015-02-06 12:00:15.8369344'' and TransportNumberActual = ''104FWA10'') or (FixationDateTime = ''2015-02-06 12:00:19.2013172'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:00:21.0529088'' and TransportNumberActual = ''A049BHO'') or (FixationDateTime = ''2015-02-06 12:00:22.2184237'' and TransportNumberActual = ''A958DM'') or (FixationDateTime = ''2015-02-06 12:01:19.7302052'' and TransportNumberActual = ''038AH05'') or (FixationDateTime = ''2015-02-06 12:01:22.1927779'' and TransportNumberActual = ''640NYA02'') or (FixationDateTime = ''2015-02-06 12:01:24.7745465'' and TransportNumberActual = ''A163YYO'') or (FixationDateTime = ''2015-02-06 12:01:26.7527538'' and TransportNumberActual = ''A187FP'') or (FixationDateTime = ''2015-02-06 12:01:28.3944819'' and TransportNumberActual = ''A979TZO'') or (FixationDateTime = ''2015-02-06 12:01:30.9350432'' and TransportNumberActual = ''123MPA02'') or (FixationDateTime = ''2015-02-06 12:01:32.7280753'' and TransportNumberActual = ''A159XHO'') or (FixationDateTime = ''2015-02-06 12:01:34.7271432'' and TransportNumberActual = ''A050RNO'') or (FixationDateTime = ''2015-02-06 12:01:35.4432677'' and TransportNumberActual = ''295BF02'') or (FixationDateTime = ''2015-02-06 12:01:36.5545339'' and TransportNumberActual = ''825NSA02'') or (FixationDateTime = ''2015-02-06 12:01:38.7261976'' and TransportNumberActual = ''340LBA05'') or (FixationDateTime = ''2015-02-06 12:01:40.3252329'' and TransportNumberActual = ''A179SYO'') or (FixationDateTime = ''2015-02-06 12:01:43.6682033'' and TransportNumberActual = ''956BHA02'') or (FixationDateTime = ''2015-02-06 12:01:45.8786135'' and TransportNumberActual = ''B319YFN'') or (FixationDateTime = ''2015-02-06 12:01:47.0068799'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:01:48.2975507'' and TransportNumberActual = ''A990XUO'') or (FixationDateTime = ''2015-02-06 12:01:56.3418393'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:02:46.7217504'' and TransportNumberActual = ''A959ODN'') or (FixationDateTime = ''2015-02-06 12:02:48.5873685'' and TransportNumberActual = ''107LZA02'') or (FixationDateTime = ''2015-02-06 12:02:50.7337435'' and TransportNumberActual = ''358KFA02'') or (FixationDateTime = ''2015-02-06 12:02:52.1118536'' and TransportNumberActual = ''A795BPO'') or (FixationDateTime = ''2015-02-06 12:02:55.2479897'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:02:57.7619114'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:02:58.6518335'' and TransportNumberActual = ''A297MUO'') or (FixationDateTime = ''2015-02-06 12:03:01.5764030'' and TransportNumberActual = ''480OAA13'') or (FixationDateTime = ''2015-02-06 12:03:02.5637403'' and TransportNumberActual = ''A233YLO'') or (FixationDateTime = ''2015-02-06 12:03:03.0155935'' and TransportNumberActual = ''A959OCO'') or (FixationDateTime = ''2015-02-06 12:03:05.8051497'' and TransportNumberActual = ''A629EUP'') or (FixationDateTime = ''2015-02-06 12:03:07.2209594'' and TransportNumberActual = ''A205UXM'') or (FixationDateTime = ''2015-02-06 12:03:08.0690135'' and TransportNumberActual = ''A744YCO'') or (FixationDateTime = ''2015-02-06 12:03:10.1834910'' and TransportNumberActual = ''A373BYP'') or (FixationDateTime = ''2015-02-06 12:03:12.3541292'' and TransportNumberActual = ''A502XLO'') or (FixationDateTime = ''2015-02-06 12:03:14.3116564'' and TransportNumberActual = ''105HPA02'') or (FixationDateTime = ''2015-02-06 12:03:15.0822387'' and TransportNumberActual = ''A859PKO'') or (FixationDateTime = ''2015-02-06 12:03:17.6148596'' and TransportNumberActual = ''612CSA02'') or (FixationDateTime = ''2015-02-06 12:03:20.2093098'' and TransportNumberActual = ''H798KZM'') or (FixationDateTime = ''2015-02-06 12:04:13.4057560'' and TransportNumberActual = ''B904WLN'') or (FixationDateTime = ''2015-02-06 12:04:15.3257155'' and TransportNumberActual = ''650FCA05'') or (FixationDateTime = ''2015-02-06 12:04:17.0672043'' and TransportNumberActual = ''A773ESP'') or (FixationDateTime = ''2015-02-06 12:04:19.4552809'' and TransportNumberActual = ''A077AMP'') or (FixationDateTime = ''2015-02-06 12:04:22.6216722'' and TransportNumberActual = ''_457HLN'') or (FixationDateTime = ''2015-02-06 12:04:24.3405234'' and TransportNumberActual = ''A398HN'') or (FixationDateTime = ''2015-02-06 12:04:26.4399067'' and TransportNumberActual = ''563AN02'') or (FixationDateTime = ''2015-02-06 12:04:28.7059695'' and TransportNumberActual = ''725DFA02'') or (FixationDateTime = ''2015-02-06 12:04:29.2663881'' and TransportNumberActual = ''390DBA02'') or (FixationDateTime = ''2015-02-06 12:04:30.3179168'' and TransportNumberActual = ''B869YDN'') or (FixationDateTime = ''2015-02-06 12:04:32.7470191'' and TransportNumberActual = ''A680HCO'') or (FixationDateTime = ''2015-02-06 12:04:33.0661245'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:04:35.2612479'' and TransportNumberActual = ''X877WWN'') or (FixationDateTime = ''2015-02-06 12:04:37.9380776'' and TransportNumberActual = ''451AH05'') or (FixationDateTime = ''2015-02-06 12:04:39.5156526'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:04:40.3078906'' and TransportNumberActual = ''B971BZO'') or (FixationDateTime = ''2015-02-06 12:04:42.0641641'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:04:44.3703534'' and TransportNumberActual = ''A117VFO'') or (FixationDateTime = ''2015-02-06 12:05:38.2290480'' and TransportNumberActual = ''497NHA02'') or (FixationDateTime = ''2015-02-06 12:05:40.8991830'' and TransportNumberActual = ''069DRA02'') or (FixationDateTime = ''2015-02-06 12:05:42.6723614'' and TransportNumberActual = ''B219ZWN'') or (FixationDateTime = ''2015-02-06 12:05:44.0676191'' and TransportNumberActual = ''A140BMP'') or (FixationDateTime = ''2015-02-06 12:05:44.9802781'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:05:45.6967364'' and TransportNumberActual = ''556KTA02'') or (FixationDateTime = ''2015-02-06 12:05:46.3966546'' and TransportNumberActual = ''307MUA02'') or (FixationDateTime = ''2015-02-06 12:05:48.3066890'' and TransportNumberActual = ''435KNA05'') or (FixationDateTime = ''2015-02-06 12:05:50.1469998'' and TransportNumberActual = ''268KNA02'') or (FixationDateTime = ''2015-02-06 12:05:52.0117151'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:05:54.5069590'' and TransportNumberActual = ''A933CPP'') or (FixationDateTime = ''2015-02-06 12:05:55.9052983'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:05:57.3942203'' and TransportNumberActual = ''241NCA02'') or (FixationDateTime = ''2015-02-06 12:05:59.3564332'' and TransportNumberActual = ''186ODA02'') or (FixationDateTime = ''2015-02-06 12:06:01.2575240'' and TransportNumberActual = ''A385HM'') or (FixationDateTime = ''2015-02-06 12:06:03.4481270'' and TransportNumberActual = ''474LHA02'') or (FixationDateTime = ''2015-02-06 12:06:04.1547221'' and TransportNumberActual = ''582DYA05'') or (FixationDateTime = ''2015-02-06 12:06:08.6589743'' and TransportNumberActual = ''A357ZWO'') or (FixationDateTime = ''2015-02-06 12:06:09.2059964'' and TransportNumberActual = ''A828AEO'') or (FixationDateTime = ''2015-02-06 12:07:03.0627031'' and TransportNumberActual = ''A673WHO'') or (FixationDateTime = ''2015-02-06 12:07:06.4937710'' and TransportNumberActual = ''A089XCO'') or (FixationDateTime = ''2015-02-06 12:07:09.6979578'' and TransportNumberActual = ''717RVA02'') or (FixationDateTime = ''2015-02-06 12:07:11.3366388'' and TransportNumberActual = ''B334BSO'') or (FixationDateTime = ''2015-02-06 12:07:12.5529312'' and TransportNumberActual = ''579HYA02'') or (FixationDateTime = ''2015-02-06 12:07:14.5695129'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:07:15.2647790'' and TransportNumberActual = ''587ACA02'') or (FixationDateTime = ''2015-02-06 12:07:16.8408394'' and TransportNumberActual = ''A331BDP'') or (FixationDateTime = ''2015-02-06 12:07:18.7420655'' and TransportNumberActual = ''597MCA02'') or (FixationDateTime = ''2015-02-06 12:07:20.3142860'' and TransportNumberActual = ''A153DM'') or (FixationDateTime = ''2015-02-06 12:07:22.9880203'' and TransportNumberActual = ''A929NKN'') or (FixationDateTime = ''2015-02-06 12:07:24.7806302'' and TransportNumberActual = ''870KYA05'') or (FixationDateTime = ''2015-02-06 12:07:26.8048139'' and TransportNumberActual = ''909RZA02'') or (FixationDateTime = ''2015-02-06 12:07:28.4219258'' and TransportNumberActual = ''313MSA05'') or (FixationDateTime = ''2015-02-06 12:07:30.3647845'' and TransportNumberActual = ''A055EUP'') or (FixationDateTime = ''2015-02-06 12:07:32.4101988'' and TransportNumberActual = ''509ODA02'') or (FixationDateTime = ''2015-02-06 12:07:33.6052970'' and TransportNumberActual = ''470HAA05'') or (FixationDateTime = ''2015-02-06 12:07:37.3009019'' and TransportNumberActual = ''A687CVP'') or (FixationDateTime = ''2015-02-06 12:07:39.3707583'' and TransportNumberActual = ''B491HUO'') or (FixationDateTime = ''2015-02-06 12:08:29.1445181'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:08:32.8475851'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:08:32.0445307'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:08:34.2730931'' and TransportNumberActual = ''196MTA02'') or (FixationDateTime = ''2015-02-06 12:08:34.8994384'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:08:35.7519359'' and TransportNumberActual = ''809MXA02'') or (FixationDateTime = ''2015-02-06 12:08:37.3305410'' and TransportNumberActual = ''A585FL'') or (FixationDateTime = ''2015-02-06 12:08:39.2438175'' and TransportNumberActual = ''114BA02'') or (FixationDateTime = ''2015-02-06 12:08:40.4601787'' and TransportNumberActual = ''888BMA02'') or (FixationDateTime = ''2015-02-06 12:08:42.8334951'' and TransportNumberActual = ''A024FA'') or (FixationDateTime = ''2015-02-06 12:08:44.3279388'' and TransportNumberActual = ''270LPA02'') or (FixationDateTime = ''2015-02-06 12:08:46.1395223'' and TransportNumberActual = ''A263AWP'') or (FixationDateTime = ''2015-02-06 12:08:48.0670737'' and TransportNumberActual = ''588NNA02'') or (FixationDateTime = ''2015-02-06 12:08:50.8895278'' and TransportNumberActual = ''721MOA02'') or (FixationDateTime = ''2015-02-06 12:08:52.5261120'' and TransportNumberActual = ''A720ED'') or (FixationDateTime = ''2015-02-06 12:08:56.7465244'' and TransportNumberActual = ''A413DPP'') or (FixationDateTime = ''2015-02-06 12:08:57.4725155'' and TransportNumberActual = ''654BBA11'') or (FixationDateTime = ''2015-02-06 12:08:59.2034664'' and TransportNumberActual = ''A470BBP'') or (FixationDateTime = ''2015-02-06 12:09:03.0311771'' and TransportNumberActual = ''211DCA02'') or (FixationDateTime = ''2015-02-06 12:09:08.5459759'' and TransportNumberActual = ''024KBA02'') or (FixationDateTime = ''2015-02-06 12:09:57.7693174'' and TransportNumberActual = ''963EKA02'') or (FixationDateTime = ''2015-02-06 12:09:57.7526627'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:09:59.3574926'' and TransportNumberActual = ''A026ECN'') or (FixationDateTime = ''2015-02-06 12:10:01.8435459'' and TransportNumberActual = ''F045002'') or (FixationDateTime = ''2015-02-06 12:10:02.2854820'' and TransportNumberActual = ''0450OZ'') or (FixationDateTime = ''2015-02-06 12:10:03.5403689'' and TransportNumberActual = ''A27____'') or (FixationDateTime = ''2015-02-06 12:10:04.0487559'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:10:06.6228663'' and TransportNumberActual = ''A946UZN'') or (FixationDateTime = ''2015-02-06 12:10:08.9099076'' and TransportNumberActual = ''211NNA02'') or (FixationDateTime = ''2015-02-06 12:10:10.7067020'' and TransportNumberActual = ''FJSA511'') or (FixationDateTime = ''2015-02-06 12:10:12.1443526'' and TransportNumberActual = ''A817FMP'') or (FixationDateTime = ''2015-02-06 12:10:14.9107976'' and TransportNumberActual = ''A039EWO'') or (FixationDateTime = ''2015-02-06 12:10:16.6692928'' and TransportNumberActual = ''880AS02'') or (FixationDateTime = ''2015-02-06 12:10:19.8914890'' and TransportNumberActual = ''766AVA02'') or (FixationDateTime = ''2015-02-06 12:10:21.7001077'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:10:23.8736075'' and TransportNumberActual = ''550MXA05'') or (FixationDateTime = ''2015-02-06 12:10:26.0847767'' and TransportNumberActual = ''625LZA05'') or (FixationDateTime = ''2015-02-06 12:10:27.7554933'' and TransportNumberActual = ''A833YAO'') or (FixationDateTime = ''2015-02-06 12:10:29.9825005'' and TransportNumberActual = ''592EWA02'') or (FixationDateTime = ''2015-02-06 12:10:31.7727504'' and TransportNumberActual = ''A221BP'') or (FixationDateTime = ''2015-02-06 12:10:32.7373756'' and TransportNumberActual = ''A157SFO'') or (FixationDateTime = ''2015-02-06 12:11:22.0818016'' and TransportNumberActual = ''A061VEO'') or (FixationDateTime = ''2015-02-06 12:11:25.7552013'' and TransportNumberActual = ''813MWA02'') or (FixationDateTime = ''2015-02-06 12:11:27.4194020'' and TransportNumberActual = ''A602DX'') or (FixationDateTime = ''2015-02-06 12:11:29.2970598'' and TransportNumberActual = ''903KEA02'') or (FixationDateTime = ''2015-02-06 12:11:31.9334160'' and TransportNumberActual = ''053BE02'') or (FixationDateTime = ''2015-02-06 12:11:33.1210327'' and TransportNumberActual = ''A320CVP'') or (FixationDateTime = ''2015-02-06 12:11:35.2183657'' and TransportNumberActual = ''A178ACO'') or (FixationDateTime = ''2015-02-06 12:11:37.4857464'' and TransportNumberActual = ''667FFA05'') or (FixationDateTime = ''2015-02-06 12:11:39.6718202'' and TransportNumberActual = ''A393BHP'') or (FixationDateTime = ''2015-02-06 12:11:42.4627560'' and TransportNumberActual = ''A331VYO'') or (FixationDateTime = ''2015-02-06 12:11:43.9382605'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:11:45.1429651'' and TransportNumberActual = ''B276RHN'') or (FixationDateTime = ''2015-02-06 12:11:46.5116435'' and TransportNumberActual = ''403HXA02'') or (FixationDateTime = ''2015-02-06 12:11:48.0705335'' and TransportNumberActual = ''344MKA02'') or (FixationDateTime = ''2015-02-06 12:11:49.6773349'' and TransportNumberActual = ''065AB02'') or (FixationDateTime = ''2015-02-06 12:11:51.7483663'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:11:51.8406052'' and TransportNumberActual = ''A607XLM'') or (FixationDateTime = ''2015-02-06 12:11:52.8672648'' and TransportNumberActual = ''851ARA02'') or (FixationDateTime = ''2015-02-06 12:11:53.0974057'' and TransportNumberActual = ''A292KNN'') or (FixationDateTime = ''2015-02-06 12:11:55.8932569'' and TransportNumberActual = ''B025NS'') or (FixationDateTime = ''2015-02-06 12:11:57.7910491'' and TransportNumberActual = ''A369EN'') or (FixationDateTime = ''2015-02-06 12:11:58.4059801'' and TransportNumberActual = ''A997KHO'') or (FixationDateTime = ''2015-02-06 12:12:50.8415811'' and TransportNumberActual = ''807CAA02'') or (FixationDateTime = ''2015-02-06 12:12:54.4617307'' and TransportNumberActual = ''738CMA02'') or (FixationDateTime = ''2015-02-06 12:12:56.7058797'' and TransportNumberActual = ''050AH02'') or (FixationDateTime = ''2015-02-06 12:12:57.3353907'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:12:58.7458311'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:12:59.8023370'' and TransportNumberActual = ''735DYA02'') or (FixationDateTime = ''2015-02-06 12:13:01.8189071'' and TransportNumberActual = ''H012PUM'') or (FixationDateTime = ''2015-02-06 12:13:02.9075242'' and TransportNumberActual = ''038FUA02'') or (FixationDateTime = ''2015-02-06 12:13:04.4319194'' and TransportNumberActual = ''A323ZNO'') or (FixationDateTime = ''2015-02-06 12:13:07.6394621'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:13:09.5770549'' and TransportNumberActual = ''A573PXN'') or (FixationDateTime = ''2015-02-06 12:13:11.9782151'' and TransportNumberActual = ''410LXA05'') or (FixationDateTime = ''2015-02-06 12:13:12.5690475'' and TransportNumberActual = ''151CSA02'') or (FixationDateTime = ''2015-02-06 12:13:14.3364647'' and TransportNumberActual = ''644FPA05'') or (FixationDateTime = ''2015-02-06 12:13:16.8021511'' and TransportNumberActual = ''B0301A'') or (FixationDateTime = ''2015-02-06 12:13:19.1917147'' and TransportNumberActual = ''A609OMO'') or (FixationDateTime = ''2015-02-06 12:13:20.4364788'' and TransportNumberActual = ''235AFA02'') or (FixationDateTime = ''2015-02-06 12:13:22.9430018'' and TransportNumberActual = ''524NSA02'') or (FixationDateTime = ''2015-02-06 12:13:24.5892113'' and TransportNumberActual = ''956DOA05'') or (FixationDateTime = ''2015-02-06 12:13:25.2784474'' and TransportNumberActual = ''A035FXO'') or (FixationDateTime = ''2015-02-06 12:13:25.4889142'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:13:27.1566781'' and TransportNumberActual = ''921KWA02'') or (FixationDateTime = ''2015-02-06 12:14:16.8711563'' and TransportNumberActual = ''255BBA02'') or (FixationDateTime = ''2015-02-06 12:14:18.3799569'' and TransportNumberActual = ''A684RLN'') or (FixationDateTime = ''2015-02-06 12:14:20.4778172'' and TransportNumberActual = ''145DOA05'') or (FixationDateTime = ''2015-02-06 12:14:22.6841918'' and TransportNumberActual = ''116LFA02'') or (FixationDateTime = ''2015-02-06 12:14:24.6482083'' and TransportNumberActual = ''421LAA05'') or (FixationDateTime = ''2015-02-06 12:14:25.7368142'' and TransportNumberActual = ''B974XZN'') or (FixationDateTime = ''2015-02-06 12:14:27.2239629'' and TransportNumberActual = ''H768047'') or (FixationDateTime = ''2015-02-06 12:14:29.2703625'' and TransportNumberActual = ''A957TMN'') or (FixationDateTime = ''2015-02-06 12:14:30.4016815'' and TransportNumberActual = ''812NKA02'') or (FixationDateTime = ''2015-02-06 12:14:32.1669565'' and TransportNumberActual = ''654OHA02'') or (FixationDateTime = ''2015-02-06 12:14:34.1968093'' and TransportNumberActual = ''A715HA'') or (FixationDateTime = ''2015-02-06 12:14:38.8162815'' and TransportNumberActual = ''497CKA02'') or (FixationDateTime = ''2015-02-06 12:14:38.9998003'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:14:41.4946550'' and TransportNumberActual = ''0325WK'') or (FixationDateTime = ''2015-02-06 12:14:43.9165420'' and TransportNumberActual = ''A755XWM'') or (FixationDateTime = ''2015-02-06 12:14:44.3892515'' and TransportNumberActual = ''122AK02'') or (FixationDateTime = ''2015-02-06 12:14:46.0207460'' and TransportNumberActual = ''478AN02'') or (FixationDateTime = ''2015-02-06 12:14:47.5806960'' and TransportNumberActual = ''A899BTP'') or (FixationDateTime = ''2015-02-06 12:14:48.8832828'' and TransportNumberActual = ''A060CAP'') or (FixationDateTime = ''2015-02-06 12:14:49.2240556'' and TransportNumberActual = ''170DAA02'') or (FixationDateTime = ''2015-02-06 12:14:51.8037588'' and TransportNumberActual = ''458AS02'') or (FixationDateTime = ''2015-02-06 12:14:53.1416044'' and TransportNumberActual = ''A657TWO'') or (FixationDateTime = ''2015-02-06 12:14:53.4943250'' and TransportNumberActual = ''A474RNN'') or (FixationDateTime = ''2015-02-06 12:15:41.2524422'' and TransportNumberActual = ''643LPA02'') or (FixationDateTime = ''2015-02-06 12:15:44.6900046'' and TransportNumberActual = ''449MBA02'') or (FixationDateTime = ''2015-02-06 12:15:45.2475394'' and TransportNumberActual = ''A708VKO'') or (FixationDateTime = ''2015-02-06 12:15:47.5900843'' and TransportNumberActual = ''757MXA02'') or (FixationDateTime = ''2015-02-06 12:15:49.1065445'' and TransportNumberActual = ''924AR02'') or (FixationDateTime = ''2015-02-06 12:15:51.3315223'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:15:54.8988394'' and TransportNumberActual = ''232RB02'') or (FixationDateTime = ''2015-02-06 12:15:55.2410025'' and TransportNumberActual = ''V015DOP'') or (FixationDateTime = ''2015-02-06 12:16:03.0183745'' and TransportNumberActual = ''262HFA02'') or (FixationDateTime = ''2015-02-06 12:16:06.6436080'' and TransportNumberActual = ''035EHA02'') or (FixationDateTime = ''2015-02-06 12:16:07.8376992'' and TransportNumberActual = ''611KCA05'') or (FixationDateTime = ''2015-02-06 12:16:08.2976796'' and TransportNumberActual = ''9438AAO'') or (FixationDateTime = ''2015-02-06 12:16:10.9842751'' and TransportNumberActual = ''939AHA02'') or (FixationDateTime = ''2015-02-06 12:16:13.1773360'' and TransportNumberActual = ''A157HK'') or (FixationDateTime = ''2015-02-06 12:16:15.0804800'' and TransportNumberActual = ''A525UEO'') or (FixationDateTime = ''2015-02-06 12:16:18.6519531'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:17:06.3000559'' and TransportNumberActual = ''A419OON'') or (FixationDateTime = ''2015-02-06 12:17:10.9672046'' and TransportNumberActual = ''B836LEN'') or (FixationDateTime = ''2015-02-06 12:17:12.0642478'' and TransportNumberActual = ''A080DSP'') or (FixationDateTime = ''2015-02-06 12:17:14.5529853'' and TransportNumberActual = ''A774FCN'') or (FixationDateTime = ''2015-02-06 12:17:15.8694720'' and TransportNumberActual = ''078KXA05'') or (FixationDateTime = ''2015-02-06 12:17:17.8921292'' and TransportNumberActual = ''097DLA02'') or (FixationDateTime = ''2015-02-06 12:17:19.3269187'' and TransportNumberActual = ''197FLA02'') or (FixationDateTime = ''2015-02-06 12:17:21.3480366'' and TransportNumberActual = ''M376UUM'') or (FixationDateTime = ''2015-02-06 12:17:22.8777906'' and TransportNumberActual = ''656AEA02'') or (FixationDateTime = ''2015-02-06 12:17:24.3295190'' and TransportNumberActual = ''689BL02'') or (FixationDateTime = ''2015-02-06 12:17:26.3239146'' and TransportNumberActual = ''826LYA02'') or (FixationDateTime = ''2015-02-06 12:17:27.8717336'' and TransportNumberActual = ''989CEA02'') or (FixationDateTime = ''2015-02-06 12:17:28.5201601'' and TransportNumberActual = ''A320YCN'') or (FixationDateTime = ''2015-02-06 12:17:30.0720529'' and TransportNumberActual = ''128NXA02'') or (FixationDateTime = ''2015-02-06 12:17:31.6506535'' and TransportNumberActual = ''B886ZTN'') or (FixationDateTime = ''2015-02-06 12:17:32.6850254'' and TransportNumberActual = ''425MRA02'') or (FixationDateTime = ''2015-02-06 12:17:34.0138468'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:17:36.0250552'' and TransportNumberActual = ''A037XUN'') or (FixationDateTime = ''2015-02-06 12:17:37.3945321'' and TransportNumberActual = ''B438TYN'') or (FixationDateTime = ''2015-02-06 12:17:39.7616549'' and TransportNumberActual = ''_______'') or (FixationDateTime = ''2015-02-06 12:17:40.0801933'' and TransportNumberActual = ''A544DPP'') or (FixationDateTime = ''2015-02-06 12:17:43.8744312'' and TransportNumberActual = ''A960BPO'') or (FixationDateTime = ''2015-02-06 12:17:45.2319772'' and TransportNumberActual = ''A672___'') or (FixationDateTime = ''2015-02-06 12:18:34.8335881'' and TransportNumberActual = ''A998ACO'') or (FixationDateTime = ''2015-02-06 12:18:36.7549914'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:18:39.9072468'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:18:41.9473846'' and TransportNumberActual = ''A048EOP'') or (FixationDateTime = ''2015-02-06 12:18:43.8899867'' and TransportNumberActual = ''669BVA02'') or (FixationDateTime = ''2015-02-06 12:18:44.1298787'' and TransportNumberActual = ''045AW02'') or (FixationDateTime = ''2015-02-06 12:18:46.0110496'' and TransportNumberActual = ''H321502'') or (FixationDateTime = ''2015-02-06 12:18:48.3323823'' and TransportNumberActual = ''A845DN'') or (FixationDateTime = ''2015-02-06 12:18:49.2992986'' and TransportNumberActual = ''NoReadRecog'') or (FixationDateTime = ''2015-02-06 12:18:51.8019866'' and TransportNumberActual = ''110LCA02'') or (FixationDateTime = ''2015-02-06 12:18:53.8568379'' and TransportNumberActual = ''755LEA02'') or (FixationDateTime = ''2015-02-06 12:18:54.2182373'' and TransportNumberActual = ''A517VXO'') or (FixationDateTime = ''2015-02-06 12:18:56.0980999'' and TransportNumberActual = ''B615BVO'') or (FixationDateTime = ''2015-02-06 12:18:58.1578350'' and TransportNumberActual = ''A651BVP''))',N'@min datetime2(7),@max datetime2(7)',@min='2015-02-06 11:41:39.7026131',@max='2015-02-06 12:18:58.1578350'

и как раз на этой операции вылетает ошибка:

System.Data.SqlClient.SqlException (0x80131904): Истекло время ожидания (Timeout). 
Время ожидания истекло до завершения операции или сервер не отвечает. ---> System.ComponentModel.Win32Exception (0x80004005): Время ожидания операции истекло
   в System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   в System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   в System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   в System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   в System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   в System.Data.SqlClient.SqlDataReader.get_MetaData()
   в System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   в System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   в System.Data.SqlClient.SqlCommand.RunExecuteReader
(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   в System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   в System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   в System.Data.SqlClient.SqlCommand.ExecuteReader()
   в DTech.RoadTraffic.Loader.Impl.SqlInsert.SqlHelper.GetIds[T](TableName tableName, InputGetIdDto[] dtos)
   в DTech.RoadTraffic.Loader.Impl.ProcessTraffic.TrafficBulkSaver.SaveTraffics(SqlHelper helper, ITrafficMappingResult[] mappingResults)
   в DTech.RoadTraffic.Loader.Impl.ProcessTraffic.TrafficBulkSaver.BeginTransaction(ITrafficMappingResult[] mappingResults, SqlConnection connection)
ClientConnectionId:c1a631b5-f5e2-4237-88b3-6357b2bd7358


в результате которой приходится откатывать транзакцию и всю порцию данных грузить заново

Подскажите в чем возможная причина ошибки? Можно ли ее побороть (желательно не меняя схему данных) и как вообще на Select может вылетать таймаут если включена опция RCS?
11 фев 15, 09:44    [17248094]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
Glory
Member

Откуда:
Сообщений: 104751
Клиентский таймаут задает клиент.
11 фев 15, 09:46    [17248097]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
Maxx_UA
Guest
с таким условие where да на ваших размерах - вообще не удивительно что оно падает, удивительно когда НЕ падает :)
Да и проблемма с название темы вообще никак не коррелирует
11 фев 15, 10:26    [17248318]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
rere1234
Member

Откуда:
Сообщений: 38
Забыл уточнить что пакетная вставка и соответственно выборка производится из нескольких параллельно работающих приложений
11 фев 15, 10:34    [17248369]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
Glory
Member

Откуда:
Сообщений: 104751
rere1234
Забыл уточнить что пакетная вставка и соответственно выборка производится из нескольких параллельно работающих приложений

Только вот у сервера нет таймаутов на время выполнения команд.
11 фев 15, 10:37    [17248387]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
rere1234
Member

Откуда:
Сообщений: 38
Glory,

Таймаут на клиенте равен 30 секундам и если его сделать больше то приложения просто не успевают вовремя обрабатывать приходящий поток данных. Непонятна причина подвисаний select после insert. Как можно ее узнать?
11 фев 15, 10:59    [17248548]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
Glory
Member

Откуда:
Сообщений: 104751
rere1234
Непонятна причина подвисаний select после insert. Как можно ее узнать?

А почему вы решили, что select именно подвисает ?
11 фев 15, 11:04    [17248581]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
rere1234
Member

Откуда:
Сообщений: 38
Glory,

В stack trace местом возникновения exception указан метод GetIds
        public IEnumerable<GetIdDtoResult<T>> GetIds<T>(TableName tableName, InputGetIdDto[] dtos)
        {
            var commandText = GenerateCommandText(tableName, dtos);

            var result = new List<GetIdDtoResult<T>>();
            using (var connection = new SqlConnection(_config.ConnectionString))
            {
                connection.Open();
                using (var transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted))
                {
                    var command = new SqlCommand(commandText, connection, transaction)
                    {
                        CommandTimeout = 30
                    };

                    command.Parameters.Add("@min", SqlDbType.DateTime2);
                    command.Parameters["@min"].Value = dtos.Min(d => d.FixationDateTime);

                    command.Parameters.Add("@max", SqlDbType.DateTime2);
                    command.Parameters["@max"].Value = dtos.Max(d => d.FixationDateTime);

                    using (var dataReader = command.ExecuteReader())
                    {
                        const int indexOfId = 0;
                        const int indexOfFixDate = 1;
                        const int indexOfGrnz = 2;

                        while (dataReader.Read())
                        {
                            var id = (T) Convert.ChangeType(dataReader.GetValue(indexOfId), typeof(T));
                            var fixationDate = (DateTime) dataReader.GetValue(indexOfFixDate);
                            var transportNumber = dataReader.GetValue(indexOfGrnz).ToString();

                            result.Add(new GetIdDtoResult<T>
                            {
                                Id = id, 
                                FixationDateTime = fixationDate,
                                TransportNumber = transportNumber
                            });
                        }
                    }
                }
            }
            return result;
        }

        private static string GenerateCommandText(TableName table, InputGetIdDto[] dtos)
        {
            if (table == TableName.None)
            {
                throw new ArgumentOutOfRangeException("table");
            }

            var grnzProperyName = table == TableName.RestrictionCar ? "TransportNumber" : "TransportNumberActual";

            var tableName = GetTableName(table);
            var predicateText = new StringBuilder();
            
            var length = dtos.Length;
            for (var i = 0; i < length; i++)
            {
                var fixationDate = dtos[i].FixationDateTime.ToString("yyyy-MM-dd HH:mm:ss.fffffff");
                var transportNumber = dtos[i].TransportNumber;

                predicateText.AppendFormat("(FixationDateTime = \'{0}\' and {1} = \'{2}\')", fixationDate, grnzProperyName,
                    transportNumber);
                if (i < length - 1)
                    predicateText.Append(" or ");
            }

            var commandText = string.Format("select Id, FixationDateTime, {0} from {1} " +
                                            "where (FixationDateTime >= @min and FixationDateTime <= @max) and " +
                                            "({2})", grnzProperyName, tableName, predicateText);
            return commandText;
        }


Да кстате в последнем решении для чтения Id мы используем новое соединение/транзакцию с уровнем ReadUncommitted, до этого был вариант с использованием существующего соединения транзакции, но ошибка все равно иногда возникает.
11 фев 15, 11:19    [17248702]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 31783
rere1234
Непонятна причина подвисаний select после insert. Как можно ее узнать?
Начните с понимания передаваемых на сервер команд (а не с анализа текста на C#)

Посмотрите их в трейсе, а так же их планы, и характеристики выполнения (чтения, записи, ЦПУ, время)
Кроме того, проанализируйте блокировки во время нагрузки - кто кого блокирует.

Это по крайней мере даст начальную информацию для анализа. Код на C# и место эксепшена в этом коде использовать как минимум неудобно для решения проблем на стороне MSSQL
11 фев 15, 11:26    [17248747]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
Glory
Member

Откуда:
Сообщений: 104751
rere1234
В stack trace местом возникновения exception указан метод GetIds

Какое отношение ваш клиентский код имеет к серверу ?
11 фев 15, 11:26    [17248751]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 31783
rere1234
Подскажите в чем возможная причина ошибки?
А, увидел команду.
Условия типа "(FixationDateTime = '2015-02-06 11:41:41.9365545' and TransportNumberActual = '214DWA02') or "
означают, видимо, скан секции. Или скан нескольких секций, или всей таблицы.
Вы план посмотрите для этого запроса.
11 фев 15, 11:32    [17248791]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 31783
rere1234
Можно ли ее побороть (желательно не меняя схему данных)
Если не менять код/модель, то вряд ли получится побороть, чекбокс "работать быстро" у MSSQL и так включён по умолчанию :-)
11 фев 15, 11:34    [17248809]     Ответить | Цитировать Сообщить модератору
 Re: таймаут при bulk insert из нескольких потоков  [new]
ЕвгенийВ
Member

Откуда: Москва
Сообщений: 4962
rere1234,
А если добавить один идентификатор (уникальный) вставки int и не вытаскивать по нему новые идентификаторы, а не строить монстрообразный запрос?
11 фев 15, 11:57    [17249010]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить