I am using a delivered set of DS maps from PeopleSoft as part of EPM 8.9.
In an attempt to understand how these maps are inter-related, I have attempted to expose the metadata in Datastage Project (delivered maps) using Metastage. When I attempt a New Import within Metastage I constantly recieve the error in the format
'TableDefinition' 'MSHASH\FILES\HASH_PS_CLASS_CF_TBL' in project 'HCM_EPM89BDL2' not found or being accessed by another user on host 'refrwmadps01'. Skipping 'MSHASH\FILES\HASH_PS_CLASS_CF_TBL'.
I guess this is because the Metadata defintion does not reside on Datastage server at DS_METADATA. To get the table structures metadata into DS_METADATA, I guess requires me in Director to Import Table Defintions. This approach is taking a long, long time. My question 'is there another way to get the metadata for the table structures used within the DS maps into DS_METADATA to allow the DS Project to be Imported into Metastage'.
Thanks in advance
Using Metastage to understand delivered Datastage project
Moderators: chulett, rschirm, roy
-
Sainath.Srinivasan
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
No-one accessing Metastage
Thanks for getting back on this topic. No-one else is accessing Metastage when I do this.
Although what I have seen is the files in the DS_METADATA directory on the DS server are those which appear to get referenced by Metastage.
As these are initially empty then this would explain why the definitions cannot be found, therefore requiring the Table definitions to be imported.
Although what I have seen is the files in the DS_METADATA directory on the DS server are those which appear to get referenced by Metastage.
As these are initially empty then this would explain why the definitions cannot be found, therefore requiring the Table definitions to be imported.
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DS_METADATA is a dynamic hashed file in which Table Definitions are stored. The directory should contain exactly three files, called DATA.30, OVER.30 and .Type30. If this is not the case, then you have major problem in your repository.
In particular, DS_METADATA is not referenced by MetaStage. It has its own database (the "hub"), which is not the same database as the DataStage repository.
Did you mean DataStage, when you said MetaStage?
Might I suggest asking Peoplesoft to give you a DataStage export file containing all the relevant table definitions?
In particular, DS_METADATA is not referenced by MetaStage. It has its own database (the "hub"), which is not the same database as the DataStage repository.
Did you mean DataStage, when you said MetaStage?
Might I suggest asking Peoplesoft to give you a DataStage export file containing all the relevant table definitions?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.