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
+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.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.