Skip to Content

Import Transaction Data From Flat File Issue in BPC

Hi Vadim,

I am running Data Manager Package "Import Transaction Data from Flat File". When i execute this Data Manager package it is showing me message that package is successful but when i check status of package then there is no package showing by system. and no data uploaded. no error also.

I am doing this activity on our Quality system. We are using BPC 10 NW version.

EPM : SP24 , PL1, .NET 4.0. Build 9385. Even same issue our business user also facing and they are using higher version of EPM. But still no luck.

Can you please advise what went wrong here?

Parag

import-transaction-data.jpg

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 07, 2017 at 01:53 PM

    Hi Vadim,

    Please find attached screen shot of file use. Conversion file is not used here. Also i am using standard Data Manager Package provided by SAP.

    transformation-file.jpg

    software-version.jpg

    installed-product-version.jpg

    transaction-data-file-snap.jpg

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2017 at 01:41 PM

    EPM version has no relation to the issue!

    Please provide BPC and BW version/SP like here: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Please provide all screenshots:

    DM package advanced script

    Transformation file (and conversion file if used)

    Text file data sample

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2017 at 03:22 PM

    In general: looks like you are importing master data for ENTITY dimension with OWNER property.

    And you have users in this owner property not defined in Quality system resulting in error.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 13, 2017 at 01:40 PM

    Master data import:

    Data file TAB delimited (correct)? And transformation file delimiter? Also TAB?

    Also <"> has to be removed from data file!

    Not:

    "[AP_w_FPA],[T3 - Business Supp],[AP_w_CBO_MN]"

    But

    [AP_w_FPA],[T3 - Business Supp],[AP_w_CBO_MN]

    Transaction import:

    Not clear how you get duplicates.

    When import there is an option to overwrite!

    Add comment
    10|10000 characters needed characters exceeded