Hi All,
we are converting SDO geometry to SDE geometry using FME workbench, it working as expected, but sometimes we are facing this issue.
"An error occurred while attempting to open the table, feature class or relationship class 'SDE.SP_ALL'. The error number from ArcObjects is: '-2147216011'. The error message from ArcObjects is: {The SQL statement was not a select statement} "
If anyone come across the issue, please let me know why and when this will occurs and how to fix.
Thank you.
Are you trying to use a where clause on the writer by any chance?
No, i am not using any clause
Hello @r8
Are you able to share the workspace(without the data) and/or the log file from the failing translation? If so, this would go a long way in helping pinpoint the nature of this issue. It would also be helpful if you could include the successful log file from the Desktop run, please.
If you do not wish to share the workspace on a public forum, you can submit a support ticket here https://www.safe.com/support/report-a-problem/ and an expert can follow up with you.