Qdabra Database Accelerator

Re: unable to store a form file in SharePoint, but it is stored in DBXL

Patrick Halstead — Fri, 08 Oct 2010 06:14:06 GMT

Hi Mr. Oka,

Unfortunately, we are unable to reproduce this error on our servers. Per our email exchange with you we understand that there is a workaround for this issue and that this is not longer a high priority issue. If that is not the case, please let us know.

Best regards,

Re: unable to store a form file in SharePoint, but it is stored in DBXL

S.Oka — Thu, 30 Sep 2010 04:00:12 GMT

Hello, I just reproduced error, and check the event log of the server and SharePoint log. Unfortunately there was error log of DBXL, but SharePoint log was not including this error. I have checked SharePoint log of yesterday, 6:16PM (JST), but SharePoint was not including this error. Thanks

Re: unable to store a form file in SharePoint, but it is stored in DBXL

Jim Cantwell — Thu, 30 Sep 2010 02:25:28 GMT

Was there anything in the Sharepoint logs ? C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\logs\

Since SharePoint is returning a general exception, the SharePoint logs or Application eventlog may have additional detail on the failure.

Re: unable to store a form file in SharePoint, but it is stored in DBXL

S.Oka — Wed, 29 Sep 2010 23:42:45 GMT

Hello, Thank you for the update. Mr.Rishe has been kindly working for this issue, so I will update later again. But I have reproduced the same issue, and I just got the same event log which I posted in the beginning. Thanks

Re: unable to store a form file in SharePoint, but it is stored in DBXL

Jim Cantwell — Wed, 29 Sep 2010 23:13:22 GMT

Can you check your Application and Qdabra eventlog on the server? You may need to reproduce the problem and then check the logs for additional detail.

Re: unable to store a form file in SharePoint, but it is stored in DBXL

Jim Cantwell — Tue, 28 Sep 2010 06:55:17 GMT

Thanks for the additional information. We will try to build a repro of this scenario to investigate further.

Re: unable to store a form file in SharePoint, but it is stored in DBXL

S.Oka — Tue, 28 Sep 2010 06:44:37 GMT

Hi, Thank you for the update. We have found what was causing such an issue. Our form template has multiline text box control, and when we type single byte, and double byte text (Japanese) there, the form was not updated in SharePoint. For example, "9/8セミナー". When we type the same words by double byte and double byte, the form was updated. For example, "９／８セミナー". There may be a connection issue between DBXL and SharePoint in regard with these language specific matter, thought these things are not able to be the issue for most of DBXL users. Thanks

Re: unable to store a form file in SharePoint, but it is stored in DBXL

Jim Cantwell — Mon, 27 Sep 2010 21:52:43 GMT

You may try changing your DBXL App pool to use the same identity as the SharePoint application pool. Also, check the SharePoint logs under C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\logs\. There may be some additional information logged that may be helpful.

If using MOSS 2007/WSSv3, replace the \14\ with \12\ in the log path.

unable to store a form file in SharePoint, but it is stored in DBXL

S.Oka — Wed, 08 Sep 2010 17:24:43 GMT

Hello

We have one strange form which is stored in DBXL, but not in SharePoint. Information in the form looks like other information in other forms stored normally in DBXL and SharePoint.

I have copied error log in the below. Please advise us.

Thanks

--------------- Copy of Error Log -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Caught exception saving document to SharePoint collection http://sv3459/work/SalesMasterForm. (DocType = 'SalesMasterForm', DocId = 17441) encountered a critical error and needs attention:

Microsoft.SharePoint.SPException: Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)) ---> System.Runtime.InteropServices.COMException (0x80020009): Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION))
   at Microsoft.SharePoint.Library.SPRequestInternalClass.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage)
   at Microsoft.SharePoint.Library.SPRequest.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage)
   --- End of inner exception stack trace ---
   at Microsoft.SharePoint.Library.SPRequest.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage)
   at Microsoft.SharePoint.SPFileCollection.AddInternal(String urlOfFile, Object file, PutFileOpt fileOpt, String createdBy, String modifiedBy, Int32 createdByID, Int32 modifiedByID, DateTime timeCreated, DateTime timeLastModified, Object varProperties, String checkInComment, SPVirusCheckStatus& virusCheckStatus, String& virusCheckMessage)
   at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite, String checkInComment, Boolean checkRequiredFields, SPVirusCheckStatus& virusCheckStatus, String& virusCheckMessage)
   at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite, String checkInComment, Boolean checkRequiredFields)
   at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite)
   at Qdabra.Dbxl.Domain.SharePointObjectModel.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)
   at Qdabra.Dbxl.Domain.Document.SaveDocumentToSharePointLists(XmlDocument xmlDoc, XmlNamespaceManager nsMgr)

The stack trace was:    at Microsoft.SharePoint.Library.SPRequest.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage)
   at Microsoft.SharePoint.SPFileCollection.AddInternal(String urlOfFile, Object file, PutFileOpt fileOpt, String createdBy, String modifiedBy, Int32 createdByID, Int32 modifiedByID, DateTime timeCreated, DateTime timeLastModified, Object varProperties, String checkInComment, SPVirusCheckStatus& virusCheckStatus, String& virusCheckMessage)
   at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite, String checkInComment, Boolean checkRequiredFields, SPVirusCheckStatus& virusCheckStatus, String& virusCheckMessage)
   at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite, String checkInComment, Boolean checkRequiredFields)
   at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite)
   at Qdabra.Dbxl.Domain.SharePointObjectModel.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)
   at Qdabra.Dbxl.Domain.Document.SaveDocumentToSharePointLists(XmlDocument xmlDoc, XmlNamespaceManager nsMgr).

---------------------------------- End -------------------------------------------------------------------------------------------------------------------------------------------------------