Hierarchy load failed in bpc

[Former Member]

Dear all

we are loading master data hierarchy daily night in to BPC from  BI info object. for cost center dimension.

however it go failed saying duplicate records found. But the log status saying nothing rejected.

Could you please advise,? hHowever when we check the duplicate records mentioend in log, they got loaded into BPC.

as bpc doesnt allow duplication, why its still displaying duplicate records

NOTE: the package didnt fail till yesterday, but failed today.

Please suggest

transformation file

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=NO

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

ENDROUTINE=ZHIERMAP

*MAPPING

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

*CONVERSION

HIER_NAME=0COSTCENTER_TO_COST_CTR_HIER_CONV.XLS

NODENAME=0COSTCENTER_TO_COST_CTR_HIER_CONV.XLS!NODENAME

PARENT=0COSTCENTER_TO_COST_CTR_HIER_CONV.XLS!PARENT

[Shrikant_Jadhav]

Hi Vijay,

Try to validate this transformation file with data and check the ST22  is there any message at the time of dump.

Shrikant

[former_member186338]

Screenshots:

- Errors

- Conversion files

...

Vadim

[Former Member]

Dear Vadim

thanks for the prompt reply

attached log file, transformation file and convesion file

[just changed extension of .xls files to .xml for uploading as the restricted for file formats here] plz change extension to .xls after downloading.

please help

thanks

packageLogfile.txt.zip

[Former Member]

transformation and conversion files

OCOSTCENTER_EXT_BUSUNTOT_TO_COST_CTR_HIER.txt.zip

[Former Member]

hi Vadim

attaching in package log and tranformation file with extension txt, plz change it to .xls once downloaded

thanks

0COSTCENTER_TO_COST_CTR_HIER_CONV.txt.zip

[former_member186338]

Sorry, but please use readable format! Save my time!

Screenshots are attached directly (paste to the editor window)

Text files are simply inserted into messages.

Vadim

[Former Member]

[Former Member]

[Former Member]

[Former Member]

[Former Member]

[former_member186338]

You have ENDROUTINE badi that can generate any possible duplicates if programmed incorrectly. Ask ABAPer to debug!

Also your conversion may result same internal for different externals (conversion for PARENT and NODE name).

Vadim