Hi All,
I have tried to find the solution to the upgrade failure on my ZENworks Configuration Management primary server without success. I have whittled down the actual errors in the following files:-

Zdc_zen_verify_<nnnnn>.log
system-update.log
novell-zenworks-configure.log
Services-messages.log

The errors are:

1) zdc_zen11_verify_<nnnnn>.log

[DEBUG] [DBKeepAlive$KeepAliveThread] Pinging database to keep connection alive
[DEBUG] [DBKeepAlive$KeepAliveThread] Exception while pinging database
java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Table 'zRule' not found
at sybase.jdbc4.sqlanywhere.IIStatement.execute(Nativ e Method)
at sybase.jdbc4.sqlanywhere.IStatement.execute(IState ment.java:309)
at com.novell.zenworks.zdc.db.DBKeepAlive$KeepAliveTh read.run(DBKeepAlive.java:52)

DEBUG] [DBObjectComparer] A known difference [Name: alternateLocation, Size: 2147483647, Type: UNKNOWN, Nullable: true] was found.

2) logs\system-update\5011030000fc50000000002014021123\System-update.log

[DEBUG] [09/13/2017 11:55:21.689] [2240] [ZENUpdater] [] [userd] [SystemUpdate] [] [DEBUG] [Unable to create service ZENJoinProxy. Service ZENJoinProxy was not found on computer '.'.] [] [] [ZENworks]

[DEBUG] [09/13/2017 11:55:24.048] [2240] [ZENUpdater] [] [userid] [SystemUpdate] [] [DEBUG] [Attempting to resolve variable: content.0.path] [] [] [ZENworks]
[DEBUG] [09/13/2017 11:55:24.048] [2240] [ZENUpdater] [] [userid] [SystemUpdate] [] [DEBUG] [variable not found in knownVariables or in environment : content.0.path] [] [] [ZENworks]
(of which there are quite a few messages)

[DEBUG] [09/13/2017 13:11:03.001] [2240] [ZENUpdater] [] [userid] [SystemUpdate] [] [DEBUG] [Starting process: sc.exe Option : failure "Novell ZENworks Agent Service" reset= 86400 actions= restart/30000/restart/60000//] [] [] [ZENworks]
[INFO] [09/13/2017 13:11:03.033] [2240] [ZENUpdater] [] [userid] [SystemUpdate] [INSTALLING_PERCENTAGE] [INSTALLING] [99] [] [] [ZENworks]


3) logs\novell-zenworks-configure.log

DEBUG] [09/13/2017 17:47:49.879] [7144] [AddJoinProxyRoleConfigureAction] [1] [userid] [ConfigureUtility] [] [Adding Joinproxy role to the server.] [] [] [] [ConfigureUtility]
[ERROR] [09/13/2017 17:48:47.723] [7144] [AddJoinProxyRoleConfigureAction] [1] [userid] [ConfigureUtility] [] [Failed to add JoinProxy role for primary server with GUID:d89103190658c3a858d5b164e4ad6204:Role HandheldAccesspoint is not valid, server type: Primary] [com.novell.zenworks.datamodel.exceptions.ObjectNot FoundException: Role HandheldAccesspoint is not valid, server type: Primary
at com.novell.zenworks.datamodel.services.zoneconfig. ZoneConfigAdminImpl.getRoleChangeMapForServer(Zone ConfigAdminImpl.java:1043)
at com.novell.zenworks.datamodel.services.zoneconfig. ZoneConfigAdminImpl.update(ZoneConfigAdminImpl.jav a:874)
at com.novell.zenworks.datamodel.services.zoneconfig. ZoneConfigAdminImpl.addZENServerRoles(ZoneConfigAd minImpl.java:1414)
at com.novell.zenworks.configure.actions.AddJoinProxy RoleConfigureAction.addJoinProxyRoleToPrimaryServe r(AddJoinProxyRoleConfigureAction.java:75)
at com.novell.zenworks.configure.actions.AddJoinProxy RoleConfigureAction.configure(AddJoinProxyRoleConf igureAction.java:24)
at com.novell.zenworks.configure.ZENworksConfigure.ex ecConfigAction(ZENworksConfigure.java:1758)
at com.novell.zenworks.configure.ZENworksConfigure.ex ecConfigAction(ZENworksConfigure.java:1885)
at com.novell.zenworks.configure.ZENworksConfigure.co nfigure(ZENworksConfigure.java:1601)
at com.novell.zenworks.configure.ZENworksConfigure.ma in(ZENworksConfigure.java:1516)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.novell.zenworks.configure.ConfigureLoader.main (ConfigureLoader.java:73)



4) Services-messages.log

[DEBUG] [09/13/2017 15:07:14.555] [2628] [ZENService] [114] [] [Assignment Web Service] [] [get Assignments for the following Consumer UID "907ed2e109053066ad53041f64e284ad~782f8a820c450345 92d492aff1d931dd"] [] [] [] [ZENServer]
[DEBUG] [09/13/2017 15:07:19.133] [2628] [ZENService] [114] [] [Assignment web service helper.] [] [Failed to get device for UID 907ed2e109053066ad53041f64e284ad~782f8a820c4503459 2d492aff1d931dd. : com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.MappingException: Unknown entity: com.novell.zenworks.datamodel.objects.users.User
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.newStandardDataModelException(Abst ractDatabaseTypeHelper.java:456)
at com.novell.zenworks.datamodel.database.sqlanywhere .SQLAnywhereHelper.newStandardDataModelException(S QLAnywhereHelper.java:311)
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.throwStandardDataModelException(Ab stractDatabaseTypeHelper.java:441)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.handleException(Abstrac tHibernateSessionImpl.java:244)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleGet(AbstractHiber nateSessionImpl.java:296)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.simpleGet(HibernateBasicSessio n.java:1229)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession._get(HibernateBasicSession.jav a:1593)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.get(HibernateBasicSession.java :753)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.get(HibernateBasicSession.java :674)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.get(HibernateBasicSession.java :669)
at com.novell.zenworks.datamodel.services.BasicAdminI mpl._get(BasicAdminImpl.java:237)
at com.novell.zenworks.datamodel.services.BasicAdminI mpl.get(BasicAdminImpl.java:232)
at com.novell.zenworks.datamodel.services.devices.Dev iceAdminImpl.get(DeviceAdminImpl.java:510)
at com.novell.zenworks.webservice.assignmentservice.A ssignmentWebServiceHelper.filterPatchPoliciesForOl derAgents(AssignmentWebServiceHelper.java:1169)
at com.novell.zenworks.webservice.assignmentservice.A ssignmentWebService.getAllAssignments(AssignmentWe bService.java:256)
at com.novell.zenworks.webservice.assignmentservice.A ssignmentWebService.getEffectiveAssignments(Assign mentWebService.java:123)
at com.novell.zenworks.assignment.schema.AssignmentSe rvice_ServiceTieSkeleton.getEffectiveAssignments(A ssignmentService_ServiceTieSkeleton.java:41)
at com.novell.zenworks.assignment.schema.AssignmentSe rvice_ServiceSkeleton._invoke(AssignmentService_Se rviceSkeleton.java:153)
at com.novell.zenworks.webservice.assignmentservice.A ssignmentServiceImpl._invoke(AssignmentServiceImpl .java:72)
at com.novell.soa.ws.server.ServletSkeleton.invokeEnd Point(ServletSkeleton.java:201)
at com.novell.soa.ws.impl.soap.MessageHandlerInvoker. invokeServerMessageHandlers(MessageHandlerInvoker. java:347)
at com.novell.soa.ws.impl.soap.SOAPHandler.handleServ erRequest(SOAPHandler.java:85)
at com.novell.soa.ws.impl.rpc.ServerDelegateImpl.hand leServerRequest(ServerDelegateImpl.java:92)
at com.novell.soa.ws.server.ServletSkeleton.handleReq uest(ServletSkeleton.java:101)
at com.novell.soa.ws.server.ServletSkeleton.doPost(Se rvletSkeleton.java:300)
at com.novell.zenworks.webservice.assignmentservice.A ssignmentServiceImpl.doPost(AssignmentServiceImpl. java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:728)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at com.novell.zenworks.webservice.lib.ChecksumFilter. doFilter(ChecksumFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at com.novell.zenworks.webservice.lib.AuthenticationF ilter.doFilter(AuthenticationFilter.java:213)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at com.novell.zenworks.webservice.lib.StatisticFilter .doFilter(StatisticFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:123)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:171)
at com.googlecode.psiprobe.Tomcat70AgentValve.invoke( Tomcat70AgentValve.java:39)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:99)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:118)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke( ZENRequestValve.java:1331)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.p rocess(AbstractHttp11Processor.java:1009)
at org.apache.coyote.AbstractProtocol$AbstractConnect ionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProce ssor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.hibernate.MappingException: Unknown entity: com.novell.zenworks.datamodel.objects.users.User
at org.hibernate.internal.SessionFactoryImpl.getEntit yPersister(SessionFactoryImpl.java:1192)
at org.hibernate.internal.SessionImpl.locateEntityPer sister(SessionImpl.java:2436)
at org.hibernate.internal.SessionImpl.access$2100(Ses sionImpl.java:172)
at org.hibernate.internal.SessionImpl$IdentifierLoadA ccessImpl.<init>(SessionImpl.java:2378)
at org.hibernate.internal.SessionImpl$IdentifierLoadA ccessImpl.<init>(SessionImpl.java:2369)
at org.hibernate.internal.SessionImpl.byId(SessionImp l.java:1047)
at org.hibernate.internal.SessionImpl.load(SessionImp l.java:971)
at com.novell.zenworks.datamodel.session.hibernate.Se ssionImpl.load(SessionImpl.java:220)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleGet(AbstractHiber nateSessionImpl.java:280)
... 48 more
] [] [] [] [ZENServer]

Got this error multiple times all through the file

I had to reboot the server after the installation failure as I was unable to load ZCC. This server was originally migrated to a Windows 2008 64-bit platform from Windows 2008 32-bit using the TID articles and it was noticeable after migration that the automatic ZENworks services seem to be running with a different service account id to that of its predecessor (old account .\_z_1_87__ new account .\_z_1_77__) The new account was the original IP address (eg. x.x.x.77) of the 64-bit server added to the management zone and then migrated from the 32 bit server (x.x.x.87).

Also the ZAA on the server no longer logs in automatically.

Everyone else seems to be working in ZCC apart from the Health status showing red.

Before I create an SR for this problem, I just wondered if anyone can shed some light on the possible problem as I have exhausted my limited knowledge of Zenworks.

Thankyou very much.