Qdabra Database Accelerator

Re: web form openning error

erockafella — Fri, 09 Nov 2012 18:54:51 GMT

In my case we have an automated process that creates a task list item in SharePoint. We have modified the list form to be displayed within InfoPath. I some occasions the automated process was not completely adding the proper body information into our append notes column.

Re: web form openning error ..pls help

Ted Fitch — Wed, 26 Jan 2011 00:19:42 GMT

Harish,

How are things going with your DBXL evaluation? Have you got everything sorted now and all is working for your evaluation?

The trial license you have does expire on January 31st (next Monday). Please let me know if you need some assitance with purchasing a license or requesting a trial extension while you complete your evaluation.

Thanks

Ted

Re: web form openning error ..pls help

harishu — Mon, 17 Jan 2011 09:14:00 GMT

hi guys

dear mel gave me a buzz and everything's sorted out for now. she is not convinced with the solution though.

she was patient with me and spent a good deal of time. much appreciated.

its time for me stop playing and get to get back to work. :)

thanx everyone

Re: web form openning error ..pls help

harishu — Sun, 16 Jan 2011 11:40:38 GMT

my phone no: xxxxxxxxxxxxx available from GMT 4:00am to 12:00PM

i think i found out when the error occurs.

i created a new plain web form and mapped to database and everything works fine.

then i changed one text box to a drop down list box and everything works fine.

i went and attached a share point list to this drop list box. bang .. the error appears.

i changed (adv.settings) from "open in browser" to "default" and it works fine in the infopath client.

now what i like to know is whether this is an error OR is this the way it supposed to work.

thanx

Re: web form openning error ..pls help

Patrick Halstead — Sat, 15 Jan 2011 14:44:32 GMT

Hi again,

What's a good time to call you? I can't promise we can call over the weekend, but we'll try. If not, first thing Monday.

Can you look at the event log in the Event Viewer (Start->Run eventvwr) and see if there are any errors underneath the Qdabra log?

Thanks!

Re: web form openning error ..pls help

harishu — Sat, 15 Jan 2011 13:55:21 GMT

please keep in mind i am in Kuwait. GMT+3

thanx

Re: web form openning error ..pls help

Patrick Halstead — Sat, 15 Jan 2011 12:53:08 GMT

Thanks for the screenshot. I have confirmed that you installed the most recent version of DBXL

Are you still seeing the same errors as before or are they different? We will investigate the errors you sent in email.

The email contains 2 error images and a RAR file including a SharePoint error log.

Can you also include a copy of your event viewer log for Qdabra Software. That might have an error in it that explains what is happening.

I've asked Mel Balsamo and Jim Cantwell to try to contact you over the weekend here. I am not sure what their availability will be so please be patient.

More soon,

Re: web form openning error ..pls help

harishu — Sat, 15 Jan 2011 09:12:23 GMT

to jim cantwell

please note that when the web form is published thru DAT, i cannot open the form. i get the error which i have sent to qdabra SUPPORT email.

if the form is published from infopath to sharepoint forms library, the form opens in browser. on submit i get an error which i suppose is expected.

thanx.

Re: web form openning error ..pls help

harishu — Fri, 14 Jan 2011 19:55:24 GMT

yes..its the same share point site (port 80) using the same account (kotcnt\spadmin). nothing has been changed except for the reinstall of DBXL.

thanx.

Re: web form openning error ..pls help

Jim Cantwell — Fri, 14 Jan 2011 18:21:37 GMT

We also came across this particular exception trace in a customer's environment this week. Can you send the xsn to our support at qdabra.com alias?

It will also help to know how your SharePoint site is configured. Is the site on a machinename:portno (where portno is not 80) and then extended using a intranet or extranet zone url?

Regards,

Jim

Re: web form openning error ..pls help

ErnestoM — Fri, 14 Jan 2011 15:07:19 GMT

I don't have any ideas on this error, but I will share this with others on the team to get their input.

Just to be sure: DBXL was (re)installed to the same site as Sharepoint (port 80) and uses the same account as SharePoint (KOTCNT\spadmin)?

Re: web form openning error ..pls help

ErnestoM — Fri, 14 Jan 2011 15:01:04 GMT

Just adding the exception I found from the rar file you attached...

