ORA-06502 NULL index table key value erro

Just took delivery of 24R1SU4 in one of our lower environments. During testing and updating configurations, I found that this page is unable to load or be opened in Page Designer:

ResourcesDetailHandling

Path: Application Base Setup → Enterprise → Resource → Resource Details

Resource Crew is also affected.

Attempting to view the API documentation in the API Doc View also results in error.

The page/API function normally in our other environments (23R2SU10).

Have any of you seen this before? Any help is greatly appreciated. Error screenshot and error stack below.

Full error stack below:

IFS Web Version: 24.1.5.20241010043720.0
Date: 2024-10-29T19:05:21.765Z

---------------------------------------------------------------------------

<none>/<none> (server error)
An error occurred while processing metadata.

n0] Error reading client metadata for ResourceDetails.
com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.readMetadataAsString(ClientMetaDataSourceImpl.java:167),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.loadClientLayout(ClientMetaDataSourceImpl.java:50),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.loadClientLayoutWithApplicationContext(ClientMetaDataSourceImpl.java:82),com.ifsworld.metadata.ClientMetadataResource.getMetadata(ClientMetadataResource.java:79),com.ifsworld.metadata.ClientMetadataResource$Proxy$_$$_WeldClientProxy.getMetadata(Unknown Source),jdk.internal.reflect.GeneratedMethodAccessor90.invoke(Unknown Source),java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source),java.base/java.lang.reflect.Method.invoke(Unknown Source),com.ibm.ws.jaxrs20.cdi.component.JaxRsFactoryImplicitBeanCDICustomizer.serviceInvoke(JaxRsFactoryImplicitBeanCDICustomizer.java:350),com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:641),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:160),org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:101),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:273),org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:213),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:444),org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:112),org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59),org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96),org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308),org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:123),org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:277),com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:137),com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:146),com.ibm.websphere.jaxrs.server.IBMRestServlet.doGet(IBMRestServlet.java:112),javax.servlet.http.HttpServlet.service(HttpServlet.java:686),com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:96),com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1258),com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:746),com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443),com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:193),com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79),com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1002),com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1140),com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1011),com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:75),com.ibm.ws.webcontainer40.servlet.CacheServletWrapper40.handleRequest(CacheServletWrapper40.java:85),com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:938),com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:281),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1184),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:453),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:412),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:566),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:500),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:360),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:327),com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:167),com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:75),com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504),com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574),com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:958),com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1047),com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper.run(ExecutorServiceImpl.java:238),java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source),java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source),java.base/java.lang.Thread.run(Unknown Source)

n1] ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 673
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 506
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 982
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 366
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1629
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1303
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1353
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1425
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1326
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1353
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1425
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 970
ORA-06512: at "IFSAPP.FND_CLIENT_SYS", line 99
ORA-06512: at "IFSAPP.FND_CLIENT_SYS", line 64
ORA-06512: at line 3

oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509),oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461),oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104),oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550),oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268),oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655),oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265),oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86),oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965),oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205),oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666),oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358),oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778),oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251),oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081),com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:390),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.readMetadataAsString(ClientMetaDataSourceImpl.java:154),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.loadClientLayout(ClientMetaDataSourceImpl.java:50),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.loadClientLayoutWithApplicationContext(ClientMetaDataSourceImpl.java:82),com.ifsworld.metadata.ClientMetadataResource.getMetadata(ClientMetadataResource.java:79),com.ifsworld.metadata.ClientMetadataResource$Proxy$_$$_WeldClientProxy.getMetadata(Unknown Source),jdk.internal.reflect.GeneratedMethodAccessor90.invoke(Unknown Source),java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source),java.base/java.lang.reflect.Method.invoke(Unknown Source),com.ibm.ws.jaxrs20.cdi.component.JaxRsFactoryImplicitBeanCDICustomizer.serviceInvoke(JaxRsFactoryImplicitBeanCDICustomizer.java:350),com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:641),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:160),org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:101),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:273),org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:213),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:444),org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:112),org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59),org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96),org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308),org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:123),org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:277),com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:137),com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:146),com.ibm.websphere.jaxrs.server.IBMRestServlet.doGet(IBMRestServlet.java:112),javax.servlet.http.HttpServlet.service(HttpServlet.java:686),com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:96),com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1258),com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:746),com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443),com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:193),com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79),com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1002),com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1140),com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1011),com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:75),com.ibm.ws.webcontainer40.servlet.CacheServletWrapper40.handleRequest(CacheServletWrapper40.java:85),com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:938),com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:281),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1184),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:453),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:412),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:566),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:500),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:360),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:327),com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:167),com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:75),com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504),com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574),com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:958),com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1047),com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper.run(ExecutorServiceImpl.java:238),java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source),java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source),java.base/java.lang.Thread.run(Unknown Source)

