ERROR CHECKING WORK STATUS doing currency_conversion

[Former Member]

Hi experts!
When I run the consolidation, appear this message:

Package log:

/CPMB/MODIFY completed in 0 seconds
/CPMB/LEGAL_CONSOLIDAT_LOGIC completed in 5 seconds
/CPMB/CLEAR completed in 0 seconds [Selection]
-------------------------------------------------------------- SELECTION = /XXXX/Consolidation/PRIVATEPUBLICATIONS/XXXX/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:CATEGORY|REAL|DIMENSION:SCOPE|XXX|DIMENSION:TIME|2017.SEP
[Message]
--------------------------------------------------------------

model: Consolidation. Package status: WARNING

Formula log:

LOG BEGIN TIME: XXX
FILE:\ROOT\WEBFOLDERS\XXXXX\ADMINAPP\Consolidation\CONSOLIDATION.LGF
USER: XXXX
APPSET: XXXX
APPLICATION:Consolidation
RUN CURRENCY CONVERSION
Error checking work status
11 SUBMITTED, 0 SUCCESS, 11 FAIL.
MESSAGE FROM DOING CURRENCY_CONVERSION
Error checking work status
RUN CONSOLIDATION
0 SUBMITTED, 0 SUCCESS, 0 FAIL. SCRIPT RUNNING TIME IN TOTAL:5.00 s.
LOG END TIME:2017-11-09 11:42:43
File path: \ROOT\WEBFOLDERS\XXXX\Consolidation\PRIVATEPUBLICATIONS\XXXX\tempfiles\20171109114238\00O2TPKA8V7CGBYN7DEJNY1U2_CONSOLIDATION.LOG

The work status is "open" in all case.

The code:

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
R_ENTITY =Global
//INCREMENTAL_MODE = X
*ENDRUN_PROGRAM *RUN_PROGRAM CONSOLIDATION
CATEGORY = %CATEGORY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
R_ENTITY = Global
//INCREMENTAL_MODE =X
*ENDRUN_PROGRAM

Can you help me?
Thank you all

[former_member186338 · Accepted solution]

To my mind your statement:

The work status is "open" in all case.

Is incorrect!

What dimensions are used for work status?

What is the intersection of 11 failed records?

[Former Member · Accepted solution]

Dimension for work status:

Model: consolidation

Enable: Yes

Hierarchy: H1

Owner Dimension: Entity

Other Dimension: Category, Scope, Time

I have the following report:

Row: Entity

Colum: Scope

Context: time sep 2017, Category: real.

The work status in "open". for all entity and group with this time.

The intersection is:

CATEGORY: REAL
SCOPE: XXX (GROUP)
TIME: 2017.SEP

[Former Member · Accepted solution]

The error appear only with one memer of dimension "scope". But I have check that the Work status is openned

[former_member186338 · Accepted solution]

Please find the entity(s) of the 11 records... test again.

In the report use

=EPMWorkStatus(...)

Or create a report showing 11 records and check cells

[former_member186338 · Accepted solution]

Sorry, but you have to prove it... with screenshots etc!

[Former Member · Accepted solution]

Thank you,

I have checked again the work status with all the entitys. All data intersection has the work status open.

I have ckeck in the web (work status report) and epm (=epmWorkStatus(...))

I do not know what can be wrong. Thank you

[former_member186338 · Accepted solution]

Please show screenshots:

WEB work status setup for the model

Report with single cell containing one of 11 values with =epmWorkStatus(...)

In SE38 execute UJ0_GET_GEN_TABNAME to get the name of work status table

In SE16 check this table

[former_member186338 · Accepted solution]

By the way, may be you have some strange ID for SCOPE?

Including some not supported characters or space?

[Former Member · Accepted solution]

Hello,

Thank you, The work status in "open" im sure about that.

The prcess work correctly with exception with one scope, the only one with the id are not number. (AAAA) NOT (1234)

Im going to check.

Thank you

[former_member186338 · Accepted solution]

Sorry, but if you want to get help - please show real screenshots and real ID's.

If it's a top secret - then you have to recreate your issue in the artificial copy of environmentshell. And then - post pictures 🙂

[former_member186338 · Accepted solution]

Or another option - perform yourself ABAP debug of script execution. It will take time but you will definitely find the reason 🙂

[Former Member]

Hi,

solution:

The "scope" "non group" is closed, and its have to be open to run currency conversión.

Thank you so much

[former_member186338]

It's exactly what I posted as an answer. Please accept the answer and close the question.

[former_member186338]

First - what is the reason to add incorrect tag:

SAP Business Planning and Consolidation, version for the Microsoft platform

please, remove it!

Second - please provide full log of package run.

[Former Member]

Hi,

My mistake. Ill do it.

Thank you

[former_member186338]

And post full log! Without it it's not possible to help.

[Former Member]

Thank you!

[former_member186338]

Ups, now i see only one tag:

SAP Business Planning and Consolidation, version for the Microsoft platform

Are you sure it's BPC MS??????

[former_member186338]

Full log including package log! I want to see selection!

[Former Member]

Hi,

Thank you, if you need more information, please let my khnow.

[ralf_wahlen3]

Hi Javier.

Look at that Snote 1806452 - Troubleshooting Errors within BPC NW Consolidation Central

See Also

• 1941497 - Checkpoints for consolidation issue
• 2101349 - Checkpoints for currency translation issue

Greets

[former_member186338]

Sorry, but the provided links has no relation to the issue described in the question.