Skip to Content
avatar image
Former Member

Issue on Transaction Data loading using multiple flat files

Hi All

I am on BPC 7 SP06.

Currently i am trying to load data from flat files in parallel.

1) I have created a process chain which is a copy of an existing standard PC ( IMPORT)

2) I have created my own variants on CONVERT, and LOAD copyin from the original.

3) i have my pc like this

----------------------------------------Start------------------------------
                                                         |
                                                    Modify dynamically
                                                         |
                                       -----------------------------------                                    
                                       |                                             |
                                      Convert1                              Convert2
                                         |                                             |
                                     Load                                      Load
                                         |__________   ___________|
                                                             OR
                                                               |
                                                         Clear BPC tables

I have my dynamic script logic editor is as follows.



INFO(%TEMPNO1%,%INCREASENO%)
INFO(%ACTNO%,%INCREASENO%)

//Load EI CAN LC

TASK(ZCONVERT_EI_CAN_LC ,OUTPUTNO,%TEMPNO1%)
TASK(ZCONVERT_EI_CAN_LC ,ACT_FILE_NO,%ACTNO%)
TASK(ZCONVERT_EI_CAN_LC,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\FINPLANFORECASTING\FORECASTING\DATAMANAGER\TRANSFORMATIONFILES\RECLASSEARNEDINCOMELC_TD_T.xls)
TASK(ZCONVERT_EI_CAN_LC ,SUSER,%USER%)
TASK(ZCONVERT_EI_CAN_LC ,SAPPSET,%APPSET%)
TASK(ZCONVERT_EI_CAN_LC ,SAPP,%APP%)
TASK(ZCONVERT_EI_CAN_LC ,FILE,\ROOT\WEBFOLDERS\FINPLANFORECASTING\FORECASTING\DATAMANAGER\DATAFILES\CAEARNEDINCOMELC.TXT)
TASK(ZCONVERT_EI_CAN_LC ,CLEARDATA,0)
TASK(ZLOAD_EI_CAN_LC ,INPUTNO,%TEMPNO1%)
TASK(ZLOAD_EI_CAN_LC ,ACT_FILE_NO,%ACTNO%)
TASK(ZLOAD_EI_CAN_LC ,RUNLOGIC,0)
TASK(ZLOAD_EI_CAN_LC ,CHECKLCK,0)
TASK(ZLOAD_EI_CAN_LC ,CLEARDATA,0)


//Load EI CAN USD

INFO(%TEMPNO1%,%INCREASENO%)
INFO(%ACTNO%,%INCREASENO%)

TASK(ZCONVERT_EI_CAN_USD ,OUTPUTNO,%TEMPNO1%)
TASK(ZCONVERT_EI_CAN_USD ,ACT_FILE_NO,%ACTNO%)
TASK(ZCONVERT_EI_CAN_LC,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\FINPLANFORECASTING\FORECASTING\DATAMANAGER\TRANSFORMATIONFILES\RECLASSEARNEDINCOMEUSD_TD_T.xls)
TASK(ZCONVERT_EI_CAN_USD ,SUSER,%USER%)
TASK(ZCONVERT_EI_CAN_USD ,SAPPSET,%APPSET%)
TASK(ZCONVERT_EI_CAN_USD ,SAPP,%APP%)
TASK(ZCONVERT_EI_CAN_USD ,FILE,\ROOT\WEBFOLDERS\FINPLANFORECASTING\FORECASTING\DATAMANAGER\DATAFILES\CAEARNEDINCOMEUSD.TXT)
TASK(ZCONVERT_EI_CAN_USD ,CLEARDATA,0)
TASK(ZLOAD_EI_CAN_USD ,INPUTNO,%TEMPNO1%)
TASK(ZLOAD_EI_CAN_USD ,ACT_FILE_NO,%ACTNO%)
TASK(ZLOAD_EI_CAN_USD ,RUNLOGIC,0)
TASK(ZLOAD_EI_CAN_USD ,CHECKLCK,0)
TASK(ZLOAD_EI_CAN_USD ,CLEARDATA,0)

When i try to run the DM package i have an error : 
Immediate Run: Error Occured while trying to run the package on the server An exception with type CX_SY_OPEN_SQL_DB occured,but was neither  handeled locally, nor declared in a RAISING Clause. The system  tried to insert a data record ,eventhough a data record  with the same  primary key  already exists.

Did any one tried to load the transaction data in parallel from different flat files.

or is there any limitation???

Regards

AK

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 21, 2010 at 04:41 PM

    Hi AK,

    I don't think anything is wrong with loading 2 flat files in parallel, but a few things raise questions in your approach:

    1. Do you have same keys in both files, i.e. is it possible that records from those 2 files are trying to overwrite each other? This will definitely produce an error.

    2. Under

    //Load EI CAN USD

    you have

    TASK(ZCONVERT_EI_CAN_LC,...

    . Is it a typo in the posting or how you really have it?

    3. You have same variables %TEMPNO1% and %ACTNO% assigned twice. Could you try changing those for one of the process types?

    If none of this heps, could you please tell what program issues that error?

    Regards,

    Gersh

    Add comment
    10|10000 characters needed characters exceeded