topic Re: An invalid SQL statement usec in Transportation Questions https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181205#M626 <HTML><HEAD></HEAD><BODY><SPAN>Unfortunately, there are no logging capabilities.&nbsp; I think we'll probably need to have a look at the project if you don't mind sending it over.&nbsp; </SPAN><BR /><BR /><SPAN>Are you evaluating the software or have you already purchased?&nbsp; If it's the latter, the best bet is to call tech support and get an incident logged for this.&nbsp; If you're in the evaluation phase, send me a note at </SPAN><A href="mailto:byagrich@esri.com">byagrich@esri.com</A><SPAN> and we'll work something out.</SPAN></BODY></HTML> Wed, 11 May 2011 16:31:31 GMT BertYagrich 2011-05-11T16:31:31Z An invalid SQL statement usec https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181202#M623 <HTML><HEAD></HEAD><BODY><SPAN>Invalid SQL statement used - I get this error when moving orders from one route to another route and the movement from one route to the other fails.</SPAN></BODY></HTML> Tue, 10 May 2011 13:19:58 GMT https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181202#M623 BradClay 2011-05-10T13:19:58Z Re: An invalid SQL statement usec https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181203#M624 <HTML><HEAD></HEAD><BODY><SPAN>Not sure about this one without more info.&nbsp; Could you give some detail as to why the order move fails?&nbsp; Maybe a screenshot or two might help.</SPAN></BODY></HTML> Tue, 10 May 2011 22:18:41 GMT https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181203#M624 BertYagrich 2011-05-10T22:18:41Z Re: An invalid SQL statement used https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181204#M625 <HTML><HEAD></HEAD><BODY><SPAN>This error also appearing with some solves, success with solving some selected groups of orders and not others. When this error appears with a solve there is no pop box with the usual explanation of reasons why the solve did not work. Is there an error log that I can see to explain this? Ideas?</SPAN></BODY></HTML> Wed, 11 May 2011 14:24:27 GMT https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181204#M625 BradClay 2011-05-11T14:24:27Z Re: An invalid SQL statement usec https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181205#M626 <HTML><HEAD></HEAD><BODY><SPAN>Unfortunately, there are no logging capabilities.&nbsp; I think we'll probably need to have a look at the project if you don't mind sending it over.&nbsp; </SPAN><BR /><BR /><SPAN>Are you evaluating the software or have you already purchased?&nbsp; If it's the latter, the best bet is to call tech support and get an incident logged for this.&nbsp; If you're in the evaluation phase, send me a note at </SPAN><A href="mailto:byagrich@esri.com">byagrich@esri.com</A><SPAN> and we'll work something out.</SPAN></BODY></HTML> Wed, 11 May 2011 16:31:31 GMT https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181205#M626 BertYagrich 2011-05-11T16:31:31Z Re: An invalid SQL statement used https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181206#M627 <HTML><HEAD></HEAD><BODY><SPAN>yes, already own the software, alright, I will write a support ticket.</SPAN></BODY></HTML> Wed, 11 May 2011 19:44:07 GMT https://community.esri.com/t5/transportation-questions/an-invalid-sql-statement-usec/m-p/181206#M627 BradClay 2011-05-11T19:44:07Z