I am attempting to copy a snowflake query layer to a local geodatabase but the GP tool fails with no error messages or any messages for that matter. What could be the issue? I have confirmed that the snowflake table gets created as I return the count of rows found.
var pgs = Project.Current.GetItems<GDBProjectItem>();
foreach (var pg in pgs)
{
if (pg.Name == "SnowflakeProd.sde")
{
var mlyr = "mylyr";
var serviceEventTablename = "MySnowflakeTable";
var query1 = $"mySnowFlakeQuery that I am choosing not to expose here";
await QueuedTask.Run(async () =>
{
using (var snowflakeSde = pg.GetDatastore() as Database)
{
var k = snowflakeSde.GetQueryDescription(query1, mlyr);
k.SetObjectIDFields(realUid);
var outTable = snowflakeSde.OpenTable(k) as Table;
var outTablePath = @"C:\Users\MyuserId\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb\TTCopySnflk";
var outpath = @"C:\Users\MyUserId\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb";
var outname = "TTCopySnflk";
var count = outTable.GetCount();
MessageBox.Show($"{count}");
var copyParams = Geoprocessing.MakeValueArray(outTable.GetPath().AbsolutePath, outTablePath);
var env = Geoprocessing.MakeEnvironmentArray(overwriteoutput: true);
var copyResult = await Geoprocessing.ExecuteToolAsync("conversion.ExportTable", copyParams, env);//, null, GPExecuteToolFlags.Default); can't get this to work
if (copyResult.IsFailed)
{
throw new Exception($"{String.Join(',', copyResult.ErrorMessages)}, {String.Join(',', copyResult.Messages)}");
}
//copyResult fails with empty error messages
}
});
}
}
@NarelleChedzey @UmaHarano @Wolf @CharlesMacleod
