Hello
I am new to SQL Server and have migrated an Access DB to SQL Server
I can connect to the database, pull content, etc but a strange thing happen
when I use the "text" datatype. I have a table called "tbl_news
where a field is called "news_story" this is a large text block that my clien
can cut and paste text from MS word. Since it needs to hold large amounts ot tex
I used the MEMO field-type in Access. When I used the TEXT field in SQL serve
some weird stuff happens. When I query the record in a recordset and display
the results on a standard ASP page - one or another fields will not print out
No matter what I try - it seems that one field won't display and there is no rhyme or reason.
When I look in the DB I see the DATA but it wont print on the screen like response.write rs("news_story"
What would cause a field not to print? somewhat hap-hazardly
SHould I use the text datatype? For ex. when I use vchar it doesnt happen. But my tex
gets truncated. Please Help - I am ready to pull my hair ouTo read from TEXT column you should use READTEXT statement,
but you can try to play with SET TEXTSIZE.
Please read "Retrieving ntext, text, or image Values" topics in BOL.
HTH
Igor Raytsin
"Padpros" <anonymous@.discussions.microsoft.com> wrote in message
news:892D6AA1-FCF8-4051-9586-B0FFAA1ED99D@.microsoft.com...
> Hello,
> I am new to SQL Server and have migrated an Access DB to SQL Server.
> I can connect to the database, pull content, etc but a strange thing
happens
> when I use the "text" datatype. I have a table called "tbl_news"
> where a field is called "news_story" this is a large text block that my
client
> can cut and paste text from MS word. Since it needs to hold large amounts
ot text
> I used the MEMO field-type in Access. When I used the TEXT field in SQL
server
> some weird stuff happens. When I query the record in a recordset and
display
> the results on a standard ASP page - one or another fields will not print
out.
> No matter what I try - it seems that one field won't display and there is
no rhyme or reason.
> When I look in the DB I see the DATA but it wont print on the screen like
response.write rs("news_story")
> What would cause a field not to print? somewhat hap-hazardly?
> SHould I use the text datatype? For ex. when I use vchar it doesnt happen.
But my text
> gets truncated. Please Help - I am ready to pull my hair out
>
Showing posts with label migrated. Show all posts
Showing posts with label migrated. Show all posts
Thursday, March 29, 2012
Datatype Problem
Hello,
I am new to SQL Server and have migrated an Access DB to SQL Server.
I can connect to the database, pull content, etc but a strange thing happens
when I use the "text" datatype. I have a table called "tbl_news"
where a field is called "news_story" this is a large text block that my clie
nt
can cut and paste text from MS word. Since it needs to hold large amounts ot
text
I used the MEMO field-type in Access. When I used the TEXT field in SQL serv
er
some weird stuff happens. When I query the record in a recordset and display
the results on a standard ASP page - one or another fields will not print ou
t.
No matter what I try - it seems that one field won't display and there is n
o rhyme or reason.
When I look in the DB I see the DATA but it wont print on the screen like re
sponse.write rs("news_story")
What would cause a field not to print? somewhat hap-hazardly?
SHould I use the text datatype? For ex. when I use vchar it doesnt happen. B
ut my text
gets truncated. Please Help - I am ready to pull my hair outTo read from TEXT column you should use READTEXT statement,
but you can try to play with SET TEXTSIZE.
Please read "Retrieving ntext, text, or image Values" topics in BOL.
HTH
Igor Raytsin
"Padpros" <anonymous@.discussions.microsoft.com> wrote in message
news:892D6AA1-FCF8-4051-9586-B0FFAA1ED99D@.microsoft.com...
> Hello,
> I am new to SQL Server and have migrated an Access DB to SQL Server.
> I can connect to the database, pull content, etc but a strange thing
happens
> when I use the "text" datatype. I have a table called "tbl_news"
> where a field is called "news_story" this is a large text block that my
client
> can cut and paste text from MS word. Since it needs to hold large amounts
ot text
> I used the MEMO field-type in Access. When I used the TEXT field in SQL
server
> some weird stuff happens. When I query the record in a recordset and
display
> the results on a standard ASP page - one or another fields will not print
out.
> No matter what I try - it seems that one field won't display and there is
no rhyme or reason.
> When I look in the DB I see the DATA but it wont print on the screen like
response.write rs("news_story")
> What would cause a field not to print? somewhat hap-hazardly?
> SHould I use the text datatype? For ex. when I use vchar it doesnt happen.
But my text
> gets truncated. Please Help - I am ready to pull my hair out
>
I am new to SQL Server and have migrated an Access DB to SQL Server.
I can connect to the database, pull content, etc but a strange thing happens
when I use the "text" datatype. I have a table called "tbl_news"
where a field is called "news_story" this is a large text block that my clie
nt
can cut and paste text from MS word. Since it needs to hold large amounts ot
text
I used the MEMO field-type in Access. When I used the TEXT field in SQL serv
er
some weird stuff happens. When I query the record in a recordset and display
the results on a standard ASP page - one or another fields will not print ou
t.
No matter what I try - it seems that one field won't display and there is n
o rhyme or reason.
When I look in the DB I see the DATA but it wont print on the screen like re
sponse.write rs("news_story")
What would cause a field not to print? somewhat hap-hazardly?
SHould I use the text datatype? For ex. when I use vchar it doesnt happen. B
ut my text
gets truncated. Please Help - I am ready to pull my hair outTo read from TEXT column you should use READTEXT statement,
but you can try to play with SET TEXTSIZE.
Please read "Retrieving ntext, text, or image Values" topics in BOL.
HTH
Igor Raytsin
"Padpros" <anonymous@.discussions.microsoft.com> wrote in message
news:892D6AA1-FCF8-4051-9586-B0FFAA1ED99D@.microsoft.com...
> Hello,
> I am new to SQL Server and have migrated an Access DB to SQL Server.
> I can connect to the database, pull content, etc but a strange thing
happens
> when I use the "text" datatype. I have a table called "tbl_news"
> where a field is called "news_story" this is a large text block that my
client
> can cut and paste text from MS word. Since it needs to hold large amounts
ot text
> I used the MEMO field-type in Access. When I used the TEXT field in SQL
server
> some weird stuff happens. When I query the record in a recordset and
display
> the results on a standard ASP page - one or another fields will not print
out.
> No matter what I try - it seems that one field won't display and there is
no rhyme or reason.
> When I look in the DB I see the DATA but it wont print on the screen like
response.write rs("news_story")
> What would cause a field not to print? somewhat hap-hazardly?
> SHould I use the text datatype? For ex. when I use vchar it doesnt happen.
But my text
> gets truncated. Please Help - I am ready to pull my hair out
>
Thursday, March 8, 2012
Data-Driven Subscriptions
Hi
I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
Hi,
Is the SSAS also 2005 or is it 2000?
|||What do you have in the RS windows service logfile <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles\ReportServerService__<timestamp>.log at the time when DD subscription fires?|||SSAS is also 2005, i had a problem with the cubes before SP1 was released, but after SP! the Cubes and SSAS 2005 seems to be working fine|||There are two log files there so i pasted both for you
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!7!11/22/2006-00:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-00:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-01:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-04:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-05:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-05:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-06:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-07:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-07:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-08:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:00:33:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:00:34:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:00:36:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to ListTasks
w3wp!library!6!11/22/2006-10:01:15:: i INFO: Call to GetRoleProperties:System Administrator
w3wp!library!6!11/22/2006-10:01:24:: i INFO: Call to SetRoleProperties:System Administrator
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to ListTasks
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetRoleProperties:System User
w3wp!library!8!11/22/2006-10:01:28:: i INFO: Call to SetRoleProperties:System User
w3wp!library!7!11/22/2006-10:01:39:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:40:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:00:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:12:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:02:20:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:22:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:22:: i INFO: Call to ListHistory( '/FutureCOM/90-10 Report' )
w3wp!library!7!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-10:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-10:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-11:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-11:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-12:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-12:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!6!11/22/2006-12:36:42:: i INFO: Reporting Web Server stopped
And the Second one is:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerWebApp__11_21_2006_07_34_32.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.|||Unfortunately these logs are not what I asked. This is from the webserver log, but subscription execution error if any gets written into the RS windows service log file named ReportServerService__<timestamp>.log. Also you don’t need to copy the whole log file contents - find entries (by timestamp in each entry) where you expect subscription to fire and copy entries with errors if any are present.|||Sorry about that Igor, but i have just gone through all the logs and it seems that as soon as it starts to give the error then it stops logging on the Log File, otherwise i would have most likely read what the error was and tried to fix it or at least have posted a better description of what is happening. Do you perhaps have any other suggestions for me?
Kind Regards|||Here is my Stored Proc that i use to run the reports in a batch along with an error that i got in the log file, perhaps there is something here that you could find missing, although this stored proc worked perfectly in SQL2000:
The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>
--My Stored Procedure
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
-- ******************************************************************
-- FSP GET SCHEDULE PARAMETERS
-- Returns a ful list of clients forthe reporting services schedules
--
-- TEST
-- fsp_GetScheduleParameters
-- ******************************************************************
ALTER PROCEDURE [dbo].[fsp_GetScheduleParametersOriginal]
AS
BEGIN
SELECT '[Client].[All Client].[' + LTRIM(RTRIM(Province)) + ']' AS [@.paramProvince],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + ']' AS [@.paramCity],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + '].[' + RTRIM(Client_Name) + ']' AS [@.Client],
dbo.fnc_GetSubscriptionYear(GetDate()) AS [Year],
dbo.fnc_GetSubscriptionMonth(GetDate()) AS [Month],
'd:\Reporting Services Output\' + Client_SerialNo AS [FileName],
LTRIM(RTRIM(Province)) AS [ProvinceName],
LTRIM(RTRIM(City)) AS [CityName],
Client_KEY AS [ClientKEY],
dbo.fnc_GetSubscriptionMonthNumber(GetDate()) AS [MonthNumber]
FROM dbo.DIM_Client
WHERE Client_KEY IN (2)
--WHERE Client_KEY NOT IN (7, 8, 9, 10, 11, 12, 21, 55, 56, 57, 58, 59, 60, 62)
ORDER BY Client_SerialNo
END
One RUN on two reports: ERROR
1/10/2007 7:32:10 AM.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item fab79ac0-b671-4455-9052-4797819e7f82
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: EventPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling finished processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: NotificationPolling processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!library!f!01/10/2007-07:32:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!f!01/10/2007-07:32:10:: Notification a9a25328-7fd8-4882-848b-fd9feded8f30 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Unscanned Totals, Attempt 0
ReportingServicesService!dbpolling!f!01/10/2007-07:32:10:: NotificationPolling finished processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: NotificationPolling processing item ff57f016-470c-49d8-82db-30001b7f7fc9
ReportingServicesService!library!d!01/10/2007-07:32:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!d!01/10/2007-07:32:11:: Notification ff57f016-470c-49d8-82db-30001b7f7fc9 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Assistant Activity Log Disp, Attempt 0
ReportingServicesService!dbpolling!d!01/10/2007-07:32:11:: NotificationPolling finished processing item ff57f016-470c-49d8-82db-30001b7f7fc9|||Have you checked that value returned for Month is within the valid range as it's defined by your report?|||I managed to track down my problem and there were a few, so if anyone is sitting with the same problem then please try to follow.
My reports read their path to place them from the stored procedure under d:\reporting services output\<client_serial> which is incorrect, i had to change that to a mapped path because reporting services requests a URL for a path to place the created reports, so i mapped a folder on my server and changed the path to \\reporting services output
Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX
My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
I hope that this will help other people in the future that have or had the same problem:
Kind Regards
Carel Greaves|||
Hi All
I have the same error...
ReportingServicesService!library!1a40!02/28/2007-17:51:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value.
Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.
Can you please be more explient? Thank you.
Regards,
Thomas.
|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.Kind Regards
Carel Greaves
Data-Driven Subscriptions
Hi
I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
Hi,
Is the SSAS also 2005 or is it 2000?
|||What do you have in the RS windows service logfile <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles\ReportServerService__<timestamp>.log at the time when DD subscription fires?|||SSAS is also 2005, i had a problem with the cubes before SP1 was released, but after SP! the Cubes and SSAS 2005 seems to be working fine|||There are two log files there so i pasted both for you
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!7!11/22/2006-00:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-00:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-01:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-04:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-05:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-05:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-06:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-07:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-07:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-08:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:00:33:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:00:34:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:00:36:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to ListTasks
w3wp!library!6!11/22/2006-10:01:15:: i INFO: Call to GetRoleProperties:System Administrator
w3wp!library!6!11/22/2006-10:01:24:: i INFO: Call to SetRoleProperties:System Administrator
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to ListTasks
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetRoleProperties:System User
w3wp!library!8!11/22/2006-10:01:28:: i INFO: Call to SetRoleProperties:System User
w3wp!library!7!11/22/2006-10:01:39:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:40:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:00:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:12:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:02:20:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:22:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:22:: i INFO: Call to ListHistory( '/FutureCOM/90-10 Report' )
w3wp!library!7!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-10:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-10:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-11:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-11:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-12:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-12:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!6!11/22/2006-12:36:42:: i INFO: Reporting Web Server stopped
And the Second one is:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerWebApp__11_21_2006_07_34_32.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.|||Unfortunately these logs are not what I asked. This is from the webserver log, but subscription execution error if any gets written into the RS windows service log file named ReportServerService__<timestamp>.log. Also you don’t need to copy the whole log file contents - find entries (by timestamp in each entry) where you expect subscription to fire and copy entries with errors if any are present.|||Sorry about that Igor, but i have just gone through all the logs and it seems that as soon as it starts to give the error then it stops logging on the Log File, otherwise i would have most likely read what the error was and tried to fix it or at least have posted a better description of what is happening. Do you perhaps have any other suggestions for me?
Kind Regards|||Here is my Stored Proc that i use to run the reports in a batch along with an error that i got in the log file, perhaps there is something here that you could find missing, although this stored proc worked perfectly in SQL2000:
The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>
--My Stored Procedure
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
-- ******************************************************************
-- FSP GET SCHEDULE PARAMETERS
-- Returns a ful list of clients forthe reporting services schedules
--
-- TEST
-- fsp_GetScheduleParameters
-- ******************************************************************
ALTER PROCEDURE [dbo].[fsp_GetScheduleParametersOriginal]
AS
BEGIN
SELECT '[Client].[All Client].[' + LTRIM(RTRIM(Province)) + ']' AS [@.paramProvince],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + ']' AS [@.paramCity],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + '].[' + RTRIM(Client_Name) + ']' AS [@.Client],
dbo.fnc_GetSubscriptionYear(GetDate()) AS [Year],
dbo.fnc_GetSubscriptionMonth(GetDate()) AS [Month],
'd:\Reporting Services Output\' + Client_SerialNo AS [FileName],
LTRIM(RTRIM(Province)) AS [ProvinceName],
LTRIM(RTRIM(City)) AS [CityName],
Client_KEY AS [ClientKEY],
dbo.fnc_GetSubscriptionMonthNumber(GetDate()) AS [MonthNumber]
FROM dbo.DIM_Client
WHERE Client_KEY IN (2)
--WHERE Client_KEY NOT IN (7, 8, 9, 10, 11, 12, 21, 55, 56, 57, 58, 59, 60, 62)
ORDER BY Client_SerialNo
END
One RUN on two reports: ERROR
1/10/2007 7:32:10 AM.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item fab79ac0-b671-4455-9052-4797819e7f82
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: EventPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling finished processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: NotificationPolling processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!library!f!01/10/2007-07:32:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!f!01/10/2007-07:32:10:: Notification a9a25328-7fd8-4882-848b-fd9feded8f30 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Unscanned Totals, Attempt 0
ReportingServicesService!dbpolling!f!01/10/2007-07:32:10:: NotificationPolling finished processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: NotificationPolling processing item ff57f016-470c-49d8-82db-30001b7f7fc9
ReportingServicesService!library!d!01/10/2007-07:32:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!d!01/10/2007-07:32:11:: Notification ff57f016-470c-49d8-82db-30001b7f7fc9 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Assistant Activity Log Disp, Attempt 0
ReportingServicesService!dbpolling!d!01/10/2007-07:32:11:: NotificationPolling finished processing item ff57f016-470c-49d8-82db-30001b7f7fc9|||Have you checked that value returned for Month is within the valid range as it's defined by your report?|||I managed to track down my problem and there were a few, so if anyone is sitting with the same problem then please try to follow.
My reports read their path to place them from the stored procedure under d:\reporting services output\<client_serial> which is incorrect, i had to change that to a mapped path because reporting services requests a URL for a path to place the created reports, so i mapped a folder on my server and changed the path to \\reporting services output
Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX
My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
I hope that this will help other people in the future that have or had the same problem:
Kind Regards
Carel Greaves|||
Hi All
I have the same error...
ReportingServicesService!library!1a40!02/28/2007-17:51:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value.
Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.
Can you please be more explient? Thank you.
Regards,
Thomas.
|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.Kind Regards
Carel Greaves
Data-Driven Subscriptions
Hi
I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
Hi,
Is the SSAS also 2005 or is it 2000?
|||What do you have in the RS windows service logfile <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles\ReportServerService__<timestamp>.log at the time when DD subscription fires?|||SSAS is also 2005, i had a problem with the cubes before SP1 was released, but after SP! the Cubes and SSAS 2005 seems to be working fine|||There are two log files there so i pasted both for you
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!7!11/22/2006-00:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-00:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-01:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-04:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-05:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-05:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-06:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-07:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-07:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-08:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:00:33:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:00:34:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:00:36:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to ListTasks
w3wp!library!6!11/22/2006-10:01:15:: i INFO: Call to GetRoleProperties:System Administrator
w3wp!library!6!11/22/2006-10:01:24:: i INFO: Call to SetRoleProperties:System Administrator
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to ListTasks
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetRoleProperties:System User
w3wp!library!8!11/22/2006-10:01:28:: i INFO: Call to SetRoleProperties:System User
w3wp!library!7!11/22/2006-10:01:39:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:40:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:00:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:12:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:02:20:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:22:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:22:: i INFO: Call to ListHistory( '/FutureCOM/90-10 Report' )
w3wp!library!7!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-10:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-10:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-11:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-11:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-12:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-12:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!6!11/22/2006-12:36:42:: i INFO: Reporting Web Server stopped
And the Second one is:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerWebApp__11_21_2006_07_34_32.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.|||Unfortunately these logs are not what I asked. This is from the webserver log, but subscription execution error if any gets written into the RS windows service log file named ReportServerService__<timestamp>.log. Also you don’t need to copy the whole log file contents - find entries (by timestamp in each entry) where you expect subscription to fire and copy entries with errors if any are present.|||Sorry about that Igor, but i have just gone through all the logs and it seems that as soon as it starts to give the error then it stops logging on the Log File, otherwise i would have most likely read what the error was and tried to fix it or at least have posted a better description of what is happening. Do you perhaps have any other suggestions for me?
Kind Regards|||Here is my Stored Proc that i use to run the reports in a batch along with an error that i got in the log file, perhaps there is something here that you could find missing, although this stored proc worked perfectly in SQL2000:
The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>
--My Stored Procedure
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
-- ******************************************************************
-- FSP GET SCHEDULE PARAMETERS
-- Returns a ful list of clients forthe reporting services schedules
--
-- TEST
-- fsp_GetScheduleParameters
-- ******************************************************************
ALTER PROCEDURE [dbo].[fsp_GetScheduleParametersOriginal]
AS
BEGIN
SELECT '[Client].[All Client].[' + LTRIM(RTRIM(Province)) + ']' AS [@.paramProvince],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + ']' AS [@.paramCity],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + '].[' + RTRIM(Client_Name) + ']' AS [@.Client],
dbo.fnc_GetSubscriptionYear(GetDate()) AS [Year],
dbo.fnc_GetSubscriptionMonth(GetDate()) AS [Month],
'd:\Reporting Services Output\' + Client_SerialNo AS [FileName],
LTRIM(RTRIM(Province)) AS [ProvinceName],
LTRIM(RTRIM(City)) AS [CityName],
Client_KEY AS [ClientKEY],
dbo.fnc_GetSubscriptionMonthNumber(GetDate()) AS [MonthNumber]
FROM dbo.DIM_Client
WHERE Client_KEY IN (2)
--WHERE Client_KEY NOT IN (7, 8, 9, 10, 11, 12, 21, 55, 56, 57, 58, 59, 60, 62)
ORDER BY Client_SerialNo
END
One RUN on two reports: ERROR
1/10/2007 7:32:10 AM.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item fab79ac0-b671-4455-9052-4797819e7f82
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: EventPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling finished processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: NotificationPolling processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!library!f!01/10/2007-07:32:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!f!01/10/2007-07:32:10:: Notification a9a25328-7fd8-4882-848b-fd9feded8f30 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Unscanned Totals, Attempt 0
ReportingServicesService!dbpolling!f!01/10/2007-07:32:10:: NotificationPolling finished processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: NotificationPolling processing item ff57f016-470c-49d8-82db-30001b7f7fc9
ReportingServicesService!library!d!01/10/2007-07:32:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!d!01/10/2007-07:32:11:: Notification ff57f016-470c-49d8-82db-30001b7f7fc9 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Assistant Activity Log Disp, Attempt 0
ReportingServicesService!dbpolling!d!01/10/2007-07:32:11:: NotificationPolling finished processing item ff57f016-470c-49d8-82db-30001b7f7fc9|||Have you checked that value returned for Month is within the valid range as it's defined by your report?|||I managed to track down my problem and there were a few, so if anyone is sitting with the same problem then please try to follow.
My reports read their path to place them from the stored procedure under d:\reporting services output\<client_serial> which is incorrect, i had to change that to a mapped path because reporting services requests a URL for a path to place the created reports, so i mapped a folder on my server and changed the path to \\reporting services output
Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX
My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
I hope that this will help other people in the future that have or had the same problem:
Kind Regards
Carel Greaves|||
Hi All
I have the same error...
ReportingServicesService!library!1a40!02/28/2007-17:51:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value.
Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.
Can you please be more explient? Thank you.
Regards,
Thomas.
|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.Kind Regards
Carel Greaves
Subscribe to:
Posts (Atom)