Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
IOCKC
Engaged Sweeper
I started to upgrade from 3.1 to 3.2 but received a sql script error when running the script. I re-ran it through the query analyzer and this is the results. Any help would be appreciated.



Msg 2714, Level 16, State 6, Line 1
There is already an object named 'tblADComputers' in the database.
Msg 1779, Level 16, State 0, Line 2
Table 'tblADComputers' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'Domain', table 'Lansweeper.dbo.tsysadmins'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'LastActiveScan' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'FQDN' in table 'tblcomputers' is specified more than once.
Msg 2714, Level 16, State 3, Procedure Web30repReverseLookupFailed, Line 4
There is already an object named 'Web30repReverseLookupFailed' in the database.
Msg 2714, Level 16, State 3, Procedure Web30repRPCserverunavailable, Line 4
There is already an object named 'Web30repRPCserverunavailable' in the database.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK_tsysreports'. Cannot insert duplicate key in object 'dbo.tsysreports'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysreports'. Cannot insert duplicate key in object 'dbo.tsysreports'.
The statement has been terminated.
Msg 2714, Level 16, State 3, Procedure Web30GetAD, Line 4
There is already an object named 'Web30GetAD' in the database.
1 REPLY 1
Hemoco
Lansweeper Alumni
See this thread, the solution is also attached
http://forum.lansweeper.com/yaf_postst661_Lansweeper-32-Upgrade-Script-Error.aspx

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now