Hi All,
During the pre-upgrade steps to upgrade from WC 9.1 M060 to WC 10.0 m020, I
had executed the default Windu from 9.1. The task ran fine giving good
output. Then I was asked to install the latest 9.1 Windu patch.after I ran
those I was not able to get the task running. I recompiled the
EPMFTValidatorPK without anything good. I had upgraded the DB beforehand and
9.1 was running on Oracle 11g. Thinking that this could be the issue I
reverted back to 10g, but still the issue exists.
Kindly suggest for possible lead on this issue.
---- End remote method server code with exception:
wt.epm.ValidateFTDataDT.runDiagnostics() ----
(LocalMessage) LightWeightService-invoker thread ended.
com.ptc.windchill.upgrade.ius.UpdateExecutionException: Error executing
IncrementalUpdate Validate EPM Family Tables (#Valida
teFamilyTableData)
Nested exception is:
(com.ptc.windchill.upgrade.directives.directivesResource/7)
com.ptc.windchill.upgrade.ius.DirectiveExecu
tionException: Method server code wt.epm.ValidateFTDataDT.runDiagnostics
failed. See nested exception for details
Nested exception is: wt.util.WTException:
java.lang.reflect.InvocationTargetException
Nested exception is: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.ptc.windchill.upgrade.directives.LightWeightServiceDirective$Server.invo
keLightWeightServiceApi(LightWeightSer
viceDirective.java:634)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
wt.method.MethodResultWriter.writeExternal(MethodResultWriter.java:151)
at wt.method.MethodResult.writeExternal(MethodResult.java:226)
at
java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1418)
at
java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1390)
at
java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1150)
at
java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:326)
at sun.rmi.server.UnicastRef.marshalValue(UnicastRef.java:274)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:315)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:
790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:6
49)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.ja
va:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:9
08)
at java.lang.Thread.run(Thread.java:619)
Caused by: wt.pom.DatastoreException: A SQL error has occurred for the
statement "BEGIN ? := EPMFTValidatorPK.ValidateEPMTabl
e(?,?,?,?,?,?,?,?,?); END;". Database system message follows:
java.sql.SQLException: ORA-06550: line 1, column 13:
