BMcDowell1 Absent Member.
Absent Member.
1216 views

Missing July 2015 Patch Tuesday

Patch Tuesday for July 2015 was a full week ago and I haven't seen any patches listed in the Patch Management area. (ZCM 11.3.2 with FRU1) A couple of Adobe patches appeared late last week and - according to the applicable patch policy cycle - were applied to the appropriate devices in a timely fashion. New DAU bundles have also been rolling in as expected. However, not a single Microsoft patch has shown up as available in several weeks. Not seeing any errors in the patch status area or loader-messages log (both attached).

Any thoughts most appreciated!

Bruce McDowell Technical Services Consultant, McDowell Consulting LLC bruce@consultbruce.com
Labels (2)
0 Likes
5 Replies
Knowledge Partner
Knowledge Partner

Re: Missing July 2015 Patch Tuesday

BMcDowell;2400954 wrote:
Patch Tuesday for July 2015 was a full week ago and I haven't seen any patches listed in the Patch Management area. (ZCM 11.3.2 with FRU1) A couple of Adobe patches appeared late last week and - according to the applicable patch policy cycle - were applied to the appropriate devices in a timely fashion. New DAU bundles have also been rolling in as expected. However, not a single Microsoft patch has shown up as available in several weeks. Not seeing any errors in the patch status area or loader-messages log (both attached).

Any thoughts most appreciated!


Not an expert on this one, but I see some errors in your log:

[TRACE] [07/20/2015 19:14:50.296] [4048] [ZENLoader] [9366] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [Error message from Database procedure zZENObjectDelete :  The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", column 'DependencyUID'.The DELETE statement conflicted with the REFERENCE constraint "fk_zLinkedObject_DependencyUID". The conflict occurred in database "zenworks_ZCM_11_2", table "dbo.zLinkedObject", co] [] [] [] [ZENServer]
[TRACE] [07/20/2015 19:14:50.298] [4048] [ZENLoader] [9366] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [Cleaned up 0 soft deleted objects in 47592 ms.] [] [] [] [ZENServer]
[TRACE] [07/20/2015 19:14:50.298] [4048] [ZENLoader] [9366] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [Failed to clean up 863 soft deleted objects.] [] [] [] [ZENServer]
[TRACE] [07/20/2015 19:14:50.306] [4048] [ZENLoader] [9366] [] [QueueAdminImpl] [] [Scheduling simple action=soft.deleted.objects.cleanup,null] [] [] [] [ZENServer]


It almost looks like it saw some MS patches (well one)--MS15-078:

[TRACE] [07/21/2015 00:02:49.644] [4048] [ZENLoader] [9366] [] [QueueAdminImpl] [] [Scheduling simple action=SUBSCRIPTION_DOWNLOAD,null] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:05.489] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [Adding patch to email 2: MS15-078 Security Update for Windows 7 (KB3079904)] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:32.493] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Macromedia Flash Player 8.0.r22 for IE.pls Supersedes: {3D92D2B9-8B07-43E9-AD4C-6BC7D9C94829}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.025] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Sun Java JRE 1.6.0_20 for Windows (All Languages).pls Supersedes: {396DBEB8-10AD-4C89-92FA-6FC7832F28FB}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.045] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Adobe APSB09-19 Flash Player 10.0.42.34 for IE (Upgrade) (All Languages).pls Supersedes: {1E0DD7FB-6BFD-40B1-8144-354DDBA3611F}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.062] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: WinZip 11.2 SR-1 (Update) (See Notes) (Rev 2).pls Supersedes: {F1533F99-7073-4FBF-9709-65BBDF465599}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.079] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Adobe APSB10-02 (English) Reader 8.2 for Windows (Update).pls Supersedes: {9F377A1A-EE02-4CD3-ADC1-13CE83829C2C}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.097] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: MS15-078 Security Update for Windows 7 (KB3079904).pls Supersedes: {A9134E4A-3B6F-4633-AA8F-9520F188FBF8}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.135] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Macromedia Flash Player 8.0.r22 for IE.pls Supersedes: {3D92D2B9-8B07-43E9-AD4C-6BC7D9C94829}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.155] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Sun Java JRE 1.6.0_20 for Windows (All Languages).pls Supersedes: {396DBEB8-10AD-4C89-92FA-6FC7832F28FB}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.173] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Adobe APSB09-19 Flash Player 10.0.42.34 for IE (Upgrade) (All Languages).pls Supersedes: {1E0DD7FB-6BFD-40B1-8144-354DDBA3611F}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.191] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: WinZip 11.2 SR-1 (Update) (See Notes) (Rev 2).pls Supersedes: {F1533F99-7073-4FBF-9709-65BBDF465599}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.209] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Adobe APSB10-02 (English) Reader 8.2 for Windows (Update).pls Supersedes: {9F377A1A-EE02-4CD3-ADC1-13CE83829C2C}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.241] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Macromedia Flash Player 8.0.r22 for IE.pls Supersedes: {3D92D2B9-8B07-43E9-AD4C-6BC7D9C94829}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.259] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Sun Java JRE 1.6.0_20 for Windows (All Languages).pls Supersedes: {396DBEB8-10AD-4C89-92FA-6FC7832F28FB}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.277] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Adobe APSB09-19 Flash Player 10.0.42.34 for IE (Upgrade) (All Languages).pls Supersedes: {1E0DD7FB-6BFD-40B1-8144-354DDBA3611F}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.300] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: WinZip 11.2 SR-1 (Update) (See Notes) (Rev 2).pls Supersedes: {F1533F99-7073-4FBF-9709-65BBDF465599}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.316] [4048] [ZENLoader] [6285] [] [Loader.PatchSubscriptionService] [] [PLS File: Adobe APSB10-02 (English) Reader 8.2 for Windows (Update).pls Supersedes: {9F377A1A-EE02-4CD3-ADC1-13CE83829C2C}] [] [] [] [ZENServer]
[TRACE] [07/21/2015 00:05:33.660] [4048] [ZENLoader] [6285] [] [PatchManagement] [] [Checking whether to create a new bundle] [] [] [] [ZENServer]


But then towards the end you have some database problems:?

[TRACE] [07/21/2015 12:04:06.714] [4048] [ZENLoader] [84] [] [DiscoveryStorer] [] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.DataException: Data truncation
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:456)
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:441)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:244)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleUpdate(AbstractHibernateSessionImpl.java:935)
at com.novell.zenworks.datamodel.services.discovery.DiscoveryAdminImpl.update(DiscoveryAdminImpl.java:300)
at com.novell.zenworks.discovery.discoverystorer.DiscoveryStorer.loadDevice(DiscoveryStorer.java:316)
at com.novell.zenworks.discovery.discoverystorer.DiscoveryStorer.loadResults(DiscoveryStorer.java:243)
at com.novell.zenworks.discovery.discoverystorer.DiscoveryStorer.loadFile(DiscoveryStorer.java:192)
at com.novell.zenworks.loader.modules.DiscoveryStorerModule.run(DiscoveryStorerModule.java:601)
at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:112)
Caused by: org.hibernate.exception.DataException: Data truncation
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:71)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy47.executeUpdate(Unknown Source)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3016)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2918)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3247)
at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:140)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:276)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1214)
at com.novell.zenworks.datamodel.session.hibernate.SessionImpl.flush(SessionImpl.java:211)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleUpdate(AbstractHibernateSessionImpl.java:926)
... 6 more
Caused by: java.sql.DataTruncation: Data truncation
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Missing July 2015 Patch Tuesday

BMcDowell,

like Kevin said - a case for Novell I think

--

Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy


0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Missing July 2015 Patch Tuesday

BMcDowell,

won't happen - it's too much work, so it's only done for "proper"
releases, not collections of patches...

--

Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy


0 Likes
BMcDowell1 Absent Member.
Absent Member.

Re: Missing July 2015 Patch Tuesday

OK, looks like I'm back on track. There's been an issue noted for a while where vendors disappear from the configurable list in the patch management configuration settings. I've seen customer sites where Microsoft has disappeared from the vendor list - and that's what happened to me. Always nice to have well placed friends who can supply a patch, code reverse-engineered from 11.4. I've applies that, rebooted the primary server and run an "Update Now" in the ZPM config. MS patches now appearing in the patch dashboard as devices refresh and report DAU results.

Bruce McDowell Technical Services Consultant, McDowell Consulting LLC bruce@consultbruce.com
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Missing July 2015 Patch Tuesday

BMcDowell,

nice

--

Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy


0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.