Error Changing Subscription Properties
Dec 1, 2005Hi
View 6 Replies
ADVERTISEMENT
Changing Properties In A DTS Package
Sep 26, 2000Is it possible to change the database name defined in the destinatation table definition of the transformation object programmitacally?
We have different database names between dev and prod. The package was created against dev. I'm trying to copy the package to the prod server and programmatically change the database name where necessary.
Changing Article Properties Without A New Snapshot
Jan 17, 2007In our replication environment, the subscriber is initially set up with an snapshot of the publisher database. However, after that, the subscriber and publisher are different and we can never re-initialize from a snapshot again (we purge data on the publisher to reduce the database size but do not purge the same data on the subscriber; we do this by stubbing out the stored procedures on the subscriber that purge data on the publisher).
If an article is added or dropped from the publication, using snapshot and synchronize, just these changes are propagated to the publisher (without an entire new snapshot).
However, if an Article Property is changed (change SCALL to MCALL under Statement Delivery options for the UPDATE statement), the interface REQUIRES an entire new snapshot. Is there any way I can avoid the new Snapshot? It overwrites the subscriber database and this cannot happen!
Linda
Dynamically Changing The Connection Properties
Apr 18, 2007I want to transfer data from one server to another by using SSIS. i want the connection string to be dynamic and also according to the some other variable, the transforming data is changing.
Could you provide me the solution thet how i am able to change my connetction string dynamically and the other variable too.
i am using VS 2003 as front end and SQL server 2005 as a backhand.
Due to VS.NET 2003 i am able to create DTS packages but i have to migrate it and then anly i am able to use it in JOB in SQL server agent of SQL server 2005.
is that any code or any stored procedure from which i am able to migrate DTS packages to SSIS packages.
Thank you
Changing MS SQL Server Express Table Properties
Jul 13, 2005Hi,
I have a MS SQL Server Express database wich I upsized once from MS
Access. I can connect to it and get/insert data but I can't update the
field properties.
I've used Access 2003, Visual Studio .Net and SQL Server Web Data
Administrator, but I can't change the properties of existing tables. I
cán add new tables and add their properties afterwards. Since I have a
lot of tables it would be too much work too recreate them all. So how
can I edit my existing tables?
Changing The Sync_type Option Of A Subscription
Sep 15, 2006If I create a subscription with a sync_type set to 'replication support only' is it possible to change that option to 'automatic' down the road without destroying and recreating the
subscription?
-mike
SQL 2012 :: Connection Properties Versus SSMS Server Properties
Mar 16, 2015I have an ODBC connection string that is working fine with the following properties:
Database="XXXXXXX",Network="YYYYYY"; strangely no server is specified in the string, but it is specified in the ODBC Connection file.
I am trying to do a new server registration in SSMS for this database.However, I don't understand where the network spec is placed.
Under Registered server name I've tried:
YYYYYYXXXXX
When I browse the server for the database instance list, I receive "network path was not found".
I even tried:"XXXXXXX",Network="YYYYYY" for the registered server name.Same error message.
What am I doing wrong ?
Subscription Error : Failure Sending Mail: An Error Has Occurred During Report Processing
Nov 16, 2007
Hello,
On the development server, I am trying to work with subscriptions . Report Server is windows authenticated.
When no paramters exist for the report, the sucbscription is successful.
But if there are paramters for the report, email delivery fails.
These are not data driven subscriptions.
Did anyone face the same problem ? Can anyone tell me where to start debugging since logfiles just say failure to send the email.
Thanks,
SqlNew
The Requested Properties Cannot Be Supported - Error
Mar 28, 2007I have a strange issue on my local test environment (Win XP Pro SP 2 - SQL server 2000 with SP4 and IIS 5.1 ), where I get an error in the Select statement if I do not include the database owner prefix, like "select * from patients where PID< 200".
If I change it to "Select * from hprs.patients where PID<200" it works fine.
However, in more complex SQL, where I have joins, and sub queries, I still get errors on my local test machine, but the live server works fine.
I use the calls in classic ASP pages on a web site and I did not get this before, only after I re-instaled SQL Server 2000 to fix another issue I had on my machine.
On the live server (also SQL Server 2000) I do not get the error.
Is there a setting I can change on my local dvelopment environment so that it is not a requirement to include the DB owner in the SQL?
Any help with this will certainly save me a lot of re writing tons of SQL so I can still test before publishing.
Thanks - Hans
The Requested Properties Cannot Be Supported. Error '80040e21'
Jul 12, 2007Hi,
I get this error "sometimes" on sql server 2000 (
The requested properties cannot be supported. error '80040e21'
when running the code below multiple times.
Any solutions for this ?
thanks in advance
gr.
Peter
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Mode = 3 '1 = adModeReadOnly
Conn.Open ConnectString
SqlSend= "Select top 30 * from tab1 WITH (UPDLOCK,readpast) where x<>'' and RecordNumber > 6200000 and Status= 2 and processed <> 3 ORDER BY RecordNumber"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Cursortype=0
rs.Cursorlocation =2
rs.LockType= 3
rs.Open SqlSend, Conn < here it gives the error
Error When Right Clicking On Database And Selecting Properties
Oct 31, 2007
Can anyone help?
When I select the database and right click. I receive the following error:
Cannot show requested dialog
Additional Information:
Cannot show requested dialog (sqlMgmt)
Property Owner is not available for Database '[DB_name]'. This property may not exist for this object,
or may not be retrievabledue to insufficient access rights. (Microsoft.SqlServer.Smo)
I am using SQL server 2005.
IIS Error On New Subscription
Mar 9, 2006hi. i was following the newbie's guide: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
on the creating a new subscription i was doing okay until i get to the last part wherein i click finish and this error pops up when it starts synchronizing data..
An error has occured on the computer running IIS. Try restarting the IIS server.
i already tried restarting the server.. is there anything else i can do to make it work?
Subscription Error 415
May 2, 2006I am getting the following error when attempting to create a SQL Server Mobile subscription:
Synchronizing Data (Error)
Messages
Unexpected HTTP status returned. [ 415,status = ]
HRESULT 0x80004005 (28632)
The operation could not be completed.
I have attempted this with more than one database (SQL Server 2005). The snapshot was created successfully. The Web configuration was completed successfully. All my security logins (DB and authentication) have the correct permissions and I have followed Microsoft's instructions perfectly (over and over again!).
I am using a MS Server2003 R2 box, Service Pack 1. All of my Mobile 5.0 components installed successfully.
This is a data formatting issue, but I am attempting with an empty table (3 fields) to make it as simple as possible. In fact, the first time through the instructions I used their SQLMobile database created with Microsoft's script. Same ending, same issue. I cannot create a SQL Server Mobile subscription.
I should mention that this error occurs on the 2nd task "Synchronizing Data".
What URL should be tested prior to subscribing - HTTP://MyBox/MyAppName? What should be the expected results? Right now, I get a page does not exist - of course, there are no pages, just the dll in the virtual directory.
I have Sharepoint Central Administration and Team Foundation Server web sites running. In addition,
Subscription Error
Dec 27, 2006Hi!
I get a strange error on some report subscriptions. The following is the stack trace:
ReportingServicesService!library!13!12/27/2006-08:07:05:: 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.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
--- End of inner exception stack trace ---
The exact same subcription worked before and if i stop and start the RS service and does a test with the subscription right after it will work. However , when i change it back to the original time it´s the same thing all over again. I found this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1033707&SiteID=1
Which says that it will be fixed in SP2. So basically i am just wondering if i got the same problem and should wait for SP2 or if i have different problem but the same error message?
Pull Subscription Error
Sep 20, 2000When doing a pull subscription where the schema is also replicated, the snapshot fails with the message " The process could not create the file
[machine name]D$MSSQL7ReplDataunc[Publisher Name]DateTable Name.sch
There is an OS Error Code of 5 saying Acces is denied.
The file mentioned above is created, so perhaps it fails trying to create a file for the next table.
Thanks for any light that you can shed!
Bill
Subscription Error Notification
Nov 7, 2007Hi,
How can I set up my data-driven subscription reports so I get notified when an execution or delivery error occurs?
Regards,
Greg McNamara
Error When Creating Subscription
Nov 7, 2007I have a client who is getting an error when they try to create a report subscription. The error is as follows:
An unexpected error occurred: A subscription delivery error has occurred. ---> A subscription delivery error has occurred. ---> One of the extension parameters is not valid for the following reason: The account you are using does not have administrator priviledges. A subscription cannot be created for [email address].
The thing I find strange is that the client was able to create a shared schedule with no problems, so I don't see how they don't have administrator privileges. The shared schedules and subscriptions are created programmatically through a web application if that is of any importance.
Any ideas on how to fix this error?
Report Subscription Error
Apr 30, 2008Hi 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.
----------------------------------------------------------------------------------------------------------
Subscription Error- RsServerConfigurationError
Feb 23, 2007Hi,
I created a report and am testing the data driven subscription to email it to myself. It is processed with 1 error. The status says "rsServerConfigurationError".
I opened the log file and it says
GetPermissions:<the report name>
Call to GetSystemPermissions
does this mean i don't have enough permissions? I'm the admin in the server. What else do i need?
Any ideas?
Thanks.
SQL Server 2005: Collation Conflict Error When Selecting Database Properties
Mar 27, 2006I have just upgraded to SQL Server 2005 from SQL Server 2000.In Microsoft SQL Server Management Studio, when I click on databaseproperties, I receive the following error:-Cannot resolve the collation conflict between"Latin1_General_CI_AS"and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.(Microsoft SQL Server, Error: 468)Some reference suggest that I can change the database collation byclicking database properties!What can I do?
View 21 Replies View RelatedEmail Subscription Error On Credentials
Sep 18, 2007Hello,
When trying to subscribe to an report via email I get to following error
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)
Can anybody help me with this issue.
Greetings
Vinnie
Error Setting Up Report Subscription
Apr 25, 2007I receive the following error when I try to save a subscription after configuring it. I appreciate any insight that anyone has.
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
The EXECUTE permission was denied on the object 'sp_add_category', database 'msdb', schema 'dbo'.
Error Creating A New Pull Subscription
Dec 7, 2005Hi
View 10 Replies View RelatedError In Create Subscription Wizard
Dec 4, 2005When 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 RelatedParameter Driven Subscription - Error
Apr 22, 2008I have set up a parameter driven subscription and am having strange results. This subscription is being set up as Web-archive, including the report and link.
At first when setting up the report, I didn't have a default value set in the report, but would choose it in the subscription and would see an error saying the parameter value provided is not valid. After seeing the error I would edit the subscription and see the parameter value was blank. This would happen if the subscription was set to start after at least a few hours. This didn't matter if I chose the subscription schedule or using a shared schedule.
When I set up a subscription the same way, but then had it delivered within the next few minutes, the report would work fine, using the given parameter.
Since one of reports is being sent to a manager, I put in a default parameter value and set up a few subscriptions. I was hoping at least if the subscription "didn't remember" the parameter value, the default would be used and delivered. I was right, the report was delivered using only the default... but will only be delivered using the default.
There have been quite a few people posting similar questions, but none of them are answered.
Any help is greatly appreciated.
Thanks in advance,
Eric
Ps - here is some of the log file relating to one of the failed subscriptions:
From: ReportServerService*.log
ReportingServicesService!library!10!4/19/2008-02:00:05:: i INFO: Schedule 93453b16-89d3-48d1-a470-d7a09fc163b6 executed at 4/19/2008 2:00:05 AM.
ReportingServicesService!library!10!4/19/2008-02:00:05:: i INFO: Schedule 93453b16-89d3-48d1-a470-d7a09fc163b6 execution completed at 4/19/2008 2:00:05 AM.
ReportingServicesService!dbpolling!10!4/19/2008-02:00:05:: i INFO: EventPolling finished processing item e40d5803-bb69-4d20-bd55-797074969348
ReportingServicesService!dbpolling!12!4/19/2008-02:00:05:: i INFO: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!4/19/2008-02:00:05:: i INFO: EventPolling processing item fe04012c-6376-4599-b980-6aa1c77036fd
ReportingServicesService!library!f!4/19/2008-02:00:05:: i INFO: Schedule 93453b16-89d3-48d1-a470-d7a09fc163b6 executed at 4/19/2008 2:00:05 AM.
ReportingServicesService!schedule!f!4/19/2008-02:00:05:: Creating Time based subscription notification for subscription: f2551ca1-f6b8-4394-8036-7fa8a9be1070
ReportingServicesService!library!f!4/19/2008-02:00:05:: i INFO: Schedule 93453b16-89d3-48d1-a470-d7a09fc163b6 execution completed at 4/19/2008 2:00:05 AM.
ReportingServicesService!dbpolling!f!4/19/2008-02:00:05:: i INFO: EventPolling finished processing item fe04012c-6376-4599-b980-6aa1c77036fd
ReportingServicesService!dbpolling!12!4/19/2008-02:00:05:: i INFO: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!4/19/2008-02:00:05:: i INFO: NotificationPolling processing item d1e8f484-659e-48a1-a5da-747108ce63af
ReportingServicesService!library!f!04/19/2008-02:00:06:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties.
ReportingServicesService!library!f!04/19/2008-02:00:06:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'day' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'day' is not a valid value.
ReportingServicesService!notification!f!04/19/2008-02:00:06:: Notification d1e8f484-659e-48a1-a5da-747108ce63af completed. Success: False, Status: , DeliveryExtension: Report Server Email, Report: Daily RTS time, Attempt 0
ReportingServicesService!dbpolling!f!04/19/2008-02:00:06:: i INFO: NotificationPolling finished processing item d1e8f484-659e-48a1-a5da-747108ce63af
Error Delivering Subscription Email
Mar 19, 2008Env: SQL Server 2000 Reporting Services - 8.00.1042.00 on Windows Server 2003 SP1 - Microsoft Windows NT 5.2.3790.0
I configured a report subscription to send an email out, but I did not realize that the mail send was tied to my account. When someone removed my windows login from the local admin group, the report delivery errored with:
"Failure sending mail: The permissions granted to user '<Domain><user>' are insufficient for performing this operation."
My login has been reinstated, but how do I configure the send mail to use a different account? Note that he report server is running under the "NT AuthorityNetworkService" account (unfortunately). I'm hoping I don't have to deal with the unattended execution account because the docs on that are awkward.
TIA,
-Peter
Subscription/Data Sync Error
Sep 28, 2006Dear All
Iam receiving an error message when trying to complete the subscription. Please find the below given error report that I get from SQL server.
Synchronizing Data (100%) (Error)
Messages
· A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)
The schema script '\MAINsnapshotuncMAIN_SQLMOBILE_TEST20060926133385MembershipData_2.sch' could not be propagated to the subscriber.
HRESULT 0x800704CF (0)
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)
The operation could not be completed.
Error Creating Subscription To Reports
Nov 20, 2006Hi all,
I am having a HUGE issue with SSRS, I am running SQL 2005 on Win 2003 server, the SQL uses SQL and windows permissions.
I have a datasource which stores it credentials securely on the server but for some reason when i try to subscribe to the report it errors saying
"Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked server the link is no longer valid."
Beats me but the credentials are stored, I am connecting using a user account which can run the report fine (This is proven).
I have SP1 installed, and have literally tried every last option in the book.
N.B i have read all the existing post about this and i seem to have a different issue, I am not using any paraeters in the report i am trying to test and i dont use anything like USR!USERID
Please help!
Andy
Report Manager - Subscription Error
Feb 14, 2008
Hello All,
I have created few reports and deployed the reports ot Report Server. When i tried to create new subscription(to schedule the report) for the report, i am getting the below 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
Please let me know the solution in this regard.
Thanks,
SR.
RDA Push Error Another User Has Opened The Database With Different Instance-level Initialization Properties. [ 32 ]
Mar 3, 2008
Hi all,
I'm using VS2005 + SQL Compact 3.1 and Enterprise Library 3.1 May 2007
I can successfully create a db using pull method, when I try to push back data I got the following SQLCE error:
"Another user has opened the database with different instance-level initialization properties. [ 32 ]"
Before calling the push method I did
SqlCeDatabase eCE = Helper.GetDB() as SqlCeDatabase;
eCE.CloseSharedConnection();
SqlCeConnectionPool.CloseSharedConnections();
SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess();
rda.InternetUrl = webSynchronizationUrl;
rda.InternetLogin = webuser;
rda.InternetPassword = webpass;
rda.LocalConnectionString = eCE.ConnectionStringWithoutCredentials;
but after the assignment the LocalConnectionString is different from ConnectionStringWithoutCredentials, there are much more ssce parameters.
What I don't understand is:
why I'm getting this error even after closing the connection ?
Since the error report [32] the ssce conflicting parameters shoud be AUTO_SHRINK_THRESHOLD, FLUSH_INTERVAL and MAX_DATABASE_SIZE
I tried to cut & paste the same values from LocalConnectionString into app.config connection string, at first It seemed to work, but now I got the same error.
Any help will be greatly appreciated
Thanks
Error Adding Stored Proc To Subscription
Dec 14, 2007I am trying to add a data driven subscription to my report. When I get to the screen to enter the Delivery Query, I enter the stored procedure (GetStatusReportData) in the query box. When i try to validate, I get a "Query is not valid" error. If I replace the stored procedure name with a generic query (select * from jobs), it works fine.
Is there some sort of syntax I need to use to enter a stored procedure here? I have used "exec GetStatusReportData" and that did not work either.
Thanks,
Stuart Fox
RS 2005: Subscription Fails With Internal Error
Dec 19, 2006Hi all,
I have a (for me) strange problem with subscribing reports.
I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.
Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:
Failure writing file LIS04 : An internal error occurred on the report
server. See the error log for more details.
The Log file contains the following: (I highlighted what I think to be the key error)
ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: 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.OverflowException: Arithmetic operation resulted in an overflow. at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
--- End of inner exception stack trace ---
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
Does anyone have an idea what goes wrong here?
Best regards
Florian
Subscription Error: Invalid Email Address
Apr 11, 2007(NOTE: FROM a NON-IT PERSON) We've implented SQL 2005 and Reporting Services, but our subscriptions only work internally: when we try to send reports via subscriptions to valid external email addresses, we get a message: invalid email address and the entire subscription does not work.. PLEASE ADVISE. IT WILL BE GREATLY APPRECIATED!