Skip to main content
  • EN

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

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

30,171
Posts
114,533
Replies
37,830
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.