Access denied when trying to use Query Builder on SharePoint List - InfoPath Dev
in

InfoPath Dev

Access denied when trying to use Query Builder on SharePoint List

Last post 05-03-2010 07:18 AM by ErnestoM. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next

  • 04-21-2010 05:46 AM

    Access denied when trying to use Query Builder on SharePoint List

    Reply Contact

    Hi,

    I have been using Query builder successfully against SQL databases for some time.  I am now trying to use it on a SharePoint List and getting an error message when clicking on the icon in Query columns.

    Details are

    The Query cannot be run for the following DataObject: DescribeListSchema
    InfoPath cannot run the specified query. 
    The SOAP response indicates that an error occurred on the server:
    System.Web.Services.Protocols.SoapException: Server was unable to process request ---> System.ApplicationException:Access denied.........

    I won't carryon typing this out unless necessary.

    It looks as if I have an issue with privileges...

    My Qdabara webservice and the SharePoint site are on the same box.

    I am the SharePoint administrator for the box and my account has access to all the sites/libraries.

    What account is being used to connect Querybuilder to SharePoint ? (Qdabra is successfully mapping to SharePoint for another DocumentType) 

    I don't really know where/what to change to eliminate this error.

    Thank you for your help

    Catharine 
    Filed under:

  • 04-21-2010 06:32 AM In reply to

    Re: Access denied when trying to use Query Builder on SharePoint List

    Mark as Answer
    Reply Contact

    Hi Catharine,

    Could you attach a screenshot of the error (via the Options tab, when replying)?

    Also, there may be errors being logged into the eventvwr; can you check? These might give us some ideas for addressing the issue.

    Thanks!

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 04-21-2010 07:25 AM In reply to

    Re: Access denied when trying to use Query Builder on SharePoint List

    qbuildererror.JPG
    Mark as Answer
    Reply Contact

    Hi

    Error attached.

    I have looked in the event viewer and I cannot see anything for today - other than the licence loading.  

    Just for information (I don't think it has anything to do with this access denied - but thought I would mention it anyway.)  EVERY time I map a document to sharepoint I get this warning message

    aught exception updating SPListItem for known item in list. http://...eu-it/ARK/ARKDocuments (DocType = 'ARKForm', DocId = 1848)

    Microsoft.SharePoint.SPException: Cannot complete this action.

    Please try again. ---> System.Runtime.InteropServices.COMException (0x80004005): Cannot complete this action.

    Please try again.

    at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags)

    at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags)

    --- End of inner exception stack trace ---

    at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags)

    at Microsoft.SharePoint.SPWeb.InitWebPublic()

    at Microsoft.SharePoint.SPWeb.get_ID()

    at Microsoft.SharePoint.SPContext.DefaultKey(HttpContext context, SPWeb web)

    at Microsoft.SharePoint.SPContext.GetContext(HttpContext context)

    at Microsoft.SharePoint.SPContext.get_Current()

    at Microsoft.SharePoint.SPListItem.AddOrUpdateItem(Boolean bAdd, Boolean bSystem, Boolean bPreserveItemVersion, Boolean bNoVersion, Boolean bMigration, Boolean bPublish, Boolean bCheckOut, Boolean bCheckin, Guid newGuidOnAdd, Int32& ulID, Object& objAttachmentNames, Object& objAttachmentContents, Boolean suppressAfterEvents)

    at Microsoft.SharePoint.SPListItem.UpdateInternal(Boolean bSystem, Boolean bPreserveItemVersion, Guid newGuidOnAdd, Boolean bMigration, Boolean bPublish, Boolean bNoVersion, Boolean bCheckOut, Boolean bCheckin, Boolean suppressAfterEvents)

    at Microsoft.SharePoint.SPListItem.Update()

    at Qdabra.Dbxl.Domain.SharePointObjectModel.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)

    The stack trace was: at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags)

    at Microsoft.SharePoint.SPWeb.InitWebPublic()

    at Microsoft.SharePoint.SPWeb.get_ID()

    at Microsoft.SharePoint.SPContext.DefaultKey(HttpContext context, SPWeb web)

    at Microsoft.SharePoint.SPContext.GetContext(HttpContext context)

    at Microsoft.SharePoint.SPContext.get_Current()

    at Microsoft.SharePoint.SPListItem.AddOrUpdateItem(Boolean bAdd, Boolean bSystem, Boolean bPreserveItemVersion, Boolean bNoVersion, Boolean bMigration, Boolean bPublish, Boolean bCheckOut, Boolean bCheckin, Guid newGuidOnAdd, Int32& ulID, Object& objAttachmentNames, Object& objAttachmentContents, Boolean suppressAfterEvents)

    at Microsoft.SharePoint.SPListItem.UpdateInternal(Boolean bSystem, Boolean bPreserveItemVersion, Guid newGuidOnAdd, Boolean bMigration, Boolean bPublish, Boolean bNoVersion, Boolean bCheckOut, Boolean bCheckin, Boolean suppressAfterEvents)

    at Microsoft.SharePoint.SPListItem.Update()

    at Qdabra.Dbxl.Domain.SharePointObjectModel.Save

    Catharine 

     

  • 04-21-2010 08:00 AM In reply to

    Re: Access denied when trying to use Query Builder on SharePoint List

    Mark as Answer
    Reply Contact

    Thanks for the screenshot. The other error looks unrelated but we can address that too.

    I know they are blanked out for security/privacy reasons, but can you confirm that the Web Service URL Prefix and the SharePoint List URL fields are the same? (in the blanked out portions) I just want to confirm that there's no machine name / host name mismatch.

    Thanks.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 04-21-2010 09:47 AM In reply to

    Re: Access denied when trying to use Query Builder on SharePoint List

    Mark as Answer
    Reply Contact

    Yes I can confirm that I get the error when they are the same.

    Just to give full information.

    Our SharePoint address and Qdabra address box was originally set up with a hostname http://hostname  but the rest of the environment has full names ie hostname.firmnet.net.

    So we have aliases set up so both http://hostname/.... and http://hostname.firmname.net/.... work.  I hope this does not cause a problem.

    Catharine

  • 04-21-2010 10:14 AM In reply to

    Re: Access denied when trying to use Query Builder on SharePoint List

    Mark as Answer
    Reply Contact

    Thanks for the info.

    There might be a hop happening somewhere; notice that the error message references the "CrossDomainAccessCheck". 

    More soon...

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 05-03-2010 07:18 AM In reply to

    Re: Access denied when trying to use Query Builder on SharePoint List

    Mark as Answer
    Reply Contact

     This was solved last week. In case anyone else faces a similar issue, the problem was that Sharepoint was accessed via http://domainname.com, whereas DBXL was installed to http://<machinename>. The solution was to switch DBXL to use the fully qualified domain name as well.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™
Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.