Environment
Situation
[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
] []