Database login blocked message retrying upgrade after a prior upgrade failure

  • 3000887
  • 06-Feb-2007
  • 27-Apr-2012

Environment

Novell ZENworks Asset Management 3.3 - ZAM3.3
Novell ZENworks 7.5 Asset Management - ZAM7.5
Novell ZENworks Tally Systems TS.Census 3.2
Novell ZENworks Asset Management 7 - ZAM7

Situation

Upgrading ZENworks to a newer version -received a failure to upgrade message during installation.

Resolution

Setup will try to shut down services after connecting to the database. At that point it will set a field in the LoginBlocked column (NC_LoginInfo) to 1 (true).

If the upgrade fails while attempting to shut down services the setup probably only changed the LoginBlocked field from 0 to 1. You can manually change that back using the SQL Enterprise Manager,but only afterbeing sure that the DBSchemaVersion did not change.

To check the DBSchemaVersion: Open up the SQL Enterprise Manager and go into the NC_NetCensusInfo table. Check the DBSchemaVersion column; if still at the old version then you can exit out of that table, open NC_LoginInfo and change the LoginBlocked to 0 and retry the upgrade.

If the DBSchema version has changed contact Novell Technical Support:

c:\TSCINST.LOG

DBUPGRADE.log

Within the TSCINST.LOG file is the name of the temp directory that shows the location to where files are written. Find out where the working temp directory is and send in the _ins5576*.log file.

Continue to work with technical support until upgrade is successfully completed.

Additional Information

Similar to TID for failed upgrade from ZENworks Tally Systems TS.Census 3.3 to ZENworks Asset Management 7 - ZAM7 TID 3000887 except for different location of LoginBlocked field.