from with in an application using the report view can you puase a report that is taking a long time to complete and then at a latter date resume where you paused the report.
View 6 RepliesGreetings,
We periodically get the following message in our three server peer-to-peer transactional replication environment:
"One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error."
What causes a subscription to be marked inactive? What properties or settings can be adjusted to minimize or eliminate this occurrence?
Everthing seems to be running OK and then we get the message. It afflicts the higest change volume publication on our slowest overseas server.
Thanks,
BCB
I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.
The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.
Again, the app will run all packages just fine. The data is imported and the results return as "Success."
The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)
Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
pkgLocation = sPackageFolder & PackageName & ".dtsx"
pkg = app.LoadPackage(pkgLocation, Nothing)
Dim vars As Variables = pkg.Variables
vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath
pkgResults = pkg.Execute()
I have a set of reports that read from an Analysis Services cube. Permissions are managed at the cube level since different users should look at the same report but different data. This is why for those reports, the data source has Windows Integrated Security set.
Those same users should be able to subscribe to those reports, the problem is that for subscriptions to work, the data sources must store the credentials. This means the filtered reports are lost since the stored account will show all the reports for all users.
Is there any way of generating "filtered subscriptions"?
Thanks in advance
Here is the scenario:
1. have report called report_a.rdl with subscriptions attached to it
2. developed a new report called report_b.rdl with the same parameter list as report_a.rdl
3. i would like to replace report_a.rdl with report_b.rdl without losing the subscriptions.
I think this is the workflow:
1. rename report_a.rdl to report_a_old.rdl in BIDS
2. rename report_b.rdl to report_a.rdl in BIDs
3. deploy report_a.rdl to reporting server
Will that work even though the ReportID GUID will change?
We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.
We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.
Hello,
I have a dril lthrough report which takes a long time (5-7 minutes) to fetch the results. The reason is that the data it returns is huge as it fetches sales data till the lowest level.
when the users later on trz to export it to excel it takes again a lot of time and eventuallz the szstem freezes. I think the volume of export might be in the range of 14/15 MB.
Is there a way to reduce first the execution speed of the report and then secondly reduce the time to export the report?
Or a way where the report is executed once a day and everyone shares the already published report?
regards
Josh
Hi,
I'm trying to setup a subscription on a SSRS report and get the following error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
I've followed the advice given in this post but still get the same result.
The SQLAgent service is running under a domain account and the Reporting Services service running under a local account. Both these accounts are assigned to the RSExec Role in the master, msdb, ReportServer and ReportServerTempDB databases. This role has execute permissions set as per the above link.
I'm now at a loss as to what else the problem could be?
All ideas welcomed!
Steve.
Hi,
I have created a subscription for a report and this subscription is scheduled to run at specific time everyday. My subscription failed because of some stored proc issue. Is there a way to re-run the subscription. I did not know how to do this so I created a temporary subscription just to run it again. Please help!
Is there a way to specify the locale for a report subscription?
I'm using the CreateSubsciption method through the web service and need to address the "User!Language" item within my reports. Currently, it's always en-US. If I manually access the report manager and set up a subscription in there, the locale is correctly taken from my browser settings. I would like to tap into this for subscriptions.
Thank You!!!
Hi,I am trying to setup a subscription but I keep running into problems.I setup the subscription fine, I see that it creates a job in SQLServer. It shows a specific domain account as the owner and I can'tfigure out why. The problem is that this account is in a differentdomain and it's having problems authenticating when it runs. I did usethis account for the services and whatnot when I originally set it up,but I've changed the account that SQL Server and SQL Server Agent rununder, but it still uses this account as the owner. The only otherthing I can think of is that the database owner ofSystemCenterReporting is still this account. Is this why it's listingthis account as the owner of the job? Where else could it be?Thanks,Bill
View 2 Replies View RelatedWe currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.
There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?
Thanks in advance,
- Jesse Wolgamott
I am new to RS. The Report developers want a way to move a report and its subscriptions to a different RS2005 instance. They tell me they can move the report but have to manually add the subscriptions back. Is that true? Is there no friendly way to move the subscriptions?
Thanks,
Michael
I have problem with using a data-driven subscription on a report with subreports. It works fine when I remove the subreport and generates error even when I add a subreport which only consists of one textbox.
I just was curious to know if using data-driven subscription on a report with subreports is supposed to work?
Thanks,
Hello,
We are using Reporting services 2005 and have been for some time. Recently we have started using the subscriptions as well. However we have come across a problem with this.
Currently we are updating our report templates by removing them and then creating them again. This worked fine until we started using subscriptions. Now, when the reports are removed, the subscriptions that are associated with the reports are also removed.
Is there a way to update a report template, without having to remove the report first? And can this be done programmatically? The code is currently publishing the reports by calling ReportingService2005.CreateReport(name, "/" + reportFolder, false, template, null);
Thanks,
Denise.
hi
i have been tasked with creating a record of all the reports ( 200+ ) within each folder ( bout 20 ) and all the subscriptions (including parameters) for our SSRS i was wondering what the best way of doing this was (SQL query?)
i have tried creating a site map with visio but im struggling to get the subscriptions details
anyone done this before (or have any ideas) i would be very grateful
thanks
Jake
I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription?
It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience).
I am developing a windows application that will run on every client station. This application will refer to a database located on a server station. Can I use MSDE for such application and if so how many remote concurrent connection can be open simultaneously?
Eric
I am working on a windows application (C#) that utilizes ODBC to acces paradox tables (works fine thought this would be the problem database) and a WinMobile database(.sdf) in order to sync table records. What I need to do is copy the .sdf file from the winmobile device then access it with this application to check for changed records on the PC and in the mobile database then copy it back to the mobile device via RAPI.
The program compiles fine but when I try to run the application I get this error. Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) .
I have already copied the System.Data.SqlServerCe.dll to my projects bin folder and then added a reference to it in the projects Reference dialog. These were also copied to the bin folder of the project
sqlceca30.dll
The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.
sqlcecompact30.dll
Provides the compact database functionality. Required if your application will use compaction.
sqlceer30[language].dll
Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.
sqlceme30.dll
Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.
sqlceoledb30.dll
Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.
sqlceqp30.dll
The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.
sqlcese30.dll
I also added using System.Data.SqlCE to the form and the dataset designer.cs
From this code in the dateset.Designer.cs file after the run is started the eroror occurs.
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter(); Error on this line....
}
return this._adapter;
Already tried this
http://msdn2.microsoft.com/en-us/library/ms171861.aspx
Is it possible to fix this? Or work around it?
Thanks Jon Stroh
Hi
My application :
On PC : Access application + Access DB
On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB
I synchronise my DBs through ActivSync.
It runs good before Windows Mobile 5.
My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported.
So what are my solutions ?
My customer wait for there PocketPC, so I need a quick solution, I don't want to rewrite all my application now.
My application run before WM5, so now I don't want to have to pay for a Visual Studio .Net, some SQL Server, etc ....
Please, what are the solutions that won't cost me more than the time that have already lost with this new Windows Mobile 5 ?
Joël
Is there a way to control some of the windows application log settings from within the logging process of a package. Specifically the 'source' parameter which comes out as 'SQLISPackage' which i'd like to be the actual name of the package which wrote to the log, and similarly 'Category' which comes out as 'none' and I'd prefer to assign something more meaniful ?
THX
I have an instance of SSRS that will not run my report subscriptions if it is using a dedicated domain account I made for the express purpose of using it to run this service.
If I have SSRS use my personal domain account as the service account, my subscriptions run correctly. If I have SSRS use this other domain account, the subscriptions do not run.
What else do I have to configure to make this run correctly not on my personal account?
Error message below.
"ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;"
I have to search the keyword from windows application using dtSearch. when user enter the list of keywords in UI, i have to connect to dtSearch tool and based on the output return, the matched keyword should be added to database table.
Now, i have problem in connecting this tool from my application.
Thanks in advance.
Hi there, i am building a mobile app using vs 2008, the app has about 8 - 12 forms that collect data.. i am thinking of
i am trying to decide how i want to save the temporary work data while the user fills the data collection forms.
when the user selects to create a new report, i will
create a new xml file...
as user moves from form to form, i will update the file
when the user has finished filling up all the data i will create a transaction and insert the data into the sql ce database and delete the file...
i will be using sql ce 3.5
i think it supports transactions
i think it also supports identity.... i am using sql management studio 2005 standalone , so i cannot visually modify the 3.5 sdf.,..,. is there a tool for 2008 that will let me visually modify the table(s)? i dont want to use the 2008 feb community edition...
is there a better way to do this? should i skip the xml and go directly into sql ce insert (for the first record creation) and updates? i think this will be a performance killer on a win mob devilce (5.0)
p.s. i cannot store data in a class, and then commit the class to the transaction because if the application crashes i will loose class data, so xml file will be needed.,
suggestions?
I installed SQL reporting services 2005 and successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://localhost/ReportServer.
------------------------------
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
------------------------------
The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)
Can anybody provide a solution for this issue....
Thanks in advance
Nirupa
Hi there,
I have a question which I put the company that host my website but I didnt get a conclusive answer. Maybe someone here will be able to advise or help me with my situation.
I want to build a database that I will run on my local server and the front end of this will be run using a windows application. I have a website which I run the database on the remote server. What I would like to do is to be able to synchronize certain tables between the two databases (such as updating products table, or orders table). I am using sql server 2005 and I am using the sql server management studio to access my database on the remote server. I did notice there is a synchronzie button. I also came across some 3rd party tools. Not sure if that is the way to go.
If anyone as done this before or can give me any suggestions, I would be delighted.
Thanks
Anthony
HelloI use vs2008 and i try to make a simple windows program with add records to a database. The problem is the database don't store the values that i add. When i run my program (in design mode) everythynf looks fine, but if i close vs2008 and restart it again the database is empty.
Why?
Thank you
I'd like to build a simple search engine against Sql Server. Does .NET Framework provide some class to help in this task? From what I've heard there is an interface which implements it..
View 1 Replies View RelatedOK
We have always used sql servwer login to the servers for all our applications for out intranet apps
And we use windows auth to do development
So when we do that we logon to wuindows, and then just connect, with no password required
But how does an application "logon" to connect to a database
Is it just in the connection string just like sql server auth
or is it different?
Hi,
I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code:
Dim cnn As New SqlCeConnection
cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf"
cnn.Open()
But I get the following error:
The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ]
Any help would be greatly appreciated!
Leila
Hi,
Any one tell me the code to connect to .sdf file in c# windows application?And tell the requirments to conncet.My sdf file path is this
C:\Documents and Settings\koti\My Documents\Example.sdf
I write this code.It is not working
string str = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Documents and Settings\koti\My Documents\Example.sdf;SSCE:Encrypt Database=True";
SqlCeConnection cn = new SqlCeConnection(str);
cn.Open();
Ant one help me Plz...
Regards,
venkat.
I'm a database newbie, trying to decide whether to create an SQL Server or Windows Application project that uses SQL Server 2005 Express. As I understand it, the advantage of an SQL Server project is that the app deploys somehow as part of the database. If that's the case, how would I handle the scenario where the database has been updating at customer site and I need to install just a new release of the software? Would I be better of creating a Windows Application project and connecting to the database explicitly? Thank you.
View 5 Replies View RelatedI've read that microsoft.applicationblocks.data for .net v2 can't be deployed to a mobile app, and my experience bears that out. So I 'm wondering if there are application blocks for windows mobile 5 that would know how to both talk to sql server mobile and sql server 2005. I see OpenNetCF has a port but as far as I can tell, they only address sql server mobile and not talking to a sql server 2005 remote database. I can use the OpenNetCF version for my sql server mobile requirements, but I'm hoping there is an encapsulation of sqlclient calls for communication with my server db.
thanks
braden