InfoPath Dev

I am seeing a problem when a different user to the one who originally submitted the document tries to edit and resubmit a document to dbxl. dbxl fails to overwrite the form in the sharepoint library. i figure this is a security problem due to the error below, but so far its stumped me. i've tried giving the users full control on the form library but still they cannot overwrite. even the qdabra user has full control...

here is the event log error...

 Event Type: Error
Event Source: Database Accelerator
Event Category: None
Event ID: 0
Date:  08/09/2009
Time:  13:22:42
User:  N/A
Computer: <computername>
Description:
Caught exception saving document to SharePoint collection https://www.domain.com/formlibrary (DocType = 'Doctype', DocId = 110) encountered a critical error and needs attention:

System.InvalidOperationException: Cannot open log for source 'Database Accelerator'. You may not have write access. ---> System.ComponentModel.Win32Exception: Access is denied
   --- End of inner exception stack trace ---
   at System.Diagnostics.EventLog.OpenForWrite(String currentMachineName)
   at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
   at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
   at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type)
   at Qdabra.Util.ServiceTool.LogWarning(String message, Exception e)
   at Qdabra.Dbxl.Domain.SharePointMethod.LogWarningWithDocId(SharePointDocumentData doc, String message, Exception exception)
   at Qdabra.Dbxl.Domain.SharePointWebServices.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)
   at Qdabra.Dbxl.Domain.Document.SaveDocumentToSharePointLists(XmlDocument xmlDoc, XmlNamespaceManager nsMgr)

The stack trace was:    at System.Diagnostics.EventLog.OpenForWrite(String currentMachineName)
   at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
   at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
   at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type)
   at Qdabra.Util.ServiceTool.LogWarning(String message, Exception e)
   at Qdabra.Dbxl.Domain.SharePointMethod.LogWarningWithDocId(SharePointDocumentData doc, String message, Exception exception)
   at Qdabra.Dbxl.Domain.SharePointWebServices.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)
   at Qdabra.Dbxl.Domain.Document.SaveDocumentToSharePointLists(XmlDocument xmlDoc, XmlNamespaceManager nsMgr).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

anyone have any idea what might cause this? i've searched the forums already and found a similar issue that occurs when installing but this did not help.

Thanks

Matt

Hi Matt,

I'm not familiar with your setup so forgive the questions.

- I'm assuming you are using a mapping in the SharePoint tab. How is this set up? Mapping to a SharePoint library on the same machine, or a separate machine? Using Publish Form and XSN or not?

- Is the xml document (stored in DBXL) updated with the modification, or is it ONLY the SharePoint library that fails to update?

- Any other errors in the event viewer?

- Does the user have access to DBXL? Can that user submit a new document?

Thanks for the additional info.

Yes im using the sharepoint mapping, its currently using the web service method to map to the library on the same machine, but ive also tried object model, with the same effect. it is set to publish form and XSN.

Yes the xml is updated in DBXL, just not in sharepoint library which does not update.

further down (relating to a different form) is another error, i'm not sure if this is related to this problem or not, but i'll post the error anyway...

Error updating list item metadata in SharePoint collection https://www.domain.com/formlib: 0x80040e2f The operation failed because an unexpected error occurred. (Result Code: 0x80040e2f) (DocType = 'Doctype', DocId = 108) encountered a critical error and needs attention.

That user does not have access to the dbxl control panel if thats what you mean? They can submit a new document just not overwrite existing :-(

EDIT:

also this error in the event log...

Event Type: Warning
Event Source: Database Accelerator
Event Category: None
Event ID: 0
Date:  07/09/2009
Time:  16:39:06
User:  N/A
Computer: <computername>
Description:
Caught exception checking out SPListItem. https://www.domain.com/formlib/108.xml (DocType = 'doctype', DocId = 108)

System.Web.Services.Protocols.SoapException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Qdabra.Dbxl.Domain.SharePointLists.Lists.CheckOutFile(String pageUrl, String checkoutToLocal, String lastmodified)
   at Qdabra.Dbxl.Domain.SharePointWebServices.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)

