1768118 - Error while launching an open hub job from Sap BW, Data Services 12.2.3.0

Error while:

Log: error_08_17_2012_06_41_57_1304__XXXXXXXXXX.txt Job Server: XXXXXXXX:3500 

Job name: XXXXXXXX_

(12.2) 08-17-12 09:52:21 (E) (4692:6112) DBS-070401: |Data flow XXXXXXX_Load|Loader QRY_NMCFQMC02_RECEP
                                                     ODBC data source <XXXXXX error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL
                                                     Server]Violation of PRIMARY KEY constraint XXXXXXX. Cannot insert duplicate key in object
                                                     'dbo.NMCFQMC02_RECEP'. The duplicate key value is (143444, 1, 250).>.
(12.2) 08-17-12 09:52:21 (E) (4692:6112) RUN-051005: |Data flow XXXXXXX_Load|Loader QRY_NMCFQMC02_RECEP
                                                     Execution of <Regular Load Operations> for target <XXXXXXX> 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.
(12.2) 08-17-12 09:52:31 (E) (0628:4740) RUN-050316: |Session XXXXXXXXXX|Work flow WF_MODCF_Job_Completion
                                                     The job encountered a critical error. Terminating job
(12.2) 08-17-12 09:52:31 (E) (0628:4740) RUN-050304: |Session XXXXXXXXXX|Work flow WF_MODCF_Job_Completion
                                                     Function call <raise_exception_ext ( The job encountered a critical error. Terminating job, 1 ) > failed, due to error <50316>:
                                                     <The job encountered a critical error. Terminating job>.
(12.2) 08-17-12 09:52:31 (E) (0628:4740) RUN-053008: |Session XXXXXXXXXX|Work flow WF_MODCF_Job_Completion
                                                     INFO: The above error occurs in the context <|Session XXXXXXXXX|Work flow WF_MODCF_Job_Completion|3 Else Step
                                                     Body|raise_exception_ext(...) Function Body|>.
(12.2) 08-17-12 09:52:32 (E) (0628:4740) BAP-220301: BAPI returned message <ERSM799 Error Message: Error: There is an extraction error. Please see the error  log at source system
                                                     for detail.> from method <bapi_isource_td_t_send>.
(12.2) 08-17-12 09:52:32 (E) (0628:4740) RUN-050316: |Session JOB_MODCF_QM_VOL_BW_JDE|Work flow WF_MODCF_Job_Completion
                                                     The job encountered a critical error. Terminating job
 

• Data Services 12.2.3.0
• SAP NW BW

KBA , EIM-DS-SAP , SAP Interfaces , How To