BusinessObjects Board

Error in opening Deski Report.

building reports desktopintelligence
#1

Hi,

We are using Business Objects XI Release 2.
We have created a report in Deski.This report is exported to public folders in the repository.

By mistake we deleted the report from public folders.Now we are unable to open the local copy of the report that is local .rep file in the local machine.We get error " You are not authorized to view the doument(FRM0008)".

While saving the report the Save for All Users" option was checked.

This issue is already discussed in the forum topics.
But no resolution has been specified in the posts.
It has been specified that to avoid this problem we can have a back up of the .rep files in the local m/c other than the one that is exported.

Is this the only possibility?

Please provide suggestions on how to resolve this issue…

Thanks

bodevXI (BOB member since 2006-05-09)

FRM008 - report access problem
FRM0008 Not authorized to use this document
FRM0008
You are not authorized to view this document(Security)
#2

In my opinion, this is a HUGE flaw in this release. Save for All users is not a solution here. This simply tells the report that it hasn’t been published. When you then publish it, the security bit is set. Now that you have unpublished it, it’s locked.

I still have not found a way in XI to fix this. In this case, they have taken security too far. There is no “General Supervisor” id that can resolve this.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

Might have a fix but its a bit messy! Surprise Surpirse another bug !! More teddies out the pram but this fix will be in SP2 due out mid next year.

Any this is straight from of of the senior tech guys

hope this helps

  1. Create a new document from the same universe as the report which is locked, it can be a simple document. Export it to a folder or a category you can remember easily
  2. Go to the CMC in the “Objects” section and find this new document in your list of objects. Go to the Document properties and see the physical name and path of the binary object into your file store, for example : frs://Input/a_138/002/000/650/aspv1zmgkojaidezafajr.c.rep
  3. If you know the path to your FileStore Input folder, then go to that path, if you don’t know where is your Input folder you can look in the CMC, into “Servers” section, click on the module named “Input.”, in the properties of this Input module you will see the full UNC path of your File store.
  4. Once in the subfolder Input/a_138/002/000/650/ take away the rep file with a weird name, but don’t delete it, you can put it in a backup folder.
  5. Copy the blocked rep file and rename it exactly as the document which was there so in this case “aspv1zmgkojaidezafajr.c.rep”.
  6. In Deski, open the “Import from Repository” dialogbox and search for the document you created in step 1 from the folder or category you exported it to. Import this document and you will actually see the exact content of the blocked report.
  7. You can of course rename this document as you wish and re-export it to the repository.

robert3975 :uk: (BOB member since 2004-11-05)

accidently deleted report
Sending a Web Intelligence Report object via email
#4

We have requested that we still have access similar to what is in 518. We have an ADAPT#00668258. We want the administrator to still have the capability to unlock reports.

If you are looking to jump on the band wagon please request your Sales team to push for this resolution. We keep getting pushback that this is by design.

chaddy23 (BOB member since 2006-04-21)

#5

Thanks.
That method still “works” with SP3+FP 3.5

I had almost given up hope on opening my report whose parent CMS had been rebuilt. Saves me from rebuilding the report.

rahul :singapore: (BOB member since 2005-05-25)

#6

This method works for anything regardless of what type. We use it for universes and all types of reports.

The thread had been idle for over 2 years. We’ve all learned alot since then.

Steve Krandel :us: (BOB member since 2002-06-25)

#7

Thank you all. That worked like a champ for me. :yesnod: :lol:

Andyisin :india: (BOB member since 2008-08-19)

#8

This topic must be included in the “FAQ Reporter”

carlos.sansores (BOB member since 2008-08-06)

#9

When this occurs because you delete the report from the repository, i have noticed that if you have the report open in DESKI at the same time then you can save this - ensuring that you check the save for all users checkbox - and open the report without any issues at all.

Not ideal i know, but it can save some heartache.

Godders :uk: (BOB member since 2004-01-19)

#10

Thanks a lot. Your post really helped a lot.

Sujata (BOB member since 2006-09-12)

#11

Thanks, method still worked on R3.1 FP 1.3

deflektor (BOB member since 2004-11-04)

#12

Has BO not provided a better solution than this? It is very complicated.

ldcaudle (BOB member since 2005-10-04)