topic Is there an output file name or path limit length in CopyRows_management? in Python Questions https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286116#M22123 <HTML><HEAD></HEAD><BODY><P>I'm processing a large amount of data, and in the process I use the copyrows function to create a new table. I do validate the table name before doing so.</P><P></P><P>Nevertheless, it comes up with the "could not output" error every once in awhile. I've modified my program to just keep going and keep a list of the ones that failed.</P><P></P><P>The only thing I can see in common is that all the tables it failed to create have names and paths on the longer side. Is this a limitation that exists in the function?</P></BODY></HTML> Fri, 25 Aug 2017 23:35:51 GMT JustinAdamson 2017-08-25T23:35:51Z Is there an output file name or path limit length in CopyRows_management? https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286116#M22123 <HTML><HEAD></HEAD><BODY><P>I'm processing a large amount of data, and in the process I use the copyrows function to create a new table. I do validate the table name before doing so.</P><P></P><P>Nevertheless, it comes up with the "could not output" error every once in awhile. I've modified my program to just keep going and keep a list of the ones that failed.</P><P></P><P>The only thing I can see in common is that all the tables it failed to create have names and paths on the longer side. Is this a limitation that exists in the function?</P></BODY></HTML> Fri, 25 Aug 2017 23:35:51 GMT https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286116#M22123 JustinAdamson 2017-08-25T23:35:51Z Re: Is there an output file name or path limit length in CopyRows_management? https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286117#M22124 <HTML><HEAD></HEAD><BODY><P>One thing that could be happening here is that the ValidateTableName is creating duplicate table names. It doesn't check that its output is unique.</P><P>What's the output workstation type?&nbsp;Can you provide a list of table names that failed?</P></BODY></HTML> Fri, 25 Aug 2017 23:40:37 GMT https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286117#M22124 curtvprice 2017-08-25T23:40:37Z Re: Is there an output file name or path limit length in CopyRows_management? https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286118#M22125 <HTML><HEAD></HEAD><BODY><P>Hope is coming in <STRONG><A href="https://docs.python.org/3/whatsnew/3.6.html">python 3.6</A></STRONG> for paths that exceed 260 characters</P><P>Under 'windows improvements'....</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><CODE><SPAN>python.exe</SPAN></CODE> and <CODE><SPAN>pythonw.exe</SPAN></CODE> have been marked as long-path aware, which means that the 260 character path limit may no longer apply. See <A href="https://docs.python.org/3/using/windows.html#max-path"><SPAN>removing the MAX_PATH limitation</SPAN></A> for details.</P></BLOCKQUOTE><P></P><P>But for security purposes, you will be required to provide the first 130 characters and the last 9 <IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Sat, 26 Aug 2017 00:30:26 GMT https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286118#M22125 DanPatterson_Retired 2017-08-26T00:30:26Z Re: Is there an output file name or path limit length in CopyRows_management? https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286119#M22126 <HTML><HEAD></HEAD><BODY><P>I had some time to do some additional testing this morning. The table names are definitely all unique so that was not the problem.</P><P></P><P>i took all the failed table names and deleted characters off the end until they were 32 characters in length, and now it works. It's strange to me that this is the case, as none of the other table-creating functions seem to be limited in this way. I'm on 10.2.2 by the way.</P></BODY></HTML> Mon, 28 Aug 2017 18:03:54 GMT https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286119#M22126 JustinAdamson 2017-08-28T18:03:54Z Re: Is there an output file name or path limit length in CopyRows_management? https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286120#M22127 <HTML><HEAD></HEAD><BODY><P>You are using <SPAN style="font-family: courier new,courier,monospace;">ValidateTableName(</SPAN>), which is a good practice, but is there the chance there are duplicate table names invovled?</P><P></P><P>From <A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/analyze/python/working-with-geodatabases.htm" title="http://desktop.arcgis.com/en/arcmap/latest/analyze/python/working-with-geodatabases.htm">Validating table and field names in Python—Help | ArcGIS Desktop</A> :</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>The <SPAN class="">ValidateTableName</SPAN> function does not determine that the specified name is unique to the specified workspace. The <SPAN class="">Exists</SPAN> function can check to see whether the table name is unique for a given workspace.</P></BLOCKQUOTE></BODY></HTML> Mon, 28 Aug 2017 19:27:47 GMT https://community.esri.com/t5/python-questions/is-there-an-output-file-name-or-path-limit-length/m-p/286120#M22127 JoshuaBixby 2017-08-28T19:27:47Z