Please point me to a handy-dandy website if there is one, or else maybe someone knows? Here's the issue - I have two subscriptions representing reports that are sent to me at 7:am. I'm testing this out before sending them out to the end users.
A few weeks ago, I noticed report A had no data. So I checked Report B. Data. Okay. I go back and run report A on sharepoint - data. Next day, Report A - no data. Report B - Data. A few days later - report A has data, report B - no data. Repeat process. Yep, both reports have data.
Could this because both reports are running at 7am and then interfering with the completion of one of the reports? I need to resolve this because somewhere down the line we're going to have several hundred reports being sent out to end users and nobody wants a blank report and 15 phone calls. I do have subscriptions set up within sharepoint that push snapshot reports out to a folder and have never seen this. Only the emails.
sharepoint subscription playing games with harried IT person
-
- 4StarLounger
- Posts: 453
- Joined: 04 Feb 2010, 03:40
sharepoint subscription playing games with harried IT person
When one cat leaves, another mysteriously shows up.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: sharepoint subscription playing games with harried IT pe
Have you tested this theory by setting up the reports to run with a delay between each report?garbsmj wrote:Could this because both reports are running at 7am and then interfering with the completion of one of the reports?
Worth a try....
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- SilverLounger
- Posts: 2051
- Joined: 25 Jan 2010, 02:12
Re: sharepoint subscription playing games with harried IT pe
How are the reports being created? Access services or Excel services or JavaScript or ???
What version of SharePoint? Up-to-date with service packs & patched?
Do both reports access the same source data?
Joe
What version of SharePoint? Up-to-date with service packs & patched?
Do both reports access the same source data?
Joe
Joe
-
- 4StarLounger
- Posts: 453
- Joined: 04 Feb 2010, 03:40
Re: sharepoint subscription playing games with harried IT pe
Hey Joe - the reports are created using sharepoint subscription services on a sharepoint 2010 installation. Both reports use the same data source.
Rudi - I split them up for report A to run at 7:00am and report B running at 7:01am. It seemed to work. However, need a better solution since we will have 100s of reports needed to be run. One would think that sharepoint could handle this.
Rudi - I split them up for report A to run at 7:00am and report B running at 7:01am. It seemed to work. However, need a better solution since we will have 100s of reports needed to be run. One would think that sharepoint could handle this.
When one cat leaves, another mysteriously shows up.
-
- 4StarLounger
- Posts: 453
- Joined: 04 Feb 2010, 03:40
Re: sharepoint subscription playing games with harried IT pe
Okay - figured out what the issue was and it's a combination of the run time and other traffic on the server. So by timing it right, now it's working. Thanks Rudi and Joe!
When one cat leaves, another mysteriously shows up.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: sharepoint subscription playing games with harried IT pe
Glad you came right.
TX for the feedback!
TX for the feedback!
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.