I get this error periodically when running a workbench copying from Oracle to SAP HANA. Only a handful of tables here and there, I've yet to establish a pattern. There are no issues with the permissions, and no queries left in the tables on the Oracle side, as far as I know.
Question
What is this error: '-2147216081'. The error message from ArcObjects is: {Invalid SQL syntax [[SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "CONDITION": line 1 col 300 (at pos 300)::420
+63- Celebrity
- 1625 replies
Are you logging your SQL statement? that should help debug what the issue is
+1I had a similar error message recently. It refers to a field name in your schema that most likely has a name that is a reserved word in the target DB. Searching for it it seems that 'Condition' is a reserved word in SAP HANA. (Mine was 'Merge' that is reserved in MS SQL...)
Hope this helps.