Syntax error or access violation; 257 sql syntax error.

Former Member — Mon, 19 Aug 2013 03:05:20 GMT

Hi all,

I have successfully loaded the data from source (HANA) into target table (HANA).

But I am still encounting the following error in my job. Please advise!

Designer version : 14.0.3

HANA Studio version : 1.0.58

(14.0) 08-16-13 15:13:30 (E) (4244:5048) DBS-070404: |Data flow
DF_HANA_TEST1|Loader Query_SHOP_FACTS3
SQL submitted to ODBC data source <DS_HANA> resulted in error <[SAP
AG][LIBODBCHDB DLL][HDB] Syntax error or access violation;257 sql syntax error:
line 1 col 14 (at pos 14)>. The SQL submitted is <ALTER SYSTEM
CHECKPOINT>.

(14.0) 08-16-13 15:13:30 (E) (4244:5048) RUN-051005: |Data flow
DF_HANA_TEST1|Loader Query_SHOP_FACTS3 Execution
of <ALTER SYSTEM CHECKPOINT> for target <SHOP_FACTS3> failed.
Possible causes: (1) Error in the SQL syntax; (2) Database connection is
broken; (3) Database related errors such as transaction log is full, etc.; (4) The user
defined in the datastore has insufficient privileges to execute the SQL. If the
error is for preload or postload operation, or if it is for regular load
operation and load triggers are defined, check the SQL. Otherwise, for (3) and
(4), contact your local DBA.

Regards,

SengLeng

Re: Syntax error or access violation; 257 sql syntax error.

Former Member — Mon, 19 Aug 2013 07:41:19 GMT

Hi,

I think you don't have full access to run the job using specific datastore.

In HANA, please check you have all access(Read/write/modify).

Regards,

Narasimha

Question Re: Syntax error or access violation; 257 sql syntax error. in Technology Q&A

Syntax error or access violation; 257 sql syntax error.

Re: Syntax error or access violation; 257 sql syntax error.