Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • 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

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.

Are you logging your SQL statement? that should help debug what the issue is

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


Community Stats

30,162
Posts
114,484
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.