Former Member

Mar 07, 2013 at 07:10 PM

/CPMB/LOAD_INFOPROV_UI Import Package keep running on Task /CPMB/LOAD_IP

148 Views

Hi All

We are using BPC NW 10 SP08. I am running DM package /CPMB/LOAD_INFOPROV_UI to import data from BW cube to BPC Cube

When we run the package in the process chain it takes 12 to 15 hours to load the data into BPC Cube which should not take more than few minutes

In SLG1 Log its showing a process in loop as below

Begin check if user(BATHAR) has authority to run function(FUNC0021)

Begin check if user(BATHAR) has authority to run task(P0098)

User BATHAR has authority to run task P0098

Begin check if user(BATHAR) has authority to run task(P0098)

User BATHAR has authority to run task P0098

Begin check if user(BATHAR) has authority to run task(P0098)

User BATHAR has authority to run task P0098

Begin check if user(BATHAR) has authority to run task(P0091)

User BATHAR has authority to run task P0091

Begin check if user(BATHAR) has authority to run task(P0091)

User BATHAR has authority to run task P0091

Begin check if user(BATHAR) has authority to run task(P0091)

User BATHAR has authority to run task P0091

Begin check if user(BATHAR) has authority to run task(P0097)

User BATHAR has authority to run task P0097

Begin check if user(BATHAR) has authority to run task(P0097)

User BATHAR has authority to run task P0097

Begin check if user(BATHAR) has authority to run task(P0097)

User BATHAR has authority to run task P0097

Begin check if user(BATHAR) has authority to run task(P0096)

User BATHAR has authority to run task P0096

Begin check if user(BATHAR) has authority to run task(P0096)

User BATHAR has authority to run task P0096

Begin check if user(BATHAR) has authority to run task(P0096)

User BATHAR has authority to run task P0096

Function FUNC0021 : Dependent task TEAM = [ADMIN][BMW][Corporate][HCV][JLR][Parts][PSV][]

Function FUNC0021 : Dependent task PKTY = [1-]

Function FUNC0021 : Dependent task USER = [1-]

In SM37 process Log it shows the log as below

07.03.2013 18:20:49 SQL-END: 07.03.2013 18:20:49 00:00:00 DBMAN 099 I

07.03.2013 18:20:49 SQL: 07.03.2013 18:20:49 BATHAR DBMAN 099 I

07.03.2013 18:20:49 TRUNCATE TABLE "/BI0/0600000005" DBMAN 099 I

07.03.2013 18:20:49 SQL-END: 07.03.2013 18:20:49 00:00:00 DBMAN 099 I

07.03.2013 18:20:50 SQL: 07.03.2013 18:20:50 BATHAR DBMAN 099 I

07.03.2013 18:20:50 TRUNCATE TABLE "/BI0/0600000005" DBMAN 099 I

07.03.2013 18:20:50 SQL-END: 07.03.2013 18:20:50 00:00:00 DBMAN 099 I

07.03.2013 18:42:48 SQL: 07.03.2013 18:42:48 BATHAR DBMAN 099 I

07.03.2013 18:42:48 TRUNCATE TABLE "/BI0/0600000005" DBMAN 099 I

07.03.2013 18:42:48 SQL-END: 07.03.2013 18:42:48 00:00:00 DBMAN 099 I

07.03.2013 18:42:48 SQL: 07.03.2013 18:42:48 BATHAR DBMAN 099 I

07.03.2013 18:42:48 TRUNCATE TABLE "/BI0/0600000005" DBMAN 099 I

07.03.2013 18:42:48 SQL-END: 07.03.2013 18:42:48 00:00:00 DBMAN 099 I

we have checked the logic and transformation files and conversion files but every thing is ok

The parameters in /CPMB/LOAD_IP are as below

TARGETMODE

RUNLOGIC 0

PREPROCESSMODE

NAME LOAD INFOPROVIDER

INPUTNO

DATATRANSFERMODE 10

CLEARDATA 0

CHECKLCK 0

ACT_FILE_NO

Previously the same package used to run in 2 - 5 minutes

Can any one highlight on the reason

Thanks

Athar