Issue on Transaction Data loading using multiple flat files

[Former Member]

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

[former_member200327 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Gersh

Thanks alot for your response...

That typo error solved the issue.

Now its working fine.

Thanks alot.

Regards

AK