Skip to Content
avatar image
Former Member

File xxxxxx.rpt not found on File Repository Server

Dear All,

for one report scheduled on the CMC I am getting always this error: File xxxxxx.rpt not found on File Repository Server.

The funny things is that if I rerun the report in the CMC this report is correctly sent with no errors.

Have you kindly got any clue about this problem? I tried to overwrote in past but without solving the problem.

Thank you in advance

Luca

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2015 at 11:27 AM

    Hi Luca,

    • Do you mean that you have to schedule the SAME report a 2nd time to not get the error?
    • In the physical location of that .rpt file, do you see that the report/file exists?
    • Is this behavior for all BO users? Including the Enterprise Administrator account?
    • What is the exact BO patch level?
    • Is the Filestore on a shared location? Or on the same server as BO?
    • Is this happening with reports which were migrated?
    • Is the behavior reproduced using the "sample reports"?

    Try the below KBAs:

    1911690 - Report schedules fail intermittently with error "File xxx.rpt not found on file repository server"

    1724745 - Existing recurring schedules are failing after migrating Crystal reports to SAP BusinessObjects BI 4.0 via UMT

    -Sid

    Add comment
    10|10000 characters needed characters exceeded

    • Go to CMC -> Folders, and locate this problem crystal report with "File not found on File Repository Server". Right click on this problem report and choose "Refresh Options" from popup menu. Check "Use Object Repository when refreshing report" if uncheck, then, "Update" and "Refresh report" Hope this helps, Jin-Chong

  • avatar image
    Former Member
    Jan 06, 2015 at 01:25 PM

    Alright.

    Since you're not able to see those KBAs:

    1. Do you have an Antivirus running on the server? If yes, try to disable it and test the issue.

    2. If your Filestore is on a shared location, ensure that the DOMAIN account that you use to run the Server Intelligence Agent has FULL access to this location.

    Hope this helps. 😊

    -Sid

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 01:50 PM

    Luca,

         I would suggest running REPOSCAN to recover any lost index and points within your FRS. First run it in SCAN mode to confirm you have issue, then you can run it in REPAIR mode.

    C:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\reposcan.exe

    Regards,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2015 at 10:44 AM

    Dear All,

    thank you very much for the support you gave me, I much appreciated it.

    I have tested in these last two days the scheduling report and it seems now it works.

    The reason can be due to the antivirus update/scanning of the company where I work. I have tried to schedule in a time where this not occur and the report were successfully scheduled. This report may have been scheduled in past in a time where the antivirus update/scanning did occur and no other report where scheduled in that time.

    Anyway I tried the option suggest to me by JinChong Tsai and indeed this option exist, I scheduled again the report after the refreshing and everything work smoothly.

    I noticed, though, even an option while I was saving the report which could be handy: is a checkbox named "Enable Repository Refresh" located in the pop up window "Save As" when selecting the Enterprise Server as a Destination: I remember this checkbox was always ticked and for some reason was unticked yesterday.

    I apologise for the manifold causes I have listed but to summarize I think that the major causes and then solutions for this tedious problem were:

    -the scheduled report did not work for the Antivirus update/scan which was running in the same range of time where it falls the scheduling report

    -the scheduled report may have not work for a missing refresh of the Repository.

    Best Regards

    Luca

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2015 at 08:37 PM

    Can we try the option "Update Objects" to remove the vulnerabilities between FRS and CMS DB to fix this issue permanently?

    Add comment
    10|10000 characters needed characters exceeded

    • In fact, it is the "Refresh Report" with refresh report object from repository to fix this problem.  However, the source report may overwrite this again when the next code promotion occurs, and you might need to apply the same.

  • avatar image
    Former Member
    Jan 07, 2015 at 09:49 AM

    Update objects from CCM was removed starting BI 4.0.

    Reposcan is the best utility to find and remove inconsistencies between CMS DB and Filestore.

    Add comment
    10|10000 characters needed characters exceeded