Syntax error or access violation; 257 sql syntax error.

[Former Member]

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

[former_member315492]

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