topic Re: Pickup Quantities field is null in output for VRP in ArcGIS Network Analyst Questions

Pickup Quantities field is null in output for VRP

ShrutiMenon — Wed, 28 Jun 2017 10:49:59 GMT

I've published the Vehicle Routing Problem as a geoprocessing service on ArcGIS Server.

I have 124 points under Orders and one depot. I'm entering route input for six routes including the Capacities parameter.

I have a column in the attribute table for Orders that specifies pickup quantities; I mapped this field to Pickup Quantities while publishing the service. However in the output table for Stops, the Pickup Quantities field is blank. The routes are being generated but capacities are being ignored. What could be the issue?

Re: Pickup Quantities field is null in output for VRP

ShubhadaKshirsagar — Thu, 29 Jun 2017 01:08:04 GMT

Hello Shruti,

The only case I can think of, in this case is when there is no value for pickupquantities column for the orders.

Either it is not set in the orders table or when you assign the orders layer as input to the VRP GP service, the chosen orders layer is not the one where the pickupquantities are set.

Could you please confirm this and respond? I could help further if it is not the case.

Thanks,

Shubhada

Re: Pickup Quantities field is null in output for VRP

ShrutiMenon — Thu, 29 Jun 2017 05:55:24 GMT

Hi Shubhada,

Thanks for your response!

No, the chosen column is the one with the quantities. I've checked and double checked! I also checked the data type in the VRP tool but everything matches. While assigning the orders layers in the VRP tool in Network Analyst, I've matched that particular column to "Pickup Quantities". (I've also tried matching it to Delivery Quantities and then publishing but it's not giving me an output either way).

Thanks,

Shruti

Re: Pickup Quantities field is null in output for VRP

ShubhadaKshirsagar — Thu, 29 Jun 2017 06:00:26 GMT

Hello Shruti,

Would you be able to send me the layer file or the orders layer?

That would give me some idea probably.

Get Outlook for iOS<https://aka.ms/o0ukef>

Re: Pickup Quantities field is null in output for VRP

ShrutiMenon — Tue, 04 Jul 2017 04:24:37 GMT

Sure, how should I send the data?

Re: Pickup Quantities field is null in output for VRP

ShubhadaKshirsagar — Sat, 08 Jul 2017 00:23:01 GMT

Hello Shruti,

Please send the data in email to SKshirsagar@esri.com and I will have a look.

Thanks,

Shubhada

Re: Pickup Quantities field is null in output for VRP

ShrutiMenon — Mon, 31 Jul 2017 09:25:05 GMT

In case anyone else has the same question, it was solved by keeping the column names in the data exactly the same as the parameter required by the VRP.

For instance, in my data, the column with the pickup quantities was named "Quantity" and I had mapped it to PickupQuantities while publishing. However, this didn't work which is why it wasn't able to read the field. Once I changed the column name, it started working fine. Rather basic, but it was an oversight that no one caught!