Qdabra Database Accelerator

DBXL 2.4 Migration !! (Old version i know !!)

CapitaUK — Mon, 27 Jul 2020 11:07:09 GMT

Ok, i am almost embarrassed to even asking this due to the version being so old, but here is my scenario. We currently have both the QDABRA Web service and its associated DB's on a single virtual Win 2008 SQL 2008 server. We are moving to new offices so in preparation we have setup two new virtual servers, both running Windows Server 2016 with one running SQL 2016. We successfully copied over (not reinstalled) the QDABRA WebService and DB's to the relevant servers, amended the QDABRA web services web.config file. My infopath form connects directly to ithe new DB successfully enough and i have it referencing the Active Directory service from the new QDABRA web service so thats working ok. The problem is with my QueryDB elements on the form that i cant get working, it can see the new webservice ok, but it seems to be trying to be using old credentials to access the QDABRA DB. Be aware that the the new servers have different names. Another thing i have noticed, when i query the new migrated Qdabrawebservice directly and go to the link to download the DBXL Administration Tool,.. when i run it, it is still referring to the current live instance and not the migrated one. We have tried simply reinstalling the DBXL from scratch but the v2.4 msi doesnt like the Windows Server 2016. We dont use the document storage elements of DBXL,.. we simply use the Active Directory service and the QueryDB. Any insight into what else i need to amend or configure would be appreciated. NB: Actually not sure if its DBXL v2.4 .. seems to be saying v3.0.2015 (see attachment).

DBXL 3.2 Installation Problem. Dreaded "error occurred configuring doctypes"

jonlawton — Mon, 07 Aug 2017 11:04:59 GMT

Hi,

I have been trying to install DBXL 3.2 and have come across this error in every single server and scenario I have installed on. I have read a thread on here about it being permissions but the account I am installing with has full sysadmin on all the SQL Servers it has been tried on. I have tried it on SharePoint servers installing to the SharePoint IIS site, not the default. I have tried installing on a clean server with just IIS running on port 80 and nothing works.

There doesn't appear to be any more information on any threads that can shed any light on this issue. It's a shame really as I was hoping this software would live up to expectation, unfortunately I can't install so unlikely to see what it's potential is.

Has anyone else suffered from this and did anyone find the problem?

All the servers are Windows 2008 R2 and SQL Servers are SQL 2008 R2 Standard.

Thanks - Jon

Get a value from a field in an InfoPath form that is not stored in database by DBXL

Doreen — Fri, 26 May 2017 19:03:52 GMT

I have an InfoPath 2007 form in SharePoint 2007 that uses DBXL and qRules. There is a value in one of the fields that is not stored in the database when it's submitted so the value must be stored in the xml of the form itself.

My goal is to retreive this value for all existing forms and store it in a new column of the database. How can I retrieve this value without having to open every form to look it up and then manually insert it into the database? Is there simple way to do this by modifying the qRules and/or DBXL?

The reason? We are migrating this particular InfoPath form to an asp.net web app and would like to be able to open the existing infopath form data in the new web app. This one value is the only missing piece.

Inherited DBXL license expired

DBA101 — Wed, 17 May 2017 10:12:10 GMT

I have recently inherited a InfoPath/SharePoint/DBXL/SQL set up that captures electronic info from a user and eventually stores it in a series of SQL databases. The system seems to be working but I can't edit any of the forms that have bugs or logic issues.

I have located the DBXL admin tool and I think the license may have expired.

The license issue seems to be stopping me from editing forms as it gives an I0033 Error and then a 'Could not determine the Document ID type, abort query' error- does it sound like renewing the license will fix thi

DBXL Admin Tool

Parrrott — Mon, 23 May 2016 15:14:36 GMT

I am no longer able to use the DBXL Admin Tool. Every time I try to open it in InfoPath 2013, I get the following error:

Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

If I hit okay then the tool will go ahead and load, but if I try to edit any of my forms, then I get this error:

Configuration system failed to initialize

