Error 1603 on Installation

The SQL Server installation has no default instance. It has an instance
called Reports. On installing RS it allowed selecting an instance so I
thought that everything was fine. When it came to configuring SQL Server
portion of the RS install I got an error 1603. This is Windows 2003 Server
and SQL Server 2000 Standard version 8.00.859
Any ideas of what to do?
Bruce L-CNevermind. I unistalled everything, cleaned up the registry and left over
files. Went into windows 2003 application server configuration and made sure
had everything. Reinstalled SQL Server default install and this time it
worked. Now everything went smoothly with RS installation. I think it didn't
like have no default installation for SQL Server.
Bruce L-C
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u1KifHXdEHA.228@.TK2MSFTNGP11.phx.gbl...
> The SQL Server installation has no default instance. It has an instance
> called Reports. On installing RS it allowed selecting an instance so I
> thought that everything was fine. When it came to configuring SQL Server
> portion of the RS install I got an error 1603. This is Windows 2003 Server
> and SQL Server 2000 Standard version 8.00.859
> Any ideas of what to do?
> Bruce L-C
>sql

Error 0x800ccc6a

Hi,
we are using an SMTP Server, which just works fine with other applications.
But if we try to send reports by e-mail, using the standard e-mail
subscription of report manager, we get this message:
"Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x800ccc6a. The server response was 451 4.7.1 Please
try again later".
Verifying the ReportServerService log, I found this message:
"Error sending email. System.Runtime.InteropServices.COMException
(0x80040211): The message could not be sent to the SMTP server. The transport
error code was 0x800ccc6a. The server response was 451 4.7.1 Please try again
later".
The smtp configuration in the RSReportServer config file is:
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>111.11.11.111</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName>anyone@.company.com</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>anyone@.company.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
Can anyone help me?
Thanks
pwiThe error you're describing is a generic SMTP server error:
0x800CCC6A SMTP_451_ERROR_PROCESSING Error processing request.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;208814)
Hmm... what does your SMTP server's log say?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pwi" <pwi@.discussions.microsoft.com> wrote in message
news:70B81ABA-AA13-4E1C-BD44-55CF66CF86F3@.microsoft.com...
> Hi,
> we are using an SMTP Server, which just works fine with other
> applications.
> But if we try to send reports by e-mail, using the standard e-mail
> subscription of report manager, we get this message:
> "Failure sending mail: The message could not be sent to the SMTP server.
> The
> transport error code was 0x800ccc6a. The server response was 451 4.7.1
> Please
> try again later".
> Verifying the ReportServerService log, I found this message:
> "Error sending email. System.Runtime.InteropServices.COMException
> (0x80040211): The message could not be sent to the SMTP server. The
> transport
> error code was 0x800ccc6a. The server response was 451 4.7.1 Please try
> again
> later".
> The smtp configuration in the RSReportServer config file is:
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>111.11.11.111</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName>anyone@.company.com</SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>anyone@.company.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> Can anyone help me?
> Thanks
> pwi
>

