HOWTO: Increase default timeout for extraction (4301285)

Issue
File is failing extraction process because it was not able to extract file in 10 minutes, what is default time.

“EXCEPTION: QUADROtech.FlightDeck.PostProcess.UnresponsibleProcessTerminatedException: Worker process [8604] was terminated, because it didn’t update its status for [10] minute(s).“

Click To See Full Image.

Solution

NOTE: This solution works only for version 4.2.0.19957 and higher.

NOTE: Setting it very High can slow down the migration – as corrupt files take longer to fail, resulting in workers being blocked.

Execute following query in SQL database which increase extraction timeout to 60 minutes:

USE [PSTFlightdeckDirectory]
GO
INSERT INTO [dbo].[ModuleSettingEntry]
([SettingCode]
,[ModuleEntryId]
,[SettingValueString]
,[SettingValueType]
,[ModuleTypeEntryId]
,[LocationEntryId])
VALUES
('Worker.AdditionalInitializationTimeout'
, NULL
,'50'
,'System.Int32'
,25
,1)
GO

Only value that can be different is [LocationEntryId]. This can be check by executing this second query:

USE PSTFlightdeckDirectory
SELECT * FROM [PSTFlightdeckDirectory].[dbo].[ModuleSettingEntry]

Solution 2

NOTE: Setting it very High can slow down the migration – as corrupt files take longer to fail, resulting in workers being blocked.

SELECT * FROM ModuleSettingEntry
WHERE SettingCode='Worker.AdditionalInitializationTimeout'
UPDATE ModuleSettingEntry SET SettingValueString='170' 
WHERE SettingCode='Worker.AdditionalInitializationTimeout'