Skip to Content
author's profile photo Former Member
Former Member

While executing AP Rapid Martz Accounts_Payable_Load_DIMS_10 - Error 70401

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

3.jpg (66.0 kB)
2.jpg (41.3 kB)
1.jpg (94.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2013 at 09:39 AM

    Hi Rahul,

    Could you please share that is there any solution, to fix this issue ??

    Thank u

    R.Arun

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Go to the workflow where the error was triggered.

      As their is a violation of primary key for the language values.

      To fix the issue, we need to add the required language value (for e.g. EN) in the where clause of the query. Save all it to reflect the changes.

      Delete the log and re-run it.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.