I've ensured that my SharePoint site is listed as an intranet site in my Internet Options (which is set through group policy), as I had a problem similar to this before and that was the solution, but it's not helping this time. I did recently upgrade to Windows 10 and InfoPath 2013 (from Windows 7 / InfoPath 2010), so I'm wondering if this might have something to do with it? Any help would be appreciated.

Can't Launch DBXL Administration Tool

hughy — Tue, 02 Feb 2016 05:23:16 GMT

I get the error below when trying to open the DBXL Administration Tool: InfoPath cannot open the selected form because of an error in the form's code. Could not load file or assembly 'InfoPath_Form_Template, Version=1.0.5540.21129, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418)

Getting Errors on publish with infopath 2013

mthandar — Tue, 02 Feb 2016 09:20:32 GMT

Hi anyone,

please advise me on bellow error message which was appear after publish with infopath 2013 version.

It is working in local but getting on server.

Form template: <HTTP://<<our server>>/QdabraWebService/Forms/ID/479/template.xsn
InfoPath cannot open the selected form because of an error in the form's code.
Could not load file or assembly 'Form Name, Version=1.0.5876.29719, Culture=neutral, PublicKeyToken=38e31ce5407f78c5' or one of its dependencies. The system cannot find the file specified.

getting error migrate infopath 2007 to infopath 2013

mthandar — Tue, 02 Feb 2016 03:53:45 GMT

Currently I am using DBXL version 2.4 which is working on InfoPath 2007 and word 2007.

I am trying to move the window 8 version, InfoPath 2013 and word 2013.

I save the existing InfoPath form into my local via DBXL admin tool then did bellow step.

1. Form options from Compatibility Form type -> InfoPath 2010 Filler Form

2. VB code open in vsta 2013 and upgrade .net framework 4.0 and build it.

3. publish InfoPath form in my local.

4. attach into DBXL via admin tool.

But when I download the InfoPath file, I am getting the following errors. Please help and advise!

InfoPath cannot open the selected form because of an error in the form's code.
One or more required components of InfoPath or the form template cannot run because of a security restriction.
Contact your system administrator or run Setup again to confirm that .NET Programmability Support is installed on your computer.
Request for the permission of type 'Microsoft.Office.InfoPath.InfoPathPermission, Microsoft.Office.InfoPath.Client.Internal.Host, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' failed.

   at Microsoft.Office.Interop.InfoPath.SemiTrust.XDocumentsCollectionWrapper.NewFromSolution(Object varURI)
   at AdminTool.Configuration.OpenTemplate(String templateUrl)
   at AdminTool.Configuration.btnOpenNewDocument_OnClick(DocActionEvent e)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

Problems with submitting data following domain changes

GedCT — Tue, 06 Oct 2015 12:00:29 GMT

We have been using the DBXL product for a number of years without any issues until a recent infrastructure change which occurred, driven by the central IT function. As part of an upgrade project, a new domain was created and as machines were upgraded to Windows 7 they were added to this new domain. Unfortunately, our SharePoint and databases servers remained on the old domain and this now seems to be causing an issue for new users when submitting data. User accounts were also migrated onto the new domain along with AD groups.

Our forms contain both push and pull functions - reading the name of the form author from the active directory as well as permitting the usual form submission. Users who had an account on the old domain prior to migration are unaffected and are able to use the forms and submit data as normal. Users who joined since the migration and subsequently have an account on the new domain can open the forms and user the data connections to read in the name of the author, etc but are unable to submit forms with the system complaining about a lack of permissions.

Access to the web service is controlled by the same AD group and hence cannot understand why it allows the user to access the web service and draw data from the AD, but won't work the other way around and accept data from the form. I have considered that the only approach would be to migrate the whole server farm over to the new domain, but thought I'd ask if anyone knew of any workarounds in the interim.

SharePoint 2013 Feature Error

bgijohn — Fri, 25 Sep 2015 14:16:17 GMT

I have successfully installed DBXL and am running through the setup. I get to the point where I have deployed the feature to my SharePoint 2013 on-prem installation and activated it on the site. When I click on DBXL Settings in the library settings page, I get ye ol' "Sorry, something went wrong" error.

I cross referenced the correlation ID with UlsViewer and am seeing the following errors:

