JR47722: CREATE PROJECT FAILS WITH ERROR "DSR.ADMIN: ERROR UPDATING SECONDARY INDICES"

APAR status

• Closed as fixed if next.

Error description

• Creating a project fails during the installation of InfoSphere
  Information Server, when using the Administrator client, or when
   using the dsadmin command.Error message: "DSR.ADMIN: Error
  updating secondary indices. Status code = -135
  DSJE_ADDPROJECTFAILED".
  

Local fix

• A known cause for the error "error updating secondary indices"
  is one or more missing I_* directories in the
  /opt/IBM/InformationServer/Server/Template directory. If the
  there is another DataStage engine installation (of the same
  version and patch level) available it is possible copy the
  Template directory from the working engine and use it to replace
   the Template directory on the broken engine. However be careful
   the backup the existing Template directory first. Note that if
  a Template directory is taken from a working engine of a
  different patch level, some of the patches on the broken engine
  may be rendered ineffective.
  

Problem summary

• We should change the project creation code such that it doesn't
   require the presence of the template index files - we could
  just run DS.REINDEX instead of using SET.INDEX - this
  needs to be done in a future release.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R870 PSN

     UP

• R910 PSN

     UP

• R912 PSN

     UP