Thursday, March 29, 2012
Deserialization failed error
receive an error stating that Parameter name: Top must be between 0 and
85.33333in, when I change it to .5in, 1.5in I get ...is not a valid value.
Anyone, please help, I have created 11 pages and don't want to recreate them
as it failed on the last page.
Thanks for any help in this matter.Resolved. Yes this can be fixed by manually editing the rdl.
"DigitalVixen" wrote:
> Can this be fixed by manually editing the rdl? I have tried however I
> receive an error stating that Parameter name: Top must be between 0 and
> 85.33333in, when I change it to .5in, 1.5in I get ...is not a valid value.
> Anyone, please help, I have created 11 pages and don't want to recreate them
> as it failed on the last page.
> Thanks for any help in this matter.
Description: String cannot have zero length. Event ID: 6003
When i add a new document to the queue, I receive this error in the event log. I used the example from the book in chapter 5 but i left out the scheduled piece. I am unable to find anything via searches on google etc. Your help would be appreciated. Thank you!
XSLT File
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="notifications">
There is a new Test Document!
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="notification">
Document Type: <xsl:value-of select="TypeName" />
Document Name: <xsl:value-of select="DocumentTitle" />
Document Category: <xsl:value-of select="CategoryName" />
<xsl:text>
</xsl:text>
</xsl:template>
</xsl:stylesheet>
Event log error:
Description: The assembly containing the content formatter could not be loaded.
EventParameters:
Instance Name: MyInstance 'Renamed for forum'
Application Name: Documents
Content Formatter Assembly Name:
Description: String cannot have zero length.
InstanceName: MyInstance 'Renamed for forum'
ApplicationName: Documents
Component: Distributor
ComponentDetails: DistributorName: MyDistributor 'Renamed for forum'
Thread: 4
ACF:
<ContentFormatter>
<ClassName>XsltFormatter</ClassName>
<Arguments>
<Argument>
<Name>XsltBaseDirectoryPath</Name>
<Value>%_ApplicationBaseDirectoryPath_%\Formatters</Value>
</Argument>
<Argument>
<Name>XsltFileName</Name>
<Value>NewDocumentByType.xslt</Value>
</Argument>
</Arguments>
</ContentFormatter>
ICF
<Application>
<ApplicationName>Documents</ApplicationName>
<BaseDirectoryPath>%_InstanceBaseDirectoryPath_%\Documents</BaseDirectoryPath>
<ApplicationDefinitionFilePath>ApplicationDefinition.xml</ApplicationDefinitionFilePath>
<Parameters>
<Parameter>
<Name>_NSServer_</Name>
<Value>%_NSServer_%</Value>
</Parameter>
<Parameter>
<Name>_SQLServer_</Name>
<Value>%_SQLServer_%</Value>
</Parameter>
<Parameter>
<Name>_ApplicationBaseDirectoryPath_</Name>
<Value>%_InstanceBaseDirectoryPath_%\Documents</Value>
</Parameter>
</Parameters>
</Application>
</Applications>
I fixed this by building a custom Formatter.
Wednesday, March 21, 2012
Deployment Help
Thank you,::Then I copied the mdf and ldf files to the new PC
did you "attach" the database ??
hth|||The test PC only has the MSDE installed. I don't know of a way to run the attach sp without query analyzer, is there a way?
Thank you,|||I tested, and I can connect the SQL Server database to a Access adp. Would this mean that I should be able to connect to my ASP.NET web pages? Could there be a problem with my connection string when I moved the app to the new PC? What is the simplest connect string to a SQL Server database, so I can test it?
Thanks you any suggestions,|||Can you install SQL Server tools (only)?
That would be easier to attach a db via Enterprise Manager (right-click DB / all tasks).|||I was trying to do this as if those tools were not available. I read that it was possible, but I cannot find the listing again.
Thank you,sql
Friday, March 9, 2012
Deploying Report Model Error
I receive the following error when I attempt to deploy a report model to the Report Server. This is the on the SQL 2005 June CTP. Does my config file for the Report Server need to be modified? Any help would be appreciated.
Thanks
-JW
Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><font face=Verdana color=#ff3300>Server Application Unavailable
</font></h1>
<font face=Verdana>
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
</body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)
Is your report server up and running. Usually it's on http://localhost/reportserver. Do you get an error when you access it?If you get Service Unavailable, it sometimes means that ASP.Net is not configured correctly. This can happen if the IIS was installed AFTER the .Net Framework 2.0 was installed. Usually what addresses this is to run "aspnet_regiis -iru" from your Windows\Microsoft.Net\Frameworks\v2.0.xxxxx\ folder.
-Lukasz|||
My Report Server is up and running and I can access it. I am also the admin.
I recently tried creating a new data source from the Report Server with the following results.
II am guessing the problem is in IIS but I don't know for sure.
Thanks for you help
-JW
Friday, February 24, 2012
Deploy Report error?
A connection could not be made to the report server
http://localhost/ReportServer.
Unable to connect to the remote server (Microsoft.ReportingServices.Designer).
What should i do to make this work?
Thanks.I reinstall my IIS and when i deploy again this report, I have a new error
message;
Error 1 The report server cannot open a connection to the report server
database. A connection to the database is required for all requests and
processing. 0 0
"GGill" wrote:
> I try to deploy report "rptInfo.rdl" and I receive this error;
> A connection could not be made to the report server
> http://localhost/ReportServer.
> Unable to connect to the remote server (Microsoft.ReportingServices.Designer).
> What should i do to make this work?
> Thanks.|||One more error i have when i try to deploy the report
-- Build started: Project: Report Project1, Configuration: Debug --
Build complete -- 0 errors, 0 warnings
-- Deploy started: Project: Report Project1, Configuration: Debug --
Deploying to http://localhost/ReportServer
Error rsReportServerDatabaseUnavailable : The report server cannot open a
connection to the report server database. A connection to the database is
required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==================== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
"GGill" wrote:
> I try to deploy report "rptInfo.rdl" and I receive this error;
> A connection could not be made to the report server
> http://localhost/ReportServer.
> Unable to connect to the remote server (Microsoft.ReportingServices.Designer).
> What should i do to make this work?
> Thanks.|||Looks like the Report Server web service cannot connect to the database. Is
this SQL Server 2005? Is so, run the configuration utility to set up a
backend database for RS. If it's SQL 2000, you may have to run Rsactivate to
provide correct database connection details.
Roman
--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
"GGill" <GGill@.discussions.microsoft.com> wrote in message
news:6FBD875E-79E9-480C-9CE5-21D45B95AA0E@.microsoft.com...
> One more error i have when i try to deploy the report
> -- Build started: Project: Report Project1, Configuration:
> Debug --
> Build complete -- 0 errors, 0 warnings
> -- Deploy started: Project: Report Project1, Configuration:
> Debug --
> Deploying to http://localhost/ReportServer
> Error rsReportServerDatabaseUnavailable : The report server cannot open a
> connection to the report server database. A connection to the database is
> required for all requests and processing.
> Deploy complete -- 1 errors, 0 warnings
> ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
> ==========> ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========> "GGill" wrote:
>> I try to deploy report "rptInfo.rdl" and I receive this error;
>> A connection could not be made to the report server
>> http://localhost/ReportServer.
>> Unable to connect to the remote server
>> (Microsoft.ReportingServices.Designer).
>> What should i do to make this work?
>> Thanks.|||Back up. Make sure RS is working. Even with no reports deployed it will
still be there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"GGill" <GGill@.discussions.microsoft.com> wrote in message
news:6FBD875E-79E9-480C-9CE5-21D45B95AA0E@.microsoft.com...
> One more error i have when i try to deploy the report
> -- Build started: Project: Report Project1, Configuration:
> Debug --
> Build complete -- 0 errors, 0 warnings
> -- Deploy started: Project: Report Project1, Configuration:
> Debug --
> Deploying to http://localhost/ReportServer
> Error rsReportServerDatabaseUnavailable : The report server cannot open a
> connection to the report server database. A connection to the database is
> required for all requests and processing.
> Deploy complete -- 1 errors, 0 warnings
> ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
> ==========> ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========> "GGill" wrote:
>> I try to deploy report "rptInfo.rdl" and I receive this error;
>> A connection could not be made to the report server
>> http://localhost/ReportServer.
>> Unable to connect to the remote server
>> (Microsoft.ReportingServices.Designer).
>> What should i do to make this work?
>> Thanks.|||From SQL Server 2005 i am connecting to sql server 2000 database.
I try to connect to 'Reporting Services Configuration Manager' and i
received error message 'Provider load failure'.
How should i make RS work?
"Bruce L-C [MVP]" wrote:
> Back up. Make sure RS is working. Even with no reports deployed it will
> still be there.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "GGill" <GGill@.discussions.microsoft.com> wrote in message
> news:6FBD875E-79E9-480C-9CE5-21D45B95AA0E@.microsoft.com...
> > One more error i have when i try to deploy the report
> >
> > -- Build started: Project: Report Project1, Configuration:
> > Debug --
> > Build complete -- 0 errors, 0 warnings
> > -- Deploy started: Project: Report Project1, Configuration:
> > Debug --
> > Deploying to http://localhost/ReportServer
> > Error rsReportServerDatabaseUnavailable : The report server cannot open a
> > connection to the report server database. A connection to the database is
> > required for all requests and processing.
> > Deploy complete -- 1 errors, 0 warnings
> > ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
> > ==========> > ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========> >
> > "GGill" wrote:
> >
> >> I try to deploy report "rptInfo.rdl" and I receive this error;
> >>
> >> A connection could not be made to the report server
> >> http://localhost/ReportServer.
> >> Unable to connect to the remote server
> >> (Microsoft.ReportingServices.Designer).
> >>
> >> What should i do to make this work?
> >>
> >> Thanks.
>
>