topic Re: GPTool Table Results in ArcGIS API for Silverlight Questions

GPTool Table Results

BrianLeroux — Wed, 23 May 2012 15:01:26 GMT

Hi-
I created a geoprocessing service that outputs a table in the scratch GDB. I am trying to retrieve the results to diplay in a datagrid but I am having issues. I have tried many methods with no luck. Below I try to count the outparameters but it is always 0. Does anyone know how to retruieve the table data?

private void GeoprocessorTask_ExecuteCompleted(object sender, ESRI.ArcGIS.Client.Tasks.GPExecuteCompleteEventArgs args)         {             btnPoint.IsEnabled = true;             MessageBox.Show(args.Results.OutParameters.Count().ToString());          }

Thanks!

Re: GPTool Table Results

JenniferNery — Wed, 23 May 2012 15:39:39 GMT

Have you tried executing Geoprocessor Task from your web browser, through the REST endpoint? Do you get the same results?

If it is a server asynchronous operation, you will need to call SubmitJob() instead.

Example of server synchronous: http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#MessageInABottle

Example of server asynchronous operation: http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#ClipFeatures

I think you want to return GPFeatureRecordSetLayer in order to display its FeatureSet in FeatureDataGrid.

Re: GPTool Table Results

BrianLeroux — Wed, 23 May 2012 15:48:17 GMT

Hi Jennifer- Thanks for the reply. When i run from the rest enpoint to the %SCRATCHWORKSPACE% i get results but they disappear from the jobs folder to check what is in the results table. I changed the output of the service to a dbf temporarily and I see my results fine. I get the messages seen below when running the gp fom rest.

The gp service is synchrounous so the execute should be fine.

I belive you are right with the GPFeatureRecordSetLayer. How do I go about that?

Results:

Messages:
�?� esriJobMessageTypeInformative: Executing (HailAnalysis): HailAnalysis "Feature Set" "100 Miles"
�?� esriJobMessageTypeInformative: Start Time: Wed May 23 11:06:24 2012
�?� esriJobMessageTypeInformative: Executing (Buffer): Buffer "Feature Set" D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\Buffer.shp "100 Miles" FULL ROUND NONE #
�?� esriJobMessageTypeInformative: Start Time: Wed May 23 11:06:24 2012
�?� esriJobMessageTypeInformative: Succeeded at Wed May 23 11:06:25 2012 (Elapsed Time: 1.00 seconds)
�?� esriJobMessageTypeInformative: Executing (Clip): Clip D:\agsResources\ArcSDE.sde\ArcSDE.A10ID.HailClaims D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\Buffer.shp D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\HailClaims_Clip.shp #
�?� esriJobMessageTypeInformative: Start Time: Wed May 23 11:06:25 2012
�?� esriJobMessageTypeInformative: Reading Features...
�?� esriJobMessageTypeInformative: Cracking Features...
�?� esriJobMessageTypeInformative: Assembling Features...
�?� esriJobMessageTypeInformative: Succeeded at Wed May 23 11:06:25 2012 (Elapsed Time: 0.00 seconds)
�?� esriJobMessageTypeInformative: Executing (Summary Statistics): Statistics D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\HailClaims_Clip.shp D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\HailClaims_Clip_Statistics.dbf "LossAmt MEAN;ExpAmt MEAN;LossAmt SUM;ExpAmt SUM" LossDt
�?� esriJobMessageTypeInformative: Start Time: Wed May 23 11:06:25 2012
�?� esriJobMessageTypeInformative: Succeeded at Wed May 23 11:06:25 2012 (Elapsed Time: 0.00 seconds)
�?� esriJobMessageTypeInformative: Executing (Sort): Sort D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\HailClaims_Clip_Statistics.dbf D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\HailClaims_Clip_Statistics_S.dbf "FREQUENCY DESCENDING" UR
�?� esriJobMessageTypeInformative: Start Time: Wed May 23 11:06:25 2012
�?� esriJobMessageTypeInformative: Succeeded at Wed May 23 11:06:25 2012 (Elapsed Time: 0.00 seconds)
�?� esriJobMessageTypeInformative: Executing (Table Select): TableSelect D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\HailClaims_Clip_Statistics_S.dbf D:\arcgisserver\arcgisjobs\gptools_gpserver\j1ef0965a68274e9e8f798b023f3ea66e\scratch\scratch.gdb\Ouput "OID >= 5"
�?� esriJobMessageTypeInformative: Start Time: Wed May 23 11:06:25 2012
�?� esriJobMessageTypeInformative: Succeeded at Wed May 23 11:06:26 2012 (Elapsed Time: 1.00 seconds)
�?� esriJobMessageTypeInformative: Succeeded at Wed May 23 11:06:26 2012 (Elapsed Time: 2.00 seconds)

