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.
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
Userlevel 5
+29
- Celebrity
- 1109 replies
-
4 April 2022
Are you logging your SQL statement? that should help debug what the issue is
+1
I 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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.