Hello everyone,
I would like to explore how can i schedule a report to a sharepoint site and the rpeort format is in PDF (current in Webi) since we would like to expose this report to everyone in our company but due to licenses issue, we can’t do that. SO another option that i can think of is to export this report to a sharepoint site.
I managed to schedule this report and locate it inside “My Document” folder in my computer. But when i tried the same method and changed the destination to the sharepoint link, it dont work. When i see the scheduled error, this is what i saw:
I’ve read some post related to this topic and tried several approach.
After tried several times, I noticed that the scheduled status is succcess but i couldnt see the report in the destination/sharepoint. Wonder where all the reports go?
If you see the attachment you will see the status success. Can someone guide me?
I’m afraid I haven’t worked with Sharepoint in a while; from memory, as long as you followed the instructions (especially with regard to the server part) and you’re using a UNC to reference the Sharepoint Folder, then it should work ok.
Can you confirm what you’ve done / the steps taken?
Hello McNelson,
Below are my steps. FYI I have tried to schedule a report to a sharepoint. 3 of it showing success and 1 failed (the reason maybe because I removed http: from the address/destination).
1.Select which report to schedule and go to schedule option.
2.At Format & Destinations:
a.Output Format and Destination
i.Output format change to Adobe
ii.Output format Details checked at File Location
b.Destination Option and Setting
i.Unchecked Use the Job Server’s defaults
ii.Add the Directory/location for the SharePoint : I get this from the
SharePoint, click at Explorer View and get the address from here : http://aabbcc.xxx.com/sites/actic/Shared Documents
iii.Add the username & Password (using my own NT login)
3.Click Schedule button
Not sure which step that I did wrong. Can you advise? Btw i have tested to do the same step to schedule to send to my mailbox and also to send to “My Document” folder in my PC and it works. COuld it be permission issue at the sharpeoint side? But i know at the SharePoint I do have read/write access. Do I need to get admin right for this purpose?
FYI I’m using my credential as the username & password (i already informed the sharepoint admin to get a full access to this site and has been granted).
In the schedule setting from the reprot that I want to publish, I am checking at the “File Location” option at the Output Format.
And at the Destination Option & Setting, i am puttring the UNC path in the box (refer attachment). Is this what you mean (sorry if this question sound stupid but I am cracking my head where to edit this setting anymore)
I am having the same issue when trying to schedule a report to a SharePoint UNC path. I took the exact same schedule and changed the path to a directory local to the server and it worked fine. I switched it back to the SharePoint UNC path and it failed. To validate that I had the proper rights to the Sharepoint location, I logged in with the same user account that I had applied to the schedule and then navidated to the UNC path. What I observed is that it took about 20-25 seconds for Windows to pull up the SharePoint path. I suspect that the Crystal processing server is timing out on trying to access the Sharepoint path. When it can’t get it right away it fails the job. If anyone has any alternate theories or input on this issue, I would welcome additional things to try.
I have verified that the File System destination type is enabled for all of our job servers. If we didn’t have them enabled then I wouldn’t be able to schedule reports to output to any other server. In our case, we are able to schedule reports to save to other servers. It is only SharePoint UNC paths that are causing us problems.
In my research I have logged into the Windows 2003 server and pasted in the SharePoint UNC path. From the time I hit to the time that the SharePoint path appears in Windows Explorer it averages about 28 seconds which in computer time is an eternity. I am certain that the Crystal Reports job server is timing out on trying to access the UNC path and then failing the schedule with: destination file error. [CrystalEnterprise.DiskUnmanaged]: []
Another experiment that I tried was to schedule the report via the CMC with applying 4 retries at at 10 second interval to the schedule. My thinking there was that maybe I could “prime the pump” by having the first attempt fail, but at somepoint during the retries that the UNC path would eventually connect and write the file. This didn’t work either.
Ideally, there would be a way I could increase the job server attempt timout settings to make it more tolerant of slow destination paths.
Mapping the UNC path as the S: drive works great as far as improving the speed of accessing the target location. When mapped it will open immediately without delay. Now how do I keep the drive mapped when I’m not logged into the server?
Wild idea:
Run the SIA under a Windows AD Domain account, that account must have proper local amdin rights such as: logon as a service, act as part of OS, etc.
See also Windows AD SSO configuration for SAPBI4.
Then Map your UNC to a drive logged into the Windows Server using that Win AD Account.
Ultimately you shouldn’t have to map a drive to access the UNC in a timely manner; the fact that drive mapping expedites the process might indicate the impediment is network orientated? I’m no expert in this realm I’m afraid , I can barely boil an egg
I do have access to an SP server though (after a year of not working with Shareproint), so will attempt a configuration and report back.
(BOB member since 2009-05-07)
(BOB member since 2003-11-27)
(BOB member since 2008-10-09)
(BOB member since 2009-05-07)
(BOB member since 2008-10-09)
(BOB member since 2009-05-07)
(BOB member since 2008-10-09)
(BOB member since 2006-01-04)
(BOB member since 2002-06-20)