Skip to Content
0

2214875 - Delta initialization with Datasource 0HR_PT_2 fails

May 19, 2017 at 06:12 PM

42

avatar image
Former Member

2214875 - Delta initialization with Datasource 0HR_PT_2 fails

Symptom

The delta initialization with Datasource 0HR_PT_2 fails with the following short dump:

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLHRMS_BIW_PTDW

Environment

SAP ERP

Reproducing the Issue

Start delta init infopackage in BW.

Cause

The number range object setting in PTDW table is wrong.

The extractor dumps in the following coding:
INSERT PTDW_WPBP_DB FROM TABLE I_WBP_DB_INSERT

Resolution

  1. Use transaction SNUM in source system, select number range object in PTDW.
  2. Use button "Number ranges"
  3. Then use the "change Status" button to set the status to 1000000001
  4. Save it.
  5. If the dump remains after that, change the value from 1000000001 to 9999999999.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers