E1: DB: Case Study on JDB9900920 - Failed to find index 1 for table F0101 (Doc ID 2296260.1)

Last updated on MARCH 14, 2022

Applies to:

JD Edwards EnterpriseOne Address Book - Version 9.1 and later
JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Purpose

The purpose of this document is to go through the resolution steps for the error below,

The Representation of Error

Representation in HTML client

Error File can not be accessed. Warning

A form level error has occurred.
CAUSE: ERROR: File can not be accessed.
Solution. . . Change IBM security or authority using the IBM EDTOBJAUT command.
This file can not be accessed with the current IBM authority
for the User executing this request.

ER Details:
  Form P01012_W01012B
  Event Grid Record is Fetched
  Line No 9
BSFN Details:
  Source File b0100033.c
  Source Line 131
  Error ID 3143

Note:

Above message can be shown only when you click small yellow color triangle on the right edge of error box. Most of time, BSFN Details give you the direct cause of the issue
The description of error is originated from World Software, which may not explain the actual cause of it.
The cause of error for this example is different from the generic description which error message reads. So check whether issue is happening globally or against specific user(s).

Representation in JDE.log

: this message appears all types of kernel logs because of the nature of F0101 (Address Book Master)

4512/272 WRK:USERID_075BAB68_ProgramID            Thu Aug 10 12:26:50.583000   JDB_RQ1.C781
   JDB9900920 - Failed to find index 1 for table F0101

4512/272 WRK:USERID_075BAB68_ProgramID            Thu Aug 10 12:26:50.584000   JDB_RQ1.C2518
   JDB3100014 - Failed to load requested index

Note:

The user ID, and ProgramID are changed
Index 1 for table F0101 is the primary key of F0101. So this type of error can cause all applications in E1 fails
This type of error can be represented only in JDE.log and JDEDEBUG.log which is tracing routine for call object kernel log because the error is coming when a certain request is made using E1 Business Function(s).