I am using a python script to populate a table with values I get from rasters files. I use arcpy.AddField_management to add a new column and arcpy.CalculateField_management to insert the values for the new column. The table has more than 450 columns and after executing arcpy.CalculateField_management I get the following error:
<SPAN class="typ" style="color: #2b91af;">ExecuteError</SPAN><SPAN class="pun" style="color: #145680;">:</SPAN><SPAN class="pln" style="color: #000000;"> ERROR </SPAN><SPAN class="lit" style="color: #953838;">999999</SPAN><SPAN class="pun" style="color: #145680;">:</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">Error</SPAN><SPAN class="pln" style="color: #000000;"> executing </SPAN><SPAN class="kwd" style="color: #8a4a0b;">function</SPAN><SPAN class="pun" style="color: #145680;">.</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">Underlying</SPAN><SPAN class="pln" style="color: #000000;"> DBMS error </SPAN><SPAN class="pun" style="color: #145680;">[[</SPAN><SPAN class="typ" style="color: #2b91af;">Microsoft</SPAN><SPAN class="pun" style="color: #145680;">][</SPAN><SPAN class="pln" style="color: #000000;">SQL </SPAN><SPAN class="typ" style="color: #2b91af;">Server</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">Native</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">Client</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="lit" style="color: #953838;">11.0</SPAN><SPAN class="pun" style="color: #145680;">][</SPAN><SPAN class="pln" style="color: #000000;">SQL </SPAN><SPAN class="typ" style="color: #2b91af;">Server</SPAN><SPAN class="pun" style="color: #145680;">]</SPAN><SPAN class="typ" style="color: #2b91af;">Cannot</SPAN><SPAN class="pln" style="color: #000000;"> create a row of size </SPAN><SPAN class="lit" style="color: #953838;">8074</SPAN><SPAN class="pln" style="color: #000000;"> which </SPAN><SPAN class="kwd" style="color: #8a4a0b;">is</SPAN><SPAN class="pln" style="color: #000000;"> greater than the allowable maximum row size of </SPAN><SPAN class="lit" style="color: #953838;">8060.</SPAN><SPAN class="pun" style="color: #145680;">]</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="typ" style="color: #2b91af;">Failed</SPAN><SPAN class="pln" style="color: #000000;"> to execute </SPAN><SPAN class="pun" style="color: #145680;">(</SPAN><SPAN class="typ" style="color: #2b91af;">CalculateField</SPAN><SPAN class="pun" style="color: #145680;">).</SPAN>
I can avoid this error executing in SQL Server:
<SPAN class="pln" style="color: #000000;">ALTER TABLE REBUILD</SPAN>
Is there anyway to execute this SQL server instruction from the script or another equivalent way to avoid the error?
