Skip to main content
  • EN

I'm loading data (450k polygons) from FGDB into SDE. Versioning is enabled.The Transaction Type is a Versioned Edit Session and my Writer Mode is Insert. I have Drop Table as No and Truncate Table as Yes. The writing is very slow and after running for 3 hrs and 43 min the transaction failed with the following error:

An error occurred while attempting to start an edit operation. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server [08S01:[Microsoft][SQL Server Native Client 11.0]TCP Provider: The specified network name is no longer available.
] [sde.DEFAULT]}

Here is the log file:

Any idea why it is throwing that error?

Thanks.

Googling the ArcObjects error number doesn't seem to yield any useful results but the SQL Server one does come up with something useful. It all seems to indicate the network connection has been lost for whatever reason.

Edit sessions are notoriously slow. What happens if you manually truncate the feature class using e.g. ArcMap before running your workspace?

See also https://knowledge.safe.com/questions/35018/table-truncating-takes-ages.html

Thanks for your ideas guys but the loading is now completed successfully!

What did I do to make it work? Not much. I had multiple SDE writers in the workspace so I removed all except the one that writes the 450k polygons. I have also added the ArcSDEGrid Snapper transformer to simulates the ArcSDE conversion on each feature by performing ArcSDE translation, scaling, and coordinate snapping. It took 4 hrs and 14 mins!

I have created a ticket to find out why it took that long and how we can improve the speed. Will update when I hear back from Safe.

Thanks.

Edit sessions are notoriously slow. What happens if you manually truncate the feature class using e.g. ArcMap before running your workspace?

See also https://knowledge.safe.com/questions/35018/table-truncating-takes-ages.html

We trying not to do any manual work as we have a lot of datasets to be loaded to the SDE.

 

 

Googling the ArcObjects error number doesn't seem to yield any useful results but the SQL Server one does come up with something useful. It all seems to indicate the network connection has been lost for whatever reason.

That's interesting because other writers on the same workspace loaded a relatively smaller number of records successfuly to the same SDE.

Here is an article recommend by Safe support for the possible reasons of the slowness of the workspace and its workaround:

https://knowledge.safe.com/articles/51216/editing-versioned-geodatabases-using-sql.html

 

Just want to share with the community and see what you think about it.

 

 

Thanks.

Here is an article recommend by Safe support for the possible reasons of the slowness of the workspace and its workaround:

https://knowledge.safe.com/articles/51216/editing-versioned-geodatabases-using-sql.html

 

Just want to share with the community and see what you think about it.

 

 

Thanks.

Thanks @yonasfme

 

In particular the issue is related to the truncate.

 

"The reason we cannot do an explicit truncate is that the versioned table we are interacting with is, in fact, a view. Views are unable to be truncated. As such, we have to use a different command to perform the truncate."

 

Thanks @yonasfme

 

In particular the issue is related to the truncate.

 

"The reason we cannot do an explicit truncate is that the versioned table we are interacting with is, in fact, a view. Views are unable to be truncated. As such, we have to use a different command to perform the truncate."

 

Thanks @MattAtSafe

 

Reply


Community Stats

30,108
Posts
114,290
Replies
37,743
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.