<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic ArcGIS10 - &amp;quot;Ghost&amp;quot; Attachment table leading in mapservice launch issue in Data Management Questions</title>
    <link>https://community.esri.com/t5/data-management-questions/arcgis10-quot-ghost-quot-attachment-table-leading/m-p/49830#M2795</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;[Newbie inside]&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Hi all,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I added several feature datasets including respectively several polygon feature classes to a map. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;In order to improve the information delivered, one asks me to create an attachment to one of the feature class for testing attachments capabilities.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The map was published trough a webservice (map + feature enabled) without any issue. After testing, one asked me to delete the attachement which were not sufficiently relevant.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I delete the attachment + relation in ArcEditor still without issue. I verified in the Postgres database (driven by ArcSDE) if everything was dropped and all about it was clear.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I started to re-publish the service and then get an error message (see attached Errorpublication.jpg) telling that the service can't be published due to a table not found. The table name was the one I just deleted.&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;When I take a look into the Set Data Sources panel it seems that my table or at least its relationship is still present somewhere (see attached Listetables.jpg). Maybe in the SDE Table registry ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Question is : Can you tell me what to do to break gently this sort of "ghost" relation and also pointing what I'm maybe doing wrong ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm in a hurry cause the big boys are, as usual, running around me to get their toys back ... &lt;span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:"&gt;😄&lt;/span&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Config : ArcEditor &amp;gt; ArcSDE/PostgreSQL 8.3 &amp;gt; ArcGIS Server Entreprise, version 10sp2&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks a lot for any help !&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Have a nice day all,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Pierre.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;[/Newbie inside]&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 17 Aug 2011 17:01:42 GMT</pubDate>
    <dc:creator>PierreLarondelle</dc:creator>
    <dc:date>2011-08-17T17:01:42Z</dc:date>
    <item>
      <title>ArcGIS10 - "Ghost" Attachment table leading in mapservice launch issue</title>
      <link>https://community.esri.com/t5/data-management-questions/arcgis10-quot-ghost-quot-attachment-table-leading/m-p/49830#M2795</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;[Newbie inside]&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Hi all,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I added several feature datasets including respectively several polygon feature classes to a map. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;In order to improve the information delivered, one asks me to create an attachment to one of the feature class for testing attachments capabilities.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The map was published trough a webservice (map + feature enabled) without any issue. After testing, one asked me to delete the attachement which were not sufficiently relevant.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I delete the attachment + relation in ArcEditor still without issue. I verified in the Postgres database (driven by ArcSDE) if everything was dropped and all about it was clear.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I started to re-publish the service and then get an error message (see attached Errorpublication.jpg) telling that the service can't be published due to a table not found. The table name was the one I just deleted.&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;When I take a look into the Set Data Sources panel it seems that my table or at least its relationship is still present somewhere (see attached Listetables.jpg). Maybe in the SDE Table registry ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Question is : Can you tell me what to do to break gently this sort of "ghost" relation and also pointing what I'm maybe doing wrong ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm in a hurry cause the big boys are, as usual, running around me to get their toys back ... &lt;span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:"&gt;😄&lt;/span&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Config : ArcEditor &amp;gt; ArcSDE/PostgreSQL 8.3 &amp;gt; ArcGIS Server Entreprise, version 10sp2&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks a lot for any help !&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Have a nice day all,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Pierre.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;[/Newbie inside]&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 17 Aug 2011 17:01:42 GMT</pubDate>
      <guid>https://community.esri.com/t5/data-management-questions/arcgis10-quot-ghost-quot-attachment-table-leading/m-p/49830#M2795</guid>
      <dc:creator>PierreLarondelle</dc:creator>
      <dc:date>2011-08-17T17:01:42Z</dc:date>
    </item>
  </channel>
</rss>

