DM package Abort but the log show successful

[Former Member]

Hello All,

While loading the master data I am facing the following issue.

The manager status shows as Abort and log shows successful, when I check the ST22 there is dump available. please find the images here below.

please find the attached short dump here below.

Thank you very much ..

Best regards,

Mallikarjun

Dump.txt.zip

[former_member186338 · Accepted solution]

Full info, please!

DM advanced script, selection, transformation and conversion files, etc...

And what is the result of the import? Correct?

Vadim

[Former Member · Accepted solution]

Hello Vadim,

I am loading data from flat file. please find the details here below

Transformation File:

Please find the advanced script here below.

Thank you very much

Mallikarjun

Advance script.txt.zip

[former_member186338 · Accepted solution]

Sample of the text file?

And have to repeat:

"And what is the result of the import? Correct?"

[Former Member · Accepted solution]

Hi Mallikarjun,

There are 2 difference packages to run to import master data IDs and its properties, and its descriptions, make sure you run the correct one. 2nd line and 5th line below.

Andy

[Former Member · Accepted solution]

Hello Andy,

I am using /CPMB/IMPORT_MASTER data manager package.

This is the first time I am facing this kind of issue, from past few months I am using the same data manager package until now I don't have any issues. Currently I am facing this kind of issue.

Thank you very much ..

Mallikarjun

[Former Member · Accepted solution]

Hello Vadim,

please find the attached sample file here below.

And I tried to import once again and again but no use getting the same dump which is attached prior communication.

Thank you very much

Mallikarjun

Sample.txt.zip

[former_member186338 · Accepted solution]

Just check you hierarchy!

May be you are trying to upload members violating the hierarchy rules...

Do you have 3 hierarchy?

17003, 18360 - base members?

Etc...

[former_member186338 · Accepted solution]

Ups!

I see that in your transformation file the delimiter is ","

But in the sample it's TAB!

Vadim

[Former Member · Accepted solution]

Hello Vadim,

Thank you very much for prompt response..

Can you please elaborate the following statement/ give an example for violating hierarchy rules.

Mallikarjun

[Former Member · Accepted solution]

Hello Vadim,

In sample file Delimiter is TAB but in normal its " ," only.. while uploading excel its not allowed me that why I save in Tab format as text file.

if its a different format while validating the transformation file we will get to know..

Thank you very much ..

Mallikarjun

[former_member186338 · Accepted solution]

Rule:

Any parent member is required to have same children in each hierarchy or no children at all!

Incorrect:

H1:

P1

  M1

  M2

H2:

P1

  M1

  M3

Vadim

[Former Member · Accepted solution]

Hi Mallikarjun,

you don't need to map the description column when you load IDs.

remove that from your transformation file then try load again.

Andy

[former_member193143 · Accepted solution]

Hello Mallikarjun,

Recently I also face this kind of issue, at that time I will check with one of our ABAP consultant, he explained in the following way..

The moment when you run a data manager package it will run a program in the back end in order to load the data from flat file to your respective dimension.

By seeing the error log there is problem in the hierarchy loading, so what I am trying to say here when the program pick the data form your file and place in some internal table later it will load to your respective dimension(its also a table). In the standard program, they will write some logs in order to display the error messages in your case the program executed all the logs and later you are getting an error so you status is success and your load failed.

One more question I want ask you here are you delete any members in the flat file which are already loaded...?

Hope it will be helpful for you ..

Thank you very much

Saida Reddy Gogireddy

[Former Member · Accepted solution]

Hello Saida,

Thank you very much for your reply.

Yes the User department deleted some cost centers which are available previously and now they added some new cost centers .

Thank you very much

Mallikarjun

[former_member193143 · Accepted solution]

Hello Mallikarjun,

Now  I can able to understand the problem, can you please answer the following question

while loading the data are you using Update Hierarchy option or Overwrite Hierarchy option..?

Thank you very much

Saida Reddy Gogireddy

[Former Member · Accepted solution]

Hello Saida Reddy,

While uploading data I am using Update hierarchy  option..

Thank you very much

[former_member193143 · Accepted solution]

Hello Mallikarjun,

That  causes the problem, use overwrite option

Reason: you deleted those members in the file and they are available in the web admin, while loading data it will check the web admin as well as file in cyclic order so the cycle is breaking becuase those members are not available in flat file. So if you overwrite it will solve the problem.

or delete those members in web admin which are not available in the flat flie and loading once again with update hierarchy option in this way it will work. other wise it will not work out

Thank you very much

Saida Reddy Gogireddy

[Former Member]

Hi,

Thanks for response,

* as column3  of the Text file (source - External) - ParentH1 column data.

H1 is the Hierarchy property (column name) created manually for the dimension to which,loading master data (Target - Internal).

i know that conversion is used for converting external format data to internal format through Conversion file,  but here i assumed that we can copy text file hierarchy column data to Dimension hierarchy property. May be not correct.

[former_member186338]

Sorry, but looks like you understand things wrong...

Manually create hierarchies - the hierarchy ID's will be PARENTH1,PARENTH2,PARENTH3

Then import.

Show the screenshot of your dimension administration.

Vadim

[Former Member]

Hello,

Thanks for Correcting me. For loading Master data from Flat file to BPC, if there were no

discrepancies in Hierarchy as explained on Hierarchy Rule, then to my understanding,

can we use this Mapping and Conversion. Correct me if wrong.

*MAPPING

ID=ID

EVDESCRIPTION=*COL(2)

PARENTH1=*COL(3)

PARENTH2=*COL(4)

PARENTH3=*COL(5)

*CONVERSION

PARENTH1=CONV_H1.XLS

PARENTH2=CONV_H2.XLS

PARENTH3=CONV_H3.XLS

--------------------------------

CONVERSION EXCEL FILES (Having manually created multiple Hierarchy H1,H2,H3 for Dimension)

PARENTH1 =CONV_H1.XLS

EXTERNAL    INTERNAL    FORMULA

      *               H1

PARENTH2  =CONV_H2.XLS

EXTERNAL    INTERNAL    FORMULA

      *                H2

PARENTH3 =CONV_H3.XLS

EXTERNAL    INTERNAL    FORMULA

      *                H3

[former_member186338]

Sorry, but what do you mean by conversion: * H1????

[Former Member]

Hi Mallikarjun,

To my Knowledge, while Validation of Transformation file Select "Set Select" tab and Enter in attribute,  hierarchy name and choose set filter by attribute or not.

Default one selected is set filters by attribute and hierarchy. but when we have hierarchy to our Dimension, then we need to choose OR option.

On the Language tab Select Short text as for Text.

Jhansi

[former_member186338]

The topic author is working with master data import from text file! Not from BW!