Mon 7/17/23 19:29:05: SQL: create table ##ida2a2_results (idnumber bigint, tablekey smallint)
Mon 7/17/23 19:29:05: Error in method server code:
Mon 7/17/23 19:29:05: java.lang.Exception: Exception of type 'java.lang.reflect.InvocationTargetException' was generated on the server with message 'null'
Mon 7/17/23 19:29:05: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Mon 7/17/23 19:29:05: 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Mon 7/17/23 19:29:05: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Mon 7/17/23 19:29:05: 	at java.lang.reflect.Method.invoke(Method.java:498)
Mon 7/17/23 19:29:05: 	at com.ptc.windchill.upgrade.updates.directives.MigratorMethod.invoke(MigratorMethod.java:131)
Mon 7/17/23 19:29:05: 	at com.ptc.windchill.upgrade.updates.directives.LightWeightServiceDirective$Server.invokeLightWeightServiceApi(LightWeightServiceDirective.java:635)
Mon 7/17/23 19:29:05: 	at sun.reflect.GeneratedMethodAccessor1833.invoke(null)
Mon 7/17/23 19:29:05: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Mon 7/17/23 19:29:05: 	at java.lang.reflect.Method.invoke(Method.java:498)
Mon 7/17/23 19:29:05: 	at wt.method.MethodResultWriter.writeExternal(MethodResultWriter.java:165)
Mon 7/17/23 19:29:05: 	at wt.method.MethodResult.writeExternal(MethodResult.java:226)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1456)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348)
Mon 7/17/23 19:29:05: 	at sun.rmi.server.UnicastRef.marshalValue(UnicastRef.java:290)
Mon 7/17/23 19:29:05: 	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:367)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.Transport$1.run(Transport.java:200)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.Transport$1.run(Transport.java:197)
Mon 7/17/23 19:29:05: 	at java.security.AccessController.doPrivileged(Native Method)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
Mon 7/17/23 19:29:05: 	at java.security.AccessController.doPrivileged(Native Method)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
Mon 7/17/23 19:29:05: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
Mon 7/17/23 19:29:05: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
Mon 7/17/23 19:29:05: 	at java.lang.Thread.run(Thread.java:748)
Mon 7/17/23 19:29:05: Task failed.
Mon 7/17/23 19:29:05: com.ptc.windchill.upgrade.updates.UpdateExecutionException: Error executing IncrementalUpdate Duplicate Key Analysis (#DuplicateKey)
Mon 7/17/23 19:29:05: Nested exception is: (com.ptc.windchill.upgrade.updates.directives.directivesResource/39) com.ptc.windchill.upgrade.updates.DirectiveExecutionException: Method server code wt.pds.DuplicateKey.runDiagnostics failed.  See nested exception for details
Mon 7/17/23 19:29:05: Nested exception is: wt.util.WTException: java.lang.reflect.InvocationTargetException
Mon 7/17/23 19:29:05: Nested exception is: java.lang.reflect.InvocationTargetException
Mon 7/17/23 19:29:05: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Mon 7/17/23 19:29:05: 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Mon 7/17/23 19:29:05: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Mon 7/17/23 19:29:05: 	at java.lang.reflect.Method.invoke(Method.java:498)
Mon 7/17/23 19:29:05: 	at com.ptc.windchill.upgrade.updates.directives.MigratorMethod.invoke(MigratorMethod.java:131)
Mon 7/17/23 19:29:05: 	at com.ptc.windchill.upgrade.updates.directives.LightWeightServiceDirective$Server.invokeLightWeightServiceApi(LightWeightServiceDirective.java:635)
Mon 7/17/23 19:29:05: 	at sun.reflect.GeneratedMethodAccessor1833.invoke(Unknown Source)
Mon 7/17/23 19:29:05: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Mon 7/17/23 19:29:05: 	at java.lang.reflect.Method.invoke(Method.java:498)
Mon 7/17/23 19:29:05: 	at wt.method.MethodResultWriter.writeExternal(MethodResultWriter.java:165)
Mon 7/17/23 19:29:05: 	at wt.method.MethodResult.writeExternal(MethodResult.java:226)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1456)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178)
Mon 7/17/23 19:29:05: 	at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348)
Mon 7/17/23 19:29:05: 	at sun.rmi.server.UnicastRef.marshalValue(UnicastRef.java:290)
Mon 7/17/23 19:29:05: 	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:367)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.Transport$1.run(Transport.java:200)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.Transport$1.run(Transport.java:197)
Mon 7/17/23 19:29:05: 	at java.security.AccessController.doPrivileged(Native Method)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
Mon 7/17/23 19:29:05: 	at java.security.AccessController.doPrivileged(Native Method)
Mon 7/17/23 19:29:05: 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
Mon 7/17/23 19:29:05: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
Mon 7/17/23 19:29:05: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
Mon 7/17/23 19:29:05: 	at java.lang.Thread.run(Thread.java:748)
Mon 7/17/23 19:29:05: Caused by: wt.util.WTException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
Mon 7/17/23 19:29:05: Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
Mon 7/17/23 19:29:05: 	at com.ptc.windchill.upgrade.dbservices.SequenceHelper.createTempTable(SequenceHelper.java:475)
Mon 7/17/23 19:29:05: 	at com.ptc.windchill.upgrade.dbservices.SequenceHelper.findDuplicates(SequenceHelper.java:436)
Mon 7/17/23 19:29:05: 	at wt.pds.DuplicateKey.runDiagnostics(DuplicateKey.java:118)
Mon 7/17/23 19:29:05: 	... 29 more
Mon 7/17/23 19:29:05: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
Mon 7/17/23 19:29:05: 	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
Mon 7/17/23 19:29:05: 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:710)
Mon 7/17/23 19:29:05: 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2953)
Mon 7/17/23 19:29:05: 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2592)
Mon 7/17/23 19:29:05: 	at com.ptc.windchill.upgrade.dbservices.SequenceHelper.createTempTable(SequenceHelper.java:462)
Mon 7/17/23 19:29:05: 	... 31 more