Error when running a standard BPC COPY data-manager package

[patrice_chartier]

When I run a standard BPC COPY package I got this error intermittently.

Can someone explain me what it means and why I got this.

It happen often when I ran 6-7 COPY in the same time with huge volume each (10 millions records).

We are on :

BPC NW 10

BW 7.31

thanks.

================================

/CPMB/MODIFY completed in 0 seconds

/CPMB/CM_CONVERT completed in 155 seconds

/CPMB/CLEAR_SOURCE_CUBE completed in 7208 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection] -------------------------------------------------------------- RUNLOGIC = No CHECKLCK = No SELECTION = /BELL/CORPORATE/PRIVATEPUBLICATIONS/A242041/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:ACCOUNT||DIMENSION:CATEGORY|ACTUAL_PRIOR_MONTH|DIMENSION:COSTCENTER||DIMENSION:DATASRC||DIMENSION:POST_LEVEL||DIMENSION:RPTCURRENCY||DIMENSION:TIME||DIMENSION:TP| TOSELECTION = /BELL/CORPORATE/PRIVATEPUBLICATIONS/A242041/TempFiles/TO.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:ACCOUNT||DIMENSION:CATEGORY|ACTUAL_WD5|DIMENSION:COSTCENTER||DIMENSION:DATASRC||DIMENSION:POST_LEVEL||DIMENSION:RPTCURRENCY||DIMENSION:TIME||DIMENSION:TP| SELECTION_KEYDATE = [Message] --------------------------------------------------------------

Task name CONVERT FOR COPYMOVE:

Reject count: 0

Record count: 0

Skip count: 0

Accept count: 9,234,795

Process step executes with parallel

Following line is for technical support Error Place:

Program name(CL_UJD_PIPE_SIMPLE_TARGET=====CP), Include name(CL_UJD_PIPE_SIMPLE_TARGET=====CM002),Source line( 127) Cannot perform write (RSDRI_CUBE_WRITE_PACKAGE)

An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause

The database returned a value containing an error

[former_member186338 · Accepted solution]

You have locks on db level. Don't launch multiple copy chains simultaneously.

[patrice_chartier · Accepted solution]

Hi Vadim, thanks for the quick answer.

But my Copies were all on different Categories (Actual, Budget, Forecast, Plan)

How Locks could happen ?

[former_member186338 · Accepted solution]

Locks are on the dB level. And dB know nothing about your bpc dimensions 🙂

[former_member186338 · Accepted solution]

P.S. Talk with basis team to monitor errors on the dB level.