Skip to main content
Question

Intermittent issues connecting to SQL server database

  • Sep 13, 2023 2:40 AM UTC
  • 2 replies
  • 202 views

naveen
Contributor
Forum|alt.badge.img+7

We are seeing an intermittent issues with connecting to database from FME workbenches ( That runs on FME server ) though the database is healthy

 

FME Server 2021.2.6

Build 21821 - win64

 

The error message is "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[HY109:[Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor position No extended error.]}"

 

Any ideas on how to investigate this further ?? Thanks

2 replies

j.botterill
Evangelist
Forum|alt.badge.img+69
  • Evangelist
  • Sep 13, 2023 8:46 AM UTC

j.botterill
Evangelist
Forum|alt.badge.img+69
  • Evangelist
  • Sep 13, 2023 8:48 AM UTC

Question Detail (safe.com)

Problem: Corruption in the SDE Registry. Article Detail (safe.com)

Solution: Delete the faulted objects with ArcCatalog