Question

SDE feature class doesn't exist? Very visible though.

  • 6 April 2022
  • 1 reply
  • 18 views
lorinda
Rank
Badge +5

Hi, Running a script to truncate an existing feature class in a sde that has attribute rules attached thru ArcPro. The warnings state the below items - table must exist - it is there, can see it via Catalog and SSMS. User has DBO. Running 2021.x FME, 2.9.2 ArcPro. Any ideas as to what I may be missing? Did set the compatibility to ArcPro, used sde connection created by ArcPro.

Thanks,

Lorinda

2022-04-06 12:41:23|  1.2| 0.0|INFORM|Transactions are being used by the Esri Geodatabase Writer

2022-04-06 12:41:25|  2.9| 1.7|ERROR |Esri Geodatabase Writer: Feature Class or Table 'IDF_Stormwater' must exist when Table Handling is set to 'Truncate Existing'

2022-04-06 12:41:25|  2.9| 0.0|ERROR |GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details

2022-04-06 12:41:25|  2.9| 0.0|STATS |GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): Finished sorting a total of 0 features.

2022-04-06 12:41:25|  2.9| 0.0|INFORM|Transaction #1 rolled back. Rerun translation specifying transaction #0 for the keyword 'TRANSACTION'

2022-04-06 12:41:25|  2.9| 0.0|INFORM|Closing the Esri Geodatabase writer

1 reply

lorinda
Rank
Badge +5

Hmm.... I upgraded the EGDB to 10.9.1 ArcGIS, then the new warning that I got was to change the transaction type to Versioned. After doing that it worked for me. Now to set up on an automation schedule for an emergency backup of the data.

Reply


Community Stats

28,710
Posts
109,487
Replies
36,559
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.