n2] ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 673
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 506
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 982
ORA-06512: at "IFSAPP.DYNAMIC_REFERENCE_METADATA_API", line 366
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1629
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1303
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1353
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1425
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1326
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1353
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 1425
ORA-06512: at "IFSAPP.MODEL_DESIGN_SYS", line 970
ORA-06512: at "IFSAPP.FND_CLIENT_SYS", line 99
ORA-06512: at "IFSAPP.FND_CLIENT_SYS", line 64
ORA-06512: at line 3

oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513),oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461),oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104),oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550),oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268),oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655),oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265),oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86),oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965),oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205),oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666),oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358),oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778),oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251),oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081),com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:390),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.readMetadataAsString(ClientMetaDataSourceImpl.java:154),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.loadClientLayout(ClientMetaDataSourceImpl.java:50),com.ifsworld.metadata.storage.datasource.ClientMetaDataSourceImpl.loadClientLayoutWithApplicationContext(ClientMetaDataSourceImpl.java:82),com.ifsworld.metadata.ClientMetadataResource.getMetadata(ClientMetadataResource.java:79),com.ifsworld.metadata.ClientMetadataResource$Proxy$_$$_WeldClientProxy.getMetadata(Unknown Source),jdk.internal.reflect.GeneratedMethodAccessor90.invoke(Unknown Source),java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source),java.base/java.lang.reflect.Method.invoke(Unknown Source),com.ibm.ws.jaxrs20.cdi.component.JaxRsFactoryImplicitBeanCDICustomizer.serviceInvoke(JaxRsFactoryImplicitBeanCDICustomizer.java:350),com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:641),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:160),org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:101),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:273),org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:213),com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:444),org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:112),org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59),org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96),org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308),org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:123),org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:277),com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:137),com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:146),com.ibm.websphere.jaxrs.server.IBMRestServlet.doGet(IBMRestServlet.java:112),javax.servlet.http.HttpServlet.service(HttpServlet.java:686),com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:96),com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1258),com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:746),com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443),com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:193),com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79),com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1002),com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1140),com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1011),com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:75),com.ibm.ws.webcontainer40.servlet.CacheServletWrapper40.handleRequest(CacheServletWrapper40.java:85),com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:938),com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:281),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1184),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:453),com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:412),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:566),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:500),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:360),com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:327),com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:167),com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:75),com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504),com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574),com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:958),com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1047),com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper.run(ExecutorServiceImpl.java:238),java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source),java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source),java.base/java.lang.Thread.run(Unknown Source)
Error details: r{"code":6502,"message":"ORA-06502: PL/SQL: numeric or value error: NULL index table key value"}]

Request Id: null
Url: https://ifsdevcloud.buyerslocal.com/main/ifsapplications/web/server/metadata/cpi/ResourceDetails?contexts=Company:RMT,Site:RMH10&ifsweb-debug=true

---------------------------------------------------------------------------

Page 1 / 1

I’ve got exactly the same error in 24R1 so it looks like a bug. I’ll be getting a case logged today.

Hi @ibalfe, when you create your case (if you haven’t already done so), it mentions it is fixed in 24R2 and there is a simple workaround. I can post the workaround here if you like.

@MWitczak That’s good to know, if you can post the workaround it would be appreciated

@ibalfe Here’s the Workaround:

Navigate to Application Base Setup → Enterprise → Resource → Basic Data → Resource Attribute Manager
Create a new record:

Attribute Type - Resource
Attribute ID - RESOURCE_ROLE
Description - Role assigned to the resource
Data Type - Text
Length - 100
LoV View - RES_ATTRIBUTE_VALUE(ATTRIBUTE_ID) … this should automatically populate

After saving this record, I was able to successfully navigate to Resource Details and Resource Crew. I hope this works for you as well!

We had the same issue in Cloud 24.1.4. Thank you @MWitczak. above solution worked

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded