Index generation


Active Member
I have a question on index generation. I am trying to a generate an index on
a custom table which was already indexed and package built on the table.
When I try to add a new index and re generate the index I get an error Index
generation failed.

One World B7332 on SQL server.




Active Member
You might have to do a full backup of the database before the index

Chi Lee
B7331, SQL Server, NT 4.0, Citrix


Legendary Poster
Hi Sailaja,

First of all, You Are Welcome on the JDEList Forums/Lists!

Have you generated the table in the default (Business Data) data source?
If not, have you create the appropriate OCM entry and activate it?
Were you in the same environment where you generated the table and for wich do you have the OCM entry (if it isn't in the default)?

If you checked all of the above and they are OK, then could be useful to send a log and a debug-log part for us to go ahead.

Welcome aboard!


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)


Well Known Member
Have you deployed the Table/Index Spec to the Enterprise Server?

OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + 4 NT PC's for development
Discover how to build no-code data integrations and business process automations.