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}");
}
}));
}
