Error running report: deploy

Showing posts with label deploy. Show all posts

Thursday, March 29, 2012

Error when trying to deploy report

Hi,
I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
to our reporting server I get the following error:
"A connection could not be made to the report server
http://sqlreportserver/ReportServer"
I can browse to the Report Manager and view reports. I am also able to debug
reports in VS.NET 2003. I've double checked the TargetFolder and
TargetServerURL in the project properties.
I am on a different domain than the report server. Could this be why I am
unable to deploy? If so, does anybody know how I can work around this.
Thanks
John a.k.a.HansHi again,
I'm still having problems with this. If anyone could give me a few pointers
that would be much appreciated.
Thanks
J
"Hans Gruber" wrote:
> Hi,
> I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> to our reporting server I get the following error:
> "A connection could not be made to the report server
> http://sqlreportserver/ReportServer"
> I can browse to the Report Manager and view reports. I am also able to debug
> reports in VS.NET 2003. I've double checked the TargetFolder and
> TargetServerURL in the project properties.
> I am on a different domain than the report server. Could this be why I am
> unable to deploy? If so, does anybody know how I can work around this.
> Thanks
> John a.k.a.Hans
>|||OK. I've made some progress. Hopefully this may help other people with the
same problem.
1) In IE. Tools --> Internet Options --> Connections --> LAN Settings.
Uncheck the 'Use a proxy server for your LAN (These.....' box.
2) Restart VS.NET 2003
3) I can now deploy reports.
Still frustrating because my colleague does not have to uncheck this box in
order to deploy...so any pointers would be much appreciated.
J
> > Hi,
> >
> > I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> > to our reporting server I get the following error:
> >
> > "A connection could not be made to the report server
> > http://sqlreportserver/ReportServer"
> >
> > I can browse to the Report Manager and view reports. I am also able to debug
> > reports in VS.NET 2003. I've double checked the TargetFolder and
> > TargetServerURL in the project properties.
> >
> > I am on a different domain than the report server. Could this be why I am
> > unable to deploy? If so, does anybody know how I can work around this.
> >
> > Thanks
> > John a.k.a.Hans
> >
> >

Error when trying to deploy a report using Oracle data source

We use SQL Server Reporting Services, My SQL box is on Win2k3. The developer
is able to run the report on his Windows XP box but when he deploys the
reports to the SQL Server where Reporting Services is running, he gets the
following error:
"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'WMS'. (rsErrorOpeningConnection)
Get Online Help
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater
He develped this report on his XP box using Visual Studio .NET and is trying
to deploy it to our SQL server production box where Reporting Services is
installed. I have installed Oracle 9.2 client on the SQL Server box and can
make successful connections to our Oracle Database (where the report is
pulling data from). What else am I missing?
Thanks!
Bea Isabelle, Database AdministratorI used the google groups search.
Look at this link:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
Basically reboot after installing. Link has other things to try.
Here is the search I used:
http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"isabelle" <isabelle@.discussions.microsoft.com> wrote in message
news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> developer
> is able to run the report on his Windows XP box but when he deploys the
> reports to the SQL Server where Reporting Services is running, he gets the
> following error:
> "An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'WMS'.
> (rsErrorOpeningConnection)
> Get Online Help
> System.Data.OracleClient requires Oracle client software version 8.1.7 or
> greater
> He develped this report on his XP box using Visual Studio .NET and is
> trying
> to deploy it to our SQL server production box where Reporting Services is
> installed. I have installed Oracle 9.2 client on the SQL Server box and
> can
> make successful connections to our Oracle Database (where the report is
> pulling data from). What else am I missing?
> Thanks!
> Bea Isabelle, Database Administrator
>|||Unfortunately, my server access won't allow me to go to those links here from
work. The only
that we haven't tried is rebooting the IIS services as the documentation
noted. I've also installed the ODP .Net
driver on the FFSQL box and he still gets the error. We will try a reboot
later today and see if that clears up the error.
Thanks!
"Bruce L-C [MVP]" wrote:
> I used the google groups search.
> Look at this link:
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
> Basically reboot after installing. Link has other things to try.
> Here is the search I used:
> http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "isabelle" <isabelle@.discussions.microsoft.com> wrote in message
> news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> > We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> > developer
> > is able to run the report on his Windows XP box but when he deploys the
> > reports to the SQL Server where Reporting Services is running, he gets the
> > following error:
> >
> > "An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'WMS'.
> > (rsErrorOpeningConnection)
> > Get Online Help
> > System.Data.OracleClient requires Oracle client software version 8.1.7 or
> > greater
> >
> > He develped this report on his XP box using Visual Studio .NET and is
> > trying
> > to deploy it to our SQL server production box where Reporting Services is
> > installed. I have installed Oracle 9.2 client on the SQL Server box and
> > can
> > make successful connections to our Oracle Database (where the report is
> > pulling data from). What else am I missing?
> >
> > Thanks!
> >
> > Bea Isabelle, Database Administrator
> >
>
>

Error when trying to deploy

I am getting this error when trying to deploy a report. As far as I can see
permissions /Authentication is all ok
A connection could not be made to the report server
http://Servername/ReportServer
Anybody have any ideas of where to start looking?Have you checked the report project properties? Right mouse on your project
and select "Properties" and be sure the TargetServerURL points to the
correct deploy server (i.e. http://hostname/ReportServer).
"PaulM" <PaulM@.discussions.microsoft.com> wrote in message
news:63646412-BB77-438B-9A45-E4723AE5262C@.microsoft.com...
>I am getting this error when trying to deploy a report. As far as I can see
> permissions /Authentication is all ok
> A connection could not be made to the report server
> http://Servername/ReportServer
> Anybody have any ideas of where to start looking?
>|||I was having this same problem on a new PC that I had just setup with .NET
and SQL Reporting. I found that I needed to have the "Bypass proxy server
for local addresses" checkbox checked in my IE browser connection settings.
I found this by comparing to my old PC.
"goodman93" wrote:
> Have you checked the report project properties? Right mouse on your project
> and select "Properties" and be sure the TargetServerURL points to the
> correct deploy server (i.e. http://hostname/ReportServer).
>
> "PaulM" <PaulM@.discussions.microsoft.com> wrote in message
> news:63646412-BB77-438B-9A45-E4723AE5262C@.microsoft.com...
> >I am getting this error when trying to deploy a report. As far as I can see
> > permissions /Authentication is all ok
> >
> > A connection could not be made to the report server
> > http://Servername/ReportServer
> >
> > Anybody have any ideas of where to start looking?
> >
> >
>
>

Error when trying to deploy

This is a multi-part message in MIME format.
--=_NextPart_000_006C_01C54B87.15611800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All
Has any one ever seen this error?
Error : The type initializer for = "Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an = exception.
I have deployed reports numerous times and never seen it.
Thanks,
Jessica
--=_NextPart_000_006C_01C54B87.15611800
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi All

Has any one ever seen this = error?

Error : The type initializer for "Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an = exception.

I have deployed reports numerous times = and never seen it.

Thanks,

Jessica

--=_NextPart_000_006C_01C54B87.15611800--A few people have reported this error before, but we never identified the
cause. Did anything on your machine change recently? What version of
Reporting Services are you using?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jessica C" <jesscobbe@.hotmail.com> wrote in message
news:u%23BoLH8SFHA.1152@.tk2msftngp13.phx.gbl...
Hi All
Has any one ever seen this error?
Error : The type initializer for
"Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an
exception.
I have deployed reports numerous times and never seen it.
Thanks,
Jessicasql

Thursday, March 22, 2012

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005, I can connect and browse to Reporting Services through any management console and even to my site through //ServerName/Reports but when i try to deploy any of my reports to the Reporting Services through my VS2005 solution i get this error

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

I am thinking there is a problem with your deploying RS 2005 reports to a 2000 RS database. I wasn't aware you could deploy 2005 reports to a 2000 RS database. Maybe you can do it if you don't convert (existing 2000) reports, I am not sure; but I doubt you'll be able to deploy them if you have converted them from 2000 to 2005. I especially think and new reports will bomb out since they would be native 2005.

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks for th information but it still gives me the same error, but don't worry too much about it, i'm just going to reinstall SQL 2000 RS with Visual Studio 2003. apparently there is some incompatibility issue between .Net Framework 2.0 and 1.1 that prevent my solutions from working properly, so until i figure out the exact problem and link the Frameworks manually in my solution i doubt that it will work.

Thanks a lot for your effort guys!

|||

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

When i installed the RS i changed the Virtual Directory Name to Forge too, so when i deployed them i had to deploy them to Forge/Forge instead of Forge/ReportServer which it suppose to be by default. ->PC Name / ReportServer Virtual Directory<--

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks a lot for your effort guys!

|||

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks a lot for your effort guys!

|||

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

Wednesday, March 21, 2012

Error when deploying report to server

I'm trying to deploy my report to the server but keep getting the following error. does anyone know how to fix or is there some steps on how to set up the server to allow this?

Error 1 The permissions granted to user 'GIP-SQLTEST\IUSR_GIP-SQLTEST' are insufficient for performing this operation. 0 0

Thanks,

the user account you are using to deploy the account needs to be DB Owner on the sql server....|||I don't know where the error message is getting this user. This is not my username on this machine nor does this user have access to the server. I'm stumped.|||

it a local system account on the SQL Box, you will find however it has no rights by default to your db.

You will see it if you look at the config settings of ssrs on the server

|||This has been changed but I still can't deploy my report to the server?

Error when deploying report builder model

I get the following error when I try to deploy a report builder model. The SQL Server 2005 "Reporting Services" are installed and running on the local machine.

TITLE: Microsoft Semantic Model Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)

BUTTONS:

OKI ended up uninstalling SQL Server 2005, uninstalling the previously installed SQLExpress, and then reinstalling SQL Server 2005. This solved the problem.|||I had the same kind a problem and i started looking some other reporting tool .The very best one on the market in my opinion is Intelliview. It is very pricey

though! You can find it here: http://www.synaptris.com/products/reporting-analytics/index.html

Error when deploying report builder model

I get the following error when I try to deploy a report builder model. The SQL Server 2005 "Reporting Services" are installed and running on the local machine.

TITLE: Microsoft Semantic Model Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

BUTTONS:

though! You can find it here: http://www.synaptris.com/products/reporting-analytics/index.htmlsql

Monday, March 19, 2012

Error when deploy SSIS with Deployment Wizard

I've get error when I deploy SSIS package with Deployment wizard like this

===================================

Could not save the package "C:\Documents and Settings\aun\My Documents\Visual Studio 2005\Projects\ImportCommittee\ImportCommittee\bin\Deployment\IMPORT_FS_DATA.dtsx" to SQL Server "(local)". (Package Installation Wizard)

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). The SQL statement that was issued has failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). The SQL statement that was issued has failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)

