After contacting ESRI, we were told to completely uninstall ArcGIS 10.1 from my PC and any associated elements. Then we were told to remove any residual registry hives left over and to delete any residual folders in C:/Program Files ... After doing all that, I reinstalled my ArcGIS components but still got the same error.
Whilst the above suggestion didn't work for me, it may be useful to some of you. This bug is very strange to me as I can successfully publish the same mxd on my colleagues PC who has the same components, operating system and service pack.
Wow that's a lot do to. Funny the definition query works with no issues in ArcMap. It only shows itself when the map is being published as a web service. Our GIS Systems Administrator believes it has to do with SQL Server and how it names things.
Husen Kang wrote:
It works for me if I publish it this way. In the Share as Service windows selects option 'Save a service definition file'.
Then, selecting the option 'No available connection'. Then choose the location where you want to save the definition file.
Use ArcCatalog to browse to the just created definition file and right click and select 'Publish as a Service'.
Hope this workaround also works for you guys.
We were receiving the same error message (except ours said "codes = 3") when attempting to publish a service pulling data from a registered Data Store (we are at Server 10.2.2). Even though the ArcGIS Server account had full share/NTFS permissions on the data store directory, we could not publish from Desktop.
After we spent a good 3 hours with tech support (his only suggestion was allowing data to be copied to the server - thanks, but no thanks), this was the only feasible workaround we could find. Thank you for the suggestion and here's hoping that ESRI will do something to address the fact that Data Stores in Server 10.2 simply do not function like they should.
Glad I can help. I am still using 10.1 here. I was hoping the problem would have been fixed at 10.2.
I also find publishing directly to ArcGIS Server takes longer than publishing via SD file.
Not sure if others experience the same.
It works for me if I publish it this way. In the Share as Service windows selects option 'Save a service definition file'.
Then, selecting the option 'No available connection'. Then choose the location where you want to save the definition file.
Use ArcCatalog to browse to the just created definition file and right click and select 'Publish as a Service'.
Hope this workaround also works for you guys.
It works for me if I publish it this way. In the Share as Service windows selects option 'Save a service definition file'.
Then, selecting the option 'No available connection'. Then choose the location where you want to save the definition file.
Use ArcCatalog to browse to the just created definition file and right click and select 'Publish as a Service'.
Hope this workaround also works for you guys.
.... I am going to try on one of the provided base maps next. Thanks for sharing.
DT