Qdabra Database Accelerator

Re: Installation Trouble

jrishe — Mon, 03 Mar 2008 00:36:25 GMT

Thank you for the offer. I'm going to play around to see what I can figure out for now, but I'm sure I will be back with questions before long.

Jimmy

Re: Installation Trouble

Clay Fox — Sun, 02 Mar 2008 22:58:01 GMT

Great to hear that Jimmy.

If you would like to discuss how to use it or see some example scenarios just send me an email and we could set something up. There is a tremendous amount of functionalty it enables so it is often nice to get an overview instead of trying to discover it all from scratch.

Re: Installation Trouble

jrishe — Sun, 02 Mar 2008 17:05:43 GMT

Thank you for the speedy response.

Looks like that did the trick, and after a quick Permissions Wizard in the IIS control panel, I can see the DBXL control panel in my browser.

Just to confirm, I had previously re-initialized ASP.NET (I was getting the 405 error), but that hadn't resolved the ASPNET permissions issue.

Now to get started on those tutorials.

Thanks again,
Jimmy

Re: Installation Trouble

Clay Fox — Sun, 02 Mar 2008 16:27:32 GMT

Have you tried reinitiallizing ASP. NET on your machine? http://www.infopathdev.com/files/folders/dbxlinstall/entry22502.aspx

Your website uses ASP.NET user and so as the installer is being configured it is not getting access to the files it needs.

If reinitializing does not work then I would look at elevating the permissions for ASPNET temporarily.

Go to Administrativr tools - Computer Management - local users and groups and put the ASPNET account in the admins group for the install and then you should be able to remove it afterwards. That would give it the permissions it needs.

Re: Installation Trouble

jrishe — Sun, 02 Mar 2008 15:42:16 GMT

Hello everyone.
Trying to install the free developer version of DBXL tonight, and I am also getting the error: "Description: Error Initializing DBXL database. Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'."
I have tried the several fixes above (modifying web.config mid-install, modifying Qdabra.Dbxl.Installer.InstallState), but without any luck.

This is my system information:

Windows XP Professional 5.1.2600
IIS 5.1
SQLSERVER EXPRESS

Looking in the Event Viewer, I seem to be getting this error every time:
------------------------
Exception information:
    Exception type: HttpException
    Exception message: The current identity (JIMMY-4D0D1315A\ASPNET) does not have write access to 'C:\WINDOWS2\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.

Request information:
    Request URL: http://jimmy-4d0d1315a/QdabraWebService/DbxlAdmin.asmx
    Request path: /QdabraWebService/DbxlAdmin.asmx
    User host address: 192.168.1.2
    User:
    Is authenticated: False
    Authentication Type:
    Thread account name: JIMMY-4D0D1315A\ASPNET

Thread information:
    Thread ID: 1
    Thread account name: JIMMY-4D0D1315A\ASPNET
    Is impersonating: False
    Stack trace:    at System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection)
   at System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags)
------------------------
Un-checking the read-only box in the properties for "C:\WINDOWS2....Temporary ASP.NET Files" doesn't help (in fact, all of the folders on my system show a green square (not checkmark) in the read-only box, which reappears if I close and open the properties. Not sure if this is normal.)

This may be obvious to everyone else here, but I'm not sure why it is trying to access the folder as user ASPNET, or how to give ASPNET write permissions. I am not myself logged on as ASPNET and did not create a user by that name.

I apologize if this is an elementary question. I am brand new to Windows web services and somewhat inexperienced with Windows administration.

Thanks in advance for any help I can get.

Jimmy

Re: Installation Trouble

ErnestoM — Mon, 14 Jan 2008 19:27:44 GMT

Awesome, this worked. Thanks Matt!

Re: Installation Trouble

Matt Faus — Mon, 14 Jan 2008 18:23:53 GMT

The problem arises after running the Repair operation. This document explains how to workaround the problem by editing the InstallState file:

http://www.infopathdev.com/files/folders/dbxlinstall/entry22506.aspx

Re: Installation Trouble

ErnestoM — Fri, 11 Jan 2008 18:22:05 GMT

