Showing posts with label instances. Show all posts
Showing posts with label instances. Show all posts

Wednesday, March 21, 2012

Error when exporting to pdf

I get the following message when I try to export a report to pdf. It works
for other instances of data. Not sure if there is to much data, a character
that is messing up the export or what. Any ideas?
Server Error in '/Reports' Application.
----
An internal error occurred on the report server. See the error log for more
details.
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.Exception: An internal error occurred on the
report server. See the error log for more details.
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:
[Exception: An internal error occurred on the report server. See the error
log for more details.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
isAbortable, String url, Stream outputStream, String& mimeType, String&
fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean
isAbortable, String format, String deviceInfo, NameValueCollection
urlAccessParameters, Stream reportStream, String& mimeType, String&
fileNameExtension) +925
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
format, String deviceInfo, NameValueCollection additionalParams, String&
mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64
----
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42
--
Thanks,
Danny BaderHello Danny,
> I get the following message when I try to export a report to pdf. It works
> for other instances of data. Not sure if there is to much data, a character
> that is messing up the export or what. Any ideas?
> Server Error in '/Reports' Application.
try to do simple report (no extra features, just simple table, text,
etc), and try to export it to PDF. If it will work, you have error in
this report, which gives you this error.
I had error too (some custom assembly...), and I get similar errors
like you. After fix in CS, everything works...
--
Best regards,
Brano mailto:2ge@.2NOgeSPAM.us

Sunday, February 26, 2012

Error uninstalling an instance of SQL Server

I am getting the following error while unsinstalling 1
instance of SQL Server on a server that has 3 instances.
Uninstall Failed. A general error occured parsing
validation status from sql.mif.
Another question, Is this the correct way to remove one
instance of SQL without affecting the others.
I ran autorun from the CD and selected an instance to
remove. But, it then says ' removing an entire
installation of SQL Server. '
How can I remove one instance ?
thxI think you can follow this:
http://support.microsoft.com/defaul...1&Product=sql2k|||I used the search from windows explorer to look at this file with notepad. A
t the bottom I noticed this...
START GROUP
NAME = "InstallStatus"
ID = 2
CLASS = "MICROSOFT|JOBSTATUS|1.0"
START ATTRIBUTE
NAME = "Status"
ID = 1
ACCESS = READ-ONLY
STORAGE = SPECIFIC
TYPE = STRING(32)
VALUE = "Failed"
END ATTRIBUTE
START ATTRIBUTE
NAME = "Description"
ID = 2
ACCESS = READ-ONLY
STORAGE = SPECIFIC
TYPE = STRING(128)
VALUE = "unInstallShield has detected that 'mmc.exe' is in use. Shut down o
ther applications and launch unInstallShield again."
END ATTRIBUTE
END GROUP
Noting the "mmc.exe is in use" message, I closed all my Computer Management,
SQL Enterprise Manager, and anything else that looked like it used MMC.exe.
The rerun of my uninstall of my SQL Instance succeeded.
From http://www.developmentnow.com/g/118...-SQL-Server.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Error uninstalling an instance of SQL Server

I am getting the following error while unsinstalling 1
instance of SQL Server on a server that has 3 instances.
Uninstall Failed. A general error occured parsing
validation status from sql.mif.
Another question, Is this the correct way to remove one
instance of SQL without affecting the others.
I ran autorun from the CD and selected an instance to
remove. But, it then says ' removing an entire
installation of SQL Server. '
How can I remove one instance ?
thxI think you can follow this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991&Product=sql2k|||I used the search from windows explorer to look at this file with notepad. At the bottom I noticed this...
START GROUP
NAME = "InstallStatus"
ID = 2
CLASS = "MICROSOFT|JOBSTATUS|1.0"
START ATTRIBUTE
NAME = "Status"
ID = 1
ACCESS = READ-ONLY
STORAGE = SPECIFIC
TYPE = STRING(32)
VALUE = "Failed"
END ATTRIBUTE
START ATTRIBUTE
NAME = "Description"
ID = 2
ACCESS = READ-ONLY
STORAGE = SPECIFIC
TYPE = STRING(128)
VALUE = "unInstallShield has detected that 'mmc.exe' is in use. Shut down other applications and launch unInstallShield again."
END ATTRIBUTE
END GROUP
Noting the "mmc.exe is in use" message, I closed all my Computer Management, SQL Enterprise Manager, and anything else that looked like it used MMC.exe. The rerun of my uninstall of my SQL Instance succeeded
From http://www.developmentnow.com/g/118_2004_1_0_0_468670/Error-uninstalling-an-instance-of-SQL-Server.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Sunday, February 19, 2012

Error stating SQL Debugger not installed

I am running a SQL 2000 server with two instances of SQL (each version
8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
Query Analyzer (ver 8.00.760) I click the execute button and receive an error
indicating that the Debugger Interface is not installed. I've went ahead and
uninstalled the debugger component and reinstalled but still get same error.
Any idea as to what may be wrong?
Ron
Make sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 16 Mar 2005 16:53:02 -0800, Ron Niederer
<RonNiederer@.discussions.microsoft.com> wrote:

>I am running a SQL 2000 server with two instances of SQL (each version
>8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
>Query Analyzer (ver 8.00.760) I click the execute button and receive an error
>indicating that the Debugger Interface is not installed. I've went ahead and
>uninstalled the debugger component and reinstalled but still get same error.
>Any idea as to what may be wrong?
>Ron

Error stating SQL Debugger not installed

I am running a SQL 2000 server with two instances of SQL (each version
8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
Query Analyzer (ver 8.00.760) I click the execute button and receive an erro
r
indicating that the Debugger Interface is not installed. I've went ahead an
d
uninstalled the debugger component and reinstalled but still get same error.
Any idea as to what may be wrong?
RonMake sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 16 Mar 2005 16:53:02 -0800, Ron Niederer
<RonNiederer@.discussions.microsoft.com> wrote:

>I am running a SQL 2000 server with two instances of SQL (each version
>8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure withi
n
>Query Analyzer (ver 8.00.760) I click the execute button and receive an err
or
>indicating that the Debugger Interface is not installed. I've went ahead a
nd
>uninstalled the debugger component and reinstalled but still get same error
.
>Any idea as to what may be wrong?
>Ron

Error stating SQL Debugger not installed

I am running a SQL 2000 server with two instances of SQL (each version
8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
Query Analyzer (ver 8.00.760) I click the execute button and receive an error
indicating that the Debugger Interface is not installed. I've went ahead and
uninstalled the debugger component and reinstalled but still get same error.
Any idea as to what may be wrong?
RonMake sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 16 Mar 2005 16:53:02 -0800, Ron Niederer
<RonNiederer@.discussions.microsoft.com> wrote:
>I am running a SQL 2000 server with two instances of SQL (each version
>8.00.818, SP3 plus hotfixes). When I try to debug a stored procedure within
>Query Analyzer (ver 8.00.760) I click the execute button and receive an error
>indicating that the Debugger Interface is not installed. I've went ahead and
>uninstalled the debugger component and reinstalled but still get same error.
>Any idea as to what may be wrong?
>Ron