[SQL0601] INDEX_<index name> in <C&DS Lib> type *FILE already exists

Technote (troubleshooting)


Problem(Abstract)

Attempts to run CLISETUP fail with the following errors:



java.sql.SQLException: [SQL0601] <index name> in <C&DS Lib> *FILE already exists.

Symptom

CLISETUP fails


Cause

A C&DS 4.0 database was restored into a new database/schema for C&DS 4.2.1. The restored indexes still pointed to the C&DS 4.0 library, and were not rebuilt.

Environment

Collaboration and Deployment Services 4.0 and 4.2.1
IBMi

Diagnosing the problem

Review the setup.log

Resolving the problem

Delete the indexes from the C&DS 4.2.1 library with the following steps:

WRKOBJ OBJ(<C&DS4.2.1 Lib>/UQ*) - then take option 4 to delete these indexes
WRKOBJ OBJ(<C&DS4.2.1 Lib>/INDEX*) - then take option 4 to delete these

Re-run clisetup

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Collaboration and Deployment Services
Content Repository

Software version:

4.2.1

Operating system(s):

IBM i

Reference #:

1644569

Modified date:

2013-07-22

Translate my page

Machine Translation

Content navigation