The description is as follows... The necessary network binding may already be
in use. The site has been deactivated. The data field contains the error
number. If anyone can help I would greatly appreciate it. Thanks!
Mendy
I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone:
System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used.
Is this a limitation of the SQLRS-WSS3 integration or is there a workaround?
Many thanks to anyone who can help!
I installed a new sql 2005 server and set 4 publications with subscription.
The replication is working but looks slow....It means when I change a value into a table the transaction take more than 30 secondes before it came into the synchronisation status monitor.
I saw that for each subscription my logreader agent could not start ...I have the following message.
Message
Executed as user: 280db02280db02sql. The replication agent encountered an error and is set to restart within the job step retry interval. See the previous job step history message or Replication Monitor for more information.
Message
-XCMDLINE 0
-XCancelEventHandle 00000000000007B4
-XParentProcessHandle 00000000000003C8
2007-04-20 09:54:32.109 Parameter values obtained from agent profile:
-pollinginterval 5000
-historyverboselevel 1
-logintimeout 15
-querytimeout 1800
-readbatchsize 500
-readbatchsize 500000
2007-04-20 09:54:32.109 Status: 4096, code: 20024, text: 'Initializing'.
2007-04-20 09:54:32.109 The agent is running. Use Replication Monitor to view the details of this agent session.
2007-04-20 09:54:32.125 Status: 16384, code: 20007, text: 'No replicated transactions are available.'.
2007-04-20 09:55:37.125 Status: 16384, code: 20007, text: 'No replicated transactions are available.'.
2007-04-20 09:55:37.125 Status: 0, code: 22037, text: 'The last step did not log any message!'.
2007-04-20 09:55:37.125 The last step did not log any message!
2007-04-20 09:55:37.125 Status: 0, code: 1007, text: 'Procedure or function sp_MSadd_logreader_history has too many arguments specified.'.
did some one have an idea of what is the reason ?
FYI.
Server is a HP 2CPU 4Gigs of ram under win2003 sp2 and sql2005 standard SP2 64 bits
Thx.
Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks
Hi, I'm new to the forum and also to SQL Server.
Has anybody implemented SharePoint Windows Services on top of SQL Express? I'm trying just that, but i'm encountering some problems when trying to enable Full-Text search. The configuration page for this option says that the database i'm running on does not support full-text search.
Thanks in advance,
Ulises
I have installed SharePoint Services 3.0 and have problems with backup.
Backup from SharePoint Central Administration never starts.
Application log:
Source: Windows SharePoint Ser
Event ID: 6398
The Execute method of job definition Microsoft.SharePoint.Administration.SPUpdateWorkerProcessGroup (ID d21cabd8-068c-487d-bc3c-4627fa542e26) threw an exception. More information is included below.
1387
and
The Execute method of job definition Microsoft.SharePoint.Administration.SPUpdateWorkerProcessGroup (ID e4b33475-e88b-49dc-ae4d-0447fa390518) threw an exception. More information is included below.
1387
Have tried with stsadm.exe but is stops (below are last three lines from CMD)
Progress: [Windows SharePoint Services Search] 50 percent complete.
Verbose: Starting object: Search instance.
Progress: [Search instance] 50 percent complete.
and in the application log:
Source: Windows SharePoint Ser
Event ID: 2442
The index was paused.
Context: Application 'Search', Catalog 'index file on the search server Search'
Regards, Iztok
I have installed SP2 on my report server and configured for Sharepoint access.
This is all ok.
I am able to use the webpart to create a report view but it wants the report. Is there a way to manage the report server (they way I did with reportmanager) in sharepoint. If so I have not found out how.
any ideas or links to show how I can have teh reports listed in Sharepoint?
Thanks
Hello. After I have installed Sharepoint Services 3 on the same machine as SSRS2005, I have configured both SSRS2005 and Sharepoint 3. Still I do not know if I have done this correct but a SSRS webpart is available within Sharepoint.
First question. When I deploy a report project should I still deploy to http://localhost/reportserver? This is not working but I would like to confirm that this is the correct way to do it.
Last question. Anyone who can point me to a site with good information regarding this setup? SSRS2005 SP2 and Sharepoint 3?
Kind regards
Thomas Ivarsson
Hi
I've recently upgraded from MSDE (SBS 2003 SP1 with .NET 2.0) to SQL Express SP1.
I am trying to enable full text sarching on the Sharepoint instance but whenever I go to Sharepoint central administaton and text sarching it reports that the SQL server installed does not suport this.
I can't find any documentation on this anywhere.
Admidatley the machine is a domain controller and I know this isn't recommended but surely this shouldn't stop this from working?
All components where selected when installing SQLExpress and I recieved no errors.
Any sugestions would be greatly appreciated.
Many kind thanks
Gareth
Gareth.Hunter@gmail.com
Hi my current setup is:
Server 1 - Office sharepoint server 2007
Server 2 - SQL Server 2005 with Service Pack 2 and reporting services
When I try to install the Reporting Services Add-in for Sharepoint on Server 1, I get an error - "Setup was interrupted"
Would you know how to fix it?
Thank you
If I upgrade my sharepoint Database from MSDE that comes with sharepoint, to SQL 2005 Express, will I lose my no limit on the Database size?
Normally MSDE has limit of 2GB but I guess it doesn't when installed with Sharepoint services. So if I upgrade to 2005 express, will I then get a 4 GB limit on size?
Thanks for your help
Not 100% sure if this is the right forum, but its the one i'm mostly used to ...
We run one one machine Sharepoint Services 3.0, we've added the webpart cab file. When we add the Report explorer that points to the second server running SSRS this works fine. When we add the Report Viewer that point to that same server running SSRS it works fine.
But, when we link to output of the Explorer to the Viewer, or vice versa, the page comes corrupt and we have to hide or delete one of the components.
Any ideas, i've been looking for some articles, found a hotfix but they all were on v 2.0 .....
Kind Regards
I see on the download page that the SharePoint Integration component only runs on x86. Are then any plans or timetable to release an x64 version? We run both the x64 version of SharePoint 2007 and SQL 2005.
This is the second SQL Server component (the first being the IIS Merge Replication agent) that has been released only for x86. What gives?
I am using MOSS 2007 and Reporting Services 2005. Integration part worked. But my existing report (analysis service report) with cascading parameter doesn't work in sharepoint. Every time you select a parameter you have click "Apply" to see the the cascading parameter. Is this a bug with report viewer webpart, because this works on regular sql 2005 rs viewer.
SharePointHelp
Hi everybody,
I was wondering if it's possible to use a sharepoint list as datasource in reporting services ? If yes, what's your trick ?
Is it possible to use a directory as datasource in reporting services ?
Thanks for your response,
Have a nice day,
Aurore
Hello all,
I configured Reporting Services in SharePoint Integrated Mode at a client and am running into an issue as described in this article: http://support.microsoft.com/default.aspx/kb/942530. I got the Cumulative Patch 4 (and 5) for SQL Server 2005 SP2 from Microsoft and applied it to the Reporting Services box. However, I€™m still seeing the same issue. Has anyone else run into this issue and resolved it?
Thanks.
Deepak.
Hi,
We are building a site with Windows sharepoint services and want to integrate reports from Reporting services. We know this can be done with the Report Explorer and Report viewer web parts. Our requirement is to make the site and also the reports (that are being displayed in the Report viewer web part) multilingual i.e. depending on the user's language preference, all the labels and texts on the report should get changed.
Is there some support within Reporting services to do this, or are there other ways (resource files, custom code etc.) through which this can be achieved.
Thanks a lot,
Simranjeev
I'm trying to install SharePoint 2007 and Reporting Services 2005 on the same server. However after installation Reporting Services will not load at http://localhost/Reports. Instead I get the following error:
Server Error in '/Reports' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.
Source Error:
Line 164: </webParts>
Line 165: <machineKey validationKey="DA65D9E6980E9CDB52426BF3C793EBAF7FBA3B866117F3CC" decryptionKey="9D7E984E12AA43FDECAB1E05D1E952822680D27BD1F37439" validation="SHA1" />
Line 166: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
Line 167: </system.web>
Line 168: <runtime>
Source File: C:InetpubwwwrootwssVirtualDirectoriesc76013d9-5b44-4d06-96dd-24fede1ea955web.config Line: 166
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
I assume that something is wrong with my virtual server set up. I have the Default Web Site stopped and SharePoint (80) running and set Reports and ReportServer using the Report Configuration to SharePoint (80).
I can get to http://localhost/ReportServer but I get this error when running a report from there:
Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
Has anyone set these up on the same server? Is there a document around on how to set this up?
Thanks
Kevin
I'm trying to create a subscription that places a file (excel or PDF) in sharepoint. I haven't been able to find a path that works. I was wondering if anyone else had had this issue and how they overcame it.
Thanks.
I have a Reporting Services implementation setup to run in Native mode. Reports on the server are being accessed through a Sharepoint website that has a Report Viewer control.
This is posing a problem because after the user logs into Sharepoint, they are again prompted to login to the report server. Is there a way to pass the users Sharepoint credentials to the report server to prevent this double login prompt?
Thanks in advance for your help!!!
I verified logs for reporting services integrated with SharePoint and I found many errors like this:
Cannot find site lookup info for request Uri [URL].
what is wrong with configuration?
Is there any way we can download sharepoint folders using ssis. I have a specific link(View on sharepoint) which I would like to download using ssis, Is it possible?
View 2 Replies View RelatedI am trying to do some integration between reporting services and sharepoint. I have some instructions that tell me to click on "Site Collection Features" under site settings. I go ahead and click site settings and find no "Site Collection features" link. How do I get this link to appear?
View 1 Replies View RelatedIs Microsoft planning to include reporting services extensionsion for usering Sharepoint lists as datasource in MS SQL Server 2008?
And what about reporting services extension for building semantic model on Sharepoint lists?
-- Thanks,
When i try to connected to existing configuration database it's only shows NT AUTHORITYNETWORK SERVICE as my login user for database access , when i type another user , error message " you must specifay the same user account as your farm server you wish to join " how i can change it.
please help me how i can change the configuration user and password for my singel farm server
Thanks , i fixed it ??
Setup: Windows server 2003 SP1, SQL 2005 SP2, Sharepoint Office server 2007, Report Services addin (CTP v9.00.3027).
Using the Report server configuration tool, setting Report Server Virtual directory, end up with RS Configuration tool crashing.
It appears to be happening on the task "Changing Secure connection level", & returns "System.NullReferenceException was unhandled
Message: Object reference not set to an instance of an object."
any ideas?
Dear friends,
I'm having problems changing the reporting services from native modo to integrate mode...
I saw a lot of articles and tips, but I still have problems...
For example, when I change my database setup to integrate mode there is all ok, but in the SharePoint tab has an image with error...
and in the sharepoint server when I need to grant acess to database gets an error to...
and the page that always runned :
http://CGDWX01115883/ReportServer
after I change to integrate does not work and gives me this error:
Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Exception has been thrown by the target of an invocation.
Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
SQL Server Reporting Services
This page must run ok, no?
Get Online Help
Exception has been thrown by the target of an invocation.
Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
SQL Server Reporting Services
This page must run ok, no?
http://CGDWX01115883/ReportServer
CGDWX01115883 is the report server and database server
SDC6001SPT01 is the SharePoint Server
Could someone help me?!
Thanks!
I have setup the Sharepoint 2007 Reporting Services add-in and am running into an issue. I was able to get a report to show up in a report viewer webpart once, but after that, I receive a message similiar to the following (for all reports);
'Execution 'ex2ubmetmr13vdffxciursfg' cannot be found '
Any help would be appreicated. I'm including my log file for the error as well as it should be helpful.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Daylight Time</TimeZone>
<Path>c:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServer__08_06_2007_12_33_12.log</Path>
<SystemName>DEV-AD-V2</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!6!8/6/2007-12:33:14:: i INFO: Reporting Web Server started
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!6!8/6/2007-12:33:15:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!6!8/6/2007-12:33:15:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!6!08/06/2007-12:33:18:: Call to GetItemTypeAction(/).
w3wp!library!6!08/06/2007-12:33:18:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!library!6!08/06/2007-12:33:20:: Call to ListParentsAction(/).
w3wp!library!6!08/06/2007-12:33:20:: Call to ListChildrenAction(/, False).
w3wp!library!6!08/06/2007-12:33:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!security!6!08/06/2007-12:33:22:: i INFO: Exception while running with elevated privileges
w3wp!security!6!08/06/2007-12:33:22:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!library!6!08/06/2007-12:33:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!security!6!08/06/2007-12:33:28:: i INFO: Exception while running with elevated privileges
w3wp!security!6!08/06/2007-12:33:28:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!library!6!08/06/2007-12:33:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!security!6!08/06/2007-12:33:28:: i INFO: Exception while running with elevated privileges
w3wp!security!6!08/06/2007-12:33:28:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!library!6!08/06/2007-12:33:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!security!6!08/06/2007-12:33:29:: i INFO: Exception while running with elevated privileges
w3wp!security!6!08/06/2007-12:33:29:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation.
w3wp!webserver!6!08/06/2007-12:33:29:: i INFO: Processed folder '/'
w3wp!library!9!08/06/2007-12:37:33:: Call to ListParentsAction(http://DEV-ad-v2/mySites).
w3wp!library!9!08/06/2007-12:37:33:: Call to ListParentsAction(http://DEV-ad-v2/mySites).
w3wp!library!9!08/06/2007-12:37:33:: Call to ListChildrenAction(http://DEV-ad-v2/mySites, False).
w3wp!webserver!9!08/06/2007-12:37:34:: i INFO: Processed folder 'http://DEV-ad-v2/mySites'
w3wp!library!9!08/06/2007-12:39:28:: Call to GetSystemPropertiesAction().
w3wp!library!9!08/06/2007-12:40:18:: Call to GetPermissionsAction(http://DEV-ad-v2).
w3wp!library!9!08/06/2007-12:40:18:: Call to GetSystemPropertiesAction().
w3wp!library!9!08/06/2007-12:40:18:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl).
w3wp!library!9!08/06/2007-12:40:26:: i INFO: Call to RenderFirst( 'http://DEV-ad-v2/Test Reports/Report1.rdl' )
w3wp!library!9!08/06/2007-12:40:29:: Using folder c:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesRSTempFiles for temporary files.
w3wp!webserver!9!08/06/2007-12:40:30:: i INFO: Processed report. Report='http://DEV-ad-v2/Test Reports/Report1.rdl', Stream=''
w3wp!library!9!8/6/2007-12:43:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!9!8/6/2007-12:53:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!9!08/06/2007-12:59:05:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3).
w3wp!library!9!08/06/2007-12:59:05:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Reports).
w3wp!library!9!08/06/2007-12:59:05:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents).
w3wp!library!6!08/06/2007-12:59:06:: Call to CreateFolderAction(Reports, http://DEV-ad-v2/Shared Documents).
w3wp!library!6!08/06/2007-12:59:08:: Call to CreateFolderAction(Report%20Project3, http://DEV-ad-v2/Shared Documents/Reports).
w3wp!library!6!08/06/2007-12:59:09:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Data Sources).
w3wp!library!6!08/06/2007-12:59:09:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents).
w3wp!library!6!08/06/2007-12:59:09:: Call to CreateFolderAction(Data%20Sources, http://DEV-ad-v2/Shared Documents).
w3wp!library!6!08/06/2007-12:59:10:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Data Sources/EDR.rsds).
w3wp!library!6!08/06/2007-12:59:10:: Call to CreateDataSourceAction(EDR.rsds, http://DEV-ad-v2/Shared Documents/Data Sources, True).
w3wp!library!6!08/06/2007-12:59:15:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl).
w3wp!library!6!08/06/2007-12:59:15:: Call to CreateReportAction(Report1.rdl, http://DEV-ad-v2/Shared Documents/Reports/Report Project3, True).
w3wp!library!6!08/06/2007-12:59:18:: Call to SetItemDataSourcesAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl).
w3wp!library!6!08/06/2007-13:02:46:: Call to GetPermissionsAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl).
w3wp!library!6!08/06/2007-13:02:46:: Call to ListParentsAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl).
w3wp!library!6!08/06/2007-13:02:49:: Call to GetPermissionsAction(http://DEV-ad-v2).
w3wp!library!6!08/06/2007-13:02:50:: Call to GetSystemPropertiesAction().
w3wp!library!6!08/06/2007-13:02:50:: Call to GetPermissionsAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl).
w3wp!session!6!08/06/2007-13:02:56:: i INFO: LoadSnapshot: Item with session: kabqahahtxbdrgqfqza3zf45, reportPath: http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl, userName: SHAREPOINTsystem not found in the database
w3wp!library!6!08/06/2007-13:02:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kabqahahtxbdrgqfqza3zf45' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kabqahahtxbdrgqfqza3zf45' cannot be found
w3wp!webserver!6!08/06/2007-13:02:56:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kabqahahtxbdrgqfqza3zf45' cannot be found
at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!6!08/06/2007-13:03:06:: Call to GetPermissionsAction(http://DEV-ad-v2).
w3wp!library!6!08/06/2007-13:03:06:: Call to GetSystemPropertiesAction().
w3wp!library!6!08/06/2007-13:03:07:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl).
w3wp!session!6!08/06/2007-13:03:10:: i INFO: LoadSnapshot: Item with session: dpeedqvwmpr3z155qsu54m55, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database
w3wp!library!6!08/06/2007-13:03:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'dpeedqvwmpr3z155qsu54m55' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'dpeedqvwmpr3z155qsu54m55' cannot be found
w3wp!webserver!6!08/06/2007-13:03:10:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'dpeedqvwmpr3z155qsu54m55' cannot be found
at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!6!08/06/2007-13:03:17:: Call to GetPermissionsAction(http://DEV-ad-v2).
w3wp!library!6!08/06/2007-13:03:17:: Call to GetSystemPropertiesAction().
w3wp!library!6!08/06/2007-13:03:17:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl).
w3wp!library!6!8/6/2007-13:03:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!session!6!08/06/2007-13:03:21:: i INFO: LoadSnapshot: Item with session: gn34sn55qxkdwi55k2fm4y55, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database
w3wp!library!6!08/06/2007-13:03:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gn34sn55qxkdwi55k2fm4y55' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gn34sn55qxkdwi55k2fm4y55' cannot be found
w3wp!webserver!6!08/06/2007-13:03:21:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gn34sn55qxkdwi55k2fm4y55' cannot be found
at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!6!08/06/2007-13:03:53:: Call to ListParentsAction(http://DEV-ad-v2/mySites).
w3wp!library!6!08/06/2007-13:03:53:: Call to ListParentsAction(http://DEV-ad-v2/mySites).
w3wp!library!6!08/06/2007-13:03:54:: Call to ListChildrenAction(http://DEV-ad-v2/mySites, False).
w3wp!webserver!6!08/06/2007-13:03:55:: i INFO: Processed folder 'http://DEV-ad-v2/mySites'
w3wp!library!6!08/06/2007-13:04:12:: Call to GetPermissionsAction(http://DEV-ad-v2).
w3wp!library!6!08/06/2007-13:04:12:: Call to GetSystemPropertiesAction().
w3wp!library!6!08/06/2007-13:04:12:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl).
w3wp!session!6!08/06/2007-13:04:23:: i INFO: LoadSnapshot: Item with session: s5oz5evzesse5cugbxxu1wy3, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database
w3wp!library!6!08/06/2007-13:04:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 's5oz5evzesse5cugbxxu1wy3' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 's5oz5evzesse5cugbxxu1wy3' cannot be found
w3wp!webserver!6!08/06/2007-13:04:23:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 's5oz5evzesse5cugbxxu1wy3' cannot be found
at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!6!08/06/2007-13:09:54:: Call to GetPermissionsAction(http://DEV-ad-v2).
w3wp!library!6!08/06/2007-13:09:54:: Call to GetSystemPropertiesAction().
w3wp!library!6!08/06/2007-13:09:54:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl).
w3wp!session!6!08/06/2007-13:09:57:: i INFO: LoadSnapshot: Item with session: ex2ubmetmr13vdffxciursfg, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database
w3wp!library!6!08/06/2007-13:09:57:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ex2ubmetmr13vdffxciursfg' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ex2ubmetmr13vdffxciursfg' cannot be found
w3wp!webserver!6!08/06/2007-13:09:57:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ex2ubmetmr13vdffxciursfg' cannot be found
at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!6!8/6/2007-13:13:17:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
Thank you,
John
I already tried SharePoint List Source and found some bugs in it. Ex. Duplication of records, sometimes its throw an error: A possible reason might be you are trying to retrieve too many items at a time (Batch size).
I also used SharePoint WebServices and store the records into XML file and used those files as a source to load the data into Sql Server Table.Â
Is there any other approach to pull the data from SharePoint List?
Hi,
I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production.
Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message:
Code Snippet
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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.ReportingServices2006.ReportingService2006.ListSecureMethods()
at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods()
--- End of inner exception stack trace ---
I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib.
Some info:
- SP apppool is running under domain account a
- SSRS apppool is running under domain account b
- SP uses NTLM authentication
- SP and SSRS are running on different servers
- SSRS Configuration shows all green checkmarks
Things I tried:
- Basic authentication instead of Windows Integrated on SSRS
- NTLM only instead of Negotiate on SSRS
- Settings SPN's for SSRS, didn't help
- Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list)
Does anyone have an idea about how to solve this? Any help is appreciated.
We'll be using 2014 enterprise to stage some excel files into sql. Can ssis read excel files from a sharepoint server?Â
View 4 Replies View RelatedWe couldn't get the report through SSRS deployed URL. Â We found dead locks in SQL DB end.how to proceed further issue resolution.
View 5 Replies View RelatedThere is a requirement to insert if there is a new record/update the existing record to Sharepoint. Am able to do Insert/Update to SharePoint if the data quantity is minimum, i.e, records in hundreds.
link: [URL] ....
if the records/data is more(in thousands), while updating to sharepoint, am getting below error. I tried to keep the minimal batch size, but still getting the same error.Is there any setting on Sharepoint that can be set to increase updation capability?
Error details:
 System.ServiceModel.ProtocolException: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method
is implemented properly. The first 1024 bytes of the response were: '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
[code].....
what is the cause of this error?