Question

ArcSDE locks in FME workflow

  • 11 October 2021
  • 2 replies
  • 7 views

Badge

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

Userlevel 2
Badge +19

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

Badge

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