Regen of Index fails

[pfd]

I added a new index to a table. I am able to regen it on my local machine. But after I check it in and our CNC guy tries to deploy it he gets the following error.

520/1424 Thu Sep 09 11:34:14 2004 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - CREATE INDEX F554901_3 ON DVDATA.F554901 (MUURAB ASC)

520/1424 Thu Sep 09 11:34:14 2004 DBPERFRQ.C384
OCI0000179 - Error - ORA-00955: name is already used by an existing object

520/1424 Thu Sep 09 11:34:14 2004 jdb_drvm.c917
JDB9900401 - Failed to execute db request

520/1424 Thu Sep 09 11:34:14 2004 jdb_exem.c680
JDB2100018 - Failed to create index 3 for table F554901 in data source Business Data - DVDATA



Any ideas why?

Thanks,
Matt


OneWorld Xe SP18.1, Oracle 8.1.7.3, HP9000

 

[jgersic]

It has been awhile since I have used Oracle but it seems like there may be
a disconnect between what indicies JDE thinks are on a table and what
actually are. It looks like there may already be an index (F554901_3) on the
table. I would try to go through SQL+ and drop the index and then go through
JDE and try to regenerate it and see if it goes through..

-John

 

[Sebastien Leclerc]

Please post a complete log, with output=file.

In order to get a more accurate picture, set the following as well in the ini:
Output=FILE
DebugFile=c:\jdedebug.log
JobFile=c:\jdedebug.log

This will merge the 2 logs.

The existing indexes need to be dropped when regenerating. I suspect that the operation failed.

Ask your CNC to check if object F554901_3 exists and if it is allocated.

 

[pfd]

I have attached the complete log.

Thanks,
Matt

 

[Sebastien Leclerc]

OK. According to the following part of the log:
Sep 09 13:53:01 ** 1336/1652 DROP INDEX DVDATA.F554901_3
Sep 09 13:53:01 ** 1336/1652 OCI0001003 - Unable to execute - DROP INDEX DVDATA.F554901_3
Sep 09 13:53:01 ** 1336/1652 OCI0001004 - Error - ORA-01418: specified index does not exist

The index would be dropped if it existed.

However, this:
Sep 09 13:53:02 ** 1336/1652 CREATE INDEX F554901_3 ON DVDATA.F554901 (MUURAB ASC)
1336/1652 Thu Sep 09 13:53:02 2004 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - CREATE INDEX F554901_3 ON DVDATA.F554901 (MUURAB ASC)

1336/1652 Thu Sep 09 13:53:02 2004 DBPERFRQ.C384
OCI0000179 - Error - ORA-00955: name is already used by an existing object

This clearly indicates that there IS an object with the name F554901_3.

As John suggests it, you yave to manually check the database for an object with that name. THIS MIGHT NOT BE AN INDEX at all and could be the name of a table.

Check in OMW if a table with that name was created. If so, you will need to delete the table from the database and copy it under a different name in OMW, regenerate it and change any application using it.

 

[pfd]

Thanks so much for all your help guys!

 

[Sebastien Leclerc]

So what was it after all?

 

[pfd]

Honestly I dont know. The CNC guy made me remove the table from another project it was in and then rebuilt the package. It worked fine .
Thanks once again for all your help.