Hello Friends, In this blog I am going to share you about the Error named SIP-23038. This Error comes when we are inserting the data through IDD and we get error like:

IP-23038: ERROR: Unexpected SQL error ORA-01438: value larger than specified precision allowed for this column . Review the server log for more details.
 

• com.siperian.dsapp.mde.domain.common.UpdateMRMDatabaseException: EXCEPTION||Application cannot complete the requested action.|Contact your system administrator and provide the detailed error information.
• at com.siperian.dsapp.mde.domain.common.UnitOfWorkProcessor.commit(UnitOfWorkProcessor.java:340)
• at com.siperian.dsapp.mde.domain.common.DataService.updatePO(DataService.java:1078)
• at com.siperian.dsapp.mde.jsf.ui.dsbean.dataview.GenericEditableDataViewBean.doInternalSave(GenericEditableDataViewBean.java:689)
• at com.siperian.dsapp.mde.jsf.ui.dsbean.dataview.savehandle.Save.doSave(Save.java:34)
• at com.siperian.dsapp.mde.jsf.ui.dsbean.dataview.savehandle.RegularSave.execute(RegularSave.java:72)
• at com.siperian.dsapp.mde.jsf.ui.dsbean.dataview.savehandle.CompositeAsyncSaveOperation.executeTabBoundOperation(CompositeAsyncSaveOperation.java:49)
• at com.siperian.dsapp.jsf.ui.dsbean.common.tab.TabBoundLongRunningOperation.execute(TabBoundLongRunningOperation.java:79)
• at com.siperian.dsapp.jsf.server.SpringLongRunningExecutor$OperationWrapper.run(SpringLongRunningExecutor.java:80)
• at com.siperian.dsapp.jsf.server.AsyncServletThreadExecutorBean.execute(AsyncServletThreadExecutorBean.java:19)
• at sun.reflect.GeneratedMethodAccessor2128.invoke(Unknown Source)
• at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
• at java.lang.reflect.Method.invoke(Method.java:606)
• at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
• at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
• at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
• at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:259)
• at org.jboss.as.ejb3.tx.CMTTxInterceptor.never(CMTTxInterceptor.java:309)
• at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:234)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
• at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
• at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.AsyncFutureInterceptorFactory$1$1.runInvocation(AsyncFutureInterceptorFactory.java:89)
• at org.jboss.as.ejb3.component.interceptors.AsyncInvocationTask.run(AsyncInvocationTask.java:73)
• at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
• at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
• at java.lang.Thread.run(Thread.java:745)
• at org.jboss.threads.JBossThread.run(JBossThread.java:122)
• Caused by: com.siperian.dsapp.common.DSRuntimeException: EXCEPTION||Problem saving object.|Correct your data and try again.
• at com.siperian.dsapp.mde.datasource.data.SifDataService.put(SifDataService.java:193)
• at com.siperian.dsapp.mde.domain.common.DSService.put(DSService.java:498)
• at com.siperian.dsapp.mde.domain.common.UnitOfWorkProcessor.putRecord(UnitOfWorkProcessor.java:1323)
• at com.siperian.dsapp.mde.domain.common.UnitOfWorkProcessor.insertRecord(UnitOfWorkProcessor.java:1286)
• at com.siperian.dsapp.mde.domain.common.UnitOfWorkProcessor.insertRecord(UnitOfWorkProcessor.java:1254)
• at com.siperian.dsapp.mde.domain.common.UnitOfWorkProcessor.handleInsertPO(UnitOfWorkProcessor.java:811)
• at com.siperian.dsapp.mde.domain.common.UnitOfWorkProcessor.commit(UnitOfWorkProcessor.java:239)
• ... 56 more
• Caused by: com.siperian.sif.client.SiperianServerException: SIP-23038: ERROR: Unexpected SQL error ORA-01438: value larger than specified precision allowed for this column . Review the server log for more details.
• at com.siperian.sif.client.EjbSiperianClient._process(EjbSiperianClient.java:169)
• at com.siperian.sif.client.SiperianClient.process(SiperianClient.java:179)
• at com.siperian.dsapp.mde.datasource.common.service.SifService.process(SifService.java:145)
• at com.siperian.dsapp.mde.datasource.data.SifDataService.put(SifDataService.java:191)
• ... 62 more
• Caused by: com.siperian.sif.message.SiperianRequestException
• at com.siperian.sif.server.RequestRouter.newRequestException(RequestRouter.java:575)
• at com.siperian.sif.server.RequestRouter.process(RequestRouter.java:339)
• at com.siperian.sif.server.RequestRouter.process(RequestRouter.java:272)
• at com.siperian.sif.server.ejb.RequestEjbBean.processTxRequired(RequestEjbBean.java:62)
• at sun.reflect.GeneratedMethodAccessor2158.invoke(Unknown Source)
• at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
• at java.lang.reflect.Method.invoke(Method.java:606)
• at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
• at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
• at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
• at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:250)
• at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:341)
• at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:79)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.EjbExceptionTransformingInterceptorFactories$1.processInvocation(EjbExceptionTransformingInterceptorFactories.java:65)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
• at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
• at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
• at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
• at org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:249)
• at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)
• at org.jboss.ejb.client.EJBObjectInterceptor.handleInvocation(EJBObjectInterceptor.java:58)
• at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)
• at org.jboss.ejb.client.EJBHomeInterceptor.handleInvocation(EJBHomeInterceptor.java:83)
• at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)
• at org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:42)
• at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)
• at org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:125)
• at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)
• at org.jboss.ejb.client.EJBInvocationHandler.sendRequestWithPossibleRetries(EJBInvocationHandler.java:253)
• at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:198)
• at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:181)
• at org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:144)
• at com.sun.proxy.$Proxy64.processTxRequired(Unknown Source)
• at com.siperian.sif.client.EjbSiperianClient._process(EjbSiperianClient.java:147)
• ... 65 more

Solution

• In order to solve such issues, first Go to the MDM Hub Console
• Then through Wrokbech -> Go to Schema -> Base object.
• Select your Desired ORS Table -> Click on Column.
• Then Check The Check Length of each specified Column carefully.
• Then Try to Insert the data according to Data Precision Required.
• Then Save or Send for Approval as per the Requirement.
• Finally problem is Solved.