Skip to main content
Solved

ORA-06502 NULL index table key value erro


MWitczak
Hero (Customer)
Forum|alt.badge.img+10

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.

[0] 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)

[1] 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)

[2] 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: [{"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

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

 

Best answer by MWitczak

@ibalfe Here’s the Workaround:

 

  • Navigate to Application Base Setup → Enterprise → Resource → Basic Data → Resource Attribute Manager
  • Create a new record:
  1. Attribute Type - Resource
  2. Attribute ID - RESOURCE_ROLE
  3. Description - Role assigned to the resource
  4. Data Type - Text
  5. Length - 100
  6. 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!

View original

10 replies

ibalfe
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 6 replies
  • October 30, 2024

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


MWitczak
Hero (Customer)
Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 63 replies
  • October 30, 2024

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.


ibalfe
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 6 replies
  • October 30, 2024

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


MWitczak
Hero (Customer)
Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 63 replies
  • Answer
  • October 30, 2024

@ibalfe Here’s the Workaround:

 

  • Navigate to Application Base Setup → Enterprise → Resource → Basic Data → Resource Attribute Manager
  • Create a new record:
  1. Attribute Type - Resource
  2. Attribute ID - RESOURCE_ROLE
  3. Description - Role assigned to the resource
  4. Data Type - Text
  5. Length - 100
  6. 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!


Forum|alt.badge.img

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


Forum|alt.badge.img+10
  • Hero (Partner)
  • 202 replies
  • January 20, 2025

@MWitczak  Thanks a lot for posting this! Worked!


Forum|alt.badge.img+2
  • Sidekick (Partner)
  • 5 replies
  • February 6, 2025

@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! 


MWitczak
Hero (Customer)
Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 63 replies
  • February 6, 2025
thprlkARC wrote:

@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.


asanka1055
Hero (Partner)
Forum|alt.badge.img+9
  • Hero (Partner)
  • 54 replies
  • February 13, 2025

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


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 3 replies
  • May 16, 2025

Thanks ​@MWitczak !! I was able to resolve a frustrating error that was blocking the Resource Details page in our production environment.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings