cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to determine consolidation area for data basis XX

former_member211095
Contributor
0 Kudos

Hi Team

For business requirement activated monitor status data stream and also activated and maintained Info Objects like Task status ..

Activated options in the consolidation area like Status Management and Hierarchy Dependent status managment.

Defined a report on the virtual cube and meanwhile executed few task in the consolidation monitor.

When we are trying to see the data in report shwoing No data available.  Also shown error message "Unable to determine Consolidation area for data basis" and Error reading the data of Info provider SEMBCSV11.

Please let me know how to resolve the probelm or is there anything that was missed.

Regards

Rajesh SVN

Accepted Solutions (1)

Accepted Solutions (1)

former_member211095
Contributor
0 Kudos

Hi Team

Issue is solved and thanks for support.

There is an inconsistency in database table UCM003C and data basis is consistent.

Followed the steps suggested by SAP:

1) Delete record with initial AREA and initial DATABASIS in UCM003C.

2) Adjust the 2 other records by adding DATABASIS XX and leave the timestamp initial.

3) Delete read buffers of MDF via report UGMD_DEL_BUFFER.

4) Regenerate AREAID (i.e. data basis) V1 via report UGMD_GEN_AREAID.

5) Regenerate cons area objects via transaction UC_AREA_GENERATE for both cons area.

Regards

Rajesh SVN


Answers (2)

Answers (2)

former_member211095
Contributor
0 Kudos

Hi Bala

Thanks for information and data model is sync without any errors.

But still system dump when tried to log into BCS/Monitor/Parameters.

Raise an OSS message, will update information once received.

Regards

Rajesh SVN

BalakrishnaGoud
Explorer
0 Kudos

Hi Rajesh,

Try below options

1. Sync consolidation area with BW in SE38 (UGMDSY20 prgramme)

2. Generate consolidation area in UCWB

Rgds.

former_member211095
Contributor
0 Kudos

Hi Bala

Thanks for your answer.

As you mentioned in point 1 for which info object need to sync for the cons area ?

Consolidation area already generated in BCS Work bench.

Still showing the same

Regards

Rajesh SVN

BalakrishnaGoud
Explorer
0 Kudos

Hi Rajesh,

For point 1.

Application - Data basis of SEM-BCS

App area    - consolidation area

Filed name - 0BCS_AREA

Rgds,

former_member211095
Contributor
0 Kudos

Hi Bala

Thanks for input for point 1.  But still same error exist when execute Bex Report.

Now system went dump when log into BCS Workbench/Monitor as - Exception condition "APPLICATION_AREA_REQUIRED" raised.

Regard

Rajesh SVN

BalakrishnaGoud
Explorer
0 Kudos

Hi Rajesh,

Please check UGWBCM tcode (data model sync).

Aplication: Data basis of SEM BCS/Source data basis of SEM BCS

Appl Area:  Controlling area.

FYI: you can use ugmd_batch_sync  programme to sync master data/hierarchy from Local (BCS) to BW

Rgds,