Re: GPTool Table Results

JenniferNery — Wed, 23 May 2012 16:36:12 GMT

I see. Does your Geoprocessor require input parameters? Do you send the same request from your Silverlight application (you can compare with browser request using Fiddler). I'm not sure if this help document will help: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00170000006p000000

Re: GPTool Table Results

BrianLeroux — Sat, 11 Dec 2021 22:36:43 GMT

It does require input and I have already used Fiddler to verify the rquest I am sending is correct.

I changed my execution type to asynchronous now so I can see my results on the server. I am now trying to update my web app to use this service. I am stuck on the part you mentioned about the GPFeatureRecordSetLayer. I see examples on how to iterate the recordset to add as graphics. I just can't seem to figure out how to iterate the records to add to a list so I can populate a table since what i am returning are just statistics that will display in a report.

GPFeatureRecordSetLayer gpLayer = e.Parameter as GPFeatureRecordSetLayer;

            foreach (Graphic graphic in gpLayer.FeatureSet.Features)
            {
               
            }

Re: GPTool Table Results

JenniferNery — Wed, 23 May 2012 16:45:57 GMT

You can look at this SDK sample: http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#ClipFeatures. The result is also a GPFeatureRecordSetLayer. You can add results to a GraphicsLayer. I imagine your feature attributes will contain the data to show in the data grid. You can then use FeatureDataGrid and set MyDataGrid.GraphicsLayer to this layer that contain the features. GraphicsLayer does not need to be part of map if there is no geometry.

Re: GPTool Table Results

BrianLeroux — Wed, 23 May 2012 19:23:26 GMT

GraphicsLayer does not need to be part of map if there is no geometry.

I did not know this. That should clear everything up. I will give it a try. Thanks!!!

Re: GPTool Table Results

BrianLeroux — Sat, 11 Dec 2021 22:36:46 GMT

Well I am not having much luck. I can't seem to retrieve my results from the GP Task. The GP Task runs fine and I do see the results in the jobs folder on the server. I then attempt to run a GetResultDataAsync to get the GPFeatureRecordSetLayer but it is getting hung up. It seems like my geoprocessorTask.GetResultDataCompleted is not firing as the completed or failed events never get triggered. Anyone see anything wrong in my code? This is the first time I try an Asynchronous request so there is verywell some user error involved here. I use the samples as a guide.

private void Geoprocessor_JobCompleted(object sender, JobInfoEventArgs e)
        
        {            
            Geoprocessor geoprocessorTask = sender as Geoprocessor;
            geoprocessorTask.GetResultDataCompleted += GeoprocessorTask_GetResultDataCompleted;
            geoprocessorTask.Failed += GeoprocessorTask_Failed;

            geoprocessorTask.GetResultDataAsync(e.JobInfo.JobId, "output");
            
        }

        private void GeoprocessorTask_GetResultDataCompleted(object sender, GPParameterEventArgs e)
        {
            GraphicsLayer graphicsLayer = MapApplication.Current.Map.Layers["MyResultGraphicsLayer"] as GraphicsLayer;
            GPFeatureRecordSetLayer gpLayer = e.Parameter as GPFeatureRecordSetLayer;

            MessageBox.Show(gpLayer.FeatureSet.Count().ToString());

            foreach (Graphic graphic in gpLayer.FeatureSet.Features)
            {                
                graphicsLayer.Graphics.Add(graphic);
            }

            MessageBox.Show(graphicsLayer.Count().ToString());

            this.dg.GraphicsLayer = graphicsLayer;
            btnPoint.IsEnabled = true; 
        }

        private void GeoprocessorTask_Failed(object sender, TaskFailedEventArgs e)
        {
            MessageBox.Show("Geoprocessing service failed: " + e.Error);
            btnPoint.IsEnabled = true;
        }

Re: GPTool Table Results

DominiqueBroux — Thu, 24 May 2012 13:27:12 GMT

