CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Issue : re-create index for table failed

edited Dec 11, 2017 11:06PM in CNC, DB and Operating System - JDE1 (MOSC) 16 commentsAnswered

Dear All,

We have tried to re-create index for table , but the result of table F0911 - Create Index Failed.

Please find the log and give solution :

3084/3608 MAIN_THREAD                        Sun Dec 03 07:53:04.255000 Jdb_ctl.c4081

Starting OneWorld

3084/4972 WRK:Starting jdeCallObject        Sun Dec 03 07:54:54.379000 Jdbodbc.c8408

ODB0000163 - wSQLPrepare failure. rc=-1

3084/4972 WRK:Starting jdeCallObject        Sun Dec 03 07:54:54.380000 Jdbodbc.c8408

ODB0000164 - STMT:00 [HY000][-913][2] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0913 - Row or object F0911 in PRODDTAE9 type *FILE in use.

3084/4972 WRK:Starting jdeCallObject        Sun Dec 03 07:54:54.381000 Jdb_drvm.c1003

JDB9900401 - Failed to execute db request

3084/4972 WRK:Starting jdeCallObject        Sun Dec 03 07:54:54.381001 Jdb_exem.c3238

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center