While executing AP Rapid Martz Accounts_Payable_Load_DIMS_10 - Error 70401

[Former Member]

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

[Former Member]

Hi Rahul,

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

Thank u

R.Arun

[Former Member]

Our Developer fixed this issue and successfully run data loads...there is some tweaking required.

During my next IST business hours i will check with him and try to post solution...

Meanwhile can you please update BODS and BOBI release and patch level...also provide more brief on your issue step to step...

thanks,

rahul

[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.