ORA-14400: inserted partition key does not map to any partition

Hello in this chapter we are soluting a partition error.

Problem descriptions :

com.evermind.server.rmi.OrionRemoteException: java.lang.RuntimeException: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "TMS.PCK_SLA", line 1766
ORA-06512: at line 1

                at com.evermind.server.ejb.EJBUtils.getUserException(EJBUtils.java:296)
                at DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.isemriTamamla(DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.java:1717)
                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:324)
                at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:124)
                at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:48)
                at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
                at java.lang.Thread.run(Thread.java:534)
at connection to /10.6.152.14 as admin
ORA-06512: at "TMS.PCK_SLA", line 1766
ORA-06512: at line 1

                at com.evermind.server.rmi.RMIConnection.EXCEPTION_ORIGINATES_FROM_THE_REMOTE_SERVER(RMIConnection.java:1602)
                at com.evermind.server.rmi.RMIConnection.invokeMethod(RMIConnection.java:1553)
                at com.evermind.server.rmi.RemoteInvocationHandler.invoke(RemoteInvocationHandler.java:55)
                at com.evermind.server.rmi.RecoverableRemoteInvocationHandler.invoke(RecoverableRemoteInvocationHandler.java:22)
                at com.evermind.server.ejb.StatelessSessionRemoteInvocationHandler.invoke(StatelessSessionRemoteInvocationHandler.java:50)
                at __Proxy11.isemriTamamla(Unknown Source)
                at tr.com.innova.tt2.appclient.isemri.frame.IsemriFrame.btnTamam_actionPerformed(IsemriFrame.java:1161)
                at tr.com.innova.tt2.appclient.isemri.frame.IsemriIsdnpriEditFrame.btnTamam_actionPerformed(IsemriIsdnpriEditFrame.java:115)
                at tr.com.innova.tt2.appclient.isemri.frame.IsemriFrame$3.actionPerformed(IsemriFrame.java:101)
                at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
                at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
                at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
                at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
                at java.awt.Component.processMouseEvent(Unknown Source)
                at javax.swing.JComponent.processMouseEvent(Unknown Source)
                at java.awt.Component.processEvent(Unknown Source)
                at java.awt.Container.processEvent(Unknown Source)
                at java.awt.Component.dispatchEventImpl(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Window.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.EventQueue.dispatchEvent(Unknown Source)
                at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
                at java.awt.EventDispatchThread.run(Unknown Source)

                Nested exception is:
java.lang.RuntimeException: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "TMS.PCK_SLA", line 1766
ORA-06512: at line 1

                at tr.com.innova.common.business.utils.dblayer.DBServices.callStoredProcedure(DBServices.java:212)
                at tr.com.innova.common.business.utils.dblayer.PersistenceEngine.callStoredProcedure(PersistenceEngine.java:524)
                at tr.com.innova.tt.business.isemri.ejb.IsemriUtility.slaHesapla(IsemriUtility.java:3505)
                at tr.com.innova.tt.business.isemri.ejb.DigerHizmetlerLocalIsemriSessionEJBBean.isemriTamamla(DigerHizmetlerLocalIsemriSessionEJBBean.java:276)
                at DigerHizmetlerLocalIsemriSessionEJBLocal_StatelessSessionBeanWrapper138.isemriTamamla(DigerHizmetlerLocalIsemriSessionEJBLocal_StatelessSessionBeanWrapper138.java:1341)
                at tr.com.innova.tt.business.isemri.ejb.DigerHizmetlerIsemriSessionEJBBean.isemriTamamla(DigerHizmetlerIsemriSessionEJBBean.java:175)
                at DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.isemriTamamla(DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.java:1704)
                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:324)
                at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:124)
                at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:48)
                at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
                at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "TMS.PCK_SLA", line 1766
ORA-06512: at line 1

                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
                at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:218)
                at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:969)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
                at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
                at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
                at com.evermind.sql.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:270)
                at com.evermind.sql.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:270)
                at com.evermind.sql.PreparedStatementBCELProxy.executeQuery(PreparedStatementBCELProxy.java:31)
                at tr.com.innova.common.business.utils.dblayer.DBServices.callStoredProcedure(DBServices.java:189)
                ... 14 more
at connection to /10.6.152.14
ORA-06512: at "TMS.PCK_SLA", line 1766
ORA-06512: at line 1

                at com.evermind.server.rmi.OrionRemoteException.receive(OrionRemoteException.java:130)
                at com.evermind.server.rmi.RMIConnection.handleMethodInvocationResponse(RMIConnection.java:1738)
                at com.evermind.server.rmi.RMIConnection.run(RMIConnection.java:453)
                at com.evermind.server.rmi.RMIConnection.run(RMIConnection.java:333)
                at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
                at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "TMS.PCK_SLA", line 1766
ORA-06512: at line 1

                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
                at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:218)
                at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:969)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
                at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
                at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
                at com.evermind.sql.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:270)
                at com.evermind.sql.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:270)
                at com.evermind.sql.PreparedStatementBCELProxy.executeQuery(PreparedStatementBCELProxy.java:31)
                at tr.com.innova.common.business.utils.dblayer.DBServices.callStoredProcedure(DBServices.java:189)
                at tr.com.innova.common.business.utils.dblayer.PersistenceEngine.callStoredProcedure(PersistenceEngine.java:524)
                at tr.com.innova.tt.business.isemri.ejb.IsemriUtility.slaHesapla(IsemriUtility.java:3505)
                at tr.com.innova.tt.business.isemri.ejb.DigerHizmetlerLocalIsemriSessionEJBBean.isemriTamamla(DigerHizmetlerLocalIsemriSessionEJBBean.java:276)
                at DigerHizmetlerLocalIsemriSessionEJBLocal_StatelessSessionBeanWrapper138.isemriTamamla(DigerHizmetlerLocalIsemriSessionEJBLocal_StatelessSessionBeanWrapper138.java:1341)
                at tr.com.innova.tt.business.isemri.ejb.DigerHizmetlerIsemriSessionEJBBean.isemriTamamla(DigerHizmetlerIsemriSessionEJBBean.java:175)
                at DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.isemriTamamla(DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.java:1704)
                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:324)
                at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:124)
                at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:48)
                at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
                at java.lang.Thread.run(Thread.java:534)

solutions :

we add the relevant partition to the problematic table.

ALTER TABLE TABLE_NAME
ADD
PARTITION Partition_number VALUES LESS THAN (value)
LOGGING
NOCOMPRESS
STORAGE (
MAXSIZE UNLIMITED
);

problem is solved.

Hits: 10

Leave a Reply

Your email address will not be published. Required fields are marked *