01/14/2011 17:08:27.49 w3wp.exe (0x1498) 0x1568 InfoPath Forms Services Maintenance 82fv Critical The form template failed to load. (User: KOTCNT\spadmin, Form Name: test2, IP: , Request: http://kotcshare/_layouts/FormServer.aspx?XmlLocation=/KOTCForms/BSYearlySetup/206.xml&Source=http://kotcshare/KOTCForms/BSYearlySetup/Forms/AllItems.aspx?GroupString=%253B%25232009%252D10%253B%2523&IsGroupRender=TRUE&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:BSYearlySetup-http-kotcshare-KOTCFormsv20110114125159d5e7bcea2842461da7e88937a278ad37:-myXSD-2011-01-11T04-55-27, Type: NullReferenceException, Exception Message: Object reference not set to an instance of an object.) 1e7e2d60-ec1c-47f2-97e6-8c3dd9121fb9

01/14/2011 17:08:27.54 w3wp.exe (0x1498) 0x1568 InfoPath Forms Services Runtime 8gec Exception Unhandled exception when rendering form System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterListDataProvider.UrlIsSameFileOrSamePath(String absoluteFileUrl, String baseFileOrFolderUrl) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterListDataProvider.IsSolutionMoved(Document document) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterListDataProvider.GetList(WebHolder webHolder, Boolean impersonatedIdentity, Document document, String siteUrl, Boolean isUrlSetThroughOM, Guid listId) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterListDataProvider.<>c__DisplayClasse.<Execute>b__3(Boolean impersonatedIdentity) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterUtil.Impersonate(DataAdapterInformation adapterInfo, String userName, String userDomain, String password, CodeToRunUnderImpersonation codeToRun) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterUtil.Impersonate(DataAdapterInformation adapterInfo, String userName, String password, CodeToRunUnderImpersonation codeToRun) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterListDataProvider.Execute(String siteUrl, Guid listId, SPContentTypeId contentTypeId, Document document, DataAdapterListDataProvider documentAdapter, Boolean useDcl, XPathNavigator queryFields, XPathNavigator resultFields, Boolean isListItemEditing, Boolean discoveryOnly, Int64& auxDomSize) at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataAdapterListDataProvider.ExecuteInternal(XPathNavigator queryFields, XPathNavigator resultFields, Boolean useListItemMode) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.QueryDataOnLoad(DataAdapter documentDataAdapter, DataObject documentDataObject) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.ExecuteInitOnLoadForDataObjects() at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.LoadSolutionAndDocument(HttpContext context, Solution solution, DocumentMetaInformation documentMetaInformation, OnInitializeCallback onInitializeCallback, OpenParameters openParameters) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.OpenDocumentWithSolution(HttpContext context, SPSite contextSite, Solution solution, DocumentMetaInformation documentMetaInformation, OnInitializeCallback onInitializeCallback, OpenParameters openParameters) at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.DataBindInternal(SolutionMetaInformation solutionMetaInformation, DocumentMetaInformation documentMetaInformation, String absoluteSolutionLocation, Boolean hasCloseHandler, Document& document) at Microsoft.Office.InfoPath.Server.Controls.FormServerPage.InitializeRenderInLine(SolutionMetaInformation solutionMetaInformation, DocumentMetaInformation documentMetaInformation, String absoluteSolutionLocation) at Microsoft.Office.InfoPath.Server.Controls.FormServerPage.NewEditingSession(SPSite contextSite, FormServerPageQueryParameters queryParameters, Boolean isFormServerProperlyConfigured, Boolean& renderSessionsStateError) at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.StartNewEditingSession() at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.EnsureDocument(EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.Controls.XmlFormView.<>c__DisplayClass8.<LoadDocumentAndPlayEventLog>b__5() at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

Re: web form openning error ..pls help

harishu — Fri, 14 Jan 2011 14:29:54 GMT

i fixed the error .. that is renamed taxonomypicker.ascx ...so doesnt show up in the event logs now.

still get the same error when trying to open a browser form ...example with cor.ID : 1e7e2d60-ec1c-47f2-97e6-8c3dd9121fb9

have attached an new log file

btw would like to tell you that the same web form published directly from info path to share point works fine.

thanx

Re: web form openning error ..pls help

ErnestoM — Fri, 14 Jan 2011 12:29:47 GMT

Thanks for the info.

Searching on Google for the error I've found the following articles:

http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/84e2496c-5cc9-4df8-9667-153d1ca02e60

http://todd-carter.com/post/2010/05/03/Help-Wanted-Taxonomy-Picker.aspx

http://davidfrette.wordpress.com/2010/05/20/why-the-taxonomypicker-ascx-is-no-longer-used/

From reading these, it sounds like a SharePoint 2010 issue?

Re: web form openning error ..pls help

harishu — Fri, 14 Jan 2011 04:53:14 GMT

ok .got it ..CoRe.ID : 78eecdba-2718-4181-b900-d79ae20eb887

and some errors from the event viewer

Load control template file /_controltemplates/TaxonomyPicker.ascx failed: Could not load type 'Microsoft.SharePoint.Portal.WebControls.TaxonomyPicker' from assembly 'Microsoft.SharePoint.Portal, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'.

The form template failed to load. (User: KOTCNT\spadmin, Form Name: test2, IP: , Request: http://kotcshare/_layouts/FormServer.aspx?XsnLocation=http://kotcshare/KOTCForms/BSYearlySetup/Forms/template.xsn&SaveLocation=http://kotcshare/KOTCForms/BSYearlySetup&Source=http://kotcshare/KOTCForms/BSYearlySetup/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:BSYearlySetup-http-kotcshare-KOTCFormsv20110113072824d5e7bcea2842461da7e88937a278ad37:-myXSD-2011-01-11T04-55-27, Type: NullReferenceException, Exception Message: Object reference not set to an instance of an object.)

thanx