InfoPath Dev

Dear Colleague,

When I attempt to start the DBXL DAT, InfoPath Designer is started, but I receive the error message
that the requested template cannot be found. The error message follows:

Form template: http://randyramin-w-pc/QdabraWebService/Forms/DAT/template.xsn
The following form template for the form cannot be found: http://randyramin-w-pc/QdabraWebService/Forms/DAT/template.xsn

I then proceeded to invoke the web service PublishDATFormTemplate in order to publish the template
corresponding to the DBXL DAT. For this I invoked the web service PublishDATFormTemplate
with the parameter: C:\Inetpub\wwwroot\QdabraWebService\install

I received the following error:

  <?xml version="1.0" encoding="utf-8" ?>
- <StatusInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://qdabra.com/webservices/">
  <Success>false</Success>
- <Errors>
- <ErrorInfo>
  <Code>I9999</Code>
  <Description>An unhandled exception was thrown: Access to the path 'C:\Inetpub\wwwroot\QdabraWebService\install' is denied.</Description>
  </ErrorInfo>
  </Errors>
  <ExecutionTime>00:00:00</ExecutionTime>
  </StatusInfo>
 

After I changed the security privileges on the DAT-template.xsn file such that the group
IIS_IUSRS (Randy-Ramin-W-PC\IIS_IUSRS) no longer had merely read privileges but instead
was granted full control, I was able to start InfoPath Designer, but it cannot find the underlying
template.

I am using Vista. Does this access problem have anything to do with the known WEBDAV bug under Vista?

If yes, then the installation guide states that I need to copy the dll Qdabra.Dbxl.WebDAV.dll
into the bin folder of the Default Web Site. However, I currently have no bin folder in the
Default Web Site. Should I first create a bin folder and then copy into it or should I just copy it
into the wwwroot folder?

As I am new to DBXL and trying to setup an installation to evaluate it, I would appreciate it if
someone can give me jump start and get me up and running.

Thanks and kind regards,

Randy

 Hello,

 Sorry to hear you're having trouble.  I'm not familiar with this issue, but I believe the instructions are telling you to put the DLL in the bin folder of the QdabraWebService site, so it looks like on your machine that would be:

 C:\Inetpub\wwwroot\QdabraWebService\bin

Please give that a try and let us know if it helps.

Please also see if replacing your server name with localhost helps, like this:

http://localhost/QdabraWebService/Forms/DAT/template.xsn

Hi Randy,

Though I have not seen this specific sequence of messages, I know that some customers have experienced a similar issue when opening DAT. Those issues were due to the fact that they had both InfoPath 2003 and InfoPath 2007 installed on the machine. Though perhaps that is not the case for you, the workaround used by them may help to unblock you.

1. Open InfoPath 2007.

2. Select File > Fill Out a Form

3. Click On My Computer (under Open a form)

4. Paste in the URL to the DAT. In my case I use http://localhost/QdabraWebService/Forms/DAT/template.xsn. Open.

RESULT: DAT will open.

Let us know if this works, or if it returns a different error message. Also, please check the Qdabra even logs for any errors.

Thanks.

Dear Enersto,

Thanks for the tip.

When I attempted to do what you describe,

1. When I entered the URL address, http://randyramin-w-pc/QdabraWebService/Forms/DAT/template.xsn or more simply http://randyramin-w-pc/QdabraWebService/install/DAT-template.xsn I received the following error message:

 Path does not exist. Change it and try again.

2. When I entered the non-URL address, C:\inetpub\wwwroot\QdabraWebService\install\DAT-template.xsn I received the following error message:

This form cannot be opened because it requires the domain permission level and it currently has restricted permission. To fix this problem, open the form from the location it was published to.

Published Location: file:///c:\qdabra%20source\Cadabra\DBXL-v2.3\DAT\DAT-template.xsn

Forms that require the domain permission level contain features that access information on a network, such as data connections, linked images, and code. 