You might check e.JobInfo.JobStatus in order to be sure the Job has succeeded (return value should be esriJobSucceeded)

Else check in your model that your parameter is called 'output'.

Else... no more idea.

Re: GPTool Table Results

BrianLeroux — Thu, 24 May 2012 13:40:14 GMT

Hi dbroux,

I already have MessageBox.Show(e.JobInfo.JobStatus.ToString()); in my code for Geoprocessor_JobCompleted and it shows the esriJobSucceeded message. I have messageboxes in my GeoprocessorTask_GetResultDataCompleted so it will show me when that completes but I never get anything.

Here is my output parameter which does not look like an issue to me.

Parameter: output
Data Type: GPRecordSet
Display Name: output
Direction: esriGPParameterDirectionOutput
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:

Thanks for your response.

Re: GPTool Table Results

BrianLeroux — Sat, 11 Dec 2021 22:36:48 GMT

Update:
I tied the GetResultDataAsync to the onclick event of a button and specified the jobID of a know job that has results in the server jobs folder. When I click the button nothing happens. I had fiddler running so I could see if a request was being sent. Nothing shows in fiddler. I am not sure why GetResultDataAsync is not firing at all.

Geoprocessor geoprocessorTask = sender as Geoprocessor;
            geoprocessorTask.GetResultDataCompleted += GeoprocessorTask_GetResultDataCompleted;
            geoprocessorTask.Failed += GeoprocessorTask_Failed;
            geoprocessorTask.GetResultDataAsync("j0ecca8fcfee3406ba977cb29b53d09dd", "output");

I put in some exception handling in my code to see what is going wrong. I get an "object reference not set to an instance of an object" in this code.

foreach (GPParameter gpParameter in e.Results.OutParameters)
                {
                    GPFeatureRecordSetLayer gpLayer = gpParameter as GPFeatureRecordSetLayer;

                    foreach (Graphic graphic in gpLayer.FeatureSet.Features)
                    {
                        graphicsLayer.Graphics.Add(graphic);
                    }
                }

Re: GPTool Table Results

BrianLeroux — Sat, 11 Dec 2021 22:36:51 GMT

So I am getting my reults back as I can get a correct feature count on the GPParameter. I still can't get my results to show in a datagrid. The code below give me a datagrid with the correct # of items but the data is showing information about the data and not the data itself. Any help is appreciated.

foreach (GPParameter gpParameter in e.Results.OutParameters)
                    if (gpParameter.Name == "output_dbf")
                    {
                        GPRecordSet gpLayer = gpParameter as GPRecordSet;
                        MessageBox.Show(gpLayer.FeatureSet.Count().ToString()); 
                        dg1.ItemsSource = gpLayer.FeatureSet.Features;                       
                    }

[ATTACH=CONFIG]16934[/ATTACH]

Re: GPTool Table Results

BrianLeroux — Sat, 11 Dec 2021 22:36:54 GMT

I am getting close but can;t quite get it to populate the datagrid. The code below gets me the correct number of features that should be in the datagrid and even adds the correct number of rows to the table. However, the table rows do not contain any data. So close and I feel like it is something very easy that I am missing. Ideas anyone?

XAML

 <sdk:DataGrid AutoGenerateColumns="True" Height="236" HorizontalAlignment="Left" Margin="12,52,0,0" Name="dg1" VerticalAlignment="Top" Width="476">
            <sdk:DataGrid.Columns>
                <!--<sdk:DataGridTextColumn Binding="{Binding Path=OID}" SortMemberPath="OID" Header="OID"/>-->
                <!--<sdk:DataGridTextColumn Binding="{Binding Path=LossDt}" SortMemberPath="LossDt" Header="LossDt"/>-->
                <!--<sdk:DataGridTextColumn Binding="{Binding Path=FREQUENCY}" SortMemberPath="FREQUENCY" Header="FREQUENCY"/>-->
                <sdk:DataGridTextColumn Binding="{Binding MEAN_LossA}" SortMemberPath="MEAN_LossA" Header="MEAN_LossA"/>
                <!--<sdk:DataGridTextColumn Binding="{Binding Path=SUM_LossAm}" SortMemberPath="SUM_LossAm" Header="SUM_LossAm"/>-->
                <!--<sdk:DataGridTextColumn Binding="{Binding Path=MEAN_ExpAm}" SortMemberPath="MEAN_ExpAm" Header="MEAN_ExpAm"/>-->
                <!--<sdk:DataGridTextColumn Binding="{Binding Path=SUM_ExpAmt}" SortMemberPath="SUM_ExpAmt" Header="SUM_ExpAmt"/>-->

            </sdk:DataGrid.Columns>
        </sdk:DataGrid>

