Skip to main content
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


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.

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+53
  • Celebrity
  • April 4, 2022

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


Forum|alt.badge.img+1
  • May 4, 2023

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings