Un-able to upload xml file - Error:ORA-14400: inserted partition key does not map to any partition

From: <m.mudhalvan_at_aozorabank.co.jp>
Date: Wed, 8 Aug 2012 14:42:52 +0900
Message-ID: <OF1EB16E1E.C0FA28E1-ON49257A54.001EE419-49257A54.001F642F_at_aozorabank.co.jp>



Dear Team,

        Just an update Today I have checked my Grid and found more error messages Management Services and Repository with "Thread: XMLLoader0 xxxxxxx.xml Failed to load xxxxxxxxxxx.xml even after 2 attempts; moving to errors directory. Error:ORA-14400: inserted partition key does not map to any partition , File name:/xxx/xxx/xxxxxx.xml"

        When we checked in the metalink found a note 303359.1 and checked the job_queue_process is set to 0 and we have changed to 10 and it is working fine.

        Now I am trying to find out the root cause of Job_queue_process changed to zero.

        Did any one faced the problem of restarting the repository DB caused or some other reason job_queue_process changed to zero?

Thanks & Regards
Mudhalvan M.M

Infrastructure Management Division
Tel. 042(319)4516 Ext. 34516
Mobile 81-80-4890-1973
Email m.mudhalvan_at_aozorabank.co.jp


$B!V!!$=$N_at_h$O!"$"$*$>$i!#!!!W(B
$BCm!'$3$N(BE-mail$B$O!"5!L)>pJs$r4^$s$G$*$j!"H/?.<T$,0U?^$7$?(B $B<u?.<T$N$_$,MxMQ(B
$B$9$k$3$H$r0U?^$7$?$b$N$G$9!#K|$,0l!"5.EB(B $B$,$3$N(BE-mail$B$NH/?.<T$,0U?^$7$?<u(B
$B?.<T$G$J$$>l9g$K$O!"$3(B $B$N(BE-mail$B$N0u:~!"%3%T!<!"E>Aw$=$NB>0l_at_Z$N;HMQ$O6X;_(B
$B$5$l(B $B$^$9!#EvJ}$N8m$j$K$h$j$3$N(BE-mail$B$r$*<u$1<h$j$K$J$C$?>l9g(B $B$O!"$*<j?t$r(B
$B$*$+$1$7$^$9$,!"$3$N(BE-mail$B$rGK4~$7!"D>$A$K$4O"(B $BMm$rD:BW$G$-$^$9$H9,$$$G$9(B
$B!#(B

----------------------------------------------------------------------------------------------------
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 08 2012 - 00:42:52 CDT

Original text of this message