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

@MWitczak Thanks a lot for posting this! Worked!

@MWitczak Thank you for the workaround. It worked.
@ibalfe Did you raise a ticket for this and if so, is there a release update version which includes a proper fix? Thank you!

@thprlkARC, according to the IFS Support knowledge base article, the proper fix for this is in 24R2 EA. See knowledge base article KB0064918 for full information.

This worked for me as well, saved lots of my time. thanks a lot.

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