I deployed a report I created to Reporting Services using Management Studio. From here I could create subscriptions, if I choose. I created a linked report in a different folder from the original report. I defined all the parameters for this linked report. I cannot create subscriptions for the linked report - the context menu items are grayed out.
Anyone know why this might be happening and what I can do to correct it?
We migrated ssrs from 2008 to ssrs 2014.after that we need to move only subscriptions to New 2014 report server DB.
How to proceed that.
I am trying to insert record in DB. But subscription ID is not identity column. How to do this.
Can I place old Subscription IDS in New 2014 reporting DB?
Does anyone have a sample of a CreateLinkedReport method they are using? I am using Reporting Services 2005 and Visual Basic 2005. I need the VB code and how I need to call it. I'd like to change one parameter, and then send it to select recipients using a specified schedule.
Thanks, Iris
I am trying to establish a OLEDB connection for a db2 server from SSMS adn some one tell me the settings. I haver tried different options but failed.
This is my connection string from SSIS
"Data Source=DB2W;User ID=myid;Provider=IBMDADB2.1;Persist Security Info=True;"
I gave
Linked Server: DB2W
Provider: IBM OLEDB provider for DB2
Product name: ???
DataSource: ???
Provider string:???
Location: ???
I found out how to create clustered index using TSQL, but how can you create clustered index and manage indexes using SQL Server Management Studio?
Thanks
Goldmember
Is it possible to use sql server managment studio to grant the create procedure to a user on their own schema?
View 2 Replies View RelatedI'm still receiving the emails of some subscriptions of reports that were already deleted, how these subscription could be deleted or turned off.
View 2 Replies View RelatedI have created couple report through report builder which using AS cube as the data source. Every time when I try to access the New Subscription from the web UI. It complains about "Subscriptions cannot be created because the cedentals used to run the report are not stored, or if a linked report, the link is no longer valid.".
So I went into "Properties" -> "Data Source" and use the custom data source. I've selected "Microsoft SQL Server Analysis Services" and put in the following Data Source=SQLTEST;Initial Catalog="Data Warehouse AS". I've select "Crednetials stored securely in the report server", using my Windows login and password.. and I've got the following error.
"
An error has occurred during report processing.
Query execution failed for data set 'dataSet'.
The SemanticQuery element at line 7, column 351 (namespace http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling) cannot appear under Envelope/Body/Execute/Command. "
Please help!!!
Hi,
Is there a way of passing a default parameter value into the subject title on a report subscription?
Currently there are std global variables i.e. @ReportName was executed at @ExecutionTime, but what other variables can be passed here to make it more relevant to the recipient?
Thx
I get rsInternalError...
It used to work, but I noticed that my existing email subscriptions stopped working around November...I only have a few...no one complained until now. We also just finished migrating to Exchagne 2k7. I changed the smtp settings in SSRS and the existing subscriptions seem to be mailing again.(one came today to a user who commented on it)(The email subscription issue is probably a totally separate issue related to major config changes in our mail routing etc.)
However, I cannot create any new subscriptions without getting an error. I'm not sure when it started(maybe after SP2?)...a user complained that they could run reports but couldn't generate a PDF for a long running report >15 mins at least and I started investigating the issue.
I looked on some lists and did notice that the SSRS account was not a in the MASTER and MSDB RSExecRole. The role existed in both dbs, but the account wasn't added...not sure if it ever was or if something changed...it is added now. I've restarted the server, etc.
The log entries include(what's kind of weird is that the security log is clean, using windows auth only on sql server, audit failed logins, but tracing the errors below says something about an access denied on 'xp_sqlagent_notify'
Application Log:
Event ID: 108 Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.
ReportServer____...Log
w3wp!library!1!04/18/2008-14:53:21:: Call to GetSystemPermissionsAction().
w3wp!library!6!04/18/2008-14:53:21:: Call to GetPermissionsAction(/Microsoft Operations Manager Reporting/Microsoft Windows Base Operating System/Disk Performance Analysis).
w3wp!library!6!04/18/2008-14:53:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
w3wp!extensionfactory!6!04/18/2008-14:53:21:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).
w3wp!library!5!04/18/2008-14:53:21:: Call to GetReportParametersAction(/Microsoft Operations Manager Reporting/Microsoft Windows Base Operating System/Disk Performance Analysis).
w3wp!library!5!04/18/2008-14:53:22:: Call to ListSchedulesAction().
w3wp!library!5!04/18/2008-14:53:22:: 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: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
ReportServerWebApp____...log
w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!extensionfactory!7!4/18/2008-14:53:22:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!7!4/18/2008-14:53:22:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.
w3wp!ui!7!4/18/2008-14:53:22:: e ERROR: 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.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListSchedules(String Site, Schedule[]& Schedules)
at Microsoft.ReportingServices.WebServer.ReportingService2005.ListSchedules(Schedule[]& Schedules)
w3wp!ui!7!4/18/2008-14:53:22:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: 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.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListSchedules(String Site, Schedule[]& Schedules)
at Microsoft.ReportingServices.WebServer.ReportingService2005.ListSchedules(Schedule[]& Schedules)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSchedules()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ListSchedules()
at Microsoft.ReportingServices.UI.SharedScheduleDropDown.EnsureSchedulesAreLoaded()
at Microsoft.ReportingServices.UI.SharedScheduleDropDown.SharedScheduleDropDown_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
Hi,
View 4 Replies View RelatedHi, I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
When clicking New Subscription (or Manage Shared Schedules) I get the following error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors
I can't find any information about this error. Does anyone know what is wrong?
Hello,
I am curious if you can create a subscription for a report that resides on reports manager with a dynamic date? We have a couple of reports on reports manager that require a date value and I tried to use getdate() for the value but it will not except it. Is there a way to have a subscription do something like this so the end user doesn't have to change the date parameter each time? Thanks in advance.
John
When creating a subscription, if there is an error detected at the end - it creates the subscription but might not create the sql agent job, and it doesn't give you a chance to correct the error.
View 3 Replies View RelatedHi,
I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS).
When I try and click on on the DDS button for a report I get the following message:
"Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."
1. I have set the data source to use stored credentials.
2. I'm using one simple string parameter
3. Its not a linked report
Any ideas?
regards,
avner
Hi,
I've created an SSRS report in Visual Studio 2005 which runs fine in the preview. I have a list of server names which when clicked on expands to a list of databases on the chosen server. When I click on a database it then queries a table of information and displays information on that database. The query is something like:
SELECT * FROM MyDB.dbo.DB_info
WHERE ServerName = @ServerName and DBname = @DBname
This works fine in preview mode. When I run it in SQL Management Studio via the Custom Reports menu it only works when the chosen server is the one that contains MyDB. I've run a trace and can see the query being issued when I use preview mode. However, when I run it from SSMS I don't see any query being issued to the database. This seems strange as it does return data in the instance described above and if I put MyDB into single-user mode it then complains that it can't access it so it is obviously trying to communicate with the database but not showing up on the trace. I've selected all events and only put a filter on the database name.
Seeing as all of the information is in the same table it seems odd that they query only works when the server name is the one where the database is held and that the query is not shown up in a trace. I'm running the report under the same credentials too.
I'm completely baffled by this so I'd be very grateful if someone could explain what might be happening here.
Thanks.
I have been following Creating a Mobile Application with SQL Server Mobile:
http://msdn2.microsoft.com/en-us/library/ms171908.aspx
I have successfully created the snapshot.
When performing the following:
Configure the publication for Web synchronization
In SQL Server Management Studio, in Object Explorer, expand the (local) computer node.
Right-click the Replication folder, and then choose Configure Web Synchronization
There is no option when Right-clicking the Replication folder under my local server, however there IS an option for Configuring Web Synchronization on the Replication folder under SQL Server Mobile. (Unfortunately the Configure the publication for Web Synchronization is listed BEFORE the SQLServer Mobile Task, so it is pretty confusing) So, assuming this is what the author meant, I successfully configured the Web Server and the SQLMobile shows under my default web site.
When I attempt to create a Subscription under SQLServer Mobile, I get the following error:
- Synchronizing Data (Error)
Messages
Unexpected HTTP status returned. [ 415,status = ]
HRESULT 0x80004005 (28632)
The operation could not be completed.
Am I missing something? Should the web configuration be done on my local SQL Server, not the SQLServer Mobile replication directory? If so, how come I do not have that option as suggested in the directions?
I have checked and rechecked permissions. As I mentioned, the snapshot is successfully created (verified by Right-clicking the publication and viewing the snapshot agent status)
I am running SQL Server 2005 Reporting Services. I created a subscription delivered by "Report Server File Share" and the UNC path points to a share on a Netware server. I get the following error when the schedule runs:
Failure writing file Completed.pdf : The network path was not found
The UNC path is \rmh5vol1deptimsoperhiscommon.
I can create the same subscription, but have it write to a Windows file share and everything works fine.
Does SQL Server 2005 Reporting Services support writing to a Netware share?
The title says it all. You can do it from a ADO.Net client so why not from TSQL.
It all uses the service broker stuff so why not?
hi All,
View 8 Replies View Related
Hi,
I need to subscribe one report in Reporting Services. I was compiled all fields and I said to report server that
I want excel file at one shared directory of the server.
When the report server tried to process the report I have the following messagge:
Failure writing file S16 : An unexpected error occurred in Report Processing.
What's the report want?
thanks.
Dear all
I cannot subscription report when I finished setup that the following is the error message
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The specified @category_id ('101') does not exist.
The SQL agent have already start. I don't know what happen.
I created a report based on an OLAP cube in the report designer using SSRS 2005. One of the dimension in the cube contains of the name and email address. I want to set up the subscription to this report so that it will send out the report to the subsciber's email address in a pre-set schedule. How do I assign the "Name", "Email" and "Parameter" in the subscription page so that it will loop through each name to send out the report rather than to set up multiple subscriptions if there are 500 names in the dimension. Also the information contains in the report is strictly to that subscriber only i.e. "Name" of the subscriber will be used as a parameter in the subscription to the report. Thanks.
View 1 Replies View RelatedMerge replication fails on one node with error. The merge process could not update the list of subscriptions.
(Source: MSSQL_REPL, Error number: MSSQL_ REPL-2147201010)
Cannot insert duplicate key row in object 'dbo.sysmergepublications' with unique index 'nc1sysmergepublications'.
The duplicate key value is . (Source: MSSQLServer, Error number: 2601)The subscription could not be created.
(Source: MSSQLServer, Error number: 14057) works fine on other subscribers.
I've created a linked server with a pretty basic Excel spreadsheet, and used this command to create a linked server to it:
sp_addlinkedserver ''XL_SPS_1', 'Excel', 'Microsoft.Jet.OLEDB.4.0', 'c:MyExcel.xls', null, 'Excel 8.0'
I want to use this as the data from which to build a report model. As linked servers don't show up in the Data Source View wizard, I created a view in SQL Server:
create view MyExcel
as
select * from XL_SPS_1...Sheet1$
Okay, great, now the view shows up in the DSV wizard and I can create the data source view. However, when I create a new report model based on this data source view, the Report Model Wizard tells me at "Create entities for all tables" that I've got an error when it processes dbo_MyExcel that "Table does not have a primary key."
I assume this is where the identifying attributes for the entities in the report model are taken from, so I really can't go further. Does anyone have an idea as to how to add a primary key to a linked server (Excel) in SQL 2005? Can this be done? Other than importing spreadsheet data to a SQL table, how can I get around this?
Thanks,
--Stan
How do I get data on my linked report based on my grouped subtotal and grand total from the main report. The subtotal and grand total are calculated columns.
I have a 3 columns in my matrix in the SSRS summary report. Actn_COAST, ActnCITY and NumbOfAccts.
The following is code for my summary report. The results are shown below.
SELECT Distinct ActnCITY, Count(ACCT) as NumbOfAccts,
CASE WHEN ActnCITY in ('NY', 'OH', IN, 'NJ', 'SC', 'NC') THEN 'EAST COAST'
WHEN ActnCITY IN ('CA'. 'NV', 'UT', 'WA', 'OR') THEN 'WEST COAST'
ELSE 'OTHER'
END AS Actn_COAST
FROM tbl1
where ACTNDATE between @STARTDT and @EndDT
Code for my detail report contains the following SQL
SELECT * FROM tbl1 where ACTNDATE between @STARTDT and @EndDT AND @ActnCITY = ActnCITY
I have linked my report based on the NumbOfAccts column. I am able to get data if I click any of the NumbOfAccts values related to the state I want. However when I am not sure how to make the subtotal and grand total work. I want when I click on the subtotal of either coast, I should be able to see records of that coast e.g., if I select 37 I should be able to see all the records in East Coast. If I click on the Grand Total, I only want data related to those 2 coasts.
When I setup a report with a subscription and after it runs it says that email address is invalid. We can send it internally by using the subscription but externally. We use a remote email host provider(smtp). Please help I have tried everything.. We are using sql 2005 server with windows pro.
View 8 Replies View RelatedIs there a way to trigger a Subscription from DTS?
or is there a another way to do the following:
I have a Subscription that creates a pdf file on our server. I want to archive the existing file before I create the new one.
I was thinking of using a DTS package to copy the file then trigger the report.
But, I'm open to other solutions...Thanks in advance!!!
Hi Guys,
When I try to create a new subscription I get the following erro.
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
EXECUTE permission denied on object 'sp_add_category', database 'msdb', schema 'dbo'.
Any ideas?
Cheers
Sonny
subscription create page looks like below
--------------------------------------------------------------------
Subscription: daily sales vs budget_Steel4
Home | My Subscriptions | Site Settings | Help
Search for:
Type or enter one or more search terms in the search box.
Report Delivery Options
Specify options for report delivery.
Delivered by:
Report Server File Share
File Name:
The file name is not allowed to be empty.
The file name is not valid. Avoid using special characters such as /?*:<>|+,[]"& in the file name.
Add a file extension when the file is created
Path:
The path is not valid. The path must conform to Uniform Naming Convention (UNC) format.
The path is not valid. The path must conform to Uniform Naming Convention (UNC) format.
Render Format:
XML file with report data CSV (comma delimited) TIFF file Acrobat (PDF) file Web page for IE 5.0 or later (.htm) Web page for most web browsers (.htm) Web archive Excel
Credentials used to access the file share:
User Name:
The user name is not allowed to be empty.
Password:
The password is not allowed to be empty.
Please reenter Password
Overwrite options:
Overwrite an existing file with a newer version
Do not overwrite the file if a previous version exists
Increment file names as newer versions are added
Subscription Processing Options
Specify options for subscription processing.
Run the subscription:
When the scheduled report run is complete.
At 8:00 PM every Mon, Tue, Wed, Thu, Fri of every week, starting 30/04/2008
On a shared schedule:
Select a shared schedule
Report Parameter Values
Specify the report parameter values to use with this subscription.
SSRS_DS_M
NULL
Use Default
A value is required.
SSRS_DS_D
NULL
Use Default
A value is required.
Select Month
JUL-04 AUG-04 SEP-04 OCT-04 NOV-04 DEC-04 JAN-05 FEB-05 MAR-05 APR-05 MAY-05 JUN-05 JUL-05 AUG-05 SEP-05 OCT-05 NOV-05 DEC-05 JAN-06 FEB-06 MAR-06 APR-06 MAY-06 JUN-06 JUL-06 AUG-06 SEP-06 OCT-06 NOV-06 DEC-06 JAN-07 FEB-07 MAR-07 APR-07 MAY-07 JUN-07 JUL-07 AUG-07 SEP-07 OCT-07 NOV-07 DEC-07 JAN-08 FEB-08 MAR-08 APR-08 MAY-08 JUN-08 JUL-08 AUG-08 SEP-08 OCT-08 NOV-08 DEC-08 2009-07 2009-08 2009-09 2009-10 2009-11 2009-12
A value is required.
----------------------------------------------------------------------------------------------------------
I am trying to create a report subscription on my test sql server (2005). I noticed that the "New Subscription" and "New data driven subscription" options are disabled in SSMS. "Delete all subscriptions" is the only enabled option. I do have the sql server agent running. What else must I do to enable these options?
thanks!
I have a report scheduled for email delivery at a certain time of the day. Is there a way I can execute the subscription ON DEMAND so that when ever I execute it, the report is processed and emailed? Is there a way to run the subscription from a batch file/ssis/tsql etc?
any help appreciated.
thanks
Jacob
Hello,
Is it possible to create a subscriptions for more than one report ? (I would like to pack in one e-mail three or four reports).
Thanks, Regards
Braulio