I've ever pass deploy wizard with test program (a little line of code) but when I've deploy with my real code it's return error I've show above

Thanks for your help

Pipope

Hi All -

I'm experiencing the same problem as well. Any solutions?

Thanks.

Error when deploy SSIS with Deployment Wizard

I've get error when I deploy SSIS package with Deployment wizard like this

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). The SQL statement that was issued has failed.

Program Location:

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). The SQL statement that was issued has failed.

Program Location:

I've ever pass deploy wizard with test program (a little line of code) but when I've deploy with my real code it's return error I've show above

Thanks for your help

Pipope

Hi All -

I'm experiencing the same problem as well. Any solutions?

Thanks.

Error when deleting report in Report Manager and SQL Management Studio

I am getting a rsInternalError when I try to delete a report in Report Manager and SQL Management Studio. I am able to deploy, move (as long as the report doesn't exist at the destination) and upload but not delete.

This is the error dump:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3050.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.10\Reporting Services\LogFiles\ReportServer__09_19_2007_00_02_45.log</Path>
<SystemName>HLTHS2</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!9/19/2007-00:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-00:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-00:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-00:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-01:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-01:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-02:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-02:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-02:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-03:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-04:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-04:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-05:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-05:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:02:48:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-06:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-07:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-09:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!09/19/2007-09:07:20:: Call to GetItemTypeAction(/Test).
w3wp!library!1!09/19/2007-09:07:21:: Call to CreateFolderAction(Test, /).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources/Warehouse).
w3wp!library!5!09/19/2007-09:07:22:: Call to GetItemTypeAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:07:25:: Call to CreateReportAction(Invoice Balance, /Test, True).
w3wp!library!7!09/19/2007-09:07:29:: Call to SetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPermissionsAction(/).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to ListChildrenAction(/, False).
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:29:: Call to GetPermissionsAction(/Test).
w3wp!library!1!09/19/2007-09:08:29:: Call to GetPropertiesAction(/Test, PathBased).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!9/19/2007-09:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!09/19/2007-09:15:04:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:04:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:05:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!1!09/19/2007-09:15:05:: Call to ListEventsAction().
w3wp!library!1!09/19/2007-09:15:08:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:13:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:15:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:18:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!1!09/19/2007-09:15:18:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!7!09/19/2007-09:15:18:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:18:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!5!09/19/2007-09:15:18:: Call to DeleteItemAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:19:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item)
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item)
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