This is new information!

a) First of all, my computer is not connected to a domain

b) Secondly, the Published Location: file:///c:\qdabra%20source\Cadabra\DBXL-v2.3\DAT\DAT-template.xsn does not exist on my computer.

c) Thirdly, the link on the DBXL Console to the DBXL Administrator points to : http://randyramin-w-pc/QdabraWebService/Forms/DAT/template.xsn but the subdirectory /Forms/DAT does not on my computer. The corresponding DAT template

is in the http://randyramin-w-pc/QdabraWebService/install directory and is called DAT-template.xsn

Am I required to have domain account for DBXL to work?

Any further ideas given this new information?

Kind regards,

Randy

Dear Jimmy,

Thank you for the tip. In the meantime, I have tested what you suggested, but it had no effect. That is, I copied Qdabra.Dbxl.WebDAV.dll into the C:\Inetpub\wwwroot\QdabraWebService\bin folder.

I also attempted to implement the action in the installation guide of copying the Qdabra.Dbxl.WebDAV.dll into the root directory and creating a Global Assembly Cache, but this was not possible as it was not "Strongly Named", i.e. no name, version and public key.

Kind regards,

Randy

Hi Randy,

Yes, DBXL can only be installed on machines that are part of a domain. Did any related errors come up during installation (in the Event Viewer)?

Do you have a machine that is joined to a domain?

Thanks,

Dear Ernesto,

Thanks for the critical information. Currently, I am not part of a domain. However, I spoke with our system administrator and found out that I can have a domain account probably some time next week.Does this mean that I should deinstall DBXL and reinstall it when I get the Windows domain account?

Regarding the Event Viewer, yes there were a number of errors listed. In particular, there were errors during the installation when attempts were made to insert data into the DBXL repository. By the way, the current setup I have is:

- DBXL database is on a remote server (with SQL Server 2008)

- DBXL is installed on MS Vista business (my laptop)

- InfoPath 2007 is installed on MS Vista business (my laptop)

- SharePoint is not installed

A Excerpt of Errors from the Event Viewer follow:

In general, it looks as if an error occurs as data will be truncated, i.e. the insert statement is too long?

Errors Setting up the DBXL Repository, for example:

SetDocumentType encountered a critical error and needs attention:

DevExpress.Xpo.DB.Exceptions.SqlExecutionErrorException: Executing Sql    'insert into "dbo"."DocumentType" ... exception 'System.Data.SqlClient.SqlException: String or binary data would be truncated.

Errors Deploying the Sample DB, for example:

Errors When attempting to Access the DBXL Admin Tool, for example:

DbxlAdmin.PublishDATFormTemplate encountered a critical error and needs attention:

System.UnauthorizedAccessException: Access to the path 'C:\Inetpub\wwwroot\QdabraWebService\install' is denied.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
   at Qdabra.Dbxl.WebService.AdminService.PublishDATFormTemplate(String templateFilePath)

Best regards,

Randy

 Hello again Randy.

The /Forms subdirectory of your site is a virtual directory, and does not physically exist on the disk in inetpub. You can see how it is defined by opening web.config and looking for the <location path="Forms">...</location> section at the bottom.

I was a bit unclear from your first message, but were you eventually able to invoke the PublishDATFormTemplate webmethod and get a success message?  It sounded like you initially had a file permissions issue there, but did you successfully call it? That is necessary in able to be able to access DAT at the /Forms/DAT/template.xsn location.

When using the PublishDATFormTemplate api, you need to specify the full path to the file.  In you case, it should be c:\inetpub\wwwroot\QdabraWebService\install\dat-template.xsn

DBXL currently requires the machine be joined with a domain to work properly.  Anonymous access is not supported, you can use the NT Authority\Authenticated Users for the global Reader alias during installation to allow everyone access to a document type.

