Jump to content
Ketarin forum

The server committed a protocol violation. Section=ResponseStatusLine


appyface
 Share

Recommended Posts

@CybTekSol Yes I downloaded it with IE7 fine. Ketarin still can't get it.

 

@flo Already have .NET framework 2.0 sp2 installed. (Checked m$ update just now, not missing any updates and .NET framework 2.0 sp2 is listed as installed. I see the same in add/remove programs applet too, shows it as installed.)

Link to comment
Share on other sites

OK I so I decided to create a separate db for this app, just for testing/troubleshooting, and to post app info and results here for anyone to replicate error message if possible.

 

I created new blank db for Ketarin. Then I imported my global settings file from other Ketarin into this one. Next I tried to import an XML file for this one problem app. I can't import, I get this error message:

 

Failed to import the file: SQLite error no such table: jobs

 

So I thought maybe I have to add the first app manually (I don't recall needing to do this in the past though). I clicked the "add new application button" and get this error:

 

Unhandled exception

SQLite error

no such table: variables.

 

(see bottom of this post for info from the 'details' box from this exception)

 

OK so maybe importing my global settings first is the problem. Delete servu_test.db and have Ketarin create a new one, I tried importing the XML for the problem app, same error. And same error if I try to add an app manually to the empty database...

 

OK so what else can cause this? I am launching Ketarin like this:

Ketarin.exe /DATABASE:servu_test.db

 

and letting Ketarin create the empty db called "servu_test" in my current directory. Is that the problem?

 

Yes it is... If instead I let Ketarin create blank "jobs.db" file I can import my app's XML and my global settings, then rename the db to whatever I like.

 

 

Flo, can this be fixed so that the name of the blank db does NOT have to be jobs.db for the first app to be created/imported? TIA!

 

 

OK on with the testing. I have renamed jobs.db to "servu_test.db" and tried to update. Same protocol error message as before:

 

3/28/2009 12:22:20 PM: Update started with 1 application(s)

3/28/2009 12:22:20 PM: Serv-U FTP Server: Using referer: http://www.serv-u.com/dn.asp

3/28/2009 12:22:25 PM: Serv-U FTP Server: Failed, The server committed a protocol violation. Section=ResponseStatusLine

3/28/2009 12:22:25 PM: Update finished

 

Below is the XML for this app, followed by the JIT debug info for the exception reported above.

 

Can anyone replicate the message? TIA for help...

--appyface

 

 

XML:

<?xml version="1.0" encoding="utf-16"?>

<Jobs>

<ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="fc82d504-e6dd-489a-a3e5-4de99cb25ffe">

<DownloadBeta>Default</DownloadBeta>

<DownloadDate xsi:nil="true" />

<CheckForUpdatesOnly>false</CheckForUpdatesOnly>

<VariableChangeIndicator />

<CanBeShared>true</CanBeShared>

<ShareApplication>false</ShareApplication>

<ExclusiveDownload>false</ExclusiveDownload>

<HttpReferer />

<Variables>

<item>

<key>

<string>vers</string>

</key>

<value>

<UrlVariable>

<RegexRightToLeft>false</RegexRightToLeft>

<VariableType>RegularExpression</VariableType>

<Regex>(?<=Download Serv-U Version ).*?(?= \(.*?>HTTP Download Site)</Regex>

<Url>http://www.serv-u.com/dn.asp</Url>

<StartText>Download Serv-U Version </StartText>

<EndText> (</EndText>

<Name>vers</Name>

</UrlVariable>

</value>

</item>

</Variables>

<ExecuteCommand />

<ExecutePreCommand />

<Category>000100</Category>

<SourceType>FixedUrl</SourceType>

<PreviousLocation>D:\Stuff\filestore\IUtils\ServUSetup_8.0.0.4.exe</PreviousLocation>

<DeletePreviousFile>false</DeletePreviousFile>

<Enabled>true</Enabled>

<FileHippoId />

<LastUpdated>2009-03-27T04:09:51.9735</LastUpdated>

<TargetPath>D:\Stuff\filestore\IUtils\{url:basefile}_{vers}.{url:ext}</TargetPath>

<FixedDownloadUrl>http://www.serv-u.com/susetup1.exe</FixedDownloadUrl>

<Name>Serv-U FTP Server</Name>

</ApplicationJob>

</Jobs>

 

 

-----------------------------------------------------------------------------------

Details from exception error:

 

Unhandled exception

SQLite error

no such table: variables.

 

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

 

************** Exception Text **************

System.Data.SQLite.SQLiteException: SQLite error

no such table: variables

at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)

at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at Ketarin.UrlVariable.get_GlobalVariables()

at Ketarin.Forms.ApplicationJobDialog.RefreshVariables()

at Ketarin.Forms.ApplicationJobDialog.OnLoad(EventArgs e)

at System.Windows.Forms.Form.OnCreateControl()

at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

at System.Windows.Forms.Control.CreateControl()

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

 

************** Loaded Assemblies **************

mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3082 (QFE.050727-3000)

CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

----------------------------------------

Ketarin

Assembly Version: 1.0.5.235

Win32 Version: 1.0.5.235

CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5/Ketarin.exe

----------------------------------------

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System.Data.SQLite

Assembly Version: 1.0.58.0

Win32 Version: 1.0.58.0

CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5/System.Data.SQLite.DLL

----------------------------------------

System.Transactions

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

----------------------------------------

System.Design

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll

----------------------------------------

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3082 (QFE.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

System.Web

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3082 (QFE.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll

----------------------------------------

System.Configuration

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.EnterpriseServices

Assembly Version: 2.0.0.0

Win32 Version: n/a

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

----------------------------------------

ycss5z6e

Assembly Version: 1.0.5.235

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

Accessibility

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

----------------------------------------

1jxa7qo7

Assembly Version: 1.0.5.235

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

kjqdomdb

Assembly Version: 1.0.5.235

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

 

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

 

For example:

 

<configuration>

<system.windows.forms jitDebugging="true" />

</configuration>

 

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

Link to comment
Share on other sites

Do you actually use the latets Ketarin version? I have no problems with creating an empty database in the current directory.

Regarding SP2: Could it possibly be, that your problem started when you installed SP2? (Try SP1 if you think that this is possible).

Link to comment
Share on other sites

@flo

 

Yes I believe Ketarin is at the most current version. It is this one:

Name          Size      Modified                Created
Ketarin.exe   618,496   3/21/2009 12:43:12 PM   3/21/2009 7:55:00 AM

No, definitely not caused by a windows update, .net SP2 or otherwise. My latest update was 3/17/09, Root Certificates. Prior to that, .net 3.5 SP1 and related was installed on 1/28/09 (which some fixes for .net 2.0 sp2). .net SP2 was long before that.

 

 

@Francisco and Flo

 

I had been using (and downloading) Serv-U with Ketarin right up to version 8.0.0.4, which I downloaded with Ketarin on 3/27 about 4am.

 

I ran Ketarin again that night and was surprised to get this error "the server committed a protocol violation"... I went to the website and saw they had released version 8.0.0.5.

 

Like the Java JDK I think the real issue is a moving target? Somewhere after 4am on 3/27 the webpage changed as to how it serves the file, which would explain what you're seeing, Francisco?

 

So the real question, just like in my "Java JDK challenge", might be this: How do we get Ketarin to download this file?

 

OR is this really some kind of .net error...?

 

Thanks everyone. Keep the ideas coming :)

--appyface

Link to comment
Share on other sites

OR is this really some kind of .net error...?

If it is you're not alone (tested w/Vista SP1 patched and XP SP2 unpatched (guine-pig machine)).

 

sss The server committed a protocol violation. Section=ResponseStatusLine (http://www.serv-u.com/susetup1.exe)

 

Yes I believe Ketarin is at the most current version.

Nope. Latest version, available from homepage, is 1.0.5.254. You're using 1.0.5. Try updating from here http://ketarin.canneverbe.com/downloads/Ketarin/

Link to comment
Share on other sites

Thanks Francisco, I also use that page to find latest Ketarin. Silly me, I only glanced at the last entry above debug. (Incorrectly assuming the latest version would also be the last one... d'oh!).

 

OK have now downloaded the current version of Ketarin:

Name          Size      Modified               Created
Ketarin.exe   618,496   3/27/2009 7:36:38 PM   3/29/2009 11:20:40 AM

 

TEST SEQUENCE 1:

 

1. Proceeded to let Ketarin create a blank db from same command line run as before:

Ketarin.exe /DATABASE:servu_test.db

 

2. As soon as the new blank db came up, I tried clicking the 'add new application' button. This time does NOT throw exception as before. I cancelled out without adding an app.

 

3. Next I tried importing my XML for the serv-u application (XML shown here, above). I still get "Failed to import the file: SQLite error no such table: jobs".

 

4. Next I tried importing my global settings XML. The import completed without error, I OK'd the dialog to close. Then I wanted to check on the settings that were imported, I used menu choice File -> Settings and I get this exception thrown:

 

SQLite error

no such table: variables.

(full text of exception is below)

 

5. I clicked "quit" on the exception rather than "continue", this closed Ketarin.

 

6. I relaunched Ketarin.exe /DATABASE:servu_test.db.

 

7. Now I can go to the menu choice File -> Settings without throwing an exception, and I can see my new settings were imported correctly.

 

8. So I tried to import the Serv-U app XML again, but still get same SQLite error message, "no such table: jobs".

 

9. So I tried clicking the 'add application' button again. But this time I get same exception thrown as above, "no such table: variables".

 

OK so once my settings are imported everything is fouled up, apparently...

 

TEST SEQUENCE 2:

 

1. I deleted "servu_test.db" and relaunched Ketarin.exe /DATABASE:servu_test.db to create a new blank one.

 

2. I used "add application" button and added a bogus application. All OK so far.

 

3. Then tried importing my Serv-U app XML, still get same error message "no such table: jobs".

 

4. I closed Ketarin and relaunched Ketarin.exe /DATABASE:servu_test.db.

 

5. Bogus app still on display, all good so far.

 

6. Then tried import of Serv-U app XML, and still get same error message "no such table: jobs".

 

I give up.

 

Francisco would you try to replicate? Just use my same command line invocation as above (I have my command line is in a .bat file in same directory with Ketarin, SQLLite dll and the DB). Just your own single app XML and global settings XML at the appropriate places, or try my Serv-U jobs XML (above). Do you get the same errors? TIA if you have time to try to replicate this.

 

--appyface

 

 

Thrown exception:

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

 

************** Exception Text **************

System.Data.SQLite.SQLiteException: SQLite error

no such table: variables

at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)

at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at Ketarin.UrlVariable.get_GlobalVariables()

at Ketarin.Forms.SettingsDialog.LoadGlobalVariables()

at Ketarin.Forms.SettingsDialog.LoadSettings()

at Ketarin.Forms.SettingsDialog.OnLoad(EventArgs e)

at System.Windows.Forms.Form.OnCreateControl()

at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

at System.Windows.Forms.Control.CreateControl()

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

 

************** Loaded Assemblies **************

mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3082 (QFE.050727-3000)

CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

----------------------------------------

Ketarin

Assembly Version: 1.0.5.254

Win32 Version: 1.0.5.254

CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5.254/Ketarin.exe

----------------------------------------

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System.Data.SQLite

Assembly Version: 1.0.58.0

Win32 Version: 1.0.58.0

CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5.254/System.Data.SQLite.DLL

----------------------------------------

System.Transactions

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

----------------------------------------

System.Design

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll

----------------------------------------

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3082 (QFE.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

System.Web

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3082 (QFE.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll

----------------------------------------

System.Configuration

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.EnterpriseServices

Assembly Version: 2.0.0.0

Win32 Version: n/a

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

----------------------------------------

vu0ekrtw

Assembly Version: 1.0.5.254

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

xcfmnk6o

Assembly Version: 1.0.5.254

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

_pkgx0p4

Assembly Version: 1.0.5.254

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

 

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

 

For example:

 

<configuration>

<system.windows.forms jitDebugging="true" />

</configuration>

 

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

Link to comment
Share on other sites

Thanks Stalker! You snuck in while I was posting the 2nd novella :)

 

Stalker if you have time would you try to replicate my blank db errors I outlined just above? As is usual, I've got two separate errors going in this thread, one for the download of Serv-U and one for the creation and importing to blank db that is NOT named jobs.db... and need help on both...

 

TIA if you have time to try it out...

--appyface

Edited by appyface
Link to comment
Share on other sites

Thanks Stalker. Yes I think the download of Serv-U is a problem with how they changed their webpage, that Ketarin cannot handle.

 

So, you had no problem creating the blank db and importing the Servu XML from above immediately?

 

How about a global settings XML file, can you export that from another Ketarin db, then import it into a brand-new blank servu_test.db (which should work), then review it with File -> Settings (without closing the Ketarin instance yet)?

Link to comment
Share on other sites

*****UPDATE******

 

I found the problem with the Serv-U and settings import. My XML files were in another directory than where Ketarin is, a zero-length "servu_test.db" file is being created in the DIRECTORY WHERE THE XML FILES ARE when I do the import.

 

Stalker, please try again but locate your XML for servu job import, in a directory higher than where Ketarin is. In my case I'm running Ketarin from directory D:\Program_Files_NOINST\Ketarin-1.0.5.254\, my XML files for servu job and for settings are in D:\Program_Files_NOINST\.

 

See if you can recreate this way? TIA,

--appyface

 

 

@Flo -- yes that's the difference for me. If my XML files are in the SAME directory with Ketarin and the servu_test.db, all is well. If I navigate to the other directory and load the XML files from there, that is what causes all the errors.

 

We'll see if Stalker and/or Francisco can replicate. Flo can you replicate? TIA,

--appyface

Edited by appyface
Link to comment
Share on other sites

Settings did not import completely. None of my global variables have been imported although I got no exceptions. Oh and the log file said that database backup could not be created.

 

 

EDIT to your EDIT:

Both my settings.xml and servu.xml were imported from a directory one level higher then Ketarin.

Ketarin's location: ~/Desktop/Ketarin (sorry for *nix ~, it's shorted and easier :P)

XML location: ~/Desktop/

Edited by Stalker
Link to comment
Share on other sites

So you could reproduce my latest step-by-step test? The settings DO import (from file in other directory than Ketarin's) but then you can't review them without throwing the exception? And the import of job XML (from file in other directory than Ketarin's) also gives the error message (there is no exception for me in that case)?

 

TIA for all your help.

 

Now I think it is up to Flo...

Link to comment
Share on other sites

So you could reproduce my latest step-by-step test? The settings DO import (from file in other directory than Ketarin's) but then you can't review them without throwing the exception?

Not an exception, no. Variables just aren't imported. No messages, exceptions or log entries are shown.

 

And the import of job XML (from file in other directory than Ketarin's) also gives the error message (there is no exception for me in that case)?

Nope to that too. The job imports fine and runs fine (well, shows Section=blablabla error because I've used ServU but still).

 

Maybe the problem in your specific settings file ? Mine is very simple. I'll attach it just so that you could try it out.

<?xml version="1.0"?>
<dictionary>
 <item>
   <key>
     <string>AuthorGuid</string>
   </key>
   <value>
     <string>System.String:{e2257af6-5cdb-4c29-98c0-ef1a84f48397}</string>
   </value>
 </item>
 <item>
   <key>
     <string>ImportFromDatabaseDialog/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:559,340</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Application name:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Application name:Width</string>
   </key>
   <value>
     <string>System.Int32:343</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Last updated:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Last updated:Width</string>
   </key>
   <value>
     <string>System.Int32:130</string>
   </value>
 </item>
 <item>
   <key>
     <string>MainForm/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:884,520</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Application:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Application:Width</string>
   </key>
   <value>
     <string>System.Int32:216</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Last updated:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Last updated:Width</string>
   </key>
   <value>
     <string>System.Int32:110</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Progress:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Progress:Width</string>
   </key>
   <value>
     <string>System.Int32:100</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Target:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Target:Width</string>
   </key>
   <value>
     <string>System.Int32:210</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Category:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Category:Width</string>
   </key>
   <value>
     <string>System.Int32:80</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Custom Value:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Custom Value:Width</string>
   </key>
   <value>
     <string>System.Int32:105</string>
   </value>
 </item>
 <item>
   <key>
     <string>Ketarin/ShowGroups</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>EditVariablesDialog/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:1165,755</string>
   </value>
 </item>
 <item>
   <key>
     <string>ApplicationJobDialog/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:413,353</string>
   </value>
 </item>
 <item>
   <key>
     <string>DefaultCommand</string>
   </key>
   <value>
     <string>System.String:</string>
   </value>
 </item>
 <item>
   <key>
     <string>UpdateAtStartup</string>
   </key>
   <value>
     <string>System.Boolean:False</string>
   </value>
 </item>
 <item>
   <key>
     <string>CustomColumn</string>
   </key>
   <value>
     <string>System.String:{version}</string>
   </value>
 </item>
 <item>
   <key>
     <string>AvoidFileHippoBeta</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>SimilarApplicationsDialog/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:330,340</string>
   </value>
 </item>
 <item>
   <key>
     <string>ErrorsDialog/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:1292,801</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/Application:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/Application:Width</string>
   </key>
   <value>
     <string>System.Int32:169</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/Error:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/Error:Width</string>
   </key>
   <value>
     <string>System.Int32:1077</string>
   </value>
 </item>
 <item>
   <key>
     <string>ConnectionTimeout</string>
   </key>
   <value>
     <string>AAEAAAD/////AQAAAAAAAAAEAQAAAA5TeXN0ZW0uRGVjaW1hbAQAAAAFZmxhZ3MCaGkCbG8DbWlkAAAAAAgICAgAAAAAAAAAAAoAAAAAAAAACw==</string>
   </value>
 </item>
 <item>
   <key>
     <string>ThreadCount</string>
   </key>
   <value>
     <string>System.Int32:3</string>
   </value>
 </item>
 <item>
   <key>
     <string>ProxyPort</string>
   </key>
   <value>
     <string>AAEAAAD/////AQAAAAAAAAAEAQAAAA5TeXN0ZW0uRGVjaW1hbAQAAAAFZmxhZ3MCaGkCbG8DbWlkAAAAAAgICAgAAAAAAAAAAAAAAAAAAAAACw==</string>
   </value>
 </item>
 <item>
   <key>
     <string>ProxyServer</string>
   </key>
   <value>
     <string>System.String:</string>
   </value>
 </item>
 <item>
   <key>
     <string>ProxyUser</string>
   </key>
   <value>
     <string>System.String:</string>
   </value>
 </item>
 <item>
   <key>
     <string>ProxyPassword</string>
   </key>
   <value>
     <string>System.String:</string>
   </value>
 </item>
 <item>
   <key>
     <string>LastUpdateCheck</string>
   </key>
   <value>
     <string>AAEAAAD/////AQAAAAAAAAAEAQAAAA9TeXN0ZW0uRGF0ZVRpbWUCAAAABXRpY2tzCGRhdGVEYXRhAAAJEIgn0QmOfssIiCfRCY5+y4gL</string>
   </value>
 </item>
 <item>
   <key>
     <string>MainForm/Location</string>
   </key>
   <value>
     <string>System.Drawing.Point:396,0</string>
   </value>
 </item>
 <item>
   <key>
     <string>Ketarin/ShowLog</string>
   </key>
   <value>
     <string>System.Boolean:False</string>
   </value>
 </item>
 <item>
   <key>
     <string>RetryCount</string>
   </key>
   <value>
     <string>System.Int32:1</string>
   </value>
 </item>
 <item>
   <key>
     <string>UpdateOnlineDatabase</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>LogDialog/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:1144,701</string>
   </value>
 </item>
 <item>
   <key>
     <string>LogDialog/Location</string>
   </key>
   <value>
     <string>System.Drawing.Point:0,69</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/LastSortColumn</string>
   </key>
   <value>
     <string>System.String:Category</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/LastSortOrder</string>
   </key>
   <value>
     <string>System.Windows.Forms.SortOrder, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089:Ascending</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/LastSortColumn</string>
   </key>
   <value>
     <string>System.String:Application name</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/LastSortOrder</string>
   </key>
   <value>
     <string>System.Windows.Forms.SortOrder, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089:None</string>
   </value>
 </item>
 <item>
   <key>
     <string>ProgressDialog/Size</string>
   </key>
   <value>
     <string>System.Drawing.Size:292,99</string>
   </value>
 </item>
 <item>
   <key>
     <string>EditVariablesDialog/Location</string>
   </key>
   <value>
     <string>System.Drawing.Point:18,23</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/LastSortColumn</string>
   </key>
   <value>
     <string>System.String:Application</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/LastSortOrder</string>
   </key>
   <value>
     <string>System.Windows.Forms.SortOrder, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089:Ascending</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Application name:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Last updated:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Application:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Last updated:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Progress:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Target:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Category:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvJobs/Custom Value:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>MinimizeToTray</string>
   </key>
   <value>
     <string>System.Boolean:False</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/Application:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvErrors/Error:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Uses:Visibility</string>
   </key>
   <value>
     <string>System.Boolean:True</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Uses:Width</string>
   </key>
   <value>
     <string>System.Int32:40</string>
   </value>
 </item>
 <item>
   <key>
     <string>olvApplications/Uses:LastDisplayIndex</string>
   </key>
   <value>
     <string>System.Int32:-1</string>
   </value>
 </item>
 <item>
   <key>
     <string>DefaultApplication</string>
   </key>
   <value>
     <string>System.String:<?xml version="1.0" encoding="utf-16"?>
<Jobs>
 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <DownloadBeta>Default</DownloadBeta>

   <CheckForUpdatesOnly>false</CheckForUpdatesOnly>
   <VariableChangeIndicator />
   <CanBeShared>true</CanBeShared>
   <ShareApplication>true</ShareApplication>
   <ExclusiveDownload>false</ExclusiveDownload>
   <HttpReferer />
   <Variables />
   <ExecuteCommand />
   <ExecutePreCommand />
   <Category />
   <SourceType>FixedUrl</SourceType>

   <DeletePreviousFile>true</DeletePreviousFile>
   <Enabled>true</Enabled>
   <FileHippoId />

   <TargetPath>{DEST_DIR}\{category}\{appname}_v{version}.{url:ext}</TargetPath>
   <FixedDownloadUrl />
   <Name />
 </ApplicationJob>
</Jobs></string>
   </value>
 </item>
</dictionary>

Link to comment
Share on other sites

Hm, could you possibly examine the .db file with SQLiteSpy? For example, after the start of Ketarin, the database file should exist. At the same time, the tables jobs, variables and settings should have been created. Maybe you can verify that?

Link to comment
Share on other sites

Same error (=appyface, "Failed to import the file: SQLite error no such table: jobs") here.

 

C:\Documents and Settings\Owner>c:\"Documents and Settings\Owner\My Documents"\K

etarin\Ketarin.exe /DATABASE:jobs_serv-u.db

 

And XML in desktop.

Edited by FranciscoR
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.