Application error when access /_layouts/15/Qdabra/Dbxl/DbxlListSettings.aspx, Error=The file '/_layouts/15/Qdabra/Dbxl/DbxlListSettings.aspx' does not exist.

System.Web.HttpException: The file '/_layouts/15/Qdabra/Dbxl/DbxlListSettings.aspx' does not exist.

Getting Error Message for Exception System.Web.HttpException (0x80004005): The file '/_layouts/15/Qdabra/Dbxl/DbxlListSettings.aspx' does not exist.

Any ideas?

Edit: When I look in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\template\layouts\Qdabra\ it is empty.

DBXL Installation user/pass Prompt

bgijohn — Tue, 15 Sep 2015 15:16:24 GMT

During installation I am getting prompted for a username and password to the web service. After going wide open with permissions and trying various accounts, I just can't seem to figure out what this is looking for and cannot complete installation. The installation has successfully created the databases and I can browse to http://domain/QdabraWebService/, but I just cannot complete the installation. Any ideas where I should be looking? Thanks.

Sync current InfoPath library with DBXL

tenbao — Thu, 23 Apr 2015 20:26:26 GMT

Hello I'm trying to sync a current InfoPath library with DBXL. Below are the steps I followed, but had an issue:

1) Created a new Document Type
2) I updated the XSN template to submit to DBXL instead of the SharePoint library and uploaded to DBXL through the DAT tool.
3) Mapped the new Document Type to the SharePoint Library
4) Next I copied the XML files from the SharePoint Library and then uploaded via the DBXL Migration Tool. That was successful.

But this creates duplicate files with the DBXL DocID number as the filename in the SharePoint Library. How do I force the uploads to use the original file name?

Sync old forms with new DBXL setup

tenbao — Mon, 30 Mar 2015 22:06:43 GMT

Where can I find instructions on how to sync current forms in an InfoPath library with DBXL to enable querying with the QueryDocumentsNodeSet method?

Trial installation fails

Leif Frederiksen — Wed, 04 Mar 2015 13:17:51 GMT

I am trying to install the trial server version. My server is Windows 2012 R2 and SQL server is 2012.

The installation stops in the "Creating table views..." phase according to the instllation GUI, but I do not think that is correct. Because when I look into the database, lots of views and table etc. has been created, and looking into the event log says something different:

Error bootstrapping system doctypes System.InvalidOperationException: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

