Home » Applications » Oracle Fusion Apps & E-Business Suite » u6678700.drv failed after restarting adpatch due to hung adworker (11.2.0.1 - R12.1.1 (Upgrade from 11.5.9 to R12.1.1) On AIX 6.1)
u6678700.drv failed after restarting adpatch due to hung adworker [message #561079] Wed, 18 July 2012 13:34 Go to next message
dafon
Messages: 9
Registered: December 2011
Junior Member
I have tried to recompile and ran adgrant but got the same error

AutoPatch error:
Error while executing statement

AutoPatch error:
ORA-04063: package body "APPS.FND_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_STATS"
ORA-06512: at "APPS.AD_STATS_UTIL_PKG", line 116
ORA-06512: at "APPS.AD_STATS_UTIL_PKG", line 207
ORA-06512: at line 5

Error calling adphistGatherStatsIfNecessary(TASK_TIMING, 42790)
AutoPatch error:
aimini(): Error calling adptaskStoreTimInfoToHist()

alter package fnd_stats compile;
alter package fnd_stats compile body;

How can this be fix
Re: u6678700.drv failed after restarting adpatch due to hung adworker [message #561085 is a reply to message #561079] Wed, 18 July 2012 14:22 Go to previous messageGo to next message
Littlefoot
Messages: 21684
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does this:
Quote:
could not find program unit being called: "APPS.FND_STATS"

mean anything to you?
Re: u6678700.drv failed after restarting adpatch due to hung adworker [message #561093 is a reply to message #561079] Wed, 18 July 2012 15:08 Go to previous messageGo to next message
John Watson
Messages: 8580
Registered: January 2010
Location: Global Village
Senior Member
I remember you asked about this last year, and I told you how I would do it:
http://www.orafaq.com/forum/mv/msg/177279/535511/148813/#msg_535511
but you then decided to do it your own way, which I really don;t think can work:
http://www.orafaq.com/forum/mv/msg/177279/535526/148813/#msg_535526
What technique have you followed, to get to this problem?
Re: u6678700.drv failed after restarting adpatch due to hung adworker [message #561109 is a reply to message #561093] Wed, 18 July 2012 22:08 Go to previous messageGo to next message
dafon
Messages: 9
Registered: December 2011
Junior Member
What I have done sofar that was working are
1. install 11.2.0.1 starter db on AIX server
2. Took an export of 9208 on HP
3. Import the 9208 to 11201 on AIX
4. Install R12.1.1 TO laid down the new file system for upgrade
5. Re run rapidwiz to upgrade and configure the new system
6. run the udriver and nls driver
7. Implement auto config on the db and apps tier

I have done two iteration, tested and got a sign off.
I'm now doing the 3rd trial with one more to go but encountering error while running u6678700.drv
it appears the workers are hung on some processes and attempt to restart it has been very painful and not working.

Any advice?

Re: u6678700.drv failed after restarting adpatch due to hung adworker [message #561110 is a reply to message #561085] Wed, 18 July 2012 22:11 Go to previous message
dafon
Messages: 9
Registered: December 2011
Junior Member
Got pass this error after recompiling the fnd_stats package that was invalid.
adpatch now appears to be hung with 12555 jobs to go.
Previous Topic: Labor Billing to customer from intercompany/interproject labor charges
Next Topic: When i m downloading Web Adi xls file
Goto Forum:
  


Current Time: Fri Jul 30 08:03:13 CDT 2021