jthrasher:
I can't get the uninstall to complete :( "An exception occurred while uninstalling. This exception will be ignored and the uninstall will continue. However, the application might not be fully uninstalled after the uninstall is complete. --> The savedState dictionary contains inconsistent data and might have been corrupted"
Since the uninstall wouldn't complete, I thought I'll just do a repair and change the Document Security settings to what I want...Wrong again, I get an error when finishing this too :( "The installation failed, and the rollback was performed. --> Count cannot be less than zero. Parameter name: count"

I'm getting the same uninstall error reported here. Is there a known solution?

Re: Installation Trouble

Clay Fox — Tue, 18 Sep 2007 13:49:42 GMT

Hi Duncan, sorry you are having issues.

Typically this is a permissions issue.

The account you are using during the installation should be in the local administrators group.

It needs to have the ability to create the web componenets in IIS.

Also the account DBXL will run under, if you are using the default, the Network Service account, must have access to the directory 'c:\inetpub\wwwroot\web.config' which is what the error here is referring to. Typically by default IIS gives most accounts read and execute permissions.

Check the permissions on your inetpub folder as well as your account.

Typically the Network Service account needs to be added to SQL for DBXL to interact with the tables there so make sure you have done this as well..

Re: Installation Trouble

Duncan Nimmo — Tue, 18 Sep 2007 09:52:23 GMT

Getting a similar error when installing to SharePoint 2003:

Error initializing DBXL database.

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message:

<html>

<head>

<title>Configuration Error</title>

<style>

body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}

p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}

b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}

H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }

H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }

pre {font-family:"Lucida Console";font-size: .9em}

.marker {font-weight: bold; color: black;text-decoration: none;}

.version {color: gray;}

.error {margin-bottom: 10px;}

.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

</style>

</head>

<span><H1>Server Error in '/QdabraWebService' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

<b> Parser Error Message: </b>An error occurred loading a configuration file: Access to the path 'c:\inetpub\wwwroot\web.config' is denied.<br><br>

<b>Source Error:</b> <br><br>

<tr>

<td>

[No relevant source lines]</pre></code>

</td>

</tr>

</table>

<br>

<b> Source File: </b> c:\inetpub\wwwroot\web.config<b> Line: </b> 0

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

</font>

</body>

</html>

<!--

[UnauthorizedAccessException]: Access to the path 'c:\inetpub\wwwroot\web.config' 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, FileShare share)

at System.Configuration.Internal.InternalConfigHost.StaticOpenStreamForRead(String streamName)

at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName, Boolean assertPermissions)

at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName)

at System.Configuration.Internal.DelegatingConfigHost.OpenStreamForRead(String streamName)

at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()

[ConfigurationErrorsException]: An error occurred loading a configuration file: Access to the path 'c:\inetpub\wwwroot\web.config' is denied. (c:\inetpub\wwwroot\web.config)

at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)

at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)

at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)

at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)

at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)

at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)

at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)

at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring()

at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()

at System.Web.Management.HealthMonitoringManager..ctor()

at System.Web.Management.HealthMonitoringManager.Manager()

at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source)

at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)

at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)

-->

--.

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

Re: Installation Trouble

Patrick Halstead — Wed, 04 Jul 2007 04:07:16 GMT

Hi JThrasher,

Glad to hear you figured it out. I'm sorry that the uninstall didn't succeed. If you still have the event log, that would be very interesting to look at. Let us know how we can help and if you'd like to see a demo of v2.1 which we hope to release in the near future.

Cheers!

Re: Installation Trouble

jthrasher — Tue, 03 Jul 2007 15:14:20 GMT

Woohoo! I finally got DBXL working correctly. Since the Uninstall wasn't working I had to go through the registry and remove all the Qdabra keys. Once I did that, I was able to reinstall fresh and set the permissions correctly.

Re: Installation Trouble

jthrasher — Fri, 29 Jun 2007 16:54:42 GMT

OK, so I finanlly got this installed successfully on the VM by creating a new SharePoint Site and selecting the new site as the install "site". Unfortunately, now I seem to be having more problems.

I can access the DBXL admin site fine, but when I attempt to submit a new form I get the error "DAT-Template Error: Save Unsuccessful I0033: Access Denied". I thought maybe this was because I left Document Security as "Builtin\Administrators" by default. So I thought, no big deal, I'll just uninstall DBXL and reinstall it with different rights....WRONG. I can't get the uninstall to complete :( "An exception occurred while uninstalling. This exception will be ignored and the uninstall will continue. However, the application might not be fully uninstalled after the uninstall is complete. --> The savedState dictionary contains inconsistent data and might have been corrupted"

Since the uninstall wouldn't complete, I thought I'll just do a repair and change the Document Security settings to what I want...Wrong again, I get an error when finishing this too :( "The installation failed, and the rollback was performed. --> Count cannot be less than zero. Parameter name: count"

Re: Installation Trouble

Patrick Halstead — Fri, 29 Jun 2007 07:56:37 GMT

Hi again,

This is a known issue when doing an install with SharePoint. SharePoint registers handlers that interrupt the installation of other Web services on the same site. You could edit the Web.config on the default site to remove the SharePoint lines, do the DBXL install and then add them back (with the Web.config for QdabraWebService updated).

Anyway, I really appreciate your perseverance. Too bad it's hard to install Web services on top of SharePoint. The workaround should work though.

Good luck!

Re: Installation Trouble

Jim Cantwell — Thu, 28 Jun 2007 22:52:13 GMT

Did you try installing on a non-Sharepoint/MOSS site?