Out-of-control Logging

This morning I found out that reporting services was logging out-of-control.
In one day I have about 2 Gigs of the last four lines:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__07_16_2004_06_40_23.log</Path>
<SystemName>[Removed]</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!runningjobs!1b48!7/16/2004-06:40:23:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 69576 seconds
ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
Expiring old execution log entries
ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
Expiration of old execution log entries is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO: Cleaned
0 broken snapshots, 0 chunks
Can anyone tell me what's going on and how to correct the problem?
Thanks in advance,
BryanCurrently the only workaround is to first try restarting the ReportServer
service. If that does not help you will need to restart the box. We are
aware of this issue and are looking into it.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bryan Bullard" <reply@.to.group.com> wrote in message
news:eWfbW10aEHA.3352@.TK2MSFTNGP10.phx.gbl...
> This morning I found out that reporting services was logging
out-of-control.
> In one day I have about 2 Gigs of the last four lines:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Central Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__07_16_2004_06_40_23.log</Path>
> <SystemName>[Removed]</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> ReportingServicesService!runningjobs!1b48!7/16/2004-06:40:23:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 69576 seconds
> ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
> Expiring old execution log entries
> ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
> Expiration of old execution log entries is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
Cleaned
> 0 broken snapshots, 0 chunks
> Can anyone tell me what's going on and how to correct the problem?
> Thanks in advance,
> Bryan
>

Outlook 2002 and Report Services Attachments

When a subscription send an email with the report attached, Outlook 2002 does
not show that there is an attachment or have the ability to open it.
I have tested this by using Outlook 2003 and a Web Email Client to get the
same email, and the attachment is present in all cases except for Outlook
2002. I have also forwarded the email from Outlook 2003 to 2002 and the
attachment is not present, but if I save the attachment in Outlook 2003 and
attach it to an email and send it to 2002 the attachment is available.
--
HaroldsHi Harolds,
- Does your attachment contains all English language information?
- What's the mail server you are using? Exchange Server 2000 or Exchange
Server 2003?
- Have you upgraded to the latest version of SQL Server 2000 Reporting
Services SP2 or SQL Server 2005 Reporting Services?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||-Yes the attachment contains all English language information.
-We do not use exchange server
-I am not sure but I believe we are using SP2, how would I know which
version of SQL Server 2000 Reporting services we are using.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi Harolds,
> - Does your attachment contains all English language information?
> - What's the mail server you are using? Exchange Server 2000 or Exchange
> Server 2003?
> - Have you upgraded to the latest version of SQL Server 2000 Reporting
> Services SP2 or SQL Server 2005 Reporting Services?
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi,
If you are not using Exchange Server, what mail server you are using? We
have an known issue with IBM Lotus Domino servers as it cannot load the
attachment, and the reports appear as a zero-byte file attachment. Check
the KB below for more detailed information.
FIX: You may receive a zero-byte attachment in e-mail when e-mail
subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
Reporting Services
http://support.microsoft.com/?id=872774
To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
you may go to the report server via link <http://<machine>/reportserver> to
see the bottom line
If it appears to be 8.00.1038, you have upgraded to SP2
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||This problem is not in the mail server, because Outlook 2003 has NO problems
with the attachment, also the mail server (CommuniGate Pro) has a web
interface for which it also has NO problems with the attachment. The problem
is that Outlook 2002 doesn't recognize the fact that the email from the
report server has an attachment.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi,
> If you are not using Exchange Server, what mail server you are using? We
> have an known issue with IBM Lotus Domino servers as it cannot load the
> attachment, and the reports appear as a zero-byte file attachment. Check
> the KB below for more detailed information.
> FIX: You may receive a zero-byte attachment in e-mail when e-mail
> subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
> Reporting Services
> http://support.microsoft.com/?id=872774
> To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
> you may go to the report server via link <http://<machine>/reportserver> to
> see the bottom line
> If it appears to be 8.00.1038, you have upgraded to SP2
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Harolds,
I understand it is only Outlook 2002 that you will encounter the error
with. However, we must check the whole process internally from Reporting
Services to Mail Server and Outlook 2002. This work had be to done by
opening a Support incident with Microsoft Customer Service and Support so
that a dedicated Support Professional can assist with this case. If you
need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql

Outer Join Not Working

I'm working with SQL Reporting Services 2005. I'm trying to list
opportunities that do not have a future open activity.
Below is my SQL statement. StateCodes of 0 are open opportunities and open
activities
SELECT Opportunity.name
FROM Activity RIGHT OUTER JOIN Opportunity
ON Activity.RegardingObjectId = Opportunity.opportunityid
WHERE (Activity.StateCode = 0) AND
(Activity.ScheduledStart > { fn NOW() }) AND
(Opportunity.statecode = 0)
It is only returning matched records when I run the query in the Data tab.
There are no instances of an Opportunity without an activity (and we have
loads!)
What am I doing wrong?It has been my experience that when the data tab works and the report
doesn't, and no errors are present, the setting of parameters is usually the
culprit. If you set default parameters, make sure that "O" and 0 (zero) are
not confused.
"Cindy" wrote:
> I'm working with SQL Reporting Services 2005. I'm trying to list
> opportunities that do not have a future open activity.
> Below is my SQL statement. StateCodes of 0 are open opportunities and open
> activities
> SELECT Opportunity.name
> FROM Activity RIGHT OUTER JOIN Opportunity
> ON Activity.RegardingObjectId = Opportunity.opportunityid
> WHERE (Activity.StateCode = 0) AND
> (Activity.ScheduledStart > { fn NOW() }) AND
> (Opportunity.statecode = 0)
> It is only returning matched records when I run the query in the Data tab.
> There are no instances of an Opportunity without an activity (and we have
> loads!)
> What am I doing wrong?
>
>|||In my case the data tab is NOT working.|||SSRS is just flaky as ever.
I would reccomend calling Microsoft once an hour and demanding to know
when SP2 is coming out since this product is basically just not
usable-- since it's soooooo buggy
Sorry; I just dont want to candy-coat it any longer
-Aaron
Cindy wrote:
> In my case the data tab is NOT working.|||Hi,
My understanding of your issue is:
Assume that your opportunity table has the following records:
OpportunityName OpportunityID StateCode
O1 1 0
O2 2 1
O3 3 0
O4 4 0
your activity table has the following records
Owner RegardingObjectId StateCode
W1 1 1
W2 2 0
W3 3 0
W4 4 0
You wanted to get the result:
OpportinityName Owner OpportunityID StateCode
O1 NULL 1 0
O3 W3 3 0
O4 W4 4 0
If I have misunderstood, please let me know.
Please try the following statement:
SELECT Opportunity.name
FROM Activity RIGHT OUTER JOIN Opportunity
ON ( Activity.RegardingObjectId = Opportunity.opportunityid AND
Activity.StateCode = 0 AND Activity.ScheduledStart > { fn NOW() })
WHERE Opportunity.statecode = 0
If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||I finally got this working with some help from the CRM Developer
newsgroup -- but the answer was all about SQL syntax. See below:
select opportunityid, name from FilteredOpportunity
where opportunityid not in
(select regardingobjectid from filteredactivitypointer where
(regardingobjecttypecode = 3) and (statecode = 0))

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony
> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm
sql

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm

Our eal copy has expired

Was under the impression reporting services was free to a licensed SQL server.
Downloaded the eval copy, great product, now a need a licensed copy how do I
go about getting a licensed copy?
Is there costs involved if so I'll need a product #.
Were using SQL 2k
MikeOk, It took a while but it looks like the pages are back up. You can look
here for information about RS 2000:
http://www.microsoft.com/sql/prodinfo/previousversions/default.mspx
http://www.microsoft.com/sql/technologies/reporting/retailfulfillment.mspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:910F09A9-CFE9-4C98-8D7C-A353927AFA0E@.microsoft.com...
> Was under the impression reporting services was free to a licensed SQL
> server.
> Downloaded the eval copy, great product, now a need a licensed copy how do
> I
> go about getting a licensed copy?
> Is there costs involved if so I'll need a product #.
> Were using SQL 2k
> Mike

OTP: Accessing RDL Reports from Visual Basic 6.0 Application

Hai! I don't know is this a silly question. Is it possible to execute and display the rdl (Sql server 2005 reporting services) report from visual basic 6.0 application.

I have a full fledged Visual basic windows application and using crystal reports. I want to create the reports using SQL server 2005 reporting services and access it from my Visual Basic 6.0 Windows application.

Thanks in advance

I'm afraid VB6 support has ended, and so VB6 questions are off topic here. Try www.vbcity.com instead.|||I'm trying to do the same and wondered whether you have found a solution.

Thanks