IBM Support

Migrated DataStage Projects gives error when browsing for Table Definitions

Troubleshooting


Problem

After migrating to Information Server 8.5, projects are missing a folder object which causes browsing to fail with "Could not find \Table Definitions\Database\Distributed Transaction of type CFolder". This issue only happens when the Migration Tool has been used to migrate existing projects. In summary, the migration tool has introduced a regression which can be resolved post-migration by repairing the repository, and then re-importing the built-in Table Definition from a new project (i.e. a project which was not migrated). This document describes the steps to diagnose and repair the problem.

Symptom

When browsing Table Definitions, error message is given: An error occured building the tree structure: Could not find \Table Definitions\Database\Distributed Transaction of type CFolder.

The error details indicates the following failure:

Exception type: ReposAccessException
Exception message: Could not find \Table Definitions\Database\Distributed Transaction of type CFolder.
Exception source: IBM.DataStage.RepositoryAccess
Exception stack trace:
IBM.DataStage.RepositoryAccess.ReposAccessException: Could not find \Table Definitions\Database\Distributed Transaction of type CFolder.
   at IBM.DataStage.RepositoryAccess.ReposManager.GetReposObject(String reposID, String folderPath, String id, String className)
   at IBM.DataStage.RepositoryAccess.ReposManager.GetParentFolder(ReposObject reposObject)
   at IBM.DataStage.RepositoryView.ReposTreeView.RetrieveAll(ReposObject reposObjectFolder)
   at IBM.DataStage.RepositoryView.ReposTreeView.RefreshEntireTree()
Inner exception IBM.DataStage.RepositoryAccess.ReposException: Could not find \Table Definitions\Database\Distributed Transaction of type CFolder.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.7;8.5.0.2;8.5.0.1;8.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21587147

Page Feedback