Rapid Mart (GL) Violation of PRIMARY KEY

dataservices rapidmarts
1

Hi,

I am having a problem with the Dataload within the Rapidmart GL. I am using the:

General_Ledger_New_Load_SAP
this job has no error while validating.

General_Ledger_Old_Load_SAP
this job has errors while validating (source table doesn’t exists)

starting the job an a few minutes later i am getting this error msg:


5264	6884	DBS-070401	18.01.2011 15:35:03	|Data flow DF_DocumentCategory_SAP|Loader TimeStampQuery_DOCUMENT_CATEGORY

5264	6884	DBS-070401	18.01.2011 15:35:03	ODBC data source <RAPIDMARTS> error message for operation <SQLExecute>: <[Microsoft][ODBC SQL Server Driver][SQL

5264	6884	DBS-070401	18.01.2011 15:35:03	Server]Violation of PRIMARY KEY constraint 'XPK_DOC_CATEG'. Cannot insert duplicate key in object 'dbo.DOCUMENT_CATEGORY'.>.

5264	6884	RUN-051005	18.01.2011 15:35:03	|Data flow DF_DocumentCategory_SAP|Loader TimeStampQuery_DOCUMENT_CATEGORY

5264	6884	RUN-051005	18.01.2011 15:35:03	Execution of <Regular Load Operations> for target <DOCUMENT_CATEGORY> failed. Possible causes: (1) Error in the SQL syntax; (2)

5264	6884	RUN-051005	18.01.2011 15:35:03	Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the

5264	6884	RUN-051005	18.01.2011 15:35:03	datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for

5264	6884	RUN-051005	18.01.2011 15:35:03	regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.

7816	5216	DBS-070401	18.01.2011 15:35:13	|Data flow DF_DocumentCategory_SAP|Loader TimeStampQuery_DOCUMENT_CATEGORY

7816	5216	DBS-070401	18.01.2011 15:35:13	|Data flow DF_DocumentCategory_SAP|Loader TimeStampQuery_DOCUMENT_CATEGORY

7816	5216	DBS-070401	18.01.2011 15:35:13	ODBC data source <RAPIDMARTS> error message for operation <SQLExecute>: <[Microsoft][ODBC SQL Server Driver][SQL

7816	5216	DBS-070401	18.01.2011 15:35:13	Server]Violation of PRIMARY KEY constraint 'XPK_DOC_CATEG'. Cannot insert duplicate key in object

7816	5216	DBS-070401	18.01.2011 15:35:13	'dbo.DOCUMENT_CATEGORY'.>.|<Regular Load Operations>|<DOCUMENT_CATEGORY>

Anyone an idea?

Best regards

System:
BO-Edge3.1 SP2
Windowsserver 2008
MSSQL Server 2008
Data Integrator 3.2
SAP 7.0 ECC6

Despicatus :switzerland: (BOB member since 2010-05-07)

2

Occasionally the SAP ERP System contains hard coded values with duplicates. We read those values from the SAP dictionary and then at the loader we get a primary key violation.

You have two options:

Understand why there is a duplicate and fix it

Set the loader to autocorrect load and forget about it

If the table would have been very important I would have suggested the first but because it is not, I would do the latter for now. And check in a few months when you have the time.

Werner Daehn :de: (BOB member since 2004-12-17)

3

Hi Werner,

thx a lot for that hint :slight_smile:

works

best regrads

Cornelius

Despicatus :switzerland: (BOB member since 2010-05-07)