Deployment + XML Config file problem

Hello

I am using XML config file to store the values e.g. Server name.... it runs fine with BIDS (Development enviroment)... but when I deploy and run it to test that XML config files values are being read by e.g. giving the wrong server name, it runs fine (may be retrieving some old values). then I come bak and test it again in the development enviroment to test, it fails ( as it supposed to be caz server name is wrong in config file)

can ne one tell me wr is the problem?

ur help and support is appreciated

regards,

Anas

Sorry to bother you but that was the problem with my config file...

it is so pathetic that package running does not show ne error or warning that's y wasted a lot of time.... fortunately i was able to solve the problem b4 I go on my holidays... i big sigh of reliefs...

regards,

Anas

Deploying Reports/Models with WSS 3.0 integrated mode

Using BIDS, and trying to deploy to a newly created reporting server. I can deploy the report but cannot figure out how to display it in the WSS 3.0 teamsite. My document library settings allow 'new report builder report' and 'new report datasource' but I don't see how to upload reports built in BIDS for use in the Sharepoint site.

Models that I created in BIDS I cannot deploy at all. Just get an error saying 'this operation is not supported in sharepoint integrated mode.

Anyone else worked through the deployment of existing datasources and reports yet to a WSS 3.0 reporting server in integrated mode?

If I just upload an RDL file to the document library and try to display it, I get the following:

System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.InvalidCastException: Specified cast is not valid.
at Microsoft.ReportingServices.Library.Security.get_UserToken()
at Microsoft.ReportingServices.SharePoint.Server.SharePointSecurity.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc, String itemPath)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2006.GetPermissions(String Item, String[]& Permissions)

Which authentication mode did you choose, on the Reporting Services integration page in Central Admin? SP2 CTP2 only supports Windows Authentication mode.|||

I've changed back to the windows mode. And I'm a little better off. After publishing the RDL file in my shared documents, I'm only lacking a datasource. Can't quite figure out how to get that there.

Maybe it's time to upgrade my visual studio 2005 with the Sharepoint package for wss 3. Would that enable me to publish reports again directly from the BIDS project?

Where I'm stuck then is putting both data models and datasources up on the sharepoint site using the reporting services integrated mode.

|||

Solved the datasource issue by just creating it in the Sharepoint document library. Then hooked it up to the report I had loaded in manually using the 'Upload' menu. For the report you will find a 'manage datasources' context menu item off the report object.

Now if someone comes up with the answer of how to get the data models up to my Sharepoint server so that the report builder can be called on, I'll be in pig heaven.

|||

You can upload an .SMDL file into SharePoint, and it will "just know" that it's a Reporting Services model (because of the file extension).

In CTP3, Models are fully supported -- you can design in Model Designer, autogen from SharePoint, manage drillthroughs and model item security, and launch Report Builder from a model's ECB menu.

|||

Slowly but surely it is coming together. Now, the magical CTP3, when will that be posted?

I have a suggestion for CTP3 if you have not thought of it. These RS documents display context menus in the shared document library. But if I do a search, the search results page does not give me the ability to use the Report/Model/Datasource with the same contextual choices. Same idea when I display things with the 'dependent items' choice (which is a slick feature in and of itself). And the last display I'd expect more of would be the page that opens when you click on the found file would offer the same contextual choices. (reports open fine, but models don't link to the report builder and open)

Now wouldn't that be a totally seamless feature that would sweeten the end-user experience?

BTW, I'm still constructing datasources for each model or report I upload to a document library. Can I simply copy a datasource (extension=rds, or ds) and just change the extension to rsds before uploading it?

Deploying a SSAS solution from File location using C#

Hi all,
i have created a SSAS solution using BIDS . I have saved the project on local hard disk. Now i need to deploy the solution through C# and not use C#. Can i do that ? if how how?

Regards..
Girija Shankar

Could you describe your goals a bit more? When you create an SSAS solution with BIDS, a script file is created that can be used to deploy a database to SSAS. You could also use the ASCMD application to submit scripts or execute a script via AMO. (I believe the Server object's Execute method handles this.)

B.

|||

Hi Bryan,

Thanks for the reply. The scenario is as folows:

1. I create a SSAS solution. i create the datasource,DSv,cubes and dimensions and Roles.I donot deploy that to the server but save the file to a local drive location.

2. If i go to the local directory path where I saved the solution i will find files such as .database, .cube,.partitions, .dim etc

3. i need to deploy the full solution from this file location to the server. After deployement i can process the cubes one by one using AMO. The processing part is clear to me using AMO but how to deploy from file location i am not able to figure out . All this has to be done through code (C#).

Regards...

Girija Shankar

|||

So, the file in the BIN folder is a complete or near-complete script. You should be able to use standard techniques to read the file (it's just XML though I would read it as a simple text file). With the script in memory, you can then submit it as a string through the AMO Server object's Execute method.

You may also want to review the ASCMD project that comes with the SSAS samples. I believe it has the functionality built in to read a file and execute it like I'm describing. It's also written in C#.

B.

|||

Bryan,

There are four files in bin folder . i suppose i would be using .asdatabase file. read that,envolope that with the create and Object Tags and execute that on server. Is this correct?

Regards...

Girija Shankar

|||

Hi, Another question.

There are some read only tags such as CreatedTimestamp, should i remove them while reading that?

Regards...
Girija Shankar

|||Another option is to use the Deployment Wizard (launched from the Start menu under Microsoft SQL Server->Analysis Services). This wizard has the option to generate a deployment script which is just an XMLA

command that can be sent the the server to deploy and optionally process the cube. This script deployment can be done using Adomd.Net, an XMLA Query in SQL Management Studio, or using the ASCMD.exe command line utilility available at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en.

Deploying a SSAS solution from File location using C#

Hi all,
i have created a SSAS solution using BIDS . I have saved the project on local hard disk. Now i need to deploy the solution through C# and not use C#. Can i do that ? if how how?

Regards..
Girija Shankar

Could you describe your goals a bit more? When you create an SSAS solution with BIDS, a script file is created that can be used to deploy a database to SSAS. You could also use the ASCMD application to submit scripts or execute a script via AMO. (I believe the Server object's Execute method handles this.)

B.

|||

Hi Bryan,

Thanks for the reply. The scenario is as folows:

1. I create a SSAS solution. i create the datasource,DSv,cubes and dimensions and Roles.I donot deploy that to the server but save the file to a local drive location.

2. If i go to the local directory path where I saved the solution i will find files such as .database, .cube,.partitions, .dim etc

3. i need to deploy the full solution from this file location to the server. After deployement i can process the cubes one by one using AMO. The processing part is clear to me using AMO but how to deploy from file location i am not able to figure out . All this has to be done through code (C#).

Regards...

Girija Shankar

|||

So, the file in the BIN folder is a complete or near-complete script. You should be able to use standard techniques to read the file (it's just XML though I would read it as a simple text file). With the script in memory, you can then submit it as a string through the AMO Server object's Execute method.

You may also want to review the ASCMD project that comes with the SSAS samples. I believe it has the functionality built in to read a file and execute it like I'm describing. It's also written in C#.

B.

|||

Bryan,

There are four files in bin folder . i suppose i would be using .asdatabase file. read that,envolope that with the create and Object Tags and execute that on server. Is this correct?

Regards...

Girija Shankar

|||

Hi, Another question.

There are some read only tags such as CreatedTimestamp, should i remove them while reading that?

Regards...
Girija Shankar

|||Another option is to use the Deployment Wizard (launched from the Start menu under Microsoft SQL Server->Analysis Services). This wizard has the option to generate a deployment script which is just an XMLA

command that can be sent the the server to deploy and optionally process the cube. This script deployment can be done using Adomd.Net, an XMLA Query in SQL Management Studio, or using the ASCMD.exe command line utilility available at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en.