w3wp!library!5!09/19/2007-09:15:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component library;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

The error in the event log is:

EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005253, P9 00000000, P10 NIL.

Thanks in advance!

Lori

Just a few things that might be worth doing.

Have you got all of the latest Service Packs installed? That is Service Pack 2 for SQL Server 2005.

Are you an Administrator, Content Manager or Publisher in Report Manager? You could check the Site Settings then look at the 3 links in the Security pane to make sure you are allocated the correct levels of security to complete the tasks.

Graham

|||

Yes, I have Service Pack 2 installed for SQL Server 2005 (vers. 9.00.3050) and all the permissions are setup correctly. I'm setup as the browser, content manager, my reports, publisher and report builder. I'm also part of the Administrators group.

Lori

|||

Has anyone figured this out yet? I have the same problem. I have SP2 installed and have all roles assigned to my user account. No one else (admins and such) can delete either. We can do everything else such as deploy and run, but not delete.

|||

I turned off the global "NOCOUNT" for SQL Server and this fixed my problem.

Lori

Error when deleting report in Report Manager and SQL Management Studio

This is the error dump:

The error in the event log is:

EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005253, P9 00000000, P10 NIL.

Thanks in advance!

Lori

Just a few things that might be worth doing.

Have you got all of the latest Service Packs installed? That is Service Pack 2 for SQL Server 2005.

Graham

|||

Lori

|||

I turned off the global "NOCOUNT" for SQL Server and this fixed my problem.

Lori

Friday, February 24, 2012

Error Trying to Deploy Report - SQL Server CTP 2005

