2473110 - Error: A job writing to Redshift Target Bulk Load option fails in SAP Data Services

• 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
                                                            <50406>.

• The same job not using the Bulk Load option fails

as follows:

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
                                                           conversion error.>.

• 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 , Job Execution , Problem