Hi we have FME Server 2021.3, ArcGIS Pro 2.9 installed [concurrent license - license manager on separate machine]
connecting to ArcGIS Enterprise Geodatabase 10.9.1
on Oracle database 21c
We have a few automations running at different schedules. We have seen intermittent issues while connecting to read/write to the geodatabase.
1) Error while retrieving an ArcObjects update cursor for the table/feature class 'xxx'. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server [ORA-03114: not connected to ORACLE] [xxx]}
2) Could not open the Enterprise Geodatabase because the local version of ArcGIS is not compatible with the server's SDE version.
The above 2 issues causes automation to fail
Also, the following error occurs consistently for each run, but the automation carries on successfully:
3) BADNEWS: Execution of statement `SELECT SDO_VERSION FROM DUAL' did not succeed; error was `ORA-00904: "SDO_VERSION": invalid identifier'. (serverType=`ORACLE8i', serverName=`xxx', userName=`xxx', password=`***', dbname=`')
Any ideas how we can prevent above errors. I have tried to add retry for 3 times after 1mins, but we still get the failures.