I have a report that tests inthe design environment OK.
When trying to deploy I get an error
"a connnection could not be made to the report Server
http://localhost/reportServer"
What causes this? How do I correct this?
I'm logged in with admin priviledges to SQL server;
There are several questions similar to this in the post and on GoogleI'm curious, why is your deployment site 'localhost' (hopefully, this is
localhost on the production server, which means you have vs.net running in
production)?
I have a similar problem, because of the way DNS handles the localhost
translation in our production environment. As a workaround, simply use the
upload functionality on your production server(s) to upload the .RDL (and
then define shared datasources as needed).
Rob
"Sammy" wrote:
> I have a report that tests inthe design environment OK.
> When trying to deploy I get an error
> "a connnection could not be made to the report Server
> http://localhost/reportServer"
> What causes this? How do I correct this?
> I'm logged in with admin priviledges to SQL server;
> There are several questions similar to this in the post and on Google|||It is localhost because I'm testing the functionality of Reporting Server on
a single user machine.
"tutor" wrote:
> I'm curious, why is your deployment site 'localhost' (hopefully, this is
> localhost on the production server, which means you have vs.net running in
> production)?
> I have a similar problem, because of the way DNS handles the localhost
> translation in our production environment. As a workaround, simply use the
> upload functionality on your production server(s) to upload the .RDL (and
> then define shared datasources as needed).
> Rob
> "Sammy" wrote:
> > I have a report that tests inthe design environment OK.
> > When trying to deploy I get an error
> > "a connnection could not be made to the report Server
> > http://localhost/reportServer"
> >
> > What causes this? How do I correct this?
> >
> > I'm logged in with admin priviledges to SQL server;
> >
> > There are several questions similar to this in the post and on Google|||Sammy,
How did you install RS2005? Did you choose the default configuration?
Or did you opt to configure manually?
If the latter, how have you configured Reporting Services?
Have you confirmed that the Reporting Services service is running?
Have you confirmed that the TCP/IP protocol is enabled?
Andrew Watt
MVP - InfoPath
On Tue, 1 Nov 2005 22:22:01 -0800, "Sammy"
<Sammy@.discussions.microsoft.com> wrote:
>I have a report that tests inthe design environment OK.
>When trying to deploy I get an error
>"a connnection could not be made to the report Server
>http://localhost/reportServer"
>What causes this? How do I correct this?
>I'm logged in with admin priviledges to SQL server;
>There are several questions similar to this in the post and on Google|||It turns out it was a configuration problem on my part . I fixed it and it
works fine
"Andrew Watt [MVP - InfoPath]" wrote:
> Sammy,
> How did you install RS2005? Did you choose the default configuration?
> Or did you opt to configure manually?
> If the latter, how have you configured Reporting Services?
> Have you confirmed that the Reporting Services service is running?
> Have you confirmed that the TCP/IP protocol is enabled?
> Andrew Watt
> MVP - InfoPath
> On Tue, 1 Nov 2005 22:22:01 -0800, "Sammy"
> <Sammy@.discussions.microsoft.com> wrote:
> >I have a report that tests inthe design environment OK.
> >When trying to deploy I get an error
> >"a connnection could not be made to the report Server
> >http://localhost/reportServer"
> >
> >What causes this? How do I correct this?
> >
> >I'm logged in with admin priviledges to SQL server;
> >
> >There are several questions similar to this in the post and on Google
>

Error trying to deploy Report

I have a report which works perfectly well within Visual Studio in design. However as soon as I try to deploy this to the Report Server it throws the following error:

w3wp!library!6!02/12/2007-16:29:17:: i INFO: Call to CreateReport( 'Defects by Application (Inactive and Active by Severity) Chart', '/AET Deployment', def)
w3wp!library!6!02/12/2007-16:29:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.DBInterface.CreateObject(Guid id, String shortName, String fullPath, String parentPath, Guid parentId, ItemType objectType, Byte[] objectContent, Guid intermediateSnapshotID, Guid link, String linkPath, ItemProperties objectProperties, String parameters, Byte[] createdBySid, String createdByName, DateTime creationDate, String mimeType)
at Microsoft.ReportingServices.Library.DBInterface.CreateObject(Guid id, String shortName, String fullPath, String parentPath, Guid parentId, ItemType objectType, Byte[] objectContent, Guid intermediateSnapshotID, Guid link, String linkPath, ItemProperties objectProperties, String parameters, String createdBy, DateTime creationDate, String mimeType)
at Microsoft.ReportingServices.Library.CatalogItemCreator.CreateItem()
at Microsoft.ReportingServices.Library.CreateReportAction._CreateReport(String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.Library.CreateReportAction.CreateReport(Guid batchId, String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
End of inner exception stack trace

I cannot identify any issues in the report definition which may indicate where data truncation may occur.

Any help appreciated.

Exception error relates to some problem with the tools, you might try to deploying the report from another machine where BIDS is installed with this project, also confirm the service pack of SQL & RS used here.|||

Using RS 2005 SP1 with SQL 2000 SP3

We have tried deploying this report from a number of locations - from BIDS, from Visual Studio, from RS itself - all fail. We have been able to deploy other reports but cannot see what is causing this deployment to fail ... especially as it runs without issues in preview.

|||

Looks like we have found the issue.

I had been looking at the parameters that were being passed from the Report back to the stored procedures and had verified all of those were OK. However one of the stored procs was returning a dataset with a tinyint which was then being used as an int within other parameters. Not sure how going from tinyint to int can ever result in truncation but when we set the type to int in the stored procedure it deployed OK.

Error trying to build and deploy for first time

I'm getting a timeout error when trying to deploy my SSAS project for the first time - any suggestions on where to go from here?

Error 1 OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. 0 0
Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property Address', Name of 'Property Address' was being processed. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the 'Unit Number' attribute of the 'Property Address' dimension from the 'foo' database was being processed. 0 0
Error 4 Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure. 0 0
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property', Name of 'Property' was being processed. 0 0
Error 6 Errors in the OLAP storage engine: An error occurred while the 'Status Type ID' attribute of the 'Property' dimension from the 'foo' database was being processed. 0 0

How long time does the task take until you see the timeout error? Also, could you check network connectivity to the relational datasource? What authentication do you use?

Sunday, February 19, 2012

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

Error 1 File system error: The following file is corrupted: Physical file: \\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Product.0.dim\1.Start Date.(All).sstore. Logical file . Errors in the metadata manager. An error occurred when loading the Product dimension, from the file, '\\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Product.1.dim.xml'. Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'.
This file has nothing to do with my database/project and is not even in the solution. Why is my deploy getting failed due to this file?
AllanDear Allan,

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Edward.

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

Since I am new to Analysis, I was practicing with the BI tool by setting up different dsvs, cubes, mining structures, etc. Most of them through the wizard. Every time I reached a level that I knew I was basically wrong and things were not working I would delete the previously generated output from the wizard. I started noticing this error, after I had deleted a two mining structures (outputs of wizard), followed by deleting I believe the dimensions first and then the cube (all related). I was working on another dsv and setting up the dimension and fact tables and everything seemed fine, I generated the cube fine as well. But processing the new cube results in this error. At the time I was working in the same soln. I started a new soln -> same error. Reregistered msolap90.dll same error. deleted the xml that seemed to be causing the problem and seemed to be corrupt (I did find it in the path specified) -> still the same error. Seems like I am stuck and can't do anything any more with analysis services. I was hoping that there was a soln for this problem online, but I guess short of reinstalling there is none.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

"file system error. The following error occurred during a file operation. The system cannot find the file specified. \\?\C:Program files\Microsoft Sql Server\MSSQL.2\OLAP\Data\Touch.45.db\Project4447005.dim.xml"

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

"Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\BudOlap07.45.db\Act List1.16.dim.xml"

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

|||We had this same problem. As soon as we upgraded the target machine to SP2, the problem went away.

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Edward.

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Edward.

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

Thursday, March 29, 2012

Error when trying to deploy report

Error when trying to deploy a report using Oracle data source

Error when trying to deploy

Error when trying to deploy

Thursday, March 22, 2012

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Wednesday, March 21, 2012

Error when deploying report to server

Error when deploying report builder model

Error when deploying report builder model

Monday, March 19, 2012

Error when deploy SSIS with Deployment Wizard

Error when deploy SSIS with Deployment Wizard

Error when deleting report in Report Manager and SQL Management Studio

Error when deleting report in Report Manager and SQL Management Studio

Friday, February 24, 2012

Error Trying to Deploy Report - SQL Server CTP 2005

Error trying to deploy Report

Error trying to build and deploy for first time

Sunday, February 19, 2012

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error running report

Blog Archive

About Me