Error "Physical Databasew not found" :-(

Hi out there,

I've created some Crystal Reports in a VB Application. Everything works fine on my comnputer.
The application is installed on several other clients, and on some other machines the reoprts do not work, CR generates an error "Physical Database not found".
On the Crystal Reports homepage several articles are given to solve this poblem, but unfortunately nothing helps.

I've done the foolowing things trying to fix the problem:
- distributing the files given in the knowledgebase with the setup
- Unsetting the "Use indexes for speed" option in the CR object
- Setting the "discard saved data" option in the CR Object

Is there any other thing I can do to try to make the CR work?

System-Environment is CR85, database Background is SQL-Server2k, ADO-Version is 2.8"Physical Database not found"

Obviously ur link 2 Db is broken. Did u check SQL client configurations. U should be using ODBC like connection, if u give a direct link to Db in CR, u should expect this problem.|||Hi Janitha,

no it's quite clear that this can't be the problem as the reports are running correctly on some machines. As the database is on sql-Server (and I'm using the sql-Server-driver, no odbc), if the connection would not be initialized correctly the reports would not run on any client.|||Hi out there,

seems that it is a network (and possibly permission of user) problem.
The setup referred to a folder on the intranet of the company, where the app was located. When I changed the link in the setup back to a local installation, everything works :-)

Error "Failed to Export the Report"

Using Crystal Reports 8.5, RDC, VB6, Win2k for both Dev and client

I'm trying to export a report to pdf, but keep getting:

Error -2147190908 (80047784) "Failed to Export the Report"

It exports fine on my Dev machine, but not on the client machine. I've earched the internet high and low for the answer. The only thing I found was a missing or incorrectly registered ExportModellar.dll and crtslv.dll. I verified that both of those files as well as the correct Destination and ExportType dlls are installed and registered properly. I even reinstalled CR 8.5 on that machine! I have no idea what to try next!

I even downloaded Crystal's Modules utility that supposed to tell you the differences between the dlls being used on 2 different machines. ExportModellar was version 8.5 on the client machine and version 9.1 on my machine, so I upgraded ExportModellar to 9.1 on the client machine, but it didn't help.

Any thoughts would be greatly appreciated!

Thanks in advance.^^^
I have the exact same problem but am using crystal 7 on windows server 2003
Everything seems fine on my machine but not on the client machines.
did you manage to solve this problem, or does any1 have any ideas?|||I finally did get it to work. I ended up downloading a hotfix and installing it on that machine. I still don't know what file was messed up.

Good luck and sorry I couldn't be of any more help!

Malleyo|||sorry to ask another question but what hot fix did you download and where did you get it from?
thanks in advance|||I don't remember which hotfix I used. Try searching Crystal Reports website:
http://support.businessobjects.com/search/advsearch.asp|||I don't remember which hotfix I used. Try searching Crystal Reports website:
http://support.businessobjects.com/search/advsearch.asp
I had the same problem. The hotfix can be found at http://support.businessobjects.com/communityCS/FilesAndUpdates/dbexdrvrwin_en.zip.asp

Roy DeWitt|||I am haing the same problem but the patch did not fix the problem...does anyone have any other ideas? We are running Crystal Report 7 on 2003 operating system.|||For this type of problems you need to make sure that the system is updated with latest patches if any

Error - Server Error in '/Reports' Application - system.drawing.dll

Hi,
I've got a small issue - I can't access my report server anymore!
Everything was working beatifully, up until we restarted the server
last night.
Now when I try to access the site i get the following:
Configuration Error
Description: An error occurred during the processing of a configuration
file required to service this request. Please review the specific error
details below and modify your configuration file appropriately.
Parser Error Message: Assembly system.drawing.dll security permission
grant set is incompatible between appdomains.
Source Error:
Line 253: <add assembly="System.Web.Services,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 254: <add assembly="System.Xml, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
Line 255: <add assembly="System.Drawing,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 256: <add assembly="System.EnterpriseServices,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 257: <add assembly="System.Web.Mobile,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Source File:
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config
Line: 255
The server hadn't been restarted since report services was installed.
As far As I'm aware, nothing else has been installed since.
Has anyone got any suggestions?
Thanks,
SarahSolved!!!
The problem related to security permission.
As it is set up for internal use only, we made the following change to
fix the problem.
In services, World Wide Web Publushing - added permisssion to allow
serice to interact with desktop.

Error - Attempted to read or write protected memory

Hi,

I am back with one more problem..

I have created few reports using SSRS 2005. I am using Oracle database in Data Source to fetch my data. It is working fine and showing me report correctly. But after running the report 8 to 10 times, it starts giving me Memory error. To get rid of that, I need to recycle (stop-start) ReportingService from IIS.

I am exactly getting following error...

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

I am not getting the actual problem, why is it giving memory error only after running few times? Please let me know if anyone facing same problem or knowing the solution for the problem.

Thanks,

HMaheta

Dear HMaheta,

Check the DTC (Distributed Transaction Coordinator) service. It should be set up to to start automatically.

HTH,

Suprotim Agarwal

|||

Hi Suprotim,

Thanks for your reply.

I checked for the DTC. It is running on the server and also marked for auto start up.

Is there any other thing, which I am missing?

Thanks,

HMaheta

ERROR - "The underlying connection was closed"

We are running Reporting Services on an SBS 2003 server and have created a
WinForms application that will print reports from RS. Everything works great
from the SBS server but when I run the application from another machine on
the same domain I get the following error: "The underlying connection was
closed: Unable to connect to the remote server."
We're not using SSL or proxies.
Does anyone have any idea what might be causing this problem? Any help would
be greatly appreciated!"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:61AD6244-FDD6-43F0-A5C9-277F269128E2@.microsoft.com...
> We are running Reporting Services on an SBS 2003 server and have created a
> WinForms application that will print reports from RS. Everything works
> great
> from the SBS server but when I run the application from another machine on
> the same domain I get the following error: "The underlying connection was
> closed: Unable to connect to the remote server."
> We're not using SSL or proxies.
> Does anyone have any idea what might be causing this problem? Any help
> would
> be greatly appreciated!
Is this a web service call? I've found a very simple way to reduce 99.9% of
these errors with web services is to place the initial web service call in a
try...catch block. If it fails, immediately try the same web service call
again. That usually fixes it.
HTH,
Mike Rodriguez

Error

When attempting to adjust the maitenance plan on one of my SQL Servers I get
the followign error message after adjusting how long logs and reports are
kept.
Microsoft SQL - DMO (ODBC SQLState: 42000)
Error 8114: Error converting data type int to tinyint.
What does all this mean?Hi George,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you encounter the error message "Error
converting data type int to tinyint" when re-saving the maintenance plan.
If I have misunderstood your concern, please feel free to point it out.
Yes, this is a known issue when you tried to edit an existing maintenance
plan in MSDE and then click on "Apply" button or "OK" button. You may work
around with the method below
1) Add the BackupDirectory registry value for the instance SQL server in
registry, you will be able to re-save and edit the maintenance job without
problem.
For example, (if you have a named instance), put it in
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer.
The String value is "BackupDirectory" and the data value is "C:\Program
Files\Microsoft SQL Server\MSSQL$nameinstance\BACKUP"
- or -
2) Delete the original existing maint plan and re-create a new one with
your desired changes.
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.|||On Jun 11, 1:08 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> On Jun 11, 3:16 pm, "mtat...@.gmail.com" <mtat...@.gmail.com> wrote:
>
>
>
>
>
>
> Hi
> Are you running DTSRun from a command prompt?
> Why are you using a DSN?
> Have you tried creating the package using the Import Wizard?
> John
I am trying to run the schedule the package from using .xp_cmdshell
and DTSRun , The package will run if execute it from Enterprise Manager|||On Jun 11, 6:20 pm, "mtat...@.gmail.com" <mtat...@.gmail.com> wrote:
> On Jun 11, 1:08 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
> I am trying to run the schedule the package from using .xp_cmdshell
> and DTSRun , The package will run if execute it from Enterprise Manager- H
ide quoted text -
> - Show quoted text -
Hi
If you manually run the command from a command prompt does it work?
If xp_cmdshell is running from a job, then make sure service accounts
have access to the directory/file.
John|||On Jun 11, 1:30 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> On Jun 11, 6:20 pm, "mtat...@.gmail.com" <mtat...@.gmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hi
> If you manually run the command from a command prompt does it work?
> If xp_cmdshell is running from a job, then make sure service accounts
> have access to the directory/file.
> John
Thanks, If I manually run the command from the command prompt it does
work, however if I try and run using xp_cmdshell I receive the error.
Both SQLAgent and MSSQL services have access to the directory/file|||When you are running it from EM, the package will use your logon to
determine the right and security to access a file but this will not be the
case when running it from a service (xp_cmdshell, DTS_Run or any other
service like SQL-Agent).
Also, if you are not using a UNC pathway but a drive letter (such as C:\);
many of these drive letters will be unknown to system accounts and other
accounts other than your own login. If you have used a driver letter, you
should replace with its full UNC name.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
<mtatlow@.gmail.com> wrote in message
news:1181582401.465253.261890@.w5g2000hsg.googlegroups.com...
> On Jun 11, 1:08 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> I am trying to run the schedule the package from using .xp_cmdshell
> and DTSRun , The package will run if execute it from Enterprise Manager
>|||On Jun 11, 9:20 pm, "mtat...@.gmail.com" <mtat...@.gmail.com> wrote:
> On Jun 11, 1:30 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Thanks, If I manually run the command from the command prompt it does
> work, however if I try and run using xp_cmdshell I receive the error.
> Both SQLAgent and MSSQL services have access to the directory/file- Hide q
uoted text -
> - Show quoted text -
Hi
You don't say what the service accounts are. The LOCALSYSTEM will not
have access to network resources, so it would have to be a domain
account. Try logging in as this account and run the package from the
command prompt.
John|||I am using a domain account that has access to the file. I am using
the [ODBC Text Driver] which does not allow you to use a UNC in the
pathway.
On Jun 11, 5:36 pm, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:[vbcol=seagreen]
> When you are running it from EM, the package will use your logon to
> determine the right and security to access a file but this will not be the
> case when running it from a service (xp_cmdshell, DTS_Run or any other
> service like SQL-Agent).
> Also, if you are not using a UNC pathway but a drive letter (such as C:\);
> many of these drive letters will be unknown to system accounts and other
> accounts other than your own login. If you have used a driver letter, you
> should replace with its full UNC name.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
> <mtat...@.gmail.com> wrote in message
> news:1181582401.465253.261890@.w5g2000hsg.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
>|||On Jun 12, 12:58 pm, "mtat...@.gmail.com" <mtat...@.gmail.com> wrote:
> I am using a domain account that has access to the file. I am using
> the [ODBC Text Driver] which does not allow you to use a UNC in the
> pathway.
> On Jun 11, 5:36 pm, "Sylvain Lafontaine" <sylvain aei ca (fill the
> blanks, no spam please)> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
Hi
So logging in as this account, you can run the job/package
sucessfully? Have you used the /L command to log output to a file?
John|||On Jun 12, 9:05 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> On Jun 12, 12:58 pm, "mtat...@.gmail.com" <mtat...@.gmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hi
> So logging in as this account, you can run the job/package
> sucessfully? Have you used the /L command to log output to a file?
> John
This is the output that I get when I use xp_cmdshell
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259
(80004005)
Error string: [Microsoft][ODBC Text Driver] '(unknown)' is not a
valid path. Make sure that the path name is spelled correctly and
that you are connected to the server on which the file resides.
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 1023 (3FF)
Error string: [Microsoft][ODBC Text Driver] '(unknown)' is not a
valid path. Make sure that the path name is spelled correctly and
that you are connected to the server on which the file resides.
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
NULL
this is the output when I run from the cmd prompt
The execution of the following DTS Package succeeded:
Package Name: test
Package Description: (null)
Package ID: {28220C92-CA63-4664-B356-2155FC002749}
Package Version: {D70556AF-1AE9-4175-83C7-B623FC755314}
Package Execution Lineage: {5DD5E480-8567-43F2-BBAA-7F9F9C9E994D}
Executed On: SERVERNAME
Executed By: username
Execution Started: 6/12/2007 9:31:01 AM
Execution Completed: 6/12/2007 9:31:01 AM
Total Execution Time: 0.64 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step Execution Started: 6/12/2007 9:31:01 AM
Step Execution Completed: 6/12/2007 9:31:01 AM
Total Step Execution Time: 0.593 seconds
Progress count in Step: 1672
****************************************
************************************
************************

