- A job Bulk Loads to Amazon S3 fails with the following in SAP Data Services:
(14.2) 05-10-17 14:08:44 (R) (17072:3253970688) DBS-070404: |Data flow ExactTarget|Loader Query_f_exctgt_sent_emails
SQL submitted to ODBC data source <redshift-msgbiadb> resulted in error <[>. The SQL submitted is <copy
adsuser.Source from 's3://msg-dashboard-data/redshift/exact-target/Target' credentials
<aws-auth-args> delimiter '~' region 'us-east-1'; >.
(14.2) 05-10-17 14:08:44 (E) (17072:3253970688) DBS-070404: |Data flow ExactTarget|Loader Query_f_exctgt_sent_emails
SQL submitted to ODBC data source <redshift-msgbiadb> resulted in error <*****>. The SQL submitted is <*****>. This message
contains some internal system details which have been hidden for security. If you need to see the full contents of the original
message, ask your administrator to assign additional privileges to your account.
(14.2) 05-10-17 14:08:44 (E) (17055:2351142720) RUN-050406: |Session Redshift|Data flow ExactTarget
Data flow <ExactTarget> received a bad system message. Message text from the child process is
Collect the following and send to Customer Support:
1. Log files(error_*, monitor_*, trace_*) associated with this failed job.
2. Exported ATL file of this failed job.
3. DDL statements of tables referenced in this failed job.
4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
the job failed.
5. Core dump, if any, generated from this failed job.
==========================================================>. The process executing data flow <ExactTarget> has died abnormally.
For NT, check errorlog.txt. For HPUX, check stack_trace.txt. Also, notify Technical Support.
(14.2) 05-10-17 14:08:44 (E) (17055:2351142720) RUN-050409: |Session Redshift
The job process could not communicate with the data flow <ExactTarget> process. For details, see previously logged error
- The same job not using the Bulk Load option fails
DBS-070401: |Data flow ExactTarget|Loader Query_f_exctgt_sent_emails
ODBC data source <redshift-msgbiadb> error message for operation <SQLExecute>: <[Amazon][Support] (50310) Unrecognized ICU
- SAP Data Services 14.2 SP8 PL2
- Linux 7.3
- Target: Amazon S3
- S3 Redshift ODBC driver
BODS, DS, Redshift Bulk Load option, S3 bulk load, Redshift ODBC driver , KBA , EIM-DS-EXE , Data Services Job Execution , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.