Fileshare subscription

Hello
I have a problem where I set up a user subscription, putting in all the
required fields for this to run correctly. I schedule it to run Once. I
check in SQL Agent for the job and it exists, as expected. I check that the
job has been run in SQL Agent, which is says it has done, successfully
(succeeded with datetime). I then look at the Subscriptions tab (in Report
Manager) to see whether it has run, though it still displays "New
Subscription" for "Last Run Status". The file also does not exist within the
directory specified. I have also looked at the Application Log in Event
Viewer (on the sever), though there isn't anything to indicate a problem
with the subscription.
Is there anywhere I can see what the problem may be?
Thanks,
MarkLook in the log from Reporting Service Server.
Could be that this is a permission issue.
If you have any questions further post the last lines of the log
here.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem where I set up a user subscription, putting in all the
> required fields for this to run correctly. I schedule it to run Once. I
> check in SQL Agent for the job and it exists, as expected. I check that
> the
> job has been run in SQL Agent, which is says it has done, successfully
> (succeeded with datetime). I then look at the Subscriptions tab (in Report
> Manager) to see whether it has run, though it still displays "New
> Subscription" for "Last Run Status". The file also does not exist within
> the
> directory specified. I have also looked at the Application Log in Event
> Viewer (on the sever), though there isn't anything to indicate a problem
> with the subscription.
> Is there anywhere I can see what the problem may be?
> Thanks,
> Mark
>|||Thanks.
From the "ReportServer__04_14_2005_00_02_16.log" file:
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetPermissions:/
aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
Entries Posted
aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> Look in the log from Reporting Service Server.
> Could be that this is a permission issue.
> If you have any questions further post the last lines of the log
> here.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> > Hello
> >
> > I have a problem where I set up a user subscription, putting in all the
> > required fields for this to run correctly. I schedule it to run Once. I
> > check in SQL Agent for the job and it exists, as expected. I check that
> > the
> > job has been run in SQL Agent, which is says it has done, successfully
> > (succeeded with datetime). I then look at the Subscriptions tab (in
Report
> > Manager) to see whether it has run, though it still displays "New
> > Subscription" for "Last Run Status". The file also does not exist within
> > the
> > directory specified. I have also looked at the Application Log in Event
> > Viewer (on the sever), though there isn't anything to indicate a problem
> > with the subscription.
> >
> > Is there anywhere I can see what the problem may be?
> >
> > Thanks,
> >
> > Mark
> >
> >
>|||Looks like an incomplete stack trace... of an exception block,
í don´t exactly know who is gonna pump out the file to the share, the
ReportServerService Account or the ASP.NET process the IIS is running on (I
guess the ASp.NET Account). Give him the appopiate permissions to access to
fileshare and you gotta be perhaps right.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Thanks.
> From the "ReportServer__04_14_2005_00_02_16.log" file:
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetPermissions:/
> aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> Entries Posted
> aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> Thanks,
> Mark
>
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
>> Look in the log from Reporting Service Server.
>> Could be that this is a permission issue.
>> If you have any questions further post the last lines of the log
>> here.
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
>> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
>> > Hello
>> >
>> > I have a problem where I set up a user subscription, putting in all the
>> > required fields for this to run correctly. I schedule it to run Once. I
>> > check in SQL Agent for the job and it exists, as expected. I check that
>> > the
>> > job has been run in SQL Agent, which is says it has done, successfully
>> > (succeeded with datetime). I then look at the Subscriptions tab (in
> Report
>> > Manager) to see whether it has run, though it still displays "New
>> > Subscription" for "Last Run Status". The file also does not exist
>> > within
>> > the
>> > directory specified. I have also looked at the Application Log in Event
>> > Viewer (on the sever), though there isn't anything to indicate a
>> > problem
>> > with the subscription.
>> >
>> > Is there anywhere I can see what the problem may be?
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> >
>>
>|||Hi Jens
Thanks for your reply, it pointed me in the right direction : ReportServer
service was, in fact, using the Local System account and not domain\svcSQL.
I also looked at the posting, below, for further information and loosely
followed the Solution #2 and now my fileshare is working fine. Now onto why
e-mails aren't... :-)
http://groups.google.co.uk/groups?q=%22My+problem+was+solved+by+calling%22&hl=en&lr=&safe=off&rls=GGLD,GGLD:2004-37,GGLD:en&selm=ODE70opMEHA.268%40TK2MSFTNGP11.phx.gbl&rnum=1
Thanks,
Mark
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:eWCSFYOQFHA.3384@.TK2MSFTNGP10.phx.gbl...
> Looks like an incomplete stack trace... of an exception block,
> í don´t exactly know who is gonna pump out the file to the share, the
> ReportServerService Account or the ASP.NET process the IIS is running on
(I
> guess the ASp.NET Account). Give him the appopiate permissions to access
to
> fileshare and you gotta be perhaps right.
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> news:Op0SOSOQFHA.1396@.TK2MSFTNGP10.phx.gbl...
> > Thanks.
> >
> > From the "ReportServer__04_14_2005_00_02_16.log" file:
> >
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetPermissions:/
> > aspnet_wp!library!1590!04/14/2005-12:17:59:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:05:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:18:08:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:29:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!ec8!04/14/2005-12:18:35:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!684!04/14/2005-12:18:42:: i INFO: Call to
> > GetPermissions:/Customer Reports/Reports/Subscription Testing/Premium
> > Entries Posted
> > aspnet_wp!library!ec8!04/14/2005-12:18:43:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!1590!04/14/2005-12:21:39:: i INFO: Call to
> > GetSystemPermissions
> > aspnet_wp!library!4fd98!4/14/2005-12:22:16:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks,
0
> > running jobs
> >
> > Thanks,
> >
> > Mark
> >
> >
> >
> > "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> > in
> > message news:O8kgBGOQFHA.896@.TK2MSFTNGP10.phx.gbl...
> >> Look in the log from Reporting Service Server.
> >> Could be that this is a permission issue.
> >>
> >> If you have any questions further post the last lines of the log
> >> here.
> >>
> >> HTH, Jens Süßmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
> >> "MCC" <cmc_za@.hotmail.com> schrieb im Newsbeitrag
> >> news:e1ySHlNQFHA.244@.TK2MSFTNGP12.phx.gbl...
> >> > Hello
> >> >
> >> > I have a problem where I set up a user subscription, putting in all
the
> >> > required fields for this to run correctly. I schedule it to run Once.
I
> >> > check in SQL Agent for the job and it exists, as expected. I check
that
> >> > the
> >> > job has been run in SQL Agent, which is says it has done,
successfully
> >> > (succeeded with datetime). I then look at the Subscriptions tab (in
> > Report
> >> > Manager) to see whether it has run, though it still displays "New
> >> > Subscription" for "Last Run Status". The file also does not exist
> >> > within
> >> > the
> >> > directory specified. I have also looked at the Application Log in
Event
> >> > Viewer (on the sever), though there isn't anything to indicate a
> >> > problem
> >> > with the subscription.
> >> >
> >> > Is there anywhere I can see what the problem may be?
> >> >
> >> > Thanks,
> >> >
> >> > Mark
> >> >
> >> >
> >>
> >>
> >
> >
>

Files sizes in a OLE bmp field

I have a database which stores word documents into tables as BLOB fields.
I need to work out what size each WORD document is.
Do you know how can I work out the individual size of each word document?
__________
'sp_spaceused worddoc_attached' only gives me the overall size of the data
in the table.
__________
Thank you for any help in advance
JAD
You can use the datalength function to do this. You can find more
information in books online under datalength.
-Sue
On Fri, 15 Oct 2004 16:05:27 +0100, "JAD" <listgrove@.yahoo.co.uk>
wrote:

>I have a database which stores word documents into tables as BLOB fields.
>I need to work out what size each WORD document is.
>Do you know how can I work out the individual size of each word document?
>__________
>'sp_spaceused worddoc_attached' only gives me the overall size of the data
>in the table.
>__________
>
>Thank you for any help in advance
>JAD
>