.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Shivakumaran
Post New Web Links

XML web service showing error in Data Source Library when I clicked on "Show Data".

Posted By:      Posted Date: November 16, 2010    Points: 0   Category :SharePoint
 

Hi ,

I am working on share point 2007.
I have added a XML Web service in Data source in Share Point designer 2007. This web service is custom web service which get data from 3 different type of list and creates XML and return that xml.

I have installed this web service as instructed in msdn. I checked it is working properly.
First time when I create a data source from XML web service in Share Point Designer 2007, It shows all records when I clicked on “Show Data ”. But after a few minutes it shows en error” The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator. ”.


Gaurav Goyal


View Complete Post


More Related Resource Links

show data in grid view error Arithmetic operation resulted in an overflow.

  

sir

i have a table there is 17 columns in 17 column 3 are number and other are varchar . when i try to display all data of that column error occures.

one more intersting think is when i try to display 6 column then grid show there data an no more error occures. 

when i run my project this error occures in grid view

Arithmetic operation resulted in an overflow. 


MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

  
Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

Data Source View Gives incorrect Error--Different Data Type

  
Hi, I'm creating a report model (2008 R2).  I am trying to create a relationship between two tables.  One FKs to another--same name and type (tinyint) columns.  But the Data Source View editor doesn't allow this, giving the message "...source and destination column have different data types".  But the columns are the same types.  I ahd this once before  acouple of years ago and don't remember how I got around it. Does anyong have ideas?  

Reporting Service Model with db2 data source?

  
Sorry if this has been already asked.  I searched, but couldn't find it any previous posts. My question is can you have db2 as a datasource in Reporting Service Model?  Currently in the drop down I can only see SQL, which we have a few models over, and Oracle.  We are using SQL server 2008 r1. If not does Microsoft have any plans to add this in the future? Thanks for any help!

Parallel Groupings are not showing the data in Reporting Service 2008.

  
Hi All, My main goal is to show rows under two adjecent groups (say A another one is B) which have one parent group lat call it as AB (all are row sections) and i have one column group for "months".The details inside the group A under the "months" group is not showing any values or expressions it returing me blank. Adjacent groups in SSRS 2008 still shows blank lines for invisible rows (why?). Any ideas.Please let me know. Veeren.

Excel Data Source SSIS AcquireConnection failed 0x80004005 unspecified error

  
Nuances of using Excel data sources with SSIS Your Development Machine Setup Needs Jet Drivers, available along with the default Office install so if you have Excel working fine locally, this is enough. Installing the "Office Data Connectivity Components" (download file name AccessDatabaseEngine.exe) as well as having Office installed corrupts the Jet Driver stack so that SSIS in VS 2008 cannot create the object to read the XLS file. You will see the title error "Unspecified Error" and "80004005" code. Resolution: Uninstall the Jet Engine pack on your development XP machine if you have Office. It will be listed as something like "Microsoft Access Database Engine (2010)". Run Office 200x setup with the Repair option and reboot. Try configuring the task in SSIS and it should be able to read the Sheet names again and columns.  Live Server (32-bit and 64-bit) Deploying your SSIS package to a server without Office 200x means it will not have the Jet Engine drivers to read XLS, XLSX files. You must install the 32-bit Office Data Connectivity Components - Jet Drivers mentioned above found here  (http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en). There are no 64-bit drivers; therefore regardless of 32 or 64-bit live environments, this step is the same. You shoul

getting error when i clicked on doucment library

  
Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)) plz help

List data validation failed error checking in dockument and uploading to library.

  
If I upload a document to the "vanilla" Document Library at the root site (I have not created sub sites yet, we are in the testing phase), the document does get uploaded but the following error appears: Error List data validation failed.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 0928c39a-f2d7-4ce6-8057-62cc01c6a951 Date and Time: 6/16/2010 5:27:58 PM Go back to site -------------------------------------------------------------------------- The doc has uploaded but is automatically checked out to me I am logged on as the ADMINISTRATOR Account Now if I try and discard the check out, it will fail as there is no original checked in version. If I try and click Check in, then the same error appears Help

Error selecting "Business Data Connectivity" service application in MSS 2010 with WCF hotfix on W8R

  
I'm getting "BDC Metadata Store is Currently Unavailable" when navigating to the External Content Types object in SPD 2010. Hot fix is installed.  No errors in the eventlog? 

Consume WCF Data service in client application throws error

  
Hi All, I am working on WCF Data service which imported stored procedure, as below.         [WebGet]         public List<GetMTSearchResultTest_Result> GettMTSearchResultTest()         {             MediaMarketResearch_PRODEntities ent = new MediaMarketResearch_PRODEntities();             return ent.GetMTSearchResultTest().ToList();         }   when i consuming this in my client application it says error as "The closed type MMRClient.MMRServiceReference.GetMTSearchResultTest_Result does not have a corresponding element settable property." I am getting this error while bind to the grid view as below. DataServiceContext context = new DataServiceContext(new Uri("http://localhost:4131/MMRDataService.svc/")); IEnumerable<GetMTSearchResultTest_Result> empResult = context.Execute<GetMTSearchResultTest_Result>(new Uri("http://localhost:4131/MMRDataService.svc/GettMTSearchResultTest"));             GridView1.DataSource = empResult;             GridView1.DataBind(); Note: I im

Consume WCF Data service in client application throws error

  
Hi All, I am working on WCF Data service which imported stored procedure, as below.         [WebGet]         public List<GetMTSearchResultTest_Result> GettMTSearchResultTest()         {             MediaMarketResearch_PRODEntities ent = new MediaMarketResearch_PRODEntities();             return ent.GetMTSearchResultTest().ToList();         }   when i consuming this in my client application it says error as "The closed type MMRClient.MMRServiceReference.GetMTSearchResultTest_Result does not have a corresponding element settable property." I am getting this error while bind to the grid view as below. DataServiceContext context = new DataServiceContext(new Uri("http://localhost:4131/MMRDataService.svc/")); IEnumerable<GetMTSearchResultTest_Result> empResult = context.Execute<GetMTSearchResultTest_Result>(new Uri("http://localhost:4131/MMRDataService.svc/GettMTSearchResultTest"));             GridView1.DataSource = empResult;             GridView1.DataBind(); Note: I im

Bussiness Data Connectivity Service error

  
Hi I created Bussiness data connectivity service application. I also started this application. When I click on this application I am getting an error message like "The requested service, 'http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc/actas' could not be activated. See the server's diagnostic trace logs for more information. Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: e6a7c44d-9956-4966-9eb5-016235d7126c Date and Time: 9/15/2010 8:53:09 AM  Go back to site " Please let me know the solution of this error. Thank you,

Can not see another WSS3.0 sites lists in SPD Data Source Library

  
I am editing a WSS3.0 (not MOSS) site in Sharepoint Designer and I am trying to display items from lists in another WSS3.0 website.  I have gone through the "Connect to another library..." steps on the "Data Source Library" tab and SPD does show entries in the "XML Files" tree but does not show any entries (or the headings) for "Sharepoint Lists" or "Sharepoint Libraries".  Is this a limitation of WSS3.0, is this not possible or am I trying to do this the wrong way?  I am basically trying to pull annoucments / diary entries from one site to other sites.

Many thanks in advance

Jonathan

Error While Showing data in Combobox

  

Hi,

 

I am developing a WPF appliction in .net 4.0 which has got one user control. For simplicity, this user control has got only one combox which gets its value from view model's observable collection. This observable colletion is populated via a call to EF entity which gets its data from a view. The combobox's itemssource property is bound to the observable collection with necessary values in SelectedValuePath and DisplayMembePath.

Now when I run this application, the combox does populates the list but instead of showing individual item from the view it just repeats the first item returned by view for total number of rows in the view. For eg.g

Combobox should show following

Data1

Data2

Data3

Instead it is showing

Data1

Data1

Data1

I tried everything but still not able to find the solution. Is it somekind of bug in WPF comboxo or I am doing something wrong.

PS: The view internally uses Union in order to join multiple values. The Query for the view is as follows

SELECT DISTINCT CASE WHEN Field = '' 

Using CROSS APPLY in a data source query causes ARITHABORT error

  

I have an issue where the following query as an OLEDB data source throws the following error:

SELECT XmlNode.value('SomeValue[1]', 'varchar(10)') as SomeValue

FROM (SELECT CAST('<TestXML><SomeValue>123</SomeValue></TestXML>' AS XML

WCF Data Service as Forms Auth ASP Auth Source

  

Hi,

I was wondering if it is possible to use a WCF Dataservice as the MemberShipProvider for a forms auth application. I have written code for a provider (below), but I do not know what to do as far as a connection string, or any other web.config properties. Please Help!!! Here is the code for my provider, anytime it says Odbc that is because I based this off of the custom Odbc provider on the msdn site. The only ACTUAL references to any odbc connection are in the comments:

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Collections.Specialized;
using System.Web.Security;
using System.Configuration.Provider;
using System.Configuration;
using System.Data.Odbc;
using System.Text;
using System.Diagnostics;
using System.Security.Cryptography;
using System.Data;
using nGreekApplication.Web.nGreekService;

namespace nGreekApplication.Web.Services
{
    public class nGreekProvider: MembershipProvider
    {
          

    //
    // 

Data Source Library won't open / grayed out

  
Hello!

I saw a similar question but the answers didn't solve my problem so here it goes.  I have a site, and many subsites underneath.  For all of them it says I'm owner/full control.  They even gave me control of the site above mine so I could have permission to do a lot of things on my sites.  Ok well every site works the same.  I open them in SharePoint Designer and can insert data view and see the data sources under the "current site".

However, this one site i have says "current site" in the data source library tab, but it is grayed out and I can't expand it.  My IT contact has no idea what's wrong since I have full permission to all these sites.  I can add webparts through sharepoint designer to this site, I just can't add data views (and I really need data views for what I'm doing).

This is a site that's been around for a bit but this is the first time I started using it to insert data views.  Unfortunately it's a live site so I can't just delete/recreate as other things on the site are currently in use and going through workflows.  

Any suggestions are appreciated!  Where can I look?  What should I check? 

Thanks so much!

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend