E1 8.9 SP2 - Problems with indexes

Hi all,

I´m having a problem with a instalation version 8.9 SP2 upgraded from Xe when I´m trying to create a Custom Report. When I select a Business View the jde.log says:

2344/4020 Mon Oct 03 19:00:47.058 ODBC_P3.C1771
ODB0000142 - JDBODBC_SpecData failed. Number of indexes has changed, table F0116.

2344/4020 Mon Oct 03 19:00:47.058 JDBODBC.C4663
ODB0000054 - Unable to get table spec. data.

2344/4020 Mon Oct 03 19:00:47.058 jdb_drvm.c1373
JDB9900184 - Failed to get table specs from db

2344/4020 Mon Oct 03 19:00:47.073 jdb_rq1.c6816
JDB9900275 - Failed to get foreign table specs

2344/4020 Mon Oct 03 19:00:47.073 jdb_rq1.c6609
JDB3100050 - Failed to load table information

2344/4020 Mon Oct 03 19:01:08.898 ODBC_P3.C1771
ODB0000142 - JDBODBC_SpecData failed. Number of indexes has changed, table F0115.

2344/4020 Mon Oct 03 19:01:08.898 JDBODBC.C4663
ODB0000054 - Unable to get table spec. data.

2344/4020 Mon Oct 03 19:01:08.898 jdb_drvm.c1373
JDB9900184 - Failed to get table specs from db

2344/4020 Mon Oct 03 19:01:08.898 jdb_rq1.c6816
JDB9900275 - Failed to get foreign table specs

2344/4020 Mon Oct 03 19:01:08.913 jdb_rq1.c6609
JDB3100050 - Failed to load table information



and the jdedebug:

Oct 03 19:00:47.151 - 2344/4020 Entering JDB_OpenForeignTable (Table F0115)
Oct 03 19:00:47.151 - 2344/4020 ODBC:I DBInitConnection shr(2) con=03F12260 env=027C12A0 dbc=027C4168 cur=0,0,0 sep=/ BRLSP001 A (JDE@Business Data - CRP)
Oct 03 19:01:08.898 - 2344/4020 ODB0000142 - JDBODBC_SpecData failed. Number of indexes has changed, table F0115.
Oct 03 19:01:08.898 - 2344/4020 ODB0000054 - Unable to get table spec. data.
Oct 03 19:01:08.898 - 2344/4020 JDB9900184 - Failed to get table specs from db
Oct 03 19:01:08.898 - 2344/4020 JDB9900275 - Failed to get foreign table specs
Oct 03 19:01:08.913 - 2344/4020 ODBC:I DBFreeConnection free(1) con=03F12260 env=027C12A0 dbc=027C4168 cur=0,0,0 sep=/ BRLSP001 A (JDE@Business Data - CRP)
Oct 03 19:01:08.913 - 2344/4020 JDB3100050 - Failed to load table information
Oct 03 19:01:08.913 - 2344/4020 Exiting JDB_OpenForeignTable with Failure (Table F0115)


The problem occurs with diferent tables. The problem does not appears on every day usage (production) just when I try to create a new report. Does any one have any Idea ???

E1 8.9 SP2_I1
AS/400 - DB2 UDB

thanks in advance.

Hi,
can u compare if the columns in the view and the tables mentioned in the log are present.