Error on Report Refresh BPC 10.0

[former_member371496]

Hi

I am getting an error when refreshing the report in BPC as UJ0_EXCEPTION_005 .

Attaching the screen shot of the same.

EPM Addin m using is Vesion 10.0 SP 13 Patch 3

                                   Build: 8288

[former_member371496 · Accepted solution]

Hi,

Thanks for the replies. I found the solution to that particular problem, actually some one added a dimension member in time dimension which was of different format other than time and that member was also not assigned to a hierarchy that's why it was throwing an error.

Regards,

Nidheesh

[Shrikant_Jadhav · Accepted solution]

Hi Nidheesh ,

Thanks for sharing solution with us.

Shrikant

[former_member186498 · Accepted solution]

Hi Nidheesh,

good that you find yourself the solution but instead of closing the thread as "assumed answered" you should mark your answer as "correct answer" this will help other users to find quickly the solution, "assumed answered" means that you didn't found a solution but you don't want to leave it open.

Regards

     Roberto

[former_member371496]

Hi

I have diagnosed the problem, when i select ALL MEMBERS in Time dimension it is fetching data but when i change it to BASE MEMBERS then it throws error UJ0_EXCEPTION_005.

Kindly Suggest any Solution .

   Log:

   

[Shrikant_Jadhav]

Hi,

Try to create simple report with one dimension (Time dimension ), check the behavior.

Add one more dimension in  axis , check the same. If the issue is reproduced , Delete any one base member of time dimension , save and process , add back same member ,try to process time dimension. Then  run UJA_REFRESH_DIM_CACHE.

Shrikant

[former_member193143]

Hi Garg,

Please go through the following SAP notes,

2091089 - 500 internal error when running report with selection of base level members

1858257 - How to enable SQE to support MDX member set functions

Check these note once, these may helpful for you ..

Regards,

Saida Reddy G

[bhagyesh_ravange]

Please check the SAP NOTE 1900597 - An exception has occured: Code SY_530

Symptom:

(You will get an error message 'An exception has occured' when refresh a report or create a new report/input schedule. You will see a "code":"SY_530" if you open the details.It is probably that your report contains a dimension which has no hierarchy and you specify 'Base Level' as member set funtion to the member of that dimension and 'Include Member' is set to false.)

Hope this helps..

[bhagyesh_ravange]

Hello Nidheesh,

Have you recently changed your model (i.e have you Add/Remove any Dimension from the Model for that report)

Regards

Bhagyesh Ravange

[Former Member]

Hi,

I am getting same error during Report creation.

Once I was trying to delete the Dimension member id, during that time one error is generated and after that this problem comes during the report creation or refresh.

Kindly suggest the possible solution or how to check the error.

Regards,

Balendu Kumar.

[Shrikant_Jadhav]

Hi Nidheesh,

Try to upgrade SP.

Go through the following link may be helpful

Shrikant

[former_member371496]

Hi Shrikant

I have checked that link but i already have updated of EPM addin :  Vesion 10.0 SP 13 Patch 3 Build: 8288

[Shrikant_Jadhav]

Hi Nidheesh,

Try to create new report and see whether the issue is reproducing or not.

Try following options- Not sure but you can try

1) Clear temp file

2) Clear metadata cache

3) Run UJA_REFRESH_DIM_CACHE

If not try to upgrade SP level, current available SP is 20

Shrikant

[former_member371496]

Hi

I have tried that also...upgraded to SP 20 now, cleared meta data cache and dim cache also. still the problem persist.

[Shrikant_Jadhav]

Hi ,

Try this-

1) Clear temp file

2) Re-install EPM Add-In,

Shrikant