Error

When attempting to adjust the maitenance plan on one of my SQL Servers I get
the followign error message after adjusting how long logs and reports are
kept.
Microsoft SQL - DMO (ODBC SQLState: 42000)
Error 8114: Error converting data type int to tinyint.
What does all this mean?Hi George,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you encounter the error message "Error
converting data type int to tinyint" when re-saving the maintenance plan.
If I have misunderstood your concern, please feel free to point it out.
Yes, this is a known issue when you tried to edit an existing maintenance
plan in MSDE and then click on "Apply" button or "OK" button. You may work
around with the method below
1) Add the BackupDirectory registry value for the instance SQL server in
registry, you will be able to re-save and edit the maintenance job without
problem.
For example, (if you have a named instance), put it in
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer.
The String value is "BackupDirectory" and the data value is "C:\Program
Files\Microsoft SQL Server\MSSQL$nameinstance\BACKUP"
- or -
2) Delete the original existing maint plan and re-create a new one with
your desired changes.
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.

Error

When attempting to adjust the maitenance plan on one of my SQL Servers I get
the followign error message after adjusting how long logs and reports are
kept.
Microsoft SQL - DMO (ODBC SQLState: 42000)
Error 8114: Error converting data type int to tinyint.
What does all this mean?
Hi George,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you encounter the error message "Error
converting data type int to tinyint" when re-saving the maintenance plan.
If I have misunderstood your concern, please feel free to point it out.
Yes, this is a known issue when you tried to edit an existing maintenance
plan in MSDE and then click on "Apply" button or "OK" button. You may work
around with the method below
1) Add the BackupDirectory registry value for the instance SQL server in
registry, you will be able to re-save and edit the maintenance job without
problem.
For example, (if you have a named instance), put it in
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer.
The String value is "BackupDirectory" and the data value is "C:\Program
Files\Microsoft SQL Server\MSSQL$nameinstance\BACKUP"
- or -
2) Delete the original existing maint plan and re-create a new one with
your desired changes.
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.

