IBM Support

Creating a new project and receive the error DSR.Admin: (error updating secondary indices)

Troubleshooting


Problem

When creating a new project with the DataStage Administrator, the following error is reported.
DSR.Admin: Error updating secondary indices.

Diagnosing The Problem

We tried to add the project manually by using QUICKADD.B.  Here are the steps.

$ cd $DSHOME
$ . ./dsenv


$ bin/uvsh RUN BP DSR_QUICKADD.B XXXX <newProjectName>
/opt/IBM/InformationServer/Server/Projects/<newProjectName> CREATE

You can run this command with XXXX in the first argument and modify path as needed.

Example
$ ./bin/uvsh "RUN BP DSR_QUICKADD.B XXXX PROJ1 /ds_projects/PROJ1 CREATE"

==========================

Quick Add Project Starting

==========================
ProjectName: PROJ1
ProjectLocation: /ds_projects/PROJ1
Illegal flavor keyword, IDEAL flavor DataStage assumed
Stage 1 completed OK
Phantom process started with process ID 15335678.
DELETEd "DS_RESENU", Type 30.
DELETEd file "D_DS_RESENU", Type 3, Modulo 1.
DELETEd file definition record "DS_RESENU" in the VOC file.
Stage 2 completed OK
Stage 3 completed OK
DSR_QUICKADD.ErrorMsg: DSR.ADMIN: Error updating secondary indices.

Looking at the project directory, PROJ1, the files were in the directory and ownership looked correct with dsadm dstage. The permissions of 775 were correct also.

Next, we tried to update the secondary index manually on one of the files.

$ cd $DSHOME
$ . ./dsenv


$ bin/uvsh
> LOGTO PROJ1
>SET.INDEX DS_ROUTINES TO NULL FORCE
Unable to read index directory name in file header block.
Unable to write index directory name in file header block.
File header block updated.
>

The unable to read and write messages were concerning.

Next, we tried to create the project on a different files system. Project creation was successful.
In this case, work with the Unix Administrator to check for incorrect permissions in the underlying file system.  Unmount the project, fix the permissions, and remount the file system.  Then, retry project creation.
If SET.INDEX output is different, verify the presence of index files in the Template project.
$ cd /opt/IBM/InformationServer/Server/Template
$ ls -d I_DS_*
On releases 11.7.0.2 and newer, there are 8 directories:
I_DS_CONTAINERS
I_DS_JOBOBJECTS
I_DS_METADATA
I_DS_STAGETYPES
I_DS_DATATYPES
I_DS_JOBS
I_DS_ROUTINES
I_DS_TRANSFORMS
Earlier releases have 14:
I_DS_CONTAINERS
I_DS_IMSVIEWSETS
I_DS_JOBS
I_DS_STAGETYPES
I_DS_DATATYPES
I_DS_IMSVSOBJECTS
I_DS_METADATA
I_DS_TRANSFORMS
I_DS_IMSDATABASES
I_DS_JCLTEMPLATES
I_DS_MFPROFILES
I_DS_IMSDBOBJECTS
I_DS_JOBOBJECTS
I_DS_ROUTINES
Restore missing directories from backup or transfer from another Information Server environment at the same release level.  Then, retry project creation.
Otherwise, gather the following.  Send resulting /tmp/Template.listing and /tmp/trace.quickadd to IBM for analysis.
1) listing on Template directory
$ ls -Rltr /opt/IBM/InformationServer/Server/Template > /tmp/Template.listing
2) trace information from running DSR_QUICKADD.B; replace project_path with an appropriate location
$ cd /opt/IBM/InformationServer/Server/DSEngine
$ . ./dsenv
On AIX:
$ truss -afe -o /tmp/trace.quickadd bin/uvsh "RUN BP DSR_QUICKADD.B XXXX TESTPROJ <project_path>/TESTPROJ CREATE"
On Linux:
$ strace -f -o /tmp/trace.quickadd bin/uvsh "RUN BP DSR_QUICKADD.B XXXX TESTPROJ <project_path>/TESTPROJ CREATE"

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.7;9.1;11.3;11.5;11.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 October 2020

UID

swg21979892

Page Feedback