Also, Vista can cause issues because of UAC (User Access Control) that prevents you being seen as an administrator.  You must run IE using 'Run as Administrator' to be seen by DBXL as a member of the local Administrators group.  It can be easier on Vista if you create a local group called DBXLAdmins and then add yourself to that group and then update the web.config for the Admin group alias.

Dear Jim,

Thank you for the additional insight into my problem. I made another step forward! (I think)

This time, before I invoked the  PublishDATFormTemplate web service with the full path as you wrote above, I ran the IE with "run as Administrator" and was thereby granted access. However, there was an error when an attempt was made to insert a record into the "dbo"."DocumentType" table in the DBXL repository. The error message is shown below. It looks like the same type of problem I noticed in the Event Viewer during the installation, namely:

... exception 'System.Data.SqlClient.SqlException: String or binary data would be truncated....

Do you have any idea what the problem is? I am using SQL Server 2008 (and not 2005). I assume that is not the problem.

Kind regards,

Randy

BODY{font:x-small 'Verdana';margin-right:1.5em} .c{cursor:hand} .b{color:red;font-family:'Courier New';font-weight:bold;text-decoration:none} .e{margin-left:1em;text-indent:-1em;margin-right:1em} .k{margin-left:1em;text-indent:-1em;margin-right:1em} .t{color:#990000} .xt{color:#990099} .ns{color:red} .dt{color:green} .m{color:blue} .tx{font-weight:bold} .db{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;border-left:1px solid #CCCCCC;font:small Courier} .di{font:small Courier} .d{color:blue} .pi{color:blue} .cb{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;font:small Courier;color:#888888} .ci{font:small Courier;color:#888888} PRE{margin:0px;display:inline}0) fix(e,"cb");} if (e.className=="di"){if (e.children(0).innerText.indexOf("\n")>0) fix(e,"db");} e.id=""; } function fix(e,cl){ e.className=cl; e.style.display="block"; j=e.parentElement.children(0); j.className="c"; k=j.children(0); k.style.visibility="visible"; k.href="http://www.infopathdev.com/forums/AddPost.aspx?ReplyToPostID=43129&Quote=False#"; } function ch(e){ mark=e.children(0).children(0); if (mark.innerText=="+"){ mark.innerText="-"; for (var i=1;i

Dear Jimmy,

Thanks for the explanation about the virtual directories.

Actually, I was able to work around the file permissions problem by starting IE with "run as administrator" (as suggested by Normal 0 21 false false false DE-CH X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} Jim Cantwell). However, I experienced an error when an attempt was made to  insert into the DocumentType table. Please refer to the error message in the previous posting.

Does this spark any idea as to what the underlying problem could be?

Kind regards,

Randy

Correct, SQL Server 2008 should not be the problem.  SQL Server 2008 is supported and I run with SQL Server 2008 on my installation as well. 

Can you provide the values you provided for the DocumentType?  Just before you select Save for the Document Type, do a 'Save As' from the File menu and then email the xml file to  Support at Qdabra.com

Thanks

As requested, I sent a response (with attachments) to the support email address.

For documentation purposes, I include the essential part of the email below that I sent to Qdabra Support .

Kind regards,

Randy

Email Extract: 

Since the truncation error is occuring during PublishDATFormTemplate, the only thing I can think of is that the QdabraDBXL database has been modified or some other external setting has prevented the database from getting created properly on installation.

Could you provide a backup of the QdabraDBXL database? 

I am also assuming that since your machine is not part of a domain, that you used SQL Authentication.  Is this correct?  The SQL Account used will need to have sysadmin permissions during installation.  It can be scaled back to db_datareader + db_datawriter permissions after the installation is completed.

Dear Jim,

As you requested I sent you a backup of the database in which I installed the DBXL repository to the Qdabra support email account.

I have established that I did NOT have sysadmin privileges at the time of DBXL installation. In the meantime, I was granted sysadmin privileges. Should I deinstall DBXL and reinstall it now with my sysadmin privileges?

Best regards,

Randy Ramin-Wright