Failed to update the database schema when applying ZCM 10.2.2 with an MS SQL database

  • Document ID:7005035
  • Creation Date:16-Dec-2009
  • Modified Date:14-May-2013
    • Micro Focus Products:
      ZENworks Configuration Management

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2.2 System Update
Microsoft SQL 2005

Situation

The ZCM 10.2.2 update failed to apply. The log file loader-messages.log on the server shows the following error message:


[DEBUG] [16.12.09 09:35:44] [] [Loader.SystemUpdateModule] [] [FINER: Executing: sql-server/schema_update-10.2.2.sql] [] []

IF NOT EXISTS (select * from zOpaqueData where name='com.novell.zenworks.rights.assignright.isConfigured')

BEGIN

update zBasicRight set zBasicRight.rights=(Convert(INT,zBasicRight.rights)|4096), zBasicRight.mask=(Convert(INT,zBasicRight.mask)|4096) where zBasicRight.id in(select zBasicRight.id from zBasicRight,zAssignedRight,zZENObject where (zBasicRight.component='Bundles' or zBasicRight.component='Policies') and zBasicRight.id=zAssignedRight.basicRight and zAssignedRight.objectUID=zZENObject.ZUID and (zZENObject.Path like '/~bundles~%' or zZENObject.Path like '/~policies~%'))

insert into zOpaqueData(object,name,data) select (select zuid from zZone),'com.novell.zenworks.rights.assignright.isConfigured','true'

END

at com.novell.zenworks.datamodel.database.SQLExecutor.executeSQLStatements(SQLExecutor.java:142)

at com.novell.zenworks.datamodel.database.SQLExecutor.executeSQLStatements(SQLExecutor.java:81)

at com.novell.zenworks.datamodel.database.SQLExecutor.executeSQL(SQLExecutor.java:68)

at com.novell.zenworks.systemupdate.PreGlobalAction_10_2_2.execute(PreGlobalAction_10_2_2.java:83)

at com.novell.zenworks.systemupdate.handlers.JarCommandHandler.executeCommand(JarCommandHandler.java:82)

at com.novell.zenworks.systemupdate.handlers.JarCommandHandler.executeCommand(JarCommandHandler.java:47)

at com.novell.zenworks.loader.modules.queue.handlers.ProcessCommandsHandler.executeCommands(ProcessCommandsHandler.java:65)

at com.novell.zenworks.loader.modules.queue.handlers.PreGlobalHandler.processAction(PreGlobalHandler.java:93)

at com.novell.zenworks.loader.modules.queue.runner.QueueThreadWorker.processAction(QueueThreadWorker.java:208)

at com.novell.zenworks.loader.modules.queue.runner.QueueThreadWorker.run(QueueThreadWorker.java:139)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)

at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.DataTruncation: Data truncation

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)

at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)

at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1120)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1073)

at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)

at com.novell.zenworks.datamodel.database.SQLExecutor.executeSQLStatements(SQLExecutor.java:111)

... 12 more

] []

Resolution

This is fixed in version 10.3 - see KB 7005455 "ZENworks Configuration Management SP3 (10.3) - update information and list of fixes" which can be found at https://www.novell.com/support