XAML CS

 public interface HailData {} 
        public class HailAttributes : HailData
        {
            //public double OID;
            //public string LossDt;
           // public double FREQUENCY;
            public string MEAN_LossA;
            //public double SUM_LossAm;
            //public double MEAN_ExpAm;
            //public double SUM_ExpAmt;
        }

        public string MEAN_LossA
        {
            get { return MEAN_LossA; }
        }


        private void GeoprocessorTask_ExecuteCompleted(object sender, ESRI.ArcGIS.Client.Tasks.GPExecuteCompleteEventArgs e)
        {
            try
            {
                this.dg1.ItemsSource = null;
                
                foreach (GPParameter gpParameter in e.Results.OutParameters)
                    if (gpParameter.Name == "output_dbf")
                    {
                        GPRecordSet gpLayer = gpParameter as GPRecordSet;

                        List<HailData> theList = new List<HailData>();

                        foreach (Graphic feature in gpLayer.FeatureSet.Features)
                        {
                            //MessageBox.Show(feature.Attributes["MEAN_LossA"].ToString());
                            theList.Add(new HailAttributes()
                            {
                                //OID = Convert.ToDouble(feature.Attributes["OID"]),
                                //LossDt = feature.Attributes["LossDt"].ToString(),
                                //FREQUENCY = Convert.ToDouble(feature.Attributes["FREQUENCY"]),
                                MEAN_LossA = feature.Attributes["MEAN_LossA"].ToString(),
                                //SUM_LossAm = Convert.ToDouble(feature.Attributes["SUM_LossAm"]),
                                //MEAN_ExpAm = Convert.ToDouble(feature.Attributes["MEAN_ExpAm"]),
                                //SUM_ExpAmt = Convert.ToDouble(feature.Attributes["SUM_ExpAmt"]),
                            });
                            
                        }
                        MessageBox.Show(theList.Count().ToString());                       
                        this.dg1.ItemsSource = theList;
                       
                    }
                                                
                btnPoint.IsEnabled = true; 
            }
            catch (OverflowException oEx)
            {
                MessageBox.Show(oEx.Message);
                btnPoint.IsEnabled = true; 
            }
            catch (FormatException fEx)
            {
                MessageBox.Show(fEx.Message);
                btnPoint.IsEnabled = true; 
            }
            catch (Exception ex)
            {
                
                MessageBox.Show(ex.Message + " stacktrace:" + ex.StackTrace);
                btnPoint.IsEnabled = true; 
            }
           

        }

Re: GPTool Table Results

DominiqueBroux — Mon, 20 Aug 2012 08:30:38 GMT

If you come back to your ItemSources set to the Features:

dg1.ItemsSource = gpLayer.FeatureSet.Features;

you should be able to bind your columns by using the Attributes dictionary:

<sdk:DataGridTextColumn Binding="{Binding Path=Attributes[OID]}" Header="OID"/>

Re: GPTool Table Results

BrianLeroux — Mon, 20 Aug 2012 11:52:16 GMT

Thanks dbroux, that did the trick.

Re: GPTool Table Results

GaryBushek — Thu, 20 Jun 2013 20:37:18 GMT

Jennifer,
Based on something Brian said above. He changed his task to asynchronous so he could see results. I'm using synchronous and don't see results. I'd rather not switch to asynchronous if I can avoid it. Is there some reason the published model wouldn't return the results as a GPRecordSet? Is this something to do with how I defined the final output in the model? I have
%scratchGDB%\Site_Results. Running the model on the server works fine but like I said, when I publish it and run from a client I don't get results. Im not that familiar with how to set up output for synchronous tasks. asynchronous is kind of obvious with the job folder specific to the task that has to be referenced by job id to retrieve status and results.

Thanks, Gary

Re: GPTool Table Results

JenniferNery — Tue, 14 Jul 2015 20:20:53 GMT

I think this guide doc might help: Geoprocessing task—ArcGIS API for Silverlight | ArcGIS for Developers