I need some pointers on how to fix this - have been trying to get this up and running for several days now, and my trial is soon expiring :-(

Form count exceeded. Please upgrade your Database Accelerator license or delete forms.

SGorges — Thu, 05 Feb 2015 18:29:35 GMT

I have inherited my SharePoint environment and I honestly do not know much about DBXL. Last month I start noticing that a lot of workflows were crashing while trying to submit information to DBXL. I was able to get logged into the BDXL Administration Tool and found that my license had expired which I was able to get renewed and re-added this morning but I am still getting errors on some of the forms when they try to submit to DBXL. The workflows are Nintex workflows and they are using a User Defined action that I assume was created by my predecessor. I have searched both here and Google and have found nothing that makes any sense to me. Can someone please give me some guidance as to what this error means and what I may need to do to correct it? Any and all help is greatly appreciated.

Errors:Error returned from server: soap:ServerSystem.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Exception Code: I1001
Exception Message: Form count exceeded. Please upgrade your Database Accelerator license or delete forms.

Receiving message" You are currently offline...please go online and try again. From DBXL dashboard

Edward Rodman — Thu, 22 Jan 2015 16:39:49 GMT

I added a new dashboard item this morning and now get the above message, I did have this once last year when i was on a different project. Now I am setting up for the 2015 project and

got the message again. Recently moved to a new laptop PC so perhaps i missed a setting somewhere. (ed)

In starting up the Standalone Dashboard...receiving "Your are off-line" message

Edward Rodman — Mon, 30 Jun 2014 14:11:43 GMT

So, I started up the Standalone dashboard this morning and received the following error.

You are currently off-line. Please go online and try again.

Can someone tell me how to handle this error.

Thanks

Cross-domain restriction error when trying to publish a form

mattpalmgren — Fri, 16 Jan 2015 20:52:58 GMT

I installed a trial of DBXL 2.9 on a dev farm. The farm consists of a SharePoint 2013 server and a SQL 2012 server. I created a separate site in IIS, and pointed the installer at the SQL server, and I am able to open the DBXL Admin Tool just fine.

I decided to use the Expense Report sample form for testing purposes, so I opened the form in InfoPath Designer, and published it to an existing site on the SharePoint server. I looked at the Data Connections in the form, and the DBXL Submit connection points to http://qdabratest/QdabraWebService/DbxlDocumentServiceEx.asmx?WSDL (qdabratest is the IIS site I created), and the SharePoint Library Submit connection points to http://internaldev:20131/ExpenseReportEventREceiver (the SharePoint site and document library).

I wanted to see if the form was working correctly with SharePoint before I went down the path of configuring it to write to SQL, so I opened a new form from the forms library, entered some data, and hit Submit. I am receiving the following error:

The form cannot be submitted because this action would violate cross-domain restrictions.

If this form template is published to a SharePoint document library, cross-domain access for user form templates must be enabled under InfoPath Forms Services in SharePoint Central Administration, and the data connection settings must be stored in a UDC file in a data connection library in the same site collection.

If this is an administrator-approved form template, the security level of the form must be set to full trust, or the data connection settings must be stored in a UDC file by using the Manage data connection files option under InfoPath Forms Services in SharePoint Central Administration

An entry has been added to the Windows event log of the server. Log ID:5758

I tried saving the connection file to a Data Connections Library on the same SharePoint site, but I still get the same error. I confirmed that cross-domain was enabled in the InfoPath Service Application in Central Admin.

Is there something else I need to configure before I am able to submit to a SharePoint library?

Qdabra docs missing from Sharepoint SP Library List

semloh1 — Fri, 21 Nov 2014 20:46:13 GMT

New to the forum, I have an info path form associated with a library and published from my Qdabra; Upon submit the form submits to the Qdabra Web Service. There seems to be an issue with the SP library no longer showing documents > 5000. I see the documents in Qdabra and the database. I have created an index in SP for large datasets. The issue is also that there are no more documents in the library > 5000 however there should be 5918.

The SP library currently has 5000 items but the mapped Qdabra node shows 5918 items and the database also show 5918 items. I read somewhere to reshred the document node and it would push out to the SP library any missing docs. After the reshred the library still on shows 5000 items and is missing the most recent docs. I have confirmed this is not a view issue in SP and have also looked in the SP Windows Explorer and still only see 5000 docs. Any suggestions for SP showing all the Qdabra docs?

Thanks,

QueryDocumentsNodeSet

tenbao — Fri, 07 Nov 2014 22:51:04 GMT

Does the DBXL web service provide a way of querying the contents of an InfoPath XML file without requiring it to be mapped in DBAdmn?

Migrate QdabraDBXL and QdabraUtility databases to another server

Doreen — Thu, 30 Oct 2014 15:30:01 GMT

I need to move the databases for our DBXL install to another server - originally it was installed on a development/test server and is working (great) with our production SharePoint server and InfoPath. But, the DBXL db's should be migrated to the production SharePoint SQL server as intended so that my test server can be strictly a test/dev environment. It is time to set it up correctly.

What is the process for a migration? Does DBXL need to be "installed" on the SQL server where it will be installed first, then databases restored? Or can I simply restore the db's to the new server? And then I assume connection strings in the InfoPath form need to be updated as well? SharePoint 2007 is installed on a stand-alone server and SharePoint SQL server another stand alone server, used strictly with each other.

I'd like a little advice before I make the move to prevent potentially breaking my InfoPath form and it's connection to database.

How will this affect existing infoPath forms that point to the former databases, after the databases are moved?

Thank you,

Doreen

P.S. We have DBXL version: 2.7.2013.211 installed on SQL Server 2008/SharePoint 2007

Qdabra DBXL Administration Tool Page not found

bhargav007 — Thu, 07 Aug 2014 20:21:40 GMT

I installed Qdabra 2.9 on SharePoint 80 site. I don't see any errors in eventvwr. While I'm trying to open the DBXL Admin tool, it's redirecting to page not found. Can any one help me out?

An error occurred while setting up a SharePoint collection mapping with the adminstrative tool. This could be a user error. In case it is a system problem, error details have been logged.

ericallen — Mon, 19 May 2014 20:58:27 GMT

I just install DBXL 2.8 on a standalone server. I used the DBXL Migration Tool to import my forms from my SharePoint 2010 environment. When I try to save any edits to the imported forms, I receive the following error:

S0002: The remote server returned a 401 Unauthorized response. Possible causes include....

Here is what I found in the Event Viewer:

An error occurred while setting up a SharePoint collection mapping with the adminstrative tool. This could be a user error. In case it is a system problem, error details have been logged.

SharePoint URL:

http://server.com/risk/Auto_Incidents

Exception:

System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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.SharePointSiteData.SiteData.GetSiteAndWeb(String strUrl, String& strSite, String& strWeb)

at Qdabra.Dbxl.Domain.SharePointMethod.EnsureFormLibraryAndPublishXsn(String qdabraWebServiceUrl, DbxlSharePointListMap mapping, ICredentials ssoCredentials, DbxlDocumentTypeProperties docTypeProperties, ISharePointXsnTemplateProvider templateProvider, WindowsIdentity userIdentity)

at Qdabra.Dbxl.Domain.SharePointWebServices.EnsureFormLibrary(String qdabraWebServiceUrl, DbxlSharePointListMap mapping, DbxlDocumentType docType, ISharePointXsnTemplateProvider templateProvider, WindowsIdentity userIdentity)

at Qdabra.Dbxl.Implementation.ServiceImplementation.UpdateSharePointListMappings(DocumentTypeInfo docTypeInfo, DbxlDocumentType docType, Session session)

Stack Trace:

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.SharePointSiteData.SiteData.GetSiteAndWeb(String strUrl, String& strSite, String& strWeb)

at Qdabra.Dbxl.Implementation.ServiceImplementation.UpdateSharePointListMappings(DocumentTypeInfo docTypeInfo, DbxlDocumentType docType, Session session) encountered a critical error and needs attention.

Url: /QdabraWebService/DbxlDocumentService.asmx

One of the form values was too large - could not be converted

Edward Rodman — Mon, 07 Jul 2014 17:06:40 GMT

Hi-

I am getting this error on several fields --

One of the form's values was too large or could not be converted

to the correct data type to be stored in the database.

I can't seem to find which field this is referring to. Is there a way to find which field is causing the issue.

Thanks,,Ed R

Issue with a form saving back to DBXL

TomRenfro — Fri, 20 Jun 2014 19:18:43 GMT

I have designed a form that reads data from a SQL table, then, if the table contains a DocID, I use SwapDOMwithDocument qRules command. I'm not saving the data back to a form library, I just want to store the data in DBXL, then I have the data mapped to the same SQL table. My intent is to allow DBXL to take care of any changes, thus removing security issues between the user, SQL Server, and the form. I also have a trigger on the SQL table that deletes the old entry, then DBXL inserts the new one. Thanks Hilary for this method.

This is working just fine when entries are replaced with new DBXL entries. However, if I'm simply updating data, I'm getting the error "InfoPath cannot submit the form. An error occurred while the form was being submitted." in preview mode, and in the browser I get "An error occurred while trying to connect to a Web service.", with a log id of 5567. Here is the error log entry I retrieved from the server:

06/20/2014 14:12:36.38 SPUCWorkerProcess.exe (0x1340) 0x2F30 InfoPath Forms Services Runtime - Data Connections eq8m Warning Form submission failed. (User: , Form Name: PersonalInfoSheet, IP: , Request: , Form ID: urn:schemas-microsoft-com:office:infopath:PersonalInfoSheet:-myXSD-2013-02-04T19-12-58, Type: DataAdapterException, Exception Message: The remote server returned an error: (400) Bad Request. The remote server returned an error: (400) Bad Request.) 86d5e6ba-7545-4d26-8a8c-1c182988d768

Do I need a separate connection for updates?