Skip to main content
Question

ArcSDE locks in FME workflow

V
Forum|alt.badge.img

Hi team,

 

While transforming the tables from Reader ArcSDE to Writer ArcSDE . At the Writer end, didnt write any features and getting following error.

"3.1| 0.0|ERROR |Could not unregister GlobalID column 'GlobalID' in table 'DBO.Publish_Test_Cables_2'. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [TCS_TEST_PUBLISH_SYNC.DBO.Publish_Test_Cables_2]}"

 

At Writer end, follownig parameters are used.

1.Preserving the Global IDs parameter with Unversioned ArcSDE table 2.Trasaction type is "Non-versioned edit session"

 

Highly appreciate for the solution!!

 

Regards

VIPLAW

2 replies

oscard
Influencer
Forum|alt.badge.img+21
  • oscardInfluencer
  • Influencer
  • October 11, 2021

Are you reading and writing the same table?

 

Maybe you have the same issue as this user: https://community.safe.com/s/question/0D54Q000080hM0N/arcsde-geodatabase-locks

V
Forum|alt.badge.img
  • viplove555
  • Author
  • October 11, 2021
oscard wrote:

Are you reading and writing the same table?

 

Maybe you have the same issue as this user: https://community.safe.com/s/question/0D54Q000080hM0N/arcsde-geodatabase-locks

Hi,

Thanks for the reply,

 

I am consuming 2 input ArcSDE Tables & comparing with Transformer "ChnageDetection" . This output writing to Target ArcSDE GDB Table (which is Unversioned for preserving the GLobal IDs).

 

But final table is not writing due to "Target table is already locked"!!

 

Regards

VIPLAW

 

Reply


Helpful Members This Week

Community Stats

31,549
Posts
119,591
Replies
39,186
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.