topic Append Annotation Feature Classes into existing ArcSDE FC - error ORA-00942 in Data Management Questions https://community.esri.com/t5/data-management-questions/append-annotation-feature-classes-into-existing/m-p/200754#M11533 <HTML><HEAD></HEAD><BODY><SPAN>ArcGIS 9.2/ArcSDE 9.2/Oracle 10g</SPAN><BR /><BR /><SPAN>I am trying to append an anno fc from a pgdb to an existing, versionned ArcSDE anno fc and I keep getting the following error :</SPAN><BR /><BR /><SPAN>DBMS table not found[DBMS table not found[ORA-00942: table or view does not exist</SPAN><BR /><SPAN>][GEO.urb_cadproj_an.DOSSIER_MRN_1]]</SPAN><BR /><BR /><SPAN>The pgdb and ArcSDE anno fc's have the exact same schema and neither of them are feature-linked.</SPAN><BR /><BR /><SPAN>I am able to successfully execute the operation with the exact same data writing to a pgdb and fgdb but not ArcSDE.</SPAN><BR /><BR /><SPAN>The only thing special about my anno fc is the fact that it has an extra field "DOSSIER_MRN" in addition to the default system annoation fields. If I copy paste the ArcSDE anno fc and remove the "DOSSIER_MRN" field, the command executes successfully. It seems as though the append operation hangs if there are extra, user defined fields when appending to an ArcSDE anno fc?</SPAN><BR /><BR /><SPAN>Has anyone had success appending into an ArcSDE anno fc with user defined fields via the Append Annotation Feature Classes Tool?</SPAN><BR /><BR /><SPAN>Any ideas?</SPAN></BODY></HTML> Mon, 10 Dec 2012 15:30:48 GMT BrentEdwards 2012-12-10T15:30:48Z Append Annotation Feature Classes into existing ArcSDE FC - error ORA-00942 https://community.esri.com/t5/data-management-questions/append-annotation-feature-classes-into-existing/m-p/200754#M11533 <HTML><HEAD></HEAD><BODY><SPAN>ArcGIS 9.2/ArcSDE 9.2/Oracle 10g</SPAN><BR /><BR /><SPAN>I am trying to append an anno fc from a pgdb to an existing, versionned ArcSDE anno fc and I keep getting the following error :</SPAN><BR /><BR /><SPAN>DBMS table not found[DBMS table not found[ORA-00942: table or view does not exist</SPAN><BR /><SPAN>][GEO.urb_cadproj_an.DOSSIER_MRN_1]]</SPAN><BR /><BR /><SPAN>The pgdb and ArcSDE anno fc's have the exact same schema and neither of them are feature-linked.</SPAN><BR /><BR /><SPAN>I am able to successfully execute the operation with the exact same data writing to a pgdb and fgdb but not ArcSDE.</SPAN><BR /><BR /><SPAN>The only thing special about my anno fc is the fact that it has an extra field "DOSSIER_MRN" in addition to the default system annoation fields. If I copy paste the ArcSDE anno fc and remove the "DOSSIER_MRN" field, the command executes successfully. It seems as though the append operation hangs if there are extra, user defined fields when appending to an ArcSDE anno fc?</SPAN><BR /><BR /><SPAN>Has anyone had success appending into an ArcSDE anno fc with user defined fields via the Append Annotation Feature Classes Tool?</SPAN><BR /><BR /><SPAN>Any ideas?</SPAN></BODY></HTML> Mon, 10 Dec 2012 15:30:48 GMT https://community.esri.com/t5/data-management-questions/append-annotation-feature-classes-into-existing/m-p/200754#M11533 BrentEdwards 2012-12-10T15:30:48Z Re: Append Annotation Feature Classes into existing ArcSDE FC - error ORA-00942 https://community.esri.com/t5/data-management-questions/append-annotation-feature-classes-into-existing/m-p/200755#M11534 <HTML><HEAD></HEAD><BODY><SPAN>The problem stems from a bug in the Append Annotation Tool. The error occurs when appending to ArcSDE annotation FCs with user defined&nbsp; numeric (ex. Short Integer, Long Integer, Double) fields. The error seems to be resolved in ArcGIS 10 as I am able to execute the tool without issues given the exact same data. As a work around with ArcGIS 9.2, I am forced to define my field as a text field and deal with the conversion through code for my use case.</SPAN></BODY></HTML> Mon, 17 Dec 2012 13:00:57 GMT https://community.esri.com/t5/data-management-questions/append-annotation-feature-classes-into-existing/m-p/200755#M11534 BrentEdwards 2012-12-17T13:00:57Z