Qdabra Database Accelerator

Re: DBXL submit working for some users and not others...

ErnestoM — Tue, 03 Aug 2010 13:18:54 GMT

Hi Catharine,

Were you able to solve this issue? Let me know if we should continue to track this, or if it is resolved.

Thanks!

Re: DBXL submit working for some users and not others...

ErnestoM — Fri, 16 Jul 2010 18:57:36 GMT

Hi Catharine,

Can you send me a screenshot of the DAT footer (to show the version number)?

I tried a similar permissions set up in DBXL v2.4 and couldn't repro the issue. I'd like to try on DBXL v2.3, same build number as yours.

Thanks!

Re: DBXL submit working for some users and not others...

Catharine — Thu, 15 Jul 2010 15:24:50 GMT

Hmmm - I am now perplexed- this is what happens in my environment.

With enforce permissions not ticked. AND user FRED not in the user list in DBXL. FRED cannot read/write to DBXL.

With enforce permissions not ticked, AND user FRED in the user list in DBXL. FRED can read/write to DBXL.

Is that what you expect ?

Until today only two of the web.config roles had items against them. FRED was not in the builtin/administrators group

Catharine

Re: DBXL submit working for some users and not others...

Jimmy — Thu, 15 Jul 2010 15:09:37 GMT

The "Enforce Permissions" box puts the permissions specified in that view into effect. If it's unchecked, only the roles specified in web.config (DBXLAdmin, GlobalAdmin, GlobalReader, GlobalWriter) will have effect for that document type.

Re: DBXL submit working for some users and not others...

Catharine — Thu, 15 Jul 2010 13:46:03 GMT

Thank you for the comment....

What does ticking the "enforce permissions box" enforce ?

I have found that if users are not listed they are not allowed to do anything - whether the box is ticked or not.

Catharine

Re: DBXL submit working for some users and not others...

Jimmy — Thu, 15 Jul 2010 13:26:11 GMT

Looks like you need to check that Enforce Permissions checkbox in the screenshot there.

DBXL submit working for some users and not others...

Catharine — Thu, 15 Jul 2010 12:33:16 GMT

Hi, - I am going to post this as I have written it all up.... but I have fixed it - by working through Ernesto's post http://www.infopathdev.com/forums/p/15039/53328.aspx#53328http://www.infopathdev.com/forums/p/15039/53328.aspx#53328

I think this is a permissions issue but cannot be sure.

I have created a form, on submit I want to send an email with link to doc id to the approvers.

So I need to submit to dbxl and retrieve the doc id before sending the email.

This is a form where I already had code so cannot use qrules. (I think I found the instructions for the following on the forum - I can't think I invented it myself ! - but I can't find the instructions at the moment.

I have created a data connection called DBXLSubmit - see attachment

I have created a secondary data source called DBXLSubmitLogic - see attachment

I have some code (see below) which is called on change of a value (Absence Type).

Public Sub getdocid()
Dim result As DbxlSubmitResult = DbxlSubmit.Submit(Me, "DbxlSubmit")
Dim submitLogicNav As XPathNavigator
submitLogicNav = DataSources("DbxlSubmitLogic").CreateNavigator()
submitLogicNav.MoveToChild("SubmitLogic", String.Empty)
submitLogicNav.SelectSingleNode("Success").SetValue(XmlConvert.ToString(result.Success))
submitLogicNav.SelectSingleNode("ErrorMessage").SetValue(result.Message)
submitLogicNav.SelectSingleNode("DocId").SetValue(result.DocId.ToString())
End Sub

When I run this form and change AbsenceType the doc id is returned and when I later submit my form it works ok.

When my user tests the form (on different PC) no doc id is returned. I have a test PC and I can log into that with my account and it works fine, if I use a test account it doesn't (hence my thought about permissions.)

In Qdabra the permissions set up are shown in the attachment.

I have checked and can see that when the user/test account submits the following error is returned - The following error occurred submitting the document: I0033: Access denied

I have looked in the eventlog of the server running qdabra - and nothing pops up when I get the error.

I have looked in the web.config and the following are set up...

So the ReaderGroupAlias and WriterGroupAlias are blank. I have put a value in these and it now works..... However I had been using Qdabra with >200 users for the last 18 months and never had this problem - so not anywhere I would have thought to look.

Catharine