Data Services - Error on SQL Transact

[mtayibi]

Hello,

I am getting an error while scheduled job has failled with " SQL submitted to database <datastore> resulted in error <>. The SQL submitted is <SQLTransact> "

And the same job has successfully ran after manually triggered. I also run it successfully after sheduled it.

Data Service Version 14.2.11.2187

Database connection via ODBC S4HANA

Error

Log File: error_03_13_2025_01_05_03_149__4ed10ab8_c515_45f6_b874_74f912834377.txt

(14.2) 03-13-25 01:07:04 (E) (17364:18112) DBS-070404: |Data flow DF_EXT_S4_SALES_VBAK_VBAP | Loader Query_EXT_S4_SALES_VBAK_VBAP

SQL submitted to the ODBC data source S4HANA_PROD resulted in error <>. The SQL submitted is SQLTransact.

(14.2) 03-13-25 01:08:06 (E) (12872:9500) DBS-070404: |Data flow DF_EXT_S4_SALES_VBAK_VBAP | Loader Query_EXT_S4_SALES_VBAK_VBAP

SQL submitted to the ODBC data source S4HANA_PROD resulted in error <>. The SQL submitted is SQLTransact.

kr

[jmuiruri]

Hi @mtayibi,

The issue appears to be happening on the database side, The SQLTransact shown here indicates that it is requesting a commit or rollback operation for all active operations on all statements associated with that particular connection. 

Since you are using ODBC, i wonder if enabling ODBC tracing will provide us with insights into what's happening. I don't know what's your target DB, but i assume it's HANA, in which case you could try enabling ODBC tracing as per the guide below

• ODBC Tracing and Trace Options

Then reproduce the issue and check the generated logs. Before attaching the odbc logs here, please make sure that you have redacted all the PII.

Regards,

Joe

[jmuiruri]

@mtayibi It appears you redacted the actual error message returned by the database and the SQL query that was being executed.

Redact the PII and provide the resulting error message.

Regards,

Joe

[mtayibi]

@jmuiruri i attached the original error message. but its in german language.