Multiple attempts required to open feature layers through ArcSDE connections

[jngtz]

Describe the bug
Opening a feature though an ArcSDE connection file (.sde) always fails on the first attempt, but works on the following attempt. This problem occurs in both R-Studio and R IDE. Whenever this occurs the working directory is automatically changed to C:/Program Files/ArcGIS/Pro/

arcgisbinding info (please complete the following information):

arc.check_portal output:
product: ArcGIS Pro (13.0.2.36056)
license: Advanced
version: 1.0.1.300

R: R version 4.2.1 - arcgisbinding version 1.0.1.300

OS: Windows 10 Enterprise

[jngtz]

I've made the following function as a workaround. It tries multiple attempts to open the SDE path, and maintains the original working directory - where x is a string containing the file path (e.g. "C:/PATH_TO/SDE_CONNECTION_FILE.sde/A_FEATURE_LAYER")

arc.openSDE <- function(x, max_attempts = 5) {
  
  wd <- getwd()
  attempt <- 1
  
  while (attempt <= max_attempts) {
    openSDE <- tryCatch(arc.open(x), error = function(err) err)
    
    if (inherits(openSDE, "error")) {
      cat("Attempt", attempt, "failed. Retrying...\n")
      attempt <- attempt + 1
      next
    }
    
    on.exit(setwd(wd))
    return(openSDE)
    
  }
  
  stop("Max attempts exceeded")
}