The stack trace was:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Qdabra.Dbxl.Domain.SharePointLists.Lists.CheckOutFile(String pageUrl, String checkoutToLocal, String lastmodified)
   at Qdabra.Dbxl.Domain.SharePointWebServices.Save(SharePointListItemMapping mapping, SharePointDocumentData doc).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

anyone have any suggestions?

Hi Matt,

I am stumped, because this doesn't seem to be an issue with our product and certainly nothing I've seen before. I have forwarded the inquiry to our support team to see if we can figure out what could be going on here. More soon...

I believe you may have uncovered a bug in DBXL.  When saving to SharePoint, DBXL impersonates the user.  If an error occurs during submit, the error is written to the eventlog, but in this case the user is still being impersonated and writing to the eventlog fails.

Can you verify the user has permissions to the document library?  You could also temporarily grant the user permission on the server by adding them to the Backup Operators, or possibly Administrators to see what the actual error attempting to be logged is.

 We will investigate a hotfix fix for this issue.  Is this server by chance a domain controller?

Hi Jim,

My initial theory was that this is what was happening, so i've already tried adding the user to the local administrators of the machine, but the same error is still logged. i've not tried adding the user to the backup operators group yet though... will this make a difference? this server is not a domain controller...

ok, perhaps i was wrong (or something was caching credentials), but ive now made the user a member of the administrators group again and now i get a different error.... as follows...

 Event Type: Error
Event Source: Database Accelerator
Event Category: None
Event ID: 0
Date:  09/09/2009
Time:  16:14:11
User:  N/A
Computer: <servername>
Description:
Caught exception saving document to SharePoint collection https://www.domain.com/formlibrary. (DocType = 'doctype', DocId = 117) encountered a critical error and needs attention:

System.Net.WebException: The remote server returned an error: (409) Conflict.
   at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)
   at System.Net.WebClient.UploadData(Uri address, String method, Byte[] data)
   at System.Net.WebClient.UploadData(String address, String method, Byte[] data)
   at Qdabra.Dbxl.Domain.SharePointWebServices.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)
   at Qdabra.Dbxl.Domain.Document.SaveDocumentToSharePointLists(XmlDocument xmlDoc, XmlNamespaceManager nsMgr)

The stack trace was:    at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)
   at System.Net.WebClient.UploadData(Uri address, String method, Byte[] data)
   at System.Net.WebClient.UploadData(String address, String method, Byte[] data)
   at Qdabra.Dbxl.Domain.SharePointWebServices.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)
   at Qdabra.Dbxl.Domain.Document.SaveDocumentToSharePointLists(XmlDocument xmlDoc, XmlNamespaceManager nsMgr).

does this shed any more light?

Please verify the permissions the user has on the form library.  Make sure they have contributor access.

Did  the form library already exist or was it created by DBXL when saving the doctype?

The user has full control over the form library. I'm not sure if the library was one i created manually or if DBXL created it... is there a way to tell?

Is this trying to save a new or existing DBXL document? 

In the SharePoint library, please check the Checked Out To column for the document being saved. 

reread your post.  it is an existing document.  If the Checked Out To column is set, that will help narrow down the problem.

i presume by 'if the column is set' you mean visible in the library view? i've made it visible but this seems to be always blank. i then enabled the check out feature of the library assuming i'd miss read something and this needs to be enabled, but still made no difference this column is always blank. Should the check out feature be turned on in the library?

I am getting this error still... and also one new error!... see below..

might be worth noting that sometimes when i try to open the form to edit it, i get a message saying that the form is open by another user or another program...

I assume dbxl has this file open when this message appears? eventually after leaving it a considerable amount of time this mssage will go away, and i can then edit and resubmit the form.

ok,

I think that making the users a member of the local admins of the machine has fixed the issue with overwriting the files, at least until a fix is released by qdabra (i dont like the idea of all the users being local admins of the server permanently)!

the only issue now is that after the file has been edited, you have to wait a considerable time (15 - 20 minutes) before the file can be edited again, i assume that dbxl has not properly closed the file or it is using it?

 the exact error from infopath when trying to open the form in sharepoint is...

"the form cannot be filled out because you do not have adequate permission, another user has the form open, or the form is open in another program. Do you want to open a read only copy for the form?"