Skip to Content
0

Error when running a standard BPC COPY data-manager package

Nov 16, 2017 at 10:02 PM

92

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Nov 16, 2017 at 10:11 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Vadim, thanks for the quick answer.

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

How Locks could happen ?

0

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

0

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

0