Crystal Reports for Enterprise 4.1 Sp4 : Error saving Report

[former_member185591]

Hello Folks,

We are using SAP BI 4.1 SP4 version in our development and end user has installed same version of CR4E. While saving a report back to BI repository after modifying, he is getting error

"Error saving report. There was an unexpected error while saving report to your server..." Please find below screenshot.

We are able to save report with admin credentials to BO repository on same machine where user is facing the issue. As per the circumstances, it looks like permission issue but not sure. I tried all KBAs I found for this error also checked rights in 'Application>Crystal Reports Configuration' and has full control there. The error also occur while saving a new blank report to user favorites.

Kindly guide further.

Regards,

Lokesh

[former_member185591 · Accepted solution]

The issue is resolved by assigning granular "Add Objects to the folder" right on top level of Temporary Storage to Everyone group. It was already Full Control(Owner) but not sure how it was working before then

[former_member205064]

check sap note  1686815 1779482  1973025

[former_member185591]

Hi Raunak,

I checked all 3 notes however it did not help. I verified rights on different levels but could not find where its missing

-User group has full control on report folder. There are no inherited rights on report folder

-Granted full control on "Crystal Reports configuration" in CMC>application on usergroup level

-Granted Full control to User on his own Favorites folder

-Tried with granular 'Add Objects to the folder' and 'Edit Objects' to user over the report folder

Please let me know if I am missing anything here.

[former_member182521]

Can you confirm where you are trying to save in your Platform. Is it in Public folder or somewhere? Have you tried to to run security query for the user from CMC to narrow down which right is preventing user to save the report.

BusinessObjects Administration - The less known Security Query

[former_member185591]

Also, I added user to administrators group and observed that he is able to save report successfully.

[former_member182521]

from where you are trying to save the reports? is it from BI launchpad or from Crystal designer? Have you tried to run Security query as well.

Thanks

Mani

[former_member190982]

Hi Lokesh,

Please verify if the right 'Add Objects to folder ' is not DENIED on Everyone group and any other group that the user is part of,

Also, have you tried saving the report directly from CMC? Does it lets you save the report ffrom CMC using that user account

Also , you can use CMS tracing to drill this further , Please see KBA, 1708824

Regards,

RVS

[former_member185591]

Hi Ritesh,

I applied HIGH level trace on CMS and followed KB 1708824. I found following lines in trace logs:

|cms_SIA_xxxxxxxx.CentralManagementServer.commitEx4|localhost:1212:1000.957681:1|Ciio85RrEkcwjxUMP3BNkhIc27|||||||||||Security::IsAllowed( U=1811923,R=1,Ob=2872115,Own=1811923,T=262 ) : IsAllowed=false defined=false 

.\InfoStore.cpp:9099:-: TraceLog message 105728

|7a1bdff3-65d5-1e44-89db-60088614d522|2015 09 01 04:24:12:131|-0500|Information| |==| | |cms_SIA_xxxxxxxx.CentralManagementServer| 1212|1000|| |1|5|1|3|BIPSDK.InfoStore:commit|xxxxxxxx:2864:2251.3113:6|BIPSDK.InfoStore:commit|xxxxxxxx:2864:2251.3113:6|cms_SIA_xxxxxxxx.CentralManagementServer.commitEx4|localhost:1212:1000.957681:1|Ciio85RrEkcwjxUMP3BNkhIc27|||||||||||[UID=1811923;ID=2872120] CInfoStoreSubsystem::CommitInfoObjects: user has no right to operate on the object 2872120

I confirmed that Si_id is user for which rights are missing by running the query

Select SI_ID, SI_NAME, SI_KIND, SI_OWNERID from CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS where SI_ID = <objectID>

But I could not find object ID 2872120 ("user has no right to operate on the object 2872120 " ). Query build has nothing for it.

Kindly suggest how to find delegency here

Regards,

Lokesh

[former_member182521]

Are you trying to run the QB query from the same User Id from whom you are facing the issue?

[former_member185591]

No Mani. I tried this in admin tools using my admin ID

Moreover, I found IsAllowed=false at 2 areas in trace logs:

U=1811923,R=1,Ob=2872115,Own=1811923,T=262

U=1811923,R=3,Ob=2872115,Own=1811923,T=1

So, I queries for 2872115 and found following:

SI_NAME 2872114JXbMoLnqn5qR1C6IClD31Jx2872113JpB665HppxnXDIxMEia5CjX

SI_ID 2872115

SI_OWNERID 1811923

SI_KIND Folder

I could not find such folder named "2872114JXbMoLnqn5qR1C6IClD31Jx2872113JpB665HppxnXDIxMEia5CjX" anywhere and its property bags looks something wrong.

Regards,

Lokesh

[former_member182521]

It seems to be temporary folder created sometime. Can we try back track using SI_PARENTID and see where it placed until you get SI_PARENTID=4 (root folder)

[former_member185591]

Hi Mani,

I tried for SI_PARENTID but it returned zero

Number of InfoObject(s) returned: 0

[former_member182521]

Publish me the screen shot of the result

Select

SI_ID, SI_NAME, SI_KIND, SI_OWNERID,SI_PARENTID

from CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS

where SI_ID = 2872115

and then

Select

SI_ID, SI_NAME, SI_KIND, SI_OWNERID,SI_PARENTID

from CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS

where SI_ID = <Parent id from Query 1>

[former_member185591]

Hi Mani,

Following are screenshots