broken project data source

BrandonFlessner

I'm trying to publish a GP service but I'm getting the error 00068 about a broken project data source. The thing is the script creates the project data source that Pro believes is missing. The script then does some stuff to populate the table using an insert cursor before copying the table to the location specified by the user:

<SPAN class="comment token">### ...</SPAN>
route <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
outTable <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CreateTable_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'in_memory'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'outTable'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">## do some stuff to populate the table</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>CopyRows_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'in_memory/outTable'</SPAN><SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Any ideas on how to get around this?

BrandonFlessner

I believe the issue was that I was trying to publish from the latest version of Pro to an earlier version of Enterprise. I would check to see that both Pro and Enterprise are the same vintage first. Hope that helps!