Skip to main content
Question

Intermittent issues connecting to SQL server database

  • September 13, 2023
  • 2 replies
  • 94 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
    Influencer
    Forum|alt.badge.img+53
    • j.botterillInfluencer
    • Influencer
    • 386 replies
    • September 13, 2023

    Hi naveen, do any of the points in this article help? The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {FDO error: -2147216072} (safe.com)

    j.botterill
    Influencer
    Forum|alt.badge.img+53
    • j.botterillInfluencer
    • Influencer
    • 386 replies
    • September 13, 2023

    Question Detail (safe.com)

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

    Solution: Delete the faulted objects with ArcCatalog


    Community Stats

    32,070
    Posts
    121,772
    Replies
    39,698
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.