DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library - InfoPath Dev
in

InfoPath Dev

DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

Last post 08-10-2013 10:44 PM by Patrick Halstead. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 08-07-2013 04:43 PM

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

    DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

    What could be a reason one manager ser gets a blank form when they open a DBXL form?  This manager user has permission to sharepoint library and Add and Write permission in the Permission tab of DAT tool.

    The form opens correctly for me (an Admin) an for other users.  I am at loss for why this behaves this way for one person only.  We are using SP and IP 2007.  This user is using Win 7 machine.

  • 08-08-2013 06:41 AM In reply to

    Re: DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

    Hi Doreen,

    If it were a problem with the doctype or document permissions, my experience is the user would get a page not found. That is, the form won't open at all, since they don't have permissions to that XML file.

    If the form is opening and it is completely blank, then I believe we must look at the form design first. Could you attach that so we may take a look? Thanks.

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


  • 08-08-2013 08:41 AM In reply to

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

    Re: DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

    Thank you Ernesto.  Form is attached.  Would you make sure the template isn't accessible publicly?

     

    (editing to remove attachment)

  • 08-08-2013 08:47 AM In reply to

    Re: DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

     Thanks. Could you also attach a screenshot (or describe) what the user sees? Is it a completely blank page, or does the user see the form controls and they are empty?

    Also, I misread the original message. When you say "Add and Write permission in the Permission tab of DAT tool" - shouldn't the user also have Read permission?

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


  • 08-08-2013 08:56 AM In reply to

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

    Re: DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

    I emailed them to you.

    As for your suggestion that user should have Read, my DAT screenshot shows it checked, but is grayed out so I'm not sure if that means it's disabled or what....

    I didn't have the answer to your first question, contacted user, he said that the header info is blank, but the rest of the information is there (the questions in each section).  He also said he can open it from another machine with the header info intact, but he couldn't save the form so I think maybe I need to investigate this further before you spend any time on it.

  • 08-08-2013 10:56 AM In reply to

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

    Re: DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

    After meeting with user and watching form open behavior on users  Win 7 machine, the form opens from link that provides input parameter to retrieve header info but header info is missing.  The form correctly retrieves the questions in each section.

    The form opens correctly from another Win 7 machine when this user is logged on as himself - both the header info and questions are intact.

    Things I tried were to clear IE cache and InfoPath cache, restarted machine.  This did not change form open behavior for this user.  The header info is still missing.

    Ernesto, can you suggest any other things for me to try?  Perhaps I didn't fully clear the cache?  What do you think?

    As a side note, I discovered two other issues with the form in troubleshooting this issue but I will post as a new issue.

  • 08-10-2013 10:44 PM In reply to

    Re: DBXL form that retreives data from database on load is blank for a manager user who has permission to SharePoint library

    If it's a single machine anomaly, I suggest:

    1. make sure that the website is in the local intranet
    2. repair Office

     please let us know if you are still stuck

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.