Thursday, March 29, 2012
etl best practice
With As there's a lot of ETL.
How much is there with report builder ? I've seen the up-coming versionn
of the erp system Dynamics Ax and it looks as if there is no ETL at all -
they
just build a report model ontop of the production database.
Is this ok ? Give's realtime but is the transaction database structue okay
for building larger reporting solutions ?
/Michael V.I think you need to perform the etl to get to the datasource view state,
then you may want to build an AS 2005 cube, or a report object model or
both. My point is the etl gets you to the intermediary point. ETL may not
be required, but may be waranted for the same reasons we used etl processes
in AS 2000. I'm not familiar with Dynamics Ax.
Steve MunLeeuw
"michael v" <test@.test.com> wrote in message
news:OxB7TjZzGHA.3440@.TK2MSFTNGP06.phx.gbl...
> Hi
> With As there's a lot of ETL.
> How much is there with report builder ? I've seen the up-coming versionn
> of the erp system Dynamics Ax and it looks as if there is no ETL at all -
> they
> just build a report model ontop of the production database.
> Is this ok ? Give's realtime but is the transaction database structue okay
> for building larger reporting solutions ?
> /Michael V.
>
Estimating Table Sizes
using in the database? I would like to be able to generate a report
that can display the amount of disk space a table is consuming.How about using sp_spaceused?
RLF
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegroups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>|||Hello,
Go to the specific database and execute the below command to get the space
usage for all tables individually.
EXEC sp_MSForEachTable 'EXEC sp_spaceused [?]';
Thanks
Hari
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegroups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>|||On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
wrote:
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
Make sure you run DBCC UPDATEUSAGE on the database before you run
sp_spaceused
Reports and corrects inaccuracies in the sysindexes table, which may
result in incorrect space usage reports by the sp_spaceused system
stored procedure.
M A Srinivas|||On Mar 15, 2:07 am, "M A Srinivas" <masri...@.gmail.com> wrote:
> On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
> wrote:
> > Is it possible to write a query that can estimate the space a table is
> > using in the database? I would like to be able to generate a report
> > that can display the amount of disk space a table is consuming.
> Make sure you run DBCC UPDATEUSAGE on the database before you run
> sp_spaceused
> Reports and corrects inaccuracies in the sysindexes table, which may
> result in incorrect space usage reports by the sp_spaceused system
> stored procedure.
> M A Srin
Thank you all for these suggestions. This is exactly what I am
looking for. I was not clear on my initial request but the
MSforeachtable stored procedure was exactly what I was looking for.
Thursday, March 22, 2012
Escape Character
Definition Language? Some data I'm including inside of a tag contains the
'>' character, and it appears to be confusing things. I'd like to retain that
character by escaping it.
Thanks.Have you installed SP1? I can include the character without trouble...
"Darin" wrote:
> Does anyone know if there is an escape sequnce you can use in Report
> Definition Language? Some data I'm including inside of a tag contains the
> '>' character, and it appears to be confusing things. I'd like to retain that
> character by escaping it.
> Thanks.|||Ok, I typed the wrong character. It is the '<' character, not the '>'
character.
Yes I have SP1 installed.
"Mary Bray [SQL Server MVP]" wrote:
> Have you installed SP1? I can include the character without trouble...
> "Darin" wrote:
> > Does anyone know if there is an escape sequnce you can use in Report
> > Definition Language? Some data I'm including inside of a tag contains the
> > '>' character, and it appears to be confusing things. I'd like to retain that
> > character by escaping it.
> >
> > Thanks.
Errow whilst initializing report server!
After installation, I was told by the wizard that I needed to initialize the report server manually...
So I went to:
http://uacl-sql2/reports
It redirects to:
http://uacl-sql2/reports/Pages/Folder.aspx
And I get the following error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The system cannot find the file specified.
Does anyone know how to fix this...I have ensured that my Reports folder allows everyone to have full access...so I do not believe it is a security issue'?
Help!
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=c26e67c885b3477087ec7fc247396beb
*****************************************I can only think that you may have to use rsactivate (a command line utility
installed with Reporting Services). The syntax would be:
rsactivate -m RSServerName -u Username -p Password.
where username and password is the Windows account with admin priveleges to
the Reporting Services Service. This command would be run on the dbserver.
If this does not work you may need to use rsconfig (another installed
command line tool) prior to using rsactivate. rsconfig sets the connection
to the ReportServer database and the options can be viewed with rsconfig /?.
This should add the symetric keys in and activate or initialize the server.
Hope this helps.
Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
www.apress.com
"Jared Smith via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c26e67c885b3477087ec7fc247396beb@.SQLMonster.com...
>I have an urgent problem which I hope someone can help me with.
> After installation, I was told by the wizard that I needed to initialize
> the report server manually...
> So I went to:
> http://uacl-sql2/reports
> It redirects to:
> http://uacl-sql2/reports/Pages/Folder.aspx
> And I get the following error:
>
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help The system cannot find the
> file specified.
>
> Does anyone know how to fix this...I have ensured that my Reports folder
> allows everyone to have full access...so I do not believe it is a
> security issue'?
> Help!
> *****************************************
> * This message was posted via http://www.sqlmonster.com
> *
> * Report spam or abuse by clicking the following URL:
> *
> http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=c26e67c885b3477087ec7fc247396beb
> *****************************************|||I ran the rsactivate utility as you suggested and was returned with:
"Unable to find Reporting Services WMI namespace =on <machinename>. Reporting Services may not be installed"
Very odd...any suggestions?
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=48b8b00053c34af6b32f676a46089d07
*****************************************|||Jared,
I would check the ReportServer service on the Report Server through
Administrative Tools\Services to see if it is started. If not, try to start
it and record any errors. Also, check to see if that service is set to logon
at NT Authority\NetworkService on the Log On ta in the properties of the
ReportServer Service itself. You may need to reinstall and one of the
options during install is how you want the service to start. Have you tried
rsconfig on the Report Server? Also, I assume that the Report Server and
ReportServer database are on the same system (from the name you specified in
the URL it appears to be the case but I am only assuming)?
Rodney Landrum, Author "Pro SQL Server Reporting Services" (Apress)
www.apress.com
"Jared Smith via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:48b8b00053c34af6b32f676a46089d07@.SQLMonster.com...
>I ran the rsactivate utility as you suggested and was returned with:
> "Unable to find Reporting Services WMI namespace => on <machinename>. Reporting Services may not be installed"
> Very odd...any suggestions?
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
> *
> * Report spam or abuse by clicking the following URL:
> *
> http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=48b8b00053c34af6b32f676a46089d07
> *****************************************|||Hi Rodney,
The rsconfig appeares to run fine. The service is also running fine, however I changed the login details to be an administrator, and restarted it....
Something odd i did notice in the logs was the same error I get when attempting to initialize the report server i.e. The system cannot find the file specified.
I have pasted the log details below...any ideas?
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__11_08_2004_13_41_25.log</Path>
<SystemName>UACL-SQL2</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!c38!11/8/2004-13:41:25:: i
INFO: Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!c38!11/8/2004-13:41:25:: i
INFO: Reporting Services starting SKU: Standard
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Execution Log Entry Expiration timer enabled: Cycle: 44314 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!1140!11/8/2004-13:41:25:: i INFO: Initializing crypto as user: UACL-SQL2\Administrator
ReportingServicesService!crypto!1140!11/8/2004-13:41:25:: i INFO: Exporting public key
ReportingServicesService!library!1140!11/8/2004-13:41:25:: Exception caught while starting service. Error: System.IO.FileNotFoundException: The system cannot find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!1140!11/8/2004-13:41:25:: Attempting to start service again...
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=03200d71bc3149edb4cc19ae7dd1db2f
*****************************************
Error-Unable to get report parameters:Unable to access Web Service
to get the following error:
"Unable to get report parameters: Unable to access Web Service: The request
failed with HTTP status 403: Forbidden."
We are calling Render() in code using an account which has admin rights to
the RS box, is not locked out, etc. Event logs show no failures and the RS
logs are as useless as ever. I see no access denieds from Windows auditing
either.
Thoughts?
thanks muchHi,
Thanks for your posting!
From your descriptions, I understood that you are not able to access Web
Service with the error message "Unable to get report parameters: Unable to
access Web Service: The request failed with HTTP status 403: Forbidden."
Have I understood you? Correct me if I was wrong.
Based on my knowledge, it seems that "anonymous" for Reportserver virual
folder is enabled. Please try the following steps and let me know whether
it works
1. Right click ReportServer in IIS->Properties->Directory Security
2. Make sure "Intergrated Windows authentication" is checked and "enable
anonymouse access" is unchecked.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael, I looked at my anonymous setting but it was set properly.
By chance, I tried to execute http://server/reportserver/reportservice.asmx
and it said that there were no permissions to execute scripts in this virtual
root. Sure enough, I looked at the ReportServer virtual root config and the
Execute permissions were improperly set. Not sure how changed, but once I
put it back to "Scripts and Executables" I was good.
Thanks much
"Michael Cheng [MSFT]" wrote:
> Hi,
> Thanks for your posting!
> From your descriptions, I understood that you are not able to access Web
> Service with the error message "Unable to get report parameters: Unable to
> access Web Service: The request failed with HTTP status 403: Forbidden."
> Have I understood you? Correct me if I was wrong.
> Based on my knowledge, it seems that "anonymous" for Reportserver virual
> folder is enabled. Please try the following steps and let me know whether
> it works
> 1. Right click ReportServer in IIS->Properties->Directory Security
> 2. Make sure "Intergrated Windows authentication" is checked and "enable
> anonymouse access" is unchecked.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hi,
Thanks for your prompt updates!
It's great to hear that it did turn out to be an authority issue and you
yourself have resolved it.
Thank you for your patience and corporation. If you have any questions or
concerns on SQL Server, don't hesitate to let me know. We are always here
to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql
Wednesday, March 21, 2012
Errors when trying to open the report designer
Studio .NET 2003) and I am getting several errors, here is the first one:
"Package 'ReportDesignerPackage' has failed to load properly ( GUID = {11B8903-8FFD-4Dfc-87CEF6A82D77AF68} ). Please contact package vendor for
assistance. Would you like to disable loading this package in the future?
You may use 'devenv/resetskippkgs' to re-enable package loading. Application
restart is recommended, due to possible environment corruption."
This error is followed by several more "Package failed to load properly"
ones before the report designer finally opens (but it will not load my
reporting services project folders and files).
Other people can open this solution without a problem. Is there some
security setting that is causing me to get these errors' Help please.
--
LaurieTHave a look to these articles
http://support.microsoft.com/?id=823245
http://support.microsoft.com/?id=830968
--
Bien cordialement
Med Bouchenafa
"LaurieT" <LaurieT@.discussions.microsoft.com> a écrit dans le message de
news: 05A1B2AE-4F32-4A80-AE7A-C57E4ED5E4D7@.microsoft.com...
>I am trying to open a report solution using the report designer (Visual
> Studio .NET 2003) and I am getting several errors, here is the first one:
> "Package 'ReportDesignerPackage' has failed to load properly ( GUID => {11B8903-8FFD-4Dfc-87CEF6A82D77AF68} ). Please contact package vendor for
> assistance. Would you like to disable loading this package in the future?
> You may use 'devenv/resetskippkgs' to re-enable package loading.
> Application
> restart is recommended, due to possible environment corruption."
> This error is followed by several more "Package failed to load properly"
> ones before the report designer finally opens (but it will not load my
> reporting services project folders and files).
> Other people can open this solution without a problem. Is there some
> security setting that is causing me to get these errors' Help please.
> --
> LaurieT
Errors using report designer with ssas based report model
errors with Report Builder as far as I can tell. However with Report
Designer, the layout displays the cube elements but errors on preview as
follows:
"The 'PerspectiveId' custom property for the 'query' perspective is either
not set or is not set to the string data type."
This is an error that has cropped up before but I'm not aware of a bug
report for it. The forum and blog guidance I have for fixing it is to:
- Create a report builder report and save it to file
- Copy the customproperties xml subtree and paste it into the Report
Designer report
I have done this but unfortunately this also errors on reopening the report
as follows:
"A connection cannot be made to the database. Set and test the connection
string. Additional information: TODO - change code to use RsProxy object
(Microsoft.ReportingServices.QueryDesigners)"
Notwithstanding the slightly disconcerting TODO comment lingering in the
code, can anyone advise cause and resolution/workaround?
Thanks in advance
David
using:
- SQL Server 2005 Analysis Services 9.0.3042
- Windows XP Pro SP2
- Visual Studio 2005 SP1
-- report designer rdl follows
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="dataSource1">
<DataSourceReference>dataSource1</DataSourceReference>
<rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<Height>5cm</Height>
</Body>
<rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<CommandText><SemanticQuery
xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
<Hierarchies>
<Hierarchy>
<BaseEntity>
<!--DimGeneric-->
<EntityID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
</BaseEntity>
<Groupings>
<Grouping Name="Generic Description">
<Expression Name="Generic Description">
<AttributeRef>
<!--Generic Description-->
<AttributeID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
</Groupings>
</Hierarchy>
</Hierarchies>
--start of report builder sourced subtree
<CustomProperties>
<CustomProperty Name="qd:PerspectiveID">
<Value
xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
</CustomProperty>
</CustomProperties>
--end of report builder sourced subtree
</SemanticQuery></CommandText>
<DataSourceName>dataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="Generic_Description">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Generic Description</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>16cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>I have also noticed that if I open a Report Builder report in Report Designer
and change the data source guid to match the data source in the report server
project, the preview displays the expected results and the generic query
designer view also works as expected, but the "query could not be loaded"
message still appears when attempting to use the data tab without the query
designer.
"David Norman" wrote:
> I have created a report model based on an SSAS database. It is usable without
> errors with Report Builder as far as I can tell. However with Report
> Designer, the layout displays the cube elements but errors on preview as
> follows:
> "The 'PerspectiveId' custom property for the 'query' perspective is either
> not set or is not set to the string data type."
> This is an error that has cropped up before but I'm not aware of a bug
> report for it. The forum and blog guidance I have for fixing it is to:
> - Create a report builder report and save it to file
> - Copy the customproperties xml subtree and paste it into the Report
> Designer report
> I have done this but unfortunately this also errors on reopening the report
> as follows:
> "A connection cannot be made to the database. Set and test the connection
> string. Additional information: TODO - change code to use RsProxy object
> (Microsoft.ReportingServices.QueryDesigners)"
> Notwithstanding the slightly disconcerting TODO comment lingering in the
> code, can anyone advise cause and resolution/workaround?
> Thanks in advance
> David
> using:
> - SQL Server 2005 Analysis Services 9.0.3042
> - Windows XP Pro SP2
> - Visual Studio 2005 SP1
> -- report designer rdl follows
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <DataSources>
> <DataSource Name="dataSource1">
> <DataSourceReference>dataSource1</DataSourceReference>
> <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> </DataSource>
> </DataSources>
> <BottomMargin>2.5cm</BottomMargin>
> <RightMargin>2.5cm</RightMargin>
> <PageWidth>21cm</PageWidth>
> <rd:DrawGrid>true</rd:DrawGrid>
> <InteractiveWidth>21cm</InteractiveWidth>
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Body>
> <ColumnSpacing>1cm</ColumnSpacing>
> <Height>5cm</Height>
> </Body>
> <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> <LeftMargin>2.5cm</LeftMargin>
> <DataSets>
> <DataSet Name="DataSet1">
> <Query>
> <CommandText><SemanticQuery
> xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> <Hierarchies>
> <Hierarchy>
> <BaseEntity>
> <!--DimGeneric-->
> <EntityID
> xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> </BaseEntity>
> <Groupings>
> <Grouping Name="Generic Description">
> <Expression Name="Generic Description">
> <AttributeRef>
> <!--Generic Description-->
> <AttributeID
> xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> </AttributeRef>
> </Expression>
> </Grouping>
> </Groupings>
> </Hierarchy>
> </Hierarchies>
> --start of report builder sourced subtree
> <CustomProperties>
> <CustomProperty Name="qd:PerspectiveID">
> <Value
> xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> </CustomProperty>
> </CustomProperties>
> --end of report builder sourced subtree
> </SemanticQuery></CommandText>
> <DataSourceName>dataSource1</DataSourceName>
> </Query>
> <Fields>
> <Field Name="Generic_Description">
> <rd:TypeName>System.String</rd:TypeName>
> <DataField>Generic Description</DataField>
> </Field>
> </Fields>
> </DataSet>
> </DataSets>
> <Width>16cm</Width>
> <InteractiveHeight>29.7cm</InteractiveHeight>
> <Language>en-US</Language>
> <TopMargin>2.5cm</TopMargin>
> <PageHeight>29.7cm</PageHeight>
> </Report>|||It appears this error does not occur for the same report model on a PC which
doesn't have VS2005 SP1 installed!
"David Norman" wrote:
> I have also noticed that if I open a Report Builder report in Report Designer
> and change the data source guid to match the data source in the report server
> project, the preview displays the expected results and the generic query
> designer view also works as expected, but the "query could not be loaded"
> message still appears when attempting to use the data tab without the query
> designer.
> "David Norman" wrote:
> > I have created a report model based on an SSAS database. It is usable without
> > errors with Report Builder as far as I can tell. However with Report
> > Designer, the layout displays the cube elements but errors on preview as
> > follows:
> >
> > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > not set or is not set to the string data type."
> >
> > This is an error that has cropped up before but I'm not aware of a bug
> > report for it. The forum and blog guidance I have for fixing it is to:
> >
> > - Create a report builder report and save it to file
> > - Copy the customproperties xml subtree and paste it into the Report
> > Designer report
> >
> > I have done this but unfortunately this also errors on reopening the report
> > as follows:
> >
> > "A connection cannot be made to the database. Set and test the connection
> > string. Additional information: TODO - change code to use RsProxy object
> > (Microsoft.ReportingServices.QueryDesigners)"
> >
> > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > code, can anyone advise cause and resolution/workaround?
> >
> > Thanks in advance
> > David
> >
> > using:
> > - SQL Server 2005 Analysis Services 9.0.3042
> > - Windows XP Pro SP2
> > - Visual Studio 2005 SP1
> >
> > -- report designer rdl follows
> > --
> >
> > <?xml version="1.0" encoding="utf-8"?>
> > <Report
> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > <DataSources>
> > <DataSource Name="dataSource1">
> > <DataSourceReference>dataSource1</DataSourceReference>
> > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > </DataSource>
> > </DataSources>
> > <BottomMargin>2.5cm</BottomMargin>
> > <RightMargin>2.5cm</RightMargin>
> > <PageWidth>21cm</PageWidth>
> > <rd:DrawGrid>true</rd:DrawGrid>
> > <InteractiveWidth>21cm</InteractiveWidth>
> > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > <rd:SnapToGrid>true</rd:SnapToGrid>
> > <Body>
> > <ColumnSpacing>1cm</ColumnSpacing>
> > <Height>5cm</Height>
> > </Body>
> > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > <LeftMargin>2.5cm</LeftMargin>
> > <DataSets>
> > <DataSet Name="DataSet1">
> > <Query>
> > <CommandText><SemanticQuery
> > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > <Hierarchies>
> > <Hierarchy>
> > <BaseEntity>
> > <!--DimGeneric-->
> > <EntityID
> > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > </BaseEntity>
> > <Groupings>
> > <Grouping Name="Generic Description">
> > <Expression Name="Generic Description">
> > <AttributeRef>
> > <!--Generic Description-->
> > <AttributeID
> > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > </AttributeRef>
> > </Expression>
> > </Grouping>
> > </Groupings>
> > </Hierarchy>
> > </Hierarchies>
> >
> > --start of report builder sourced subtree
> >
> > <CustomProperties>
> > <CustomProperty Name="qd:PerspectiveID">
> > <Value
> > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > </CustomProperty>
> > </CustomProperties>
> >
> > --end of report builder sourced subtree
> >
> > </SemanticQuery></CommandText>
> > <DataSourceName>dataSource1</DataSourceName>
> > </Query>
> > <Fields>
> > <Field Name="Generic_Description">
> > <rd:TypeName>System.String</rd:TypeName>
> > <DataField>Generic Description</DataField>
> > </Field>
> > </Fields>
> > </DataSet>
> > </DataSets>
> > <Width>16cm</Width>
> > <InteractiveHeight>29.7cm</InteractiveHeight>
> > <Language>en-US</Language>
> > <TopMargin>2.5cm</TopMargin>
> > <PageHeight>29.7cm</PageHeight>
> > </Report>|||I finally found a bug report on Connect for SQL Server 2005 SP2 (Client Tools)
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
Microsoft will "consider fixing it in a future release". There is no
workaround listed, and I have found nothing better than selectively removing
and adding the customproperties subtree to enable different parts of the
report designer (which of course is a big nuisance).
BTW thanks world for not replying to my posts!
"David Norman" wrote:
> It appears this error does not occur for the same report model on a PC which
> doesn't have VS2005 SP1 installed!
> "David Norman" wrote:
> > I have also noticed that if I open a Report Builder report in Report Designer
> > and change the data source guid to match the data source in the report server
> > project, the preview displays the expected results and the generic query
> > designer view also works as expected, but the "query could not be loaded"
> > message still appears when attempting to use the data tab without the query
> > designer.
> >
> > "David Norman" wrote:
> >
> > > I have created a report model based on an SSAS database. It is usable without
> > > errors with Report Builder as far as I can tell. However with Report
> > > Designer, the layout displays the cube elements but errors on preview as
> > > follows:
> > >
> > > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > > not set or is not set to the string data type."
> > >
> > > This is an error that has cropped up before but I'm not aware of a bug
> > > report for it. The forum and blog guidance I have for fixing it is to:
> > >
> > > - Create a report builder report and save it to file
> > > - Copy the customproperties xml subtree and paste it into the Report
> > > Designer report
> > >
> > > I have done this but unfortunately this also errors on reopening the report
> > > as follows:
> > >
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. Additional information: TODO - change code to use RsProxy object
> > > (Microsoft.ReportingServices.QueryDesigners)"
> > >
> > > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > > code, can anyone advise cause and resolution/workaround?
> > >
> > > Thanks in advance
> > > David
> > >
> > > using:
> > > - SQL Server 2005 Analysis Services 9.0.3042
> > > - Windows XP Pro SP2
> > > - Visual Studio 2005 SP1
> > >
> > > -- report designer rdl follows
> > > --
> > >
> > > <?xml version="1.0" encoding="utf-8"?>
> > > <Report
> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > > <DataSources>
> > > <DataSource Name="dataSource1">
> > > <DataSourceReference>dataSource1</DataSourceReference>
> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > > </DataSource>
> > > </DataSources>
> > > <BottomMargin>2.5cm</BottomMargin>
> > > <RightMargin>2.5cm</RightMargin>
> > > <PageWidth>21cm</PageWidth>
> > > <rd:DrawGrid>true</rd:DrawGrid>
> > > <InteractiveWidth>21cm</InteractiveWidth>
> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> > > <Body>
> > > <ColumnSpacing>1cm</ColumnSpacing>
> > > <Height>5cm</Height>
> > > </Body>
> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > > <LeftMargin>2.5cm</LeftMargin>
> > > <DataSets>
> > > <DataSet Name="DataSet1">
> > > <Query>
> > > <CommandText><SemanticQuery
> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > > <Hierarchies>
> > > <Hierarchy>
> > > <BaseEntity>
> > > <!--DimGeneric-->
> > > <EntityID
> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > > </BaseEntity>
> > > <Groupings>
> > > <Grouping Name="Generic Description">
> > > <Expression Name="Generic Description">
> > > <AttributeRef>
> > > <!--Generic Description-->
> > > <AttributeID
> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > > </AttributeRef>
> > > </Expression>
> > > </Grouping>
> > > </Groupings>
> > > </Hierarchy>
> > > </Hierarchies>
> > >
> > > --start of report builder sourced subtree
> > >
> > > <CustomProperties>
> > > <CustomProperty Name="qd:PerspectiveID">
> > > <Value
> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > > </CustomProperty>
> > > </CustomProperties>
> > >
> > > --end of report builder sourced subtree
> > >
> > > </SemanticQuery></CommandText>
> > > <DataSourceName>dataSource1</DataSourceName>
> > > </Query>
> > > <Fields>
> > > <Field Name="Generic_Description">
> > > <rd:TypeName>System.String</rd:TypeName>
> > > <DataField>Generic Description</DataField>
> > > </Field>
> > > </Fields>
> > > </DataSet>
> > > </DataSets>
> > > <Width>16cm</Width>
> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> > > <Language>en-US</Language>
> > > <TopMargin>2.5cm</TopMargin>
> > > <PageHeight>29.7cm</PageHeight>
> > > </Report>|||This is peer supported. Plus, MS people do not tend to be here. Although if
you have MSDN subscription you can do a managed newsgroup where you register
an alias and they guarantee I believe an answer in two days.
The fact no one answered means that people doing this for no pay and just
because they want to help did not jump in because they did not know an
answer.
In the future if you do not get an answer here you might try the web forums.
Different people hang out there and also more MS people hang out there.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Oh, by the way. I assume at some point you might want help in the future.
Being hostile is a great way to get someone to help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
>I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
>Tools)
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> Microsoft will "consider fixing it in a future release". There is no
> workaround listed, and I have found nothing better than selectively
> removing
> and adding the customproperties subtree to enable different parts of the
> report designer (which of course is a big nuisance).
> BTW thanks world for not replying to my posts!
> "David Norman" wrote:
>> It appears this error does not occur for the same report model on a PC
>> which
>> doesn't have VS2005 SP1 installed!
>> "David Norman" wrote:
>> > I have also noticed that if I open a Report Builder report in Report
>> > Designer
>> > and change the data source guid to match the data source in the report
>> > server
>> > project, the preview displays the expected results and the generic
>> > query
>> > designer view also works as expected, but the "query could not be
>> > loaded"
>> > message still appears when attempting to use the data tab without the
>> > query
>> > designer.
>> >
>> > "David Norman" wrote:
>> >
>> > > I have created a report model based on an SSAS database. It is usable
>> > > without
>> > > errors with Report Builder as far as I can tell. However with Report
>> > > Designer, the layout displays the cube elements but errors on preview
>> > > as
>> > > follows:
>> > >
>> > > "The 'PerspectiveId' custom property for the 'query' perspective is
>> > > either
>> > > not set or is not set to the string data type."
>> > >
>> > > This is an error that has cropped up before but I'm not aware of a
>> > > bug
>> > > report for it. The forum and blog guidance I have for fixing it is
>> > > to:
>> > >
>> > > - Create a report builder report and save it to file
>> > > - Copy the customproperties xml subtree and paste it into the Report
>> > > Designer report
>> > >
>> > > I have done this but unfortunately this also errors on reopening the
>> > > report
>> > > as follows:
>> > >
>> > > "A connection cannot be made to the database. Set and test the
>> > > connection
>> > > string. Additional information: TODO - change code to use RsProxy
>> > > object
>> > > (Microsoft.ReportingServices.QueryDesigners)"
>> > >
>> > > Notwithstanding the slightly disconcerting TODO comment lingering in
>> > > the
>> > > code, can anyone advise cause and resolution/workaround?
>> > >
>> > > Thanks in advance
>> > > David
>> > >
>> > > using:
>> > > - SQL Server 2005 Analysis Services 9.0.3042
>> > > - Windows XP Pro SP2
>> > > - Visual Studio 2005 SP1
>> > >
>> > > -- report designer rdl follows
>> > > --
>> > >
>> > > <?xml version="1.0" encoding="utf-8"?>
>> > > <Report
>> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
>> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
>> > > <DataSources>
>> > > <DataSource Name="dataSource1">
>> > > <DataSourceReference>dataSource1</DataSourceReference>
>> > >
>> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
>> > > </DataSource>
>> > > </DataSources>
>> > > <BottomMargin>2.5cm</BottomMargin>
>> > > <RightMargin>2.5cm</RightMargin>
>> > > <PageWidth>21cm</PageWidth>
>> > > <rd:DrawGrid>true</rd:DrawGrid>
>> > > <InteractiveWidth>21cm</InteractiveWidth>
>> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
>> > > <rd:SnapToGrid>true</rd:SnapToGrid>
>> > > <Body>
>> > > <ColumnSpacing>1cm</ColumnSpacing>
>> > > <Height>5cm</Height>
>> > > </Body>
>> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
>> > > <LeftMargin>2.5cm</LeftMargin>
>> > > <DataSets>
>> > > <DataSet Name="DataSet1">
>> > > <Query>
>> > > <CommandText><SemanticQuery
>> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
>> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
>> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
>> > > <Hierarchies>
>> > > <Hierarchy>
>> > > <BaseEntity>
>> > > <!--DimGeneric-->
>> > > <EntityID
>> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
>> > > </BaseEntity>
>> > > <Groupings>
>> > > <Grouping Name="Generic Description">
>> > > <Expression Name="Generic Description">
>> > > <AttributeRef>
>> > > <!--Generic Description-->
>> > > <AttributeID
>> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
>> > > </AttributeRef>
>> > > </Expression>
>> > > </Grouping>
>> > > </Groupings>
>> > > </Hierarchy>
>> > > </Hierarchies>
>> > >
>> > > --start of report builder sourced subtree
>> > >
>> > > <CustomProperties>
>> > > <CustomProperty Name="qd:PerspectiveID">
>> > > <Value
>> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
>> > > </CustomProperty>
>> > > </CustomProperties>
>> > >
>> > > --end of report builder sourced subtree
>> > >
>> > > </SemanticQuery></CommandText>
>> > > <DataSourceName>dataSource1</DataSourceName>
>> > > </Query>
>> > > <Fields>
>> > > <Field Name="Generic_Description">
>> > > <rd:TypeName>System.String</rd:TypeName>
>> > > <DataField>Generic Description</DataField>
>> > > </Field>
>> > > </Fields>
>> > > </DataSet>
>> > > </DataSets>
>> > > <Width>16cm</Width>
>> > > <InteractiveHeight>29.7cm</InteractiveHeight>
>> > > <Language>en-US</Language>
>> > > <TopMargin>2.5cm</TopMargin>
>> > > <PageHeight>29.7cm</PageHeight>
>> > > </Report>|||Didn't intend to be hostile, sorry it came across that way. Hope someone gets
some benefit from my investigations.
"Bruce L-C [MVP]" wrote:
> This is peer supported. Plus, MS people do not tend to be here. Although if
> you have MSDN subscription you can do a managed newsgroup where you register
> an alias and they guarantee I believe an answer in two days.
> The fact no one answered means that people doing this for no pay and just
> because they want to help did not jump in because they did not know an
> answer.
> In the future if you do not get an answer here you might try the web forums.
> Different people hang out there and also more MS people hang out there.
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
> Oh, by the way. I assume at some point you might want help in the future.
> Being hostile is a great way to get someone to help.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
> news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
> >I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
> >Tools)
> >
> > http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> >
> > Microsoft will "consider fixing it in a future release". There is no
> > workaround listed, and I have found nothing better than selectively
> > removing
> > and adding the customproperties subtree to enable different parts of the
> > report designer (which of course is a big nuisance).
> >
> > BTW thanks world for not replying to my posts!
> >
> > "David Norman" wrote:
> >
> >> It appears this error does not occur for the same report model on a PC
> >> which
> >> doesn't have VS2005 SP1 installed!
> >>
> >> "David Norman" wrote:
> >>
> >> > I have also noticed that if I open a Report Builder report in Report
> >> > Designer
> >> > and change the data source guid to match the data source in the report
> >> > server
> >> > project, the preview displays the expected results and the generic
> >> > query
> >> > designer view also works as expected, but the "query could not be
> >> > loaded"
> >> > message still appears when attempting to use the data tab without the
> >> > query
> >> > designer.
> >> >
> >> > "David Norman" wrote:
> >> >
> >> > > I have created a report model based on an SSAS database. It is usable
> >> > > without
> >> > > errors with Report Builder as far as I can tell. However with Report
> >> > > Designer, the layout displays the cube elements but errors on preview
> >> > > as
> >> > > follows:
> >> > >
> >> > > "The 'PerspectiveId' custom property for the 'query' perspective is
> >> > > either
> >> > > not set or is not set to the string data type."
> >> > >
> >> > > This is an error that has cropped up before but I'm not aware of a
> >> > > bug
> >> > > report for it. The forum and blog guidance I have for fixing it is
> >> > > to:
> >> > >
> >> > > - Create a report builder report and save it to file
> >> > > - Copy the customproperties xml subtree and paste it into the Report
> >> > > Designer report
> >> > >
> >> > > I have done this but unfortunately this also errors on reopening the
> >> > > report
> >> > > as follows:
> >> > >
> >> > > "A connection cannot be made to the database. Set and test the
> >> > > connection
> >> > > string. Additional information: TODO - change code to use RsProxy
> >> > > object
> >> > > (Microsoft.ReportingServices.QueryDesigners)"
> >> > >
> >> > > Notwithstanding the slightly disconcerting TODO comment lingering in
> >> > > the
> >> > > code, can anyone advise cause and resolution/workaround?
> >> > >
> >> > > Thanks in advance
> >> > > David
> >> > >
> >> > > using:
> >> > > - SQL Server 2005 Analysis Services 9.0.3042
> >> > > - Windows XP Pro SP2
> >> > > - Visual Studio 2005 SP1
> >> > >
> >> > > -- report designer rdl follows
> >> > > --
> >> > >
> >> > > <?xml version="1.0" encoding="utf-8"?>
> >> > > <Report
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> >> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> >> > > <DataSources>
> >> > > <DataSource Name="dataSource1">
> >> > > <DataSourceReference>dataSource1</DataSourceReference>
> >> > >
> >> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> >> > > </DataSource>
> >> > > </DataSources>
> >> > > <BottomMargin>2.5cm</BottomMargin>
> >> > > <RightMargin>2.5cm</RightMargin>
> >> > > <PageWidth>21cm</PageWidth>
> >> > > <rd:DrawGrid>true</rd:DrawGrid>
> >> > > <InteractiveWidth>21cm</InteractiveWidth>
> >> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> >> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> >> > > <Body>
> >> > > <ColumnSpacing>1cm</ColumnSpacing>
> >> > > <Height>5cm</Height>
> >> > > </Body>
> >> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> >> > > <LeftMargin>2.5cm</LeftMargin>
> >> > > <DataSets>
> >> > > <DataSet Name="DataSet1">
> >> > > <Query>
> >> > > <CommandText><SemanticQuery
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> >> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> >> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> >> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> >> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> >> > > <Hierarchies>
> >> > > <Hierarchy>
> >> > > <BaseEntity>
> >> > > <!--DimGeneric-->
> >> > > <EntityID
> >> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> >> > > </BaseEntity>
> >> > > <Groupings>
> >> > > <Grouping Name="Generic Description">
> >> > > <Expression Name="Generic Description">
> >> > > <AttributeRef>
> >> > > <!--Generic Description-->
> >> > > <AttributeID
> >> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> >> > > </AttributeRef>
> >> > > </Expression>
> >> > > </Grouping>
> >> > > </Groupings>
> >> > > </Hierarchy>
> >> > > </Hierarchies>
> >> > >
> >> > > --start of report builder sourced subtree
> >> > >
> >> > > <CustomProperties>
> >> > > <CustomProperty Name="qd:PerspectiveID">
> >> > > <Value
> >> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> >> > > </CustomProperty>
> >> > > </CustomProperties>
> >> > >
> >> > > --end of report builder sourced subtree
> >> > >
> >> > > </SemanticQuery></CommandText>
> >> > > <DataSourceName>dataSource1</DataSourceName>
> >> > > </Query>
> >> > > <Fields>
> >> > > <Field Name="Generic_Description">
> >> > > <rd:TypeName>System.String</rd:TypeName>
> >> > > <DataField>Generic Description</DataField>
> >> > > </Field>
> >> > > </Fields>
> >> > > </DataSet>
> >> > > </DataSets>
> >> > > <Width>16cm</Width>
> >> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> >> > > <Language>en-US</Language>
> >> > > <TopMargin>2.5cm</TopMargin>
> >> > > <PageHeight>29.7cm</PageHeight>
> >> > > </Report>
>
>sql
Monday, March 19, 2012
Errors on Datasource.aspx page
I have an installation of RS 2000 on a Win 2003 server.
I've started getting an error whenever I access the Data Source pages
using the Report Manager.
The page loads OK. But I cannot make any changes. For example, if I try
to change the "Connect Using" options from "Windows Integrated
Secuirty" to "Credentials stored securely ...", the radio button shows
the selection, but the required text boxes are not enabled, In the
bottom left corener of the IE status bar, "Error on Page" flashes.
The server log files and event logs show nothing regarding the error.
This happens on all Data Source pages on this server.
Any ideas?
It sounds like some of the javascript files are missing. Try reregistering asp.net client files by running aspnet_regiis -c from \windows\microsoft.net\framework\v1.1.4322.Sunday, March 11, 2012
Errors in SQL Server 2005 Profiler
I notice this running the SQL Server Profiler under the application name Report Server. Every time it runs, it reports an error (in the Error field of Profiler). Does anyone know what this is?
declare @.p1 nvarchar(64)
set @.p1=NULL
exec GetDBVersion @.DBVersion=@.p1 output
select @.p1
Do you mean when running Reporting Service (or just an application named Report Server?), you found errors with the statements you post? If you're talking about Reporting Service, take a look at this post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=277072&SiteId=1
To understand the error, you may take a look at:
http://msdn2.microsoft.com/en-us/library/aa256379(SQL.80).aspx
Friday, March 9, 2012
Errors exporting to excel
This only happens with certain parameter values?
--
Message posted via http://www.sqlmonster.comThere are a couple of fixes out there for Excel. Take a look at
Microsoft.com for Excel\Reporting services issues.
If you have a good repro I can do in house, please send it to me.
--
| From: "William Nichols via SQLMonster.com" <forum@.SQLMonster.com>
| Subject: Errors exporting to excel
| Date: Fri, 28 Jan 2005 13:07:35 GMT
| Organization: http://www.SQLMonster.com
| Message-ID: <b4e260ddb47c48b7bf16a89e152b3412@.SQLMonster.com>
| X-Abuse-Report: http://www.SQLMonster.com/Uwe/NB/Abuse.aspx
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 178.67-18-207.reverse.theplanet.com 67.18.207.178
| Lines: 1
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41174
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Report works fine in HTML and exporting to PDF but when exporting to
excel and opening the file we receive a notification that errors were
detected and a repair was attempted. The repair notification states that
the damage to the file was too extensive to repair and the file can be
opened with only the raw tabular data (no formatting or charts).
|
| This only happens with certain parameter values?
|
| --
| Message posted via http://www.sqlmonster.com
||||I've got the same problem!
I turned off the legend on the chart, and now it works perfectly!
Any ideas'
Try turning off the legend and let me know if that worked.
- Joel
"William Nichols via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:b4e260ddb47c48b7bf16a89e152b3412@.SQLMonster.com...
> Report works fine in HTML and exporting to PDF but when exporting to excel
> and opening the file we receive a notification that errors were detected
> and a repair was attempted. The repair notification states that the
> damage to the file was too extensive to repair and the file can be opened
> with only the raw tabular data (no formatting or charts).
> This only happens with certain parameter values?
> --
> Message posted via http://www.sqlmonster.com
Errors Configuring Reporting Services
I am trying to re-install reporting services on a server. In the report
services configuration tool,
The Server staus is Green
The Report Server Virtual Directory is Green
THe Report Manager Virtual Directory is RED
when I click on NEW... to create one I get the following error
ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual
directory specified already exists. Specify a different name.
at
ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String
virtualDirectory, String path)
but IIS Manager does not list any directory called Reports
Any ideas how I should proceed from hereThis is 2005, not Katmai? Both Config Tool and server are at same SP level?
"Bob Miller" <someone@.microsoft.com> wrote in message
news:uZGcMR83HHA.3940@.TK2MSFTNGP05.phx.gbl...
> Hi
> I am trying to re-install reporting services on a server. In the report
> services configuration tool,
> The Server staus is Green
> The Report Server Virtual Directory is Green
> THe Report Manager Virtual Directory is RED
> when I click on NEW... to create one I get the following error
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual
> directory specified already exists. Specify a different name.
> at
> ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String
> virtualDirectory, String path)
> but IIS Manager does not list any directory called Reports
> Any ideas how I should proceed from here
>|||Yes,
SQL 2005 and Service Pack 2 has been applied prior to attempting the
configuration
Cheers
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:eEOoJgD4HHA.1208@.TK2MSFTNGP05.phx.gbl...
> This is 2005, not Katmai? Both Config Tool and server are at same SP
> level?
> "Bob Miller" <someone@.microsoft.com> wrote in message
> news:uZGcMR83HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> I am trying to re-install reporting services on a server. In the report
>> services configuration tool,
>> The Server staus is Green
>> The Report Server Virtual Directory is Green
>> THe Report Manager Virtual Directory is RED
>> when I click on NEW... to create one I get the following error
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual
>> directory specified already exists. Specify a different name.
>> at
>> ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String
>> virtualDirectory, String path)
>> but IIS Manager does not list any directory called Reports
>> Any ideas how I should proceed from here
Sunday, February 26, 2012
Error:The type initializer for "Microsoft.ReportDesigner.Drawing.Language" threw an except
I've been trying to get to the bottom of this error it prevents be
from loading the report in Design Mode. As of right now when opening
a report in design mode through the VS .Net 2003 IDE I get the
following:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception.
I've tried uninstall/reinstall, reporting services service pack 1 and
debuging the devenv.exe from another ide instance. Debug error is:
System.ComponentModel.Design.Serialization.CodeDomSerializerException:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
Microsoft.DataWarehouse.Serialization.XmlSerializationException:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
System.TypeInitializationException: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
System.ArgumentException: Culture ID 31770 (0x7C1A) is not a supported
culture.
Parameter name: culture
at System.Globalization.CultureInfo..ctor(Int32 culture, Boolean
useUserOverride)
at System.Globalization.CultureTable.GetCultures(CultureTypes
types)
at Microsoft.ReportDesigner.Drawing.Language.GetStandardValues()
at Microsoft.ReportDesigner.Drawing.Language..cctor()
-- End of inner exception stack trace --
at Microsoft.ReportDesigner.Drawing.Language..ctor(String value)
at Microsoft.ReportDesigner.Drawing.LanguageConverter.CreateObject(String
value)
at Microsoft.ReportDesigner.Drawing.XmlStringListConverter.ConvertFrom(ITypeDescriptorContext
context, CultureInfo culture, Object value)
at System.ComponentModel.DefaultValueAttribute..ctor(Type type,
String value)
-- End of inner exception stack trace --
at Microsoft.ReportDesigner.Serialization.DesignXmlReader.ReadRoot(Type
type)
at Microsoft.ReportDesigner.Serialization.DesignXmlReader.DeserializeComponent(IDesignerSerializationManager
manager, XmlReader reader, Type root)
at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.DeserializeObject(IDesignerSerializationManager
manager, Object serializationStream)
at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.Deserialize(IDesignerSerializationManager
manager, Object serializationStream)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Deserialize()Hi, I got the same error here, if you already fixed this problem, please post
here waht is going on.
Thanks, Rafael
"Ricardo" wrote:
> Hi,
> I've been trying to get to the bottom of this error it prevents be
> from loading the report in Design Mode. As of right now when opening
> a report in design mode through the VS .Net 2003 IDE I get the
> following:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception.
> I've tried uninstall/reinstall, reporting services service pack 1 and
> debuging the devenv.exe from another ide instance. Debug error is:
> System.ComponentModel.Design.Serialization.CodeDomSerializerException:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> Microsoft.DataWarehouse.Serialization.XmlSerializationException:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> System.TypeInitializationException: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> System.ArgumentException: Culture ID 31770 (0x7C1A) is not a supported
> culture.
> Parameter name: culture
> at System.Globalization.CultureInfo..ctor(Int32 culture, Boolean
> useUserOverride)
> at System.Globalization.CultureTable.GetCultures(CultureTypes
> types)
> at Microsoft.ReportDesigner.Drawing.Language.GetStandardValues()
> at Microsoft.ReportDesigner.Drawing.Language..cctor()
> -- End of inner exception stack trace --
> at Microsoft.ReportDesigner.Drawing.Language..ctor(String value)
> at Microsoft.ReportDesigner.Drawing.LanguageConverter.CreateObject(String
> value)
> at Microsoft.ReportDesigner.Drawing.XmlStringListConverter.ConvertFrom(ITypeDescriptorContext
> context, CultureInfo culture, Object value)
> at System.ComponentModel.DefaultValueAttribute..ctor(Type type,
> String value)
> -- End of inner exception stack trace --
> at Microsoft.ReportDesigner.Serialization.DesignXmlReader.ReadRoot(Type
> type)
> at Microsoft.ReportDesigner.Serialization.DesignXmlReader.DeserializeComponent(IDesignerSerializationManager
> manager, XmlReader reader, Type root)
> at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.DeserializeObject(IDesignerSerializationManager
> manager, Object serializationStream)
> at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.Deserialize(IDesignerSerializationManager
> manager, Object serializationStream)
> at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Deserialize()
>|||I have problem in Reporting Services 2005 with width of report - max. limit is probably 406,34921 cm. Is it possible to increase this limit to for exapmle 450 cm ?
From http://www.developmentnow.com/g/115_2004_11_0_0_453315/ErrorThe-type-initializer-for-Microsoft-ReportDesigner-Drawing-Language-threw-an-exception.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Error:rsErrorReadingNextDataRow
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.
Which version / build of Reporting Services are you using?
Which data source are you using?
If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||
Hello Brian,
We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.
An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.
Thanks for your help.
Atul
|||Hi,
I have the same problem now, what is the solution ?
Regards.
Mario
|||Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource
Error:rsErrorReadingNextDataRow
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.
Which version / build of Reporting Services are you using?
Which data source are you using?
If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||
Hello Brian,
We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.
An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.
Thanks for your help.
Atul
|||Hi,
I have the same problem now, what is the solution ?
Regards.
Mario
|||Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource
Error:rsErrorReadingNextDataRow
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.
Which version / build of Reporting Services are you using?
Which data source are you using?
If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||
Hello Brian,
We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.
An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.
Thanks for your help.
Atul
|||Hi,
I have the same problem now, what is the solution ?
Regards.
Mario
|||Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource
|||Even i m facing same problem at client place. Did any one find the solution for this?
I guess this error might be related one of the following two things
1 Connection.
I am able to reproduce this error only when i disconnected the network during report generation.
2 Permission
The stored procedure might not have sufficient permission. Perticularly when one of the dataset depending upon another dataset. For example when we use formula to hide columns in report based on value of another dataset.
Error:rsErrorReadingNextDataRow
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.
Which version / build of Reporting Services are you using?
Which data source are you using?
If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||
Hello Brian,
We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.
An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00
When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.
Thanks for your help.
Atul
|||Hi,
I have the same problem now, what is the solution ?
Regards.
Mario
|||Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource
|||Even i m facing same problem at client place. Did any one find the solution for this?
I guess this error might be related one of the following two things
1 Connection.
I am able to reproduce this error only when i disconnected the network during report generation.
2 Permission
The stored procedure might not have sufficient permission. Perticularly when one of the dataset depending upon another dataset. For example when we use formula to hide columns in report based on value of another dataset.
error:no report server found on the specified machine while setting up reporting services config
Hello,
I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...
Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...
Can somebody please help me on this...
Thanks in advance...
Nirupa
Hello Nirupa,
Can you make sure you have IIS installed and running? If so, make sure you have /Reports and /ReportServer showing in IIS management.
Then, check to see if you have the following three folders in the C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services directory (where x is the component number for RS). LogFiles, ReportManager, & ReportServer
Hope this helps.
Jarret
|||Hi Jarret,
Thanks for your suggestions first,
yes I installed IIS and it is running,
and
I couldn't find any folder C:\Program Files\Microsoft SQL Server\MSSQL.1\ Reporting Services directory
...LogFiles, ReportManager, & ReportServer
I could see only path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ Backup
'' \Bin
'' \Install
'' \LOG
'' \repldata
'' \TemplateData
can you suggest me what might had happen.... or what shall be done
Thanks
Nirupa
|||Do you have a MSSQL.2, MSSQL.3, or MSSQL.4 folder? If so, look in each for the 3 folders I listed in my last post. If you don't have these folders, you probably should reinstall Reporting Services.
Jarret
|||Hello Jarret
I do not have the folders that you have mentioned....As you have mentioned will probably need reinstallation
Thank you
Nirupa
|||That is correct, if you don't have these folders, you don't have RS installed. Try to re-install and see if that fixes your problem.
Jarret
|||Hi Jarret,
Thanks for your suggestions.As you mentioned, I reinstalled SQL reporting services and got the above mention folders(MSSQL.1,MSSQL.2,MSSQL.3) and also I successfully configured reporting services.While trying to deploy my reporting services application in to localhost , I got the below mentioned error : " 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) "
can you please sugguest me work around for this issue.
Friday, February 17, 2012
ERROR: System.OutOfMemoryException
ERROR:
Exception of type 'System.OutOfMemoryException' was thrownBuy more RAM ¬¬
No, I'm kidding. Well, what are you exactly doing? Are you running a report
that accesses many tables or tables with many rows?|||What a great sense of humor!
However, I am just running a report via Report Manager.
http://reportserv/reports
TABLE ROWS below:
6,683
QUERY below:
SELECT Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
FROM Lists_Members AS Lists_Members INNER JOIN
List_Codes_Table AS List_Codes_Table ON
Lists_Members.LSTM_Lists_ID = List_Codes_Table.LIST_Id
GROUP BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
ORDER BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group
"F. Dwarf" wrote:
> Buy more RAM ¬¬
> No, I'm kidding. Well, what are you exactly doing? Are you running a report
> that accesses many tables or tables with many rows?|||Well, I'm still puzzled. I don't figure out what could be the problem
ERROR: Subscription
message is returned?
'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
SERVER'. The step failedI am sending the logfile for review. Thank you.
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45:: EventPolling
polling service stopped
ReportingServicesService!dbpolling!c!11/28/2005-01:34:45:: EventPolling
heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45::
NotificationPolling polling service stopped
ReportingServicesService!dbpolling!b!11/28/2005-01:34:45::
NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45:: SchedulePolling
polling service stopped
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45:: UpgradePolling
polling service stopped
ReportingServicesService!servicecontroller!9!11/28/2005-01:34:47:: Service
controller exiting.
"Terry" wrote:
> After setting up and running the report subscription, the following Job error
> message is returned?
> 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
> SERVER'. The step failed
>|||Hi Terry,
Do you allow 'NT AUTHORITY\NETWORK SERVER' to access your database?
if i not wrong, the 'NT AUTHORITY\NETWORK SERVER' don't have permission to
access the database
thanks
Nicky
Error: Subreport could not be shown. : A report with only one subreport
I created a simple report that just one item in it, a subreport. If I
run the report in my .Net Visual Studio, the report displays ok with the
subreport. When I deploy the report to the report server, the report
displays "Error: Subreport could not be shown. " message.
The main report has no parameters and the subreport's parameters are set
using the Subreport Properties dialog.
Is this a bug? What is the work around?
SteveThe main report has no datasets it is pretty much almost an empty report
except for the subreport.
The subreport has at least 4 additional subreports inside itself.
It seems if the subreport doesn't contain internal subreports inside then I
don't get the error.
"steve kwon" <steven,kwon@.lmco.com> wrote in message
news:Owxae%23CrFHA.2624@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I created a simple report with just one item in it, a subreport. If I
> run the report in my .Net Visual Studio, the report displays ok with the
> subreport. When I deploy the report to the report server, the report
> displays "Error: Subreport could not be shown. " message.
> The main report has no parameters and the subreport's parameters are
> set using the Subreport Properties dialog.
> Is this a bug? What is the work around?
> Steve
>