public Task Execute() { return(Task.Factory.StartNew(() => { //Nothing to do if (!_configuration.query.IncludeDimensions) { return; } if (_doExecute) { var timer = Stopwatch.StartNew(); try { _datset = SqlHelper.GetDataset(ConfigHelper.ConnectionString, _sql, _configuration.parameters); //Log long running timer.Stop(); if (timer.ElapsedMilliseconds > 10000) { LoggerCQ.LogWarning($"NormalDimensionBuilderDelay: ID={_configuration.schema.ID}, Elapsed={timer.ElapsedMilliseconds}, Query=\"{_configuration.query.ToString()}\""); } } catch (Exception ex) { RepositoryHealthMonitor.HealthCheck(_configuration.schema.ID); DataManager.AddSkipItem(_configuration.schema.ID); LoggerCQ.LogError(ex, $"NormalDimensionBuilder: ID={_configuration.schema.ID}, Query=\"{_configuration.query.ToString()}\", Error={ex.Message}"); } } })); }
public Task Execute() { return(Task.Factory.StartNew(() => { //Nothing to do if (!_configuration.query.IncludeDimensions && !_configuration.query.IncludeRecords) { return; } var timer = Stopwatch.StartNew(); try { _dsList = SqlHelper.GetDataset(ConfigHelper.ConnectionString, _sql, _listParameters); //Log long running timer.Stop(); if (timer.ElapsedMilliseconds > 10000) { LoggerCQ.LogWarning($"ListDimensionBuilderDelay: ID={_configuration.schema.ID}, DIdx={_newDimension?.DIdx}, Elapsed={timer.ElapsedMilliseconds}, Query=\"{_configuration.query.ToString()}\""); } } catch (Exception ex) { RepositoryHealthMonitor.HealthCheck(_configuration.schema.ID); DataManager.AddSkipItem(_configuration.schema.ID); var message = ex.Message; if (message.Contains("Timeout Expired")) { message = "Timeout Expired"; //Do not show whole message, no value } LoggerCQ.LogError($"ListDimensionBuilder: ID={_configuration.schema.ID}, DIdx={_newDimension?.DIdx}, Elapsed={timer.ElapsedMilliseconds}, Query=\"{_configuration.query.ToString()}\", Error={message}"); } })); }
public Task Execute() { return(Task.Factory.StartNew(() => { try { _datset = SqlHelper.GetDataset(ConfigHelper.ConnectionString, _sql, _configuration.parameters); } catch (Exception ex) { RepositoryHealthMonitor.HealthCheck(_configuration.schema.ID); DataManager.AddSkipItem(_configuration.schema.ID); LoggerCQ.LogError(ex, $"RecordBuilder: ID={_configuration.schema.ID}, Query=\"{_configuration.query.ToString()}\", Error={ex.Message}"); } })); }