Upgrade error "Server error in '/lansweeper32' Application

[lhawk]

I went through the upgrade PDF and get this:
Server Error in '/lansweeper32' Application.
--------------------------------------------------------------------------------

Column 'nonactive' does not belong to table theTable.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Column 'nonactive' does not belong to table theTable.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[ArgumentException: Column 'nonactive' does not belong to table theTable.]
System.Data.DataRow.GetDataColumn(String columnName) +1773557
System.Data.DataRow.get_Item(String columnName) +13
ASP.state_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +1154
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
System.Web.UI.Page.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1266




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

Any clue as to what's up?

[lhawk]

Issue resolved. I restored by DB to before upgrade attempts. Had my DBA run the sql upgrade script directly in SQL. He received some errors but site comes up now, and it is scanning computers again. Thanks for the help.

[lhawk]

I sent an email cause I have no easy way to upload an image right now.

[Hemoco]

Could you post a screenshot of the sql console please with the error on it.

[lhawk]

Same thing:
There is already an object named 'TsysConfig' in the database

Should I delete that table and run again since it is trying to recreate it?

[Hemoco]

What I meant was: do not use the upgrade tool but use the management tools that came with SQL server, then provide the errors.

[lhawk]

What I sent in the second post is what I get when I run the SQL script. Does it matter that we are connecting to a MS SQL2000 server running on another server?

[Hemoco]

Could you post the errors you got when running from the sqlserver console please.
PS. make sure you select the correct database and not the master database.

[lhawk]

I re-ran it again twice. Both time I got "There is already an object named 'TsysConfig' in the database" when executed. Also both timest the same errors appears in the site.

[Hemoco]

Please rerun the sql upgrade script from the sqlserver management console.
Ignore any error you should receive.