Error

I am getting this error trying accessing RM page.
Server Error in '/Reports' Application.
----
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set
to an instance of an object.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an
object.]
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object
sender, EventArgs e) +58
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64
Any idea?
ThanksOn Aug 12, 8:20 pm, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
> I am getting this error trying accessing RM page.
> Server Error in '/Reports' Application.
> ----
> Object reference not set to an instance of an object.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.NullReferenceException: Object reference not set
> to an instance of an object.
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
> [NullReferenceException: Object reference not set to an instance of an
> object.]
> Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object
> sender, EventArgs e) +58
> System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> +92
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +64
> Any idea?
> Thanks
This looks like a dual post. Here was my response for that one.
You should try looking in the SSRS logs to see if it gives you any
descriptive information (normally located in: C:\Program Files
\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles ). If you
cannot resolve the issue by looking at the logs, you should look into
reinstalling SSRS. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Erratic report execution

When we request reports through the Report Manager, sometimes they run
and sometimes they don't (ie they time out after 30 minutes.)
Specifically, when I run exactly the same report with exactly the same
parameters and examine the ExecutionLog I will see numbers such as:
First report request (does not run):
TimeEnd - TimeStart = 30:14.4
TimeDataRetrieval = 0
TimeProcessing = 1814137
Status = rsProcessingAborted
Second report request (does run):
TimeEnd - TimeStart = 00:27.7
TimeDataRetrieval = 14087
TimeProcessing = 12502
Status = rsSuccess
This situation occurs with different reports (not just one specific
one), different users (not just one specific user) and unpredictably (I
have not been able to define the conditions under which a report will
not run.) Sometimes running a second request immediately after the
first will appear to "trigger" the report to run (which made me suspect
a cache issue) but at other times the second request is made a day or
two later and the report runs correctly (ie long after the cache has
been flushed.) More often than not the reports do run.
We are running SP1 and all of the reports use multiple datasets via
stored procedures. Most of the stored procedures use (NOLOCK) on the
SELECT statements.
I searched the forum but could not find a discussion on this topic.
Does anyone have any suggestions as to how I can track this down?
Regards.I am also facing the same problem. In my case, the details when the report
didn't run are:
TimeDataRetrieval = 0
TimeProcessing = 29305548
Status = rsProcessingAborted
Can someone prescribe further course of action?
Thanks in advance!