invalid object named 'TsysConfig

[golhelpdesk]

When I open the GUI console, I get the following error: invalid object named 'TsysConfig after upgrading from 3.2 to 3.5.

I tried running the SQL script a 2nd time, but still receive the same error. Any ideas on how to fix this?

[Marco]

Thanks ...

It's work directly in "SQL Management Studio" --> Database --> New Query ....

[golhelpdesk]

Try running it from the Query Analyzer. That also works

[Marco]

If I try to execute just a part of the code the result is "Command completed successfully"

ALTER TABLE [tsysassetlinks] NOCHECK CONSTRAINT ALL
INSERT INTO [tsysassetlinks] ([Vendor],[Assetlink]) VALUES ('Hewlett-Packard','http://search.hp.com/query.html?cc=us&lang=en&qt={model}')
INSERT INTO [tsysassetlinks] ([Vendor],[Assetlink]) VALUES ('HP','http://search.hp.com/query.html?cc=us&lang=en&qt={model}')
INSERT INTO [tsysassetlinks] ([Vendor],[Assetlink]) VALUES ('IBM','http://www-307.ibm.com/pc/support/site.wss/quickPath.do?sitestyle=lenovo&quickPathEntry={model}')
INSERT INTO [tsysassetlinks] ([Vendor],[Assetlink]) VALUES ('Compaq','http://search.hp.com/query.html?cc=us&lang=en&qt={model}')
ALTER TABLE [tsysassetlinks] CHECK CONSTRAINT ALL
GO

[Marco]

Hello,

I have the same problem. When I try to update the database (3.2 to 3.5), i receive this message in lsupgrade :
"There is already an object named 'TsysConfig' in the database"

I my case, Lansweeper is on the same server that sql database. I have no specific errors during the upgrade.

Marco

[golhelpdesk]

Running the script from the sqlserver console did the trick. Thanks!

[Hemoco]

Could you let the upgrade script run from the sqlserver management console please.

The create table for tsysconfig is the first statement.

[golhelpdesk]

this is the eror if I try running the script again:

There is already an object named 'TsysConfig' in the database

[golhelpdesk]

Yes it is connecting to the right database. I did not receive any errors except for the script error described above. I also tried to restart the lansweeper servers and the sql database (SQL 2000 residing on a different server).

[Hemoco]

Are you sure that you are connecting to the correct database?

Did you get any errors during the upgrade?