Showing posts with label receive. Show all posts
Showing posts with label receive. Show all posts

Thursday, March 29, 2012

Deserialization failed error

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.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

I'm trying to test my ASP.NET application. Everything is working to the point of getting to my login page to open. When I try to login I receive and error that the database does not exist or access is denied. I used the developer version of SQL Server to create the database and installed the MSDE on my test PC. Then I copied the mdf and ldf files to the new PC. Is there something else I should be doing? Or any suggestions?

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.

The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Help


II am guessing the problem is in IIS but I don't know for sure.
Thanks for you help
-JW

|||Actually, the problem is with some change in the machine account used to encrypt decrypt data. You either need to restore the symmetric key used when you set up the server for the first time or reset the keys in the database. These actions can be done by the Reporting Services configuration tool or the rskeymgmt command line utility.

Friday, February 24, 2012

Deploy Report error?

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.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.
>
>