topic Error when adding breaks in a vehicule routing problem (invalid SQL query) in ArcGIS Network Analyst Questions https://community.esri.com/t5/arcgis-network-analyst-questions/error-when-adding-breaks-in-a-vehicule-routing/m-p/196885#M1982 <HTML><HEAD></HEAD><BODY><SPAN>Hi I am trying to add breaks on each of the 12 routes created for a paratransit service. the solver works well, however when I try to add breaks (MaxCumulWorkTime or MaxCumulWorkTime) an error occurs (invalid SQL query). Only TimeWindows breaks are working. </SPAN><BR /><BR /><SPAN>I followed ArcGis instructions carefully and I don't understand why it is not working... Can someone helps?</SPAN><BR /><BR /><SPAN>Thank you!</SPAN></BODY></HTML> Thu, 19 May 2011 16:03:59 GMT denismatarangas 2011-05-19T16:03:59Z Error when adding breaks in a vehicule routing problem (invalid SQL query) https://community.esri.com/t5/arcgis-network-analyst-questions/error-when-adding-breaks-in-a-vehicule-routing/m-p/196885#M1982 <HTML><HEAD></HEAD><BODY><SPAN>Hi I am trying to add breaks on each of the 12 routes created for a paratransit service. the solver works well, however when I try to add breaks (MaxCumulWorkTime or MaxCumulWorkTime) an error occurs (invalid SQL query). Only TimeWindows breaks are working. </SPAN><BR /><BR /><SPAN>I followed ArcGis instructions carefully and I don't understand why it is not working... Can someone helps?</SPAN><BR /><BR /><SPAN>Thank you!</SPAN></BODY></HTML> Thu, 19 May 2011 16:03:59 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/error-when-adding-breaks-in-a-vehicule-routing/m-p/196885#M1982 denismatarangas 2011-05-19T16:03:59Z Re: Error when adding breaks in a vehicule routing problem (invalid SQL query) https://community.esri.com/t5/arcgis-network-analyst-questions/error-when-adding-breaks-in-a-vehicule-routing/m-p/196886#M1983 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Could you please provide more details on how you added the MaxCumulWorkTime break? </SPAN><BR /><BR /><SPAN>A vehicle routing problem analysis layer can only be solved if all breaks are of the same type; that is, the solve process will fail if there is any combination of time-window, maximum-travel-time, and maximum-work-time breaks.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN><BR /><BR /><SPAN>Anna</SPAN></BODY></HTML> Thu, 19 May 2011 17:15:26 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/error-when-adding-breaks-in-a-vehicule-routing/m-p/196886#M1983 NaAn 2011-05-19T17:15:26Z