Skip to Content
0
Former Member
Apr 02, 2013 at 11:44 AM

While executing AP Rapid Martz Accounts_Payable_Load_DIMS_10 - Error 70401

32 Views

Hi Guya,

We have setup BODS Rapid solution for AP with reference to the video link provided taking Data source as ERP 6.0 IDES system..

Rapid mart installation videos link:

http://scn.sap.com/community/data-services/blog/2012/07/09/getting-started-with-sap-rapid-marts

We could manage to successfully finish all the steps as per video , except last step.

As a last step step when we are executing job Accounts_payable_load_sap as mentioned below , following is the error occurred...


1780 12680 DBS-070401 02-04-2013 16:45:40 |Data flow DF_Language_SAP|Loader FirstorDelta_FirstLoad_LANGUAGE

1780 12680 DBS-070401 02-04-2013 16:45:40 ODBC data source <VS03BOD> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL

1780 12680 DBS-070401 02-04-2013 16:45:40 Server]Violation of PRIMARY KEY constraint 'PK__LANGUAGE__C96329A617E4190E'. Cannot insert duplicate key in object

1780 12680 DBS-070401 02-04-2013 16:45:40 'dbo.LANGUAGE'. The duplicate key value is (0040, a, 1).>.

1780 12680 RUN-051005 02-04-2013 16:45:40 |Data flow DF_Language_SAP|Loader FirstorDelta_FirstLoad_LANGUAGE

1780 12680 RUN-051005 02-04-2013 16:45:40 Execution of <Regular Load Operations> for target <LANGUAGE> failed. Possible causes: (1) Error in the SQL syntax; (2) Database

1780 12680 RUN-051005 02-04-2013 16:45:40 connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore

1780 12680 RUN-051005 02-04-2013 16:45:40 has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load

1780 12680 RUN-051005 02-04-2013 16:45:40 operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.

4048 10916 DBS-070401 02-04-2013 16:46:00 |Data flow DF_Language_SAP|Loader FirstorDelta_FirstLoad_LANGUAGE

4048 10916 DBS-070401 02-04-2013 16:46:00 ODBC data source <VS03BOD> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL

4048 10916 DBS-070401 02-04-2013 16:46:00 Server]Violation of PRIMARY KEY constraint 'PK__LANGUAGE__C96329A617E4190E'. Cannot insert duplicate key in object

4048 10916 DBS-070401 02-04-2013 16:46:00 'dbo.LANGUAGE'. The duplicate key value is (0040, a, 1).>.|<Regular Load Operations>|<LANGUAGE>

Can some one please advice how do i fix it and I have attached steps document for reference.

Thanks & Regards,

Rahul

Attachments

3.jpg (66.0 kB)
2.jpg (41.3 kB)
1.jpg (94.8 kB)