{"id":661,"date":"2010-08-02T23:30:00","date_gmt":"2010-08-02T23:30:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/"},"modified":"2010-08-02T23:30:00","modified_gmt":"2010-08-02T23:30:00","slug":"resolution-for-sharepoint-designer-2010-data-source-non-specific-error","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/","title":{"rendered":"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d"},"content":{"rendered":"<div class=\"ExternalClass11412CD779534D32BB37F125600E7E29\">\n<p>Boy, this one was fun\u2026 but I learned a few things tonight.<\/p>\n<h2>What I learned<\/h2>\n<ul>\n<li><strong>Lesson 1<\/strong>: There are several extra steps necessary now, to expose list data from one site on another using a dataview web part \u2013 no more can you simply connect to another library&#8221; as you could in SPD 2007 (remember this? <a href=\"http:\/\/sharepointgeorge.com\/2009\/display-sharepoint-list-site-data-view-web-part\">http:\/\/sharepointgeorge.com\/2009\/display-sharepoint-list-site-data-view-web-part<\/a>).<\/li>\n<li><strong>Lesson 2<\/strong>: SharePoint keeps its own list of trusted CA&#8217;s, in addition (and different) to those that Windows manages in its certificates store<\/li>\n<\/ul>\n<h2>What I was trying to do<\/h2>\n<p>First off, I was trying to do something relatively simple. I wanted to display the latest blog posts that existed in a blog site, in the root site. I used to do this all the time, with a couple of clicks. First off, this is involves a few more steps now, and I&#8217;ll outline them quickly for the uninitiated\u2026<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf1.png\" \/><\/p>\n<p><strong>Figure 1 : Create a SOAP Service Connection <\/strong><\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf2.png\" \/><\/p>\n<p><strong>Figure 2 : Connect to the LISTS.ASMX Web Service <\/strong><\/p>\n<p><strong><em>Syntax to connect is: <\/em><\/strong><\/p>\n<p>https:\/\/site_URL\/blog_Site\/_vti_bin\/lists.asmx?WSDL<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf3.png\" \/><\/p>\n<p><strong>Figure 3 : Finally, give it a meaningful name and assign whatever authentication necessary <\/strong><\/p>\n<h2>Where it went wrong<\/h2>\n<p>Ok, here&#8217;s where the wheels fell off the proverbial bus. The above should have worked. But it didn&#8217;t and it was (after some painful\/long troubleshooting) because the SSL certificate used for the site (our site is behind an HTTPS URL) was not part of the SharePoint trusted list of CA&#8217;s. I discovered this through ULS log viewing (see below), some Googling (er, Binging) \u2013 see references below, as Claims is also impacted by this\u2026<\/p>\n<p>So, the end result of the above steps &#8220;SHOULD&#8221; have simply allowed me to add the dataview to any SharePoint page, like this:<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf4.png\" \/><\/p>\n<p><strong>Figure 4 : this should have been the end of this story&#8230; <\/strong><\/p>\n<p>Then I could have merrily added items from lists, massaged them with conditional formatting and did all those things I actually enjoy doing, instead of pulling out my hair.<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf5.png\" \/><\/p>\n<p><strong>Figure 5 : this is what you SHOULD get <\/strong><\/p>\n<p>But alas, holidays hate me and I got this instead\u2026<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf6.png\" \/><\/p>\n<p><strong>Figure 6 : Mr. Yuck says Blech&#8230; <\/strong><\/p>\n<p>And for those of you searching for this dialog box on Google, here&#8217;s me trying to help you below:<\/p>\n<p><strong>Data Source Details <\/strong><\/p>\n<p><em>Current Data Source: <\/em><\/p>\n<p><em>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. <\/em><\/p>\n<h2>Troubleshooting<\/h2>\n<p>Alas, I did the following\u2026<\/p>\n<p>Using the trusty ULS Log Viewer (<a href=\"http:\/\/code.msdn.microsoft.com\/ULSViewer\">http:\/\/code.msdn.microsoft.com\/ULSViewer<\/a>), I detected that &#8220;the root of the certificate chain is not a trusted root authority&#8221; occurred whenever I tried to look at the above data source.<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf7.png\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf8.png\" \/><\/p>\n<h2>Finally, the fix\u2026<\/h2>\n<p>Ok, get on with it, everyone is likely saying at this point\u2026<\/p>\n<p>First, you need to acquire the root cert (DER encoded library) so that you can plug it into Central Administration. There are lots of ways to get the root certificate, but this way worked quick for me:<\/p>\n<p>Open MMC, Add the Certificates Snap-In, find the related Root cert for your SSL Certificate (in my case, it was an Equifax Certificate) and Export it as a file\u2026<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf9.png\" \/><\/p>\n<p><strong>Figure 7 : Find your root cert, export it DER encoded <\/strong><\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf10.png\" \/><\/p>\n<p><strong>Figure 8 : Save the file somewhere, you&#8217;ll need it in a moment <\/strong><\/p>\n<p>As this point, there are several different suggestions out there, Central Administration or Powershell. Central Administration was quick, easy and worked first time, so why go all Matrix on the problem, eh? \ud83d\ude42<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf11.png\" \/><\/p>\n<p><strong>Figure 9 : Open Central Administration and click on Security <\/strong><\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf12.png\" \/><\/p>\n<p><strong>Figure 10 : click on Manage Trust <\/strong><\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf13.png\" \/><\/p>\n<p><strong>Figure 11 : give your root a name and browse to that CER file you created and click OK <\/strong><\/p>\n<p>That&#8217;s it folks. I did an IISRESET but only out of habit and I&#8217;m too lazy to pull everything out to see if it was actually necessary. \ud83d\ude09<\/p>\n<p>But now my dataviews display properly\u2026<\/p>\n<p><img decoding=\"async\" src=\"\/brainlitterarchive\/Lists\/Photos\/080310_0630_Resolutionf14.png\" \/><\/p>\n<p><strong>Figure 12 : Hope this helps someone! <\/strong><\/p>\n<h2>References<\/h2>\n<p>Thanks to these resources for helping me find my way\u2026<\/p>\n<ul>\n<li><a href=\"http:\/\/social.technet.microsoft.com\/Forums\/en\/sharepoint2010setup\/thread\/179f9080-5456-414a-9cc5-1ea07c26cc47\">http:\/\/social.technet.microsoft.com\/Forums\/en\/sharepoint2010setup\/thread\/179f9080-5456-414a-9cc5-1ea07c26cc47<\/a><\/li>\n<li><a href=\"http:\/\/social.msdn.microsoft.com\/Forums\/en\/sharepoint2010general\/thread\/2dc6af5b-3afa-466d-b6e7-0c66368c5aff\">http:\/\/social.msdn.microsoft.com\/Forums\/en\/sharepoint2010general\/thread\/2dc6af5b-3afa-466d-b6e7-0c66368c5aff<\/a><\/li>\n<li><a href=\"http:\/\/blogs.technet.com\/b\/speschka\/archive\/2010\/02\/13\/root-of-certificate-chain-not-trusted-error-with-claims-authentication.aspx\">http:\/\/blogs.technet.com\/b\/speschka\/archive\/2010\/02\/13\/root-of-certificate-chain-not-trusted-error-with-claims-authentication.aspx<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Boy, this one was fun\u2026 but I learned a few things tonight. What I learned Lesson 1: There are several extra steps necessary now, to expose list data from one site on another using a dataview web part \u2013 no more can you simply connect to another library&#8221; as you could in SPD 2007 (remember &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[14,334,338,339],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Boy, this one was fun\u2026 but I learned a few things tonight. What I learned Lesson 1: There are several extra steps necessary now, to expose list data from one site on another using a dataview web part \u2013 no more can you simply connect to another library&#8221; as you could in SPD 2007 (remember &hellip;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-02T23:30:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/\",\"name\":\"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2010-08-02T23:30:00+00:00\",\"dateModified\":\"2010-08-02T23:30:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d - Brainlitter - Inside the mind of Sean Wallbridge","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/","og_locale":"en_US","og_type":"article","og_title":"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Boy, this one was fun\u2026 but I learned a few things tonight. What I learned Lesson 1: There are several extra steps necessary now, to expose list data from one site on another using a dataview web part \u2013 no more can you simply connect to another library&#8221; as you could in SPD 2007 (remember &hellip;","og_url":"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2010-08-02T23:30:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/","url":"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/","name":"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2010-08-02T23:30:00+00:00","dateModified":"2010-08-02T23:30:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2010\/08\/02\/resolution-for-sharepoint-designer-2010-data-source-non-specific-error\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Resolution for SharePoint Designer 2010 Data Source \u201cNon-Specific Error\u201d